Mumpo Mumpo - 1 year ago 121
PHP Question

Syntax error with single quotes in Laravel 5 Eloquent Query Builder

I've been trying to write a massive

query with a
clause, and I've found that Laravel 5.3 Eloquent Query Builder makes a syntax error.

The query is the following:

$query = $this->model
->where('state', "pending")
->whereRaw('created_at <= NOW() - INTERVAL 12 HOUR')
->update(['state' => "timeout"]);

Which is translated to this:

update `orders`
set `state` = timeout, `updated_at` = 2016-09-21 21:47:39
where `state` = pending and created_at <= NOW() - INTERVAL 12 HOUR

This query keeps failing since the values for the columns
are not written with single quotes.

How can I force Laravel to write to put the single quotes correctly?

Answer Source

Maybe try where('created_at', DB::raw('NOW() - ..'));

And why are you putting peding in single quotes? Laravel escapes values automatically.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download