How to delete an array present inside where_in condition in codeigniter?

Question

I have where_in condition $this->db->where_in('student_id',$arr); Now I want to delete the contents present in $arr from a table using this code $this->db->delete('top_students'); But I got a database error

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 DELETE FROM top_students WHERE student_id IN()"

How to solve this?

i think `$arr` is empty - check your values... – Atural Aug 14 '18 at 11:11 — Atural, Aug 14 '18 at 11:11
The SQL clearly shows that `$arr` is empty. – asprin Aug 14 '18 at 11:12 — asprin, Aug 14 '18 at 11:12

Pradeep · Accepted Answer · 2018-08-14T11:11:31.013

1

Hope this will help you :

Check for empty like this ;

if ( ! empty($arr))
{
   $this->db->where_in('student_id',$arr);
   $this->db->delete('top_students'); 
}

For more : https://www.codeigniter.com/user_guide/database/query_builder.html#deleting-data

edited Aug 14 '18 at 11:11

answered Aug 14 '18 at 11:10

Pradeep

9,667
13
27
34

isn't that exactly what OP is doing ? – Atural Aug 14 '18 at 11:10
Actually $arr is not empty, Sometimes it will be empty if I have not assigned students into my top_students table. AT that time I am getting this error. Thanks for the help – Dishi Aug 14 '18 at 11:22
is my answer helps you? – Pradeep Aug 14 '18 at 11:54
Yes. Thankyou @pradeep – Dishi Aug 14 '18 at 12:27

How to delete an array present inside where_in condition in codeigniter?

1 Answers1