πŸš€ DevOps & SRE Certification Program πŸ“… Starting: 1st of Every Month 🀝 +91 8409492687 πŸ” Contact@DevOpsSchool.com

Upgrade & Secure Your Future with DevOps, SRE, DevSecOps, MLOps!

We spend hours scrolling social media and waste money on things we forget, but won’t spend 30 minutes a day earning certifications that can change our lives.
Master in DevOps, SRE, DevSecOps & MLOps by DevOpsSchool!

Learn from Guru Rajesh Kumar and double your salary in just one year.


Get Started Now!

How to merge two or multiple tables to each other in the Laravel PHP Framework? (Part-2)

How to merge two or multiple tables to each other in the Laravel PHP Framework?

Part-1 Part-3

Step 1. Go to app/Country.php. Now, we need to list all the properties we need in the $fillable array.

class Country extends Model
{
protected $fillable = ['country_name'];
}
view raw country.php hosted with ❀ by GitHub

Step 2. Go to app/Http/Controllers/CountryController.php file.

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Input;
use App\Country;
class CountryController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$countries = Country::all()->toArray();
$countries = DB::table('countries')->orderBy('country_id','desc')->paginate(5);
return view('country.index', ['countries' => $countries]);
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
return view('country.create');
}
public function search(Request $request)
{
$search = $request->get('search');
if($search != ''){
$countries = Country::where('country_name','like', '%' .$search. '%')->paginate(2);
$countries->appends(array('search'=> Input::get('search'),));
if(count($countries )>0){
return view('country.index',['countries'=>$countries]);
}
return back()->with('error','No results Found');
}
}
public function store(Request $request)
{
$this->validate($request, [
'country_name' => 'required',
]);
$country = new Country([
'country_name' => $request->get('country_name')
]);
$country->save();
return redirect()->route('country.create')->with('success', 'Data Added');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$country = Country::where('country_id',$id)->first();
return view('country.edit', compact('country'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$this->validate($request, [
'country_name' => 'required',
]);
$data = array(
'country_name' => $request->country_name
);
Country::where('country_id', $id)->update($data);
return redirect()->route('country.index')->with('success', 'Data Updated');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$country = Country::where('country_id', $id);
$country->delete();
return redirect()->route('country.index')->with('success', 'Data Deleted');
}
}
view raw countryController.php hosted with ❀ by GitHub

Step 3. Then, go to routes/web.php file and define all these routes.

Route::resource('country','CountryController');
Route::any('/search', 'CountryController@search');

Run URL

This image has an empty alt attribute; its file name is image-7-1024x576.png

Thanks

Certification Courses

DevOpsSchool has introduced a series of professional certification courses designed to enhance your skills and expertise in cutting-edge technologies and methodologies. Whether you are aiming to excel in development, security, or operations, these certifications provide a comprehensive learning experience. Explore the following programs:

DevOps Certification, SRE Certification, and DevSecOps Certification by DevOpsSchool

Explore our DevOps Certification, SRE Certification, and DevSecOps Certification programs at DevOpsSchool. Gain the expertise needed to excel in your career with hands-on training and globally recognized certifications.