Join in laravel.

 <?php

$data = DB::table('users')

        ->join('contacts', 'users.id', '=', 'contacts.user_id')

        ->join('orders', 'users.id', '=', 'orders.user_id' )

        ->select('users.id','contacts.name','orders.price')

        ->get();

?>

Comments

Post a Comment

Popular posts from this blog

My Sql Query ..

 1.  select product_id from products where low_fats = 'Y' && recyclable = 'Y' ; 2. select name from customer where referee_id != 2 || referee_id is null ; 3. select name, population , area from world where area > 3000000 or population > 25000000 ; 4. select distinct author_id as id from Views where author_id = viewer_id order by id; 5. select tweet_id from tweets where char_length (content) > 15 ; 6. select unique_id, name from Employees left join EmployeeUNI on Employees.id = EmployeeUNI.id; 7. select customer_id , count (visits.visit_id) as count_no_trans from visits left join transactions on visits.visit_id = transactions.visit_id where transaction_id is null group by customer_id; 8. SELECT w1.id FROM Weather w1, Weather w2 WHERE DATEDIFF(w1.recordDate, w2.recordDate) = 1 AND w1.temperature > w2.temperature;
Read more

Interview question laravel.

 1. for table use  protected $table = "mytablename" ; 2. difference between post  from web and api . sol. @csrf token 3.  diff web.php and api.php  sol. https://koenwoortman.com/laravel-difference-between-web-and-api-routes/ 4. many to many relation 5. patch and put = multiple column update in put and update single column in patch . 6.  show single variable in all view files. sol: https://stackoverflow.com/questions/32683069/how-to-make-a-variable-available-to-all-my-pages-in-laravel 7. how many table use in one to one                                           one to many                                           many  to many  
Read more