• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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?

#2
[eluser]mddd[/eluser]
Yes this is the same because CodeIgniter uses the mysql functions in the background.
Besides, the Mysql server will not give you an id that was inserted for another connection than your own.
So you can safely use this. It will never give you 'some one else's' id.

#3
[eluser]Harshadewa[/eluser]
mddd,
Thank you for the reply!


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.