Populate Relationship into DropDown from Database Laravel

Often in your form, you will need to populate the data directly from the database. This is usually the case when you have a one to many or many to many relationship established between your models and you want to persist the relationship data on form submission.

For this Example let’s consider a Product model which has a one to one relationship with Category Model.

Consider a Form to Add new Product into the database. In our form, we would want the ability to select the category which the product belongs to.


namespace App\Http\Controllers\Admin;

use App\Category;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;

class ProductController extends Controller

     * Show the form for creating a new resource.
     * @return \Illuminate\Http\Response
    public function create()
        $categories = Category::all(['id','name']);
        return view('products.create',compact('categories'));

As you see, in the create method we get all the categories and pass it on to the product create page.

Livewire Component Library

And here is how you can render the dropdown in your view page.

Host Laravel Application on DigitalOcean

Use coupon 5balloons on this Cloudways Affiliate URL to get special discount.
<div class="form-group">
    <label for="name">Category</label>
    <select class="form-control">
      @foreach($categories as $category)
        <option value="{{$category->id}}">{{$category->name}}</option>

Site Footer