How to run delete query in Codeigniter. I have set of array and a key. In MySQL my query run perfectly.
DELETE FROM `TABLE` WHERE `style_id`=2 && `ID` NOT IN (5,9,12)
In Codeigniter how to write and run this query. I tried below code but not working.
$ids = '5,9,12';
$this->db->where('style_id', $style_id)->where_not_in('ID', $ids);
$this->db->delete('TABLE');
Try this: you must have $ids as array
$ids = array(5,9,12);
$style_id= 2;
$this->db->where('style_id', $style_id);
$this->db->where_not_in('ID', $ids);
$this->db->delete('TABLE');
-> in $this->db->->where_not_in('ID', $ids);
You can write this in single line if you want to like this:
$this->db->delete('table name',array('field1'=>'value1','field2 !='=>'value2'));
short and simple.
Try this
this->db->where('style_id', $style_id);
this->db->where_not_in('ID', $ids);
$this->db->delete('TABLE');
This will join two arguments with AND clause
And Data should be
array
$ids = array(10, 20, '30);
Id
$style_id = 15;
$this->db->where('style_id', $style_id)->where_not_in('ID', $ids); this will bid dta with OR clauseYou can run this directly :
DELETE FROM `TABLE` WHERE `style_id`=2 && `ID` NOT IN (5,9,12)
in $this->db->query("DELETE FROM `TABLE` WHERE `style_id`=2 && `ID` NOT IN (5,9,12)");
// Try it
$ids = array(5,9,12);
$style_id =2;
$this->db->where('ID', $style_id);
$this->db->where_not_in('ID', $ids);
$this->db->delete('TABLE');
