Now, we’ll create the 2nd table State to merge with the Country table.
Step 1. Create child file resources/views/State folder with name create.blade.php.
Step 2. Create edit.blade.php file. In this file within resources/views/State folder.
Step 3. Create an index.blade.php file within resource/views/State/ folder.
Step 4. Go to app/State.php. Now, we need to list all the properties we need in the $fillable array.
Step 5. Go to app/Http/Controllers/StateController.php file.
->leftJoin('countries', 'states.country_id', '=', 'countries.country_id')
public function index()
{
$states = State::all()->toArray();
$states = DB::table('states')
->leftJoin('countries', 'states.country_id', '=', 'countries.country_id')
->orderBy('state_id','desc')->paginate(5);
return view('state.index', ['states' => $states]);
}
Step 6. Then, go to routes/web.php file and define all these routes.
Route::resource('state','StateController');
Route::any('/search1', 'StateController@search');
Run the URL
Thanks
With MotoShare.in, you can book a bike instantly, enjoy doorstep delivery, and ride without worries. Perfect for travelers, professionals, and adventure enthusiasts looking for a seamless mobility solution.