Level 67
Why don't you use Eloquent/models and set up some relationships?
Then it would just be Vehicle::with('reservation')->get().
https://laravel.com/docs/5.6/eloquent-relationships#many-to-many
Jul 18, 2018
2
Level 1
db::select returning null at joins query
I am trying to fetch results from a joins query using DB::select( ). The query shows output in mysql phpmyadmin but not in laravel.
$q1=DB::select("Select id from vehicle"); // returns a single column of multiple ids
for($i=0; $i<=count($q1); $i++)
{
$q2=DB::select("Select * from reservation inner join vehicle on (reservation.v_id=vehicle.id) where vehicle.id=?",[$q1[$i]->id]);
// returns null when $q[$i]->id is written and returns some data when an integer is given instead of $q1 object
}
Please help if you understood my problem.
Level 73
Like @Cronix said or if you are set on using SQL make it one query.
SELECT v.id v_id, r.*
FROM vehicle v, reservation r
WHERE v.id = r.v_id;
A few tips always use plural for your tables like vehicles and reservations and don't abriviate foreign keys like v_id should be vehicle_id.
Please or to participate in this conversation.