how to pass the query result to the view? Laravel

Question

I can not get the result of such a request:

$performance = DB::select("SELECT ROUND(TIME_TO_SEC(timediff(NOW(), date_finish))/60) FROM tickets WHERE id = ?", [$id]);

the result comes in the form of an array:

array:1 [
 0 => {#1385 
  +"ROUND(TIME_TO_SEC(timediff(NOW(), date_finish))/60)": "299"
 }
]

Nima Tf · Accepted Answer · 2021-10-15 18:57:05Z

2

Thats becouse your not included get() in end of your code. Replace this:

$performance = DB::select("SELECT ROUND(TIME_TO_SEC(timediff(NOW(), date_finish))/60) FROM tickets WHERE id = ?", [$id])->get();

with this:

$performance = DB::select("SELECT ROUND(TIME_TO_SEC(timediff(NOW(), date_finish))/60) FROM tickets WHERE id = ?", [$id]);

answered Oct 15, 2021 at 18:57

Nima Tf

711 silver badge9 bronze badges

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

5 Comments

lev_ Over a year ago

now wrote the request correctly $performance = DB::table('tickets')->selectRaw('ROUND(TIME_TO_SEC(timediff(NOW(), date_finish))/60)')->where('id', $id)->get(); but still the result is output as an array

lev_ Over a year ago

Nima Tf Over a year ago

May I ask what your query does?

lev_ Over a year ago

this query gets the difference between the dates of the given string

Nima Tf Over a year ago

Did you tried whereBetween? Look at this link too stackoverflow.com/a/33361741/13661216

Collectives™ on Stack Overflow

how to pass the query result to the view? Laravel

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related