Laravel considering variable as column name in query builder

Question

I am using laravel 5.5 and checking event checking if slot available between 2 times using this query:

$schedules->where('id', $id)
                ->wherebetween($date, ['start','end'])
                ->orwherebetween($endTime, ['start','end'])
                ->orwherebetween('start', [$date,$endTime])
                ->orderBy('start')->get();

getting this error

"message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column '2019-03-06 13:00:00' in 'where clause'

Use whereRaw()

M Khalid Junaid
– M Khalid Junaid

2019-03-08 05:34:14 +00:00
Commented Mar 8, 2019 at 5:34 — M Khalid Junaid
– M Khalid Junaid, Commented Mar 8, 2019 at 5:34

Kapitan Teemo · Accepted Answer · 2019-03-08 06:05:25Z

2

its because the 1st parameter should be the name of the column:

you should change your code to:

->wherebetween('column name', ['1st date','2nd date'])
->orwherebetween('column name', ['1st date','2nd date'])

answered Mar 8, 2019 at 6:05

Kapitan Teemo

2,1641 gold badge15 silver badges26 bronze badges

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

Comments

Huzoor Bux · Accepted Answer · 2019-03-08 10:12:39Z

-1

I have fixed that by adding DB::raw() read more

$schedules->where('id', $id)
                ->wherebetween(DB::raw($date), ['start','end'])
                ->orwherebetween(DB::raw($endTime), ['start','end'])
                ->orwherebetween('start', [$date,$endTime])
                ->orderBy('start')->get();

answered Mar 8, 2019 at 10:12

Huzoor Bux

1,0484 gold badges23 silver badges46 bronze badges

1 Comment

George Smith Nov 20 at 13:22

Unless you have columns names as dates I'm pretty much sure you can just keep the last orWhereBetween (changed to whereBetween) and have the same result

Collectives™ on Stack Overflow

Laravel considering variable as column name in query builder

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related