mysql - 这是我面临的这个问题，传递给 Illuminate\Database\Connection::prepareBindings() 的参数 1 必须是数组类型，给定 null

Question

这是我得到的错误：

    $order_items = DB::select("SELECT i.`id`,i.`chef_id`,i.`selected_date_type`,i.`delivery_date`, REPLACE(REPLACE(TRIM(g.items), ' ', ' '), ' ', ', ') AS collection_items ,
                    CONCAT(chef_address.latitude,", ",chef_address.longitude) AS source_address,CONCAT(customer_address.latitude,", ",customer_address.longitude) AS destination_address 
                        FROM order_item i INNER JOIN ( SELECT `delivery_date`,`selected_date_type`,`chef_id`,`order_id`, GROUP_CONCAT(`id` SEPARATOR ' ') AS items 
                            FROM order_item GROUP BY `delivery_date`, `selected_date_type`, `chef_id`,`order_id` ) g ON g.`delivery_date` = i.`delivery_date` AND g.`selected_date_type` = i.`selected_date_type` AND g.`chef_id` = i.`chef_id` AND g.`order_id`= i.`order_id`
                                inner join `orders` on `orders`.`id` = i.`order_id` inner join `user_address` as `customer_address` on `customer_address`.`id` = `orders`.`address_id` 
                                    inner join `user_address` as `chef_address` on `chef_address`.`user_id` = i.`chef_id` WHERE i.`order_id` = ( ? )",[$orderCart->id]);

此查询在我的数据库中运行良好，但在 laravel 中无法正常工作！

标签： mysqllaravel