Join queries in Laravel

Question

I'm having a lot of issues writing this query. Can someone please advise!

Select all from bookings table where

bookings.product_id = product.id

then based on the return, i want to say if a field in the returned results (created_at) is greater than "7" then return 1 otherwise return 0.

@GauravDave you are right, I was thinking about giving him the plain SQL query — Robson
– Robson, Commented May 5, 2015 at 10:39

Sameer Shaikh · Accepted Answer · 2015-05-05 09:10:12Z

2

$data = DB::table('product')->join('bookings','bookings.product_id','=','product.id')->get();
if($data->created_at > 7){
  return 1;
}else{
  return 0;
}

Here is the query which will work for you

answered May 5, 2015 at 9:10

Sameer Shaikh

7,8642 gold badges19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Paul Over a year ago

This query seems to work but whenever i try to reference this in the blade view i get a Trying to get property of non-object error. In the blade view i have the if statement. The query is contained in my routes file and passes into the page where im trying to reference it

Sameer Shaikh Over a year ago

first of all writing a query in route is a super bad practice.what you wanna do is create a controller point your route to a function of that controller write the above code in the function and pass the data to the view using with.

Paul Over a year ago

i know but i can pass other variables through this and it isn't a problem. i just need it to reference the right field from the table but it is saying there is no object of any field name returned. is there any way i can check what the query returns?

Sameer Shaikh Over a year ago

before the if statement do this echo '<pre>'; print_r($data->toArray()); echo '<pre>'; exit;

Marco · Accepted Answer · 2015-05-05 10:05:13Z

1

Assumption:- you wanted to write booking.product_id = product_id If my assumption is correct below answer might help you.

with temp as(
Select * from bookings where
bookings.product_id = product_id)
select case when temp.created_at > 7 then 1 else 0
        end as comparison
from temp;

Let me know if my assumption was incorrect so that I can give you right answer.

edited May 5, 2015 at 10:05

Marco

24.1k13 gold badges81 silver badges132 bronze badges

answered May 5, 2015 at 9:09

Swati Joshi

711 silver badge8 bronze badges

Collectives™ on Stack Overflow

Join queries in Laravel

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related