Welcome Guest, Not a member yet? Register   Sign In
Question about ActiveRecords - mysql_insert_id()
#1

[eluser]Harshadewa[/eluser]
In a multi-user environment, if we use $this->db->insert_id() (CodeIgniter ActiveRecord) to retrieve the id value of last inserted row, is there a chance of getting an ID of a different db session?

According to the MySQL spec, they say;

"The value of mysql_insert_id() is affected only by statements issued within the current client connection. It is not affected by statements issued by other clients."

So, is it same with the CodeIgniter's ActiveRecord $this->db->insert_id() ?

Is there a chance of 2 or more users who are inserting records to the same table, would get wrong last insert id's?

Does CodeIgniter Active Records maintain unique db sessions for its concurrent users?


Messages In This Thread
Question about ActiveRecords - mysql_insert_id() - by El Forum - 08-09-2010, 03:17 AM
Question about ActiveRecords - mysql_insert_id() - by El Forum - 08-09-2010, 04:23 AM
Question about ActiveRecords - mysql_insert_id() - by El Forum - 08-09-2010, 04:32 AM



Theme © iAndrew 2016 - Forum software by © MyBB