[SOLVED] How to know what ID of the insertObject was

[rand486]

I'm afraid this may be a dumb question, but I'll ask anyway.

I noticed that the call $db->insertObject() returns a void. Is there an easy way to know what the id (primary key) it created was?

Example: I have a function that creates an article in jos_content, and I want to know what the ID was of the article I just created.

I'm afraid if I query the most recently created article on a very busy server that it will pull a different article by chance on occasion. Or by sheer chance, two articles are created at the same date and time (down to the second). Hey, accidents happen.

[mokelly]

Here is a way to do it. http://help.joomla.org/content/view/716/60/ Sometimes the mysql_insert_id() will work but it is always best to use the Joomla framework.

[rand486]

Awesome, thanks. I'll mark this solved.

Just to be 100% sure though, this means it will get the record I JUST entered, right?

To explain, there's no way the following could happen?

1) this php script (Instance A) is run, enters the record.
2) Another user runs the same script (Instance B), entering another record
3) Instance A now hits insertID() but returns the ID of the record created by Instance B.

The (pseudo)code would be like the following:

Code: Select all

$database->insertObject( '#__users', $user, 'id' );

//Is there a possibility a second instance of this script will run and insertObject() another record here?

return $database->insertID();

[mokelly]

I believe as long as you use the Joomla framework you are safe. I think Joomla uses the session variables to identify the user and keep track of these types of variables by user.

[rand486]

Oh that's right, I totally forgot. My paranoia of threading was pointless. Thanks again!

[tim92109]

Typical Joomla forum. This has been solved? Why? Because it has a link to a page that Joomla removed? TYPICAL.