While executing search query with CodeIgniter 4 the dB prefix appended two times.
below is the query
SELECT `db_deposit`.`id`, `db_deposit`.`member_no`, `date_of_seed`, `db_member`.`name`, `amount_planted_week`, `harvest_date`, `db_admin`.`firstname`, `db_admin`.`lastname` FROM `db_deposit` LEFT JOIN `db_admin` ON `db_admin`.`admin_id`=`db_deposit`.`added_by` LEFT JOIN `db_member` ON `db_member`.`id`=`db_deposit`.`member_id` WHERE (`db_``db_deposit`.`id` LIKE '%ddd%' ESCAPE '!' OR `db_``db_deposit`.`member_no` LIKE '%ddd%' ESCAPE '!' OR `amount_planted_week` LIKE '%ddd%' ESCAPE '!' OR `db_``db_admin`.`firstname` LIKE '%ddd%' ESCAPE '!' ) ORDER BY `db_deposit`.`id` DESC LIMIT 10
Code is something like this,
if ($request['search']['value'] != '') {
$builder->groupStart();
for ($i = 0; $i < count($datatable_fields); $i++) {
if ($request['columns'][$i]['searchable'] == true) {
$builder->orLike($datatable_fields[$i], $request['search']['value']);
}
}
$builder->groupEnd();
}
Can anyone help me with this!