I'm using CodeIgniter, and I have to insert an ID in my table, but it doesn't work, I made this :
$this->db->insert('mytable', $data);
$id = $this->db->insert_id();
-
2do you have the table configured to have a primary key that auto increments?Rooster– Rooster2013-03-21 17:01:23 +00:00Commented Mar 21, 2013 at 17:01
-
1Can you update your question to include the value of $data.Seain Malkin– Seain Malkin2013-03-21 17:26:15 +00:00Commented Mar 21, 2013 at 17:26
Add a comment
|
2 Answers
it's fixed, I just forgot to use auto_increment in my ID column. Thank you ;)
Comments
this works normally for me:
function insert($data){
$this->db->insert('users',$data);
return $this->db->insert_id();
}
you have to set your ID field to AUTO INCREMENT and be sure $data is an associative array, like:
$data = array(
'db_field'=>'value'
);
