Hi all,
I'm a newbie in PHP, and I want to know what's the best technique you
guys use when you need to get the id of the last inserted value in the
database.
My first thought is to do a SELECT on the db and get the last id, but I
know that if I have two almost simultaneous connections I
On Fri, July 20, 2007 1:10 pm, Marcelo Wolfgang wrote:
I'm a newbie in PHP, and I want to know what's the best technique you
guys use when you need to get the id of the last inserted value in the
database.
My first thought is to do a SELECT on the db and get the last id, but
I
know that if
One easy solution would be to get the ID before you do the insert
i.e. in Oracle you would run the query:
select some_id_generating_seq.nextval from dual
and then you would use that id to insert and you would know the id after
that...and the DB would take care of locking and such.
So, check
However, wouldn't obtaining the id in that manner still possibly lead to
duplication? The DB would take care of the locking on the inserts, but the
inserts would be populated from a non-locking select, right? Which means
that, with two similar transactions getting ready to occur, you could end
im not sure, but i think you still want to surround the insert and the db
specific call to get the
last insert id within a transaction.
-nathan
On 7/20/07, Uber Wannabe [EMAIL PROTECTED] wrote:
However, wouldn't obtaining the id in that manner still possibly lead to
duplication? The DB would
On Fri, July 20, 2007 2:07 pm, Uber Wannabe wrote:
However, wouldn't obtaining the id in that manner still possibly lead
to
duplication? The DB would take care of the locking on the inserts,
but the
inserts would be populated from a non-locking select, right? Which
No.
In the case of
On Fri, July 20, 2007 2:42 pm, Nathan Nobbe wrote:
im not sure, but i think you still want to surround the insert and the
db
specific call to get the
last insert id within a transaction.
ID generation and uniqueness thereof is SOOO common, that most (all?)
the DBs support it without wrapping
On Friday 20 July 2007 21:10:28 Marcelo Wolfgang wrote:
Hi all,
I'm a newbie in PHP, and I want to know what's the best technique you
guys use when you need to get the id of the last inserted value in the
database.
My first thought is to do a SELECT on the db and get the last id, but I
8 matches
Mail list logo