Laravel - Invalid parameter number: parameter was not defined

Wednesday, November 4, 2015

On Laravel, why do I get an error




Invalid parameter number: parameter was not defined




I have included all parameters.



When I tested directly on PHPMyAdmin, it work fine.



Code:



$results = \DB::select('SELECT client_id,
date_format(start_date,"%d/%m/%Y") as start_date,
date_format(end_date,"%d/%m/%Y") as end_date,
first_name, last_name, phone, postcode
FROM hire INNER JOIN client ON client.id = hire.client_id
where ((:sdate between start_date and end_date OR :edate between start_date and end_date) OR (:sdate <= start_date and end_date <= :edate)) AND car_id = :car_id', [
'sdate' => $start_date,
'edate' => $end_date,
'car_id' => $car_id
]
);


Variable example:



$start_date = $inputs['start_date'];  //2015-10-27
$end_date = $inputs['end_date']; //2015-10-27
$car_id = $inputs['car_id']; //5

0 comments:

Post a Comment