Bladephp: Now with 8+ codeigniter, php, and laravel project 8+ php project From $37/Month From Rs. 2499/Month

Join Query in Laravel 5

by
Category:laravel
mysql laravel
Join Query in Laravel 5

The query builder may also be used to write join statements. To perform a basic "inner join", you may use the join method on a query builder instance. The first argument passed to the join method is the name of the table you need to join to, while the remaining arguments specify the column constraints for the join. Of course, as you can see, you can join to multiple tables in a single query.

$data['get_cartlist'] = DB::table('cart')
    ->join('cart_products', 'cart.crt_id', '=', 'cart_products.cart_id')
    ->join('diamond_master', 'cart_products.loat_id', '=', 'diamond_master.Loat_NO')
    ->where('cart.user_id','=',Auth::user()->id)
    ->where('diamond_master.user_id','=',Auth::user()->parent_id)
    ->where('cart_products.status','=','0')
    ->select('diamond_master.*','cart_products.crt_p_id', 'cart_products.loat_id',
'cart_products.add_date','diamond_master.id as diamondid')
		->orderBy('cart_products.add_date', 'desc')
    ->get();
return view('front.checkout',$data);

Insert query in Laravel 5 using Model

How to make Condition based query in Laravel 5 using Model

Insert Query in Laravel 5

Update Query in Laravel 5

Delete Query in Laravel 5


0 Comments


Html code work in comment box


Related Post