Parameters errors in Laravel

Question

I'm facing Invalid parameter number: parameter was not defined

It's because of this ?

and

  (
     (orders.hour_begin >= :begin_hour and orders.hour_final <= :hour_final )
     or 
     (orders.hour_begin <= :begin_hour and orders.hour_final > :hour_final  )
     or 
     (orders.date_final > :hour_final and orders.hour_final <= :hour_final  )
     or 
     (orders.hour_begin >= :begin_hour and orders.hour_final <= :hour_final )
     )

I define the same parameter in the array

array('begin_hour' => $begin_hour, 'hour_final' => $hour_final)

score 5 · Answer 1 · answered Jan 19 '18 at 17:07

5

You need to bind 8 separate parameters, even if the values are the same;

answered Jan 19 '18 at 17:07

vpalade

1,427
1
16
20

1

is there a reason for this horrible drawback, does anyone know? – raveren Mar 26 '19 at 06:20

score 0 · Answer 2 · answered Jan 19 '18 at 16:54

0

This looks like the PDO parameters list is not matching with the parameters in the query. Try to ensure that the parameters list and parameters passed to the statement execute both have the same number of parameters.

This is a similar problem "Invalid parameter number: parameter was not defined" Inserting data

answered Jan 19 '18 at 16:54

Amit Chandrashekar Singh

363
4
16

i'm using laravel – Jan 19 '18 at 16:56
Laravel uses PDO internally. Perhaps this is a closer question, https://stackoverflow.com/questions/33526391/laravel-invalid-parameter-number-parameter-was-not-defined – Amit Chandrashekar Singh Jan 19 '18 at 16:58

Parameters errors in Laravel

2 Answers2

Linked