Welcome Guest, Not a member yet? Register   Sign In
Codeigniter 4 like query issue
#1

I am not sure that having issue in CodeIgniter 4 or not but I am getting issue to show two times db prefix in query while I use Like. Following is my query. mysqli_sql_exception #1054

$order_status_ids = [14, 21];
$builder = $this->db1->table('order');
$builder->join('order_product', 'order.order_id = order_product.order_id','LEFT');
$builder->Like('order_product.name', $_GET['query']);
$builder->whereIn('order.order_status_id', $order_status_ids);
$query = $builder->get();
return $query->getResultArray();

Showing query like as below. "ssiegel_" is my db prefix. I am using multi database connection. As you can see that adding two times prefix in like condition [ssiegel_``ssiegel_order_product.name LIKE ]

SELECT * FROM ssiegel_order LEFT JOIN ssiegel_order_product ON ssiegel_order.order_id = ssiegel_order_product.order_id WHERE ssiegel_``ssiegel_order_product.name LIKE '%Apple Fiber Powder%' ESCAPE '!' AND ssiegel_order.order_status_id IN (14,21)

Any one have solution for this issue or any updates in CodeIgniter 4 to update library. 

Thanks in advance!
Reply


Messages In This Thread
Codeigniter 4 like query issue - by versioningsolutions - 12-21-2022, 06:17 AM
RE: Codeigniter 4 like query issue - by kenjis - 12-22-2022, 02:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB