Controller in Laravel

Admin

2 years ago

Create controller file ‘app/Http/Controllers/ProductController.php‘ and paste the given code below

<?php

namespace App\Http\Controllers;

use DB;
use Illuminate\Foundation\Auth\Access\AuthorizesRequests;
use Illuminate\Foundation\Bus\DispatchesJobs;
use Illuminate\Foundation\Validation\ValidatesRequests;
use Illuminate\Routing\Controller as BaseController;

class ProductController extends BaseController
{
    public function index(){
		$products = DB::table('products')
				->selectRaw('*')
				->where('status', '=', 1)
				//->where('id', '=', $id)				
				->get();
		
		return view("products/productList",compact('products'));
	}

	public function detail($id){		
		$products = DB::table('products')
				->selectRaw('*')
				->where('status', '=', 1)
				->where('id', '=', $id)				
				->get();
		
		return view("products/productDetail",compact('products'));		
	}
}

<?php

namespace App\Http\Controllers;

use DB;

use Illuminate\Foundation\Auth\Access\AuthorizesRequests;

use Illuminate\Foundation\Bus\DispatchesJobs;

use Illuminate\Foundation\Validation\ValidatesRequests;

use Illuminate\Routing\Controller as BaseController;

class ProductController extends BaseController

{

public function index(){

$products = DB::table('products')

->selectRaw('*')

->where('status', '=', 1)

//->where('id', '=', $id)

->get();

return view("products/productList",compact('products'));

}

public function detail($id){

$products = DB::table('products')

->selectRaw('*')

->where('status', '=', 1)

->where('id', '=', $id)

->get();

return view("products/productDetail",compact('products'));

}

public function index() and public function detail($id) are methods you can remove these method and write your own.

in detail($id) method you can see select query with multiple where clause in laravel.