Hi guys,
I never can get mysql_insert_id?
Is this broken with PHP4?
Please let me know if you can get it to work. or work around.
Thanks.
--Clemson
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thursday 07 February 2002 23:08, Erik Price wrote:
> I have two questions:
I think the php-db list is more appropriate for these.
> 1. Can anyone tell me whether the following statement is true or false?
> The PHP function mysql_insert_id() differs from the MySQL function
> LAST_INSERT_ID() i
I have two questions:
1. Can anyone tell me whether the following statement is true or false?
The PHP function mysql_insert_id() differs from the MySQL function
LAST_INSERT_ID() in that the PHP function returns the last
auto-incremented value from the current connection, and the MySQL
function
Jimmy,
> > However it is also possible that in order to save time the LAST_ID
> > information is built into the resultset coming back from the INSERT -
> > thus when mysql_insert_id() is called PHP would not need to go back
> > to MySQL/last_insert_id().
>
> yes, what you said could be true also
Hi DL,
> ="session" is not the correct word/its use is potentially confusing
> (perhaps that's why it's in quotes?) - persistence refers to the
> continuing connection between PHP and MySQL.
yup, you're right.
session is not the correct word, but i can't find the
correct/easy word to subtitute s
Hi Jimmy,
> >> the only problem i can think of might occur with pconnect is,
> >> last_insert_id() will return you the last inserted ID from
> >> previous 'session', not current 'session'.
> >> to prevent this, you should call last_insert_id() only when
> >> your INSERT query executed succesfully
Hi mike,
last_insert_id() will return you the last inserted ID from
previous 'session', not current 'session'.
to prevent this, you should call last_insert_id() only when
your INSERT query executed succesfully.
>> Most probably the returned value would be wrong, because it wi
on 1/16/02 10:47 AM, Jimmy at [EMAIL PROTECTED] wrote:
> Hi DL,
>
>>> the only problem i can think of might occur with pconnect is,
>>> last_insert_id() will return you the last inserted ID from
>>> previous 'session', not current 'session'.
>>> to prevent this, you should call last_insert_id()
Hi DL,
>> the only problem i can think of might occur with pconnect is,
>> last_insert_id() will return you the last inserted ID from
>> previous 'session', not current 'session'.
>> to prevent this, you should call last_insert_id() only when
>> your INSERT query executed succesfully.
> =Of cour
Hi Jimmy,
> >> 2 because the (function argument) controlling feature is the
> >> connection, it is not possible for another concurrent user to
> >> 'steal' your ID or influence the ID returned to you - it's all
>
> > Ok, assume you are correct, but what if you are using persistent
> > connections
Hi Martin,
> > 2 because the (function argument) controlling feature is the connection, it is not
>possible for another
> > concurrent user to 'steal' your ID or influence the ID returned to you - it's all
>yours!
>
> Ok, assume you are correct, but what if you are using persistent
> connection
on 1/16/02 7:42 AM, Martin Wickman at [EMAIL PROTECTED] wrote:
> Dl Neil wrote:
>
>> 2 because the (function argument) controlling feature is the connection, it
>> is not possible for another
>> concurrent user to 'steal' your ID or influence the ID returned to you - it's
>> all yours!
>
> Ok,
Hi Martin,
>> 2 because the (function argument) controlling feature is the
>> connection, it is not possible for another concurrent user to
>> 'steal' your ID or influence the ID returned to you - it's all
> Ok, assume you are correct, but what if you are using persistent
> connections (ie pcon
Dl Neil wrote:
> 2 because the (function argument) controlling feature is the connection, it is not
>possible for another
> concurrent user to 'steal' your ID or influence the ID returned to you - it's all
>yours!
Ok, assume you are correct, but what if you are using persistent
connections (i
Hi Wee,
> Is it possible that I would get the wrong ID (Not the ID I just inserted in
> Auto_Increment field) by using mysql_insert_id function if someone is also
> inserting record at the same time? How does mysql_insert_id work accurately?
=A couple of things here:
1 if the field is defined
Hi Wee,
> Is it possible that I would get the wrong ID (Not the ID I just inserted in
> Auto_Increment field) by using mysql_insert_id function if someone is also
> inserting record at the same time? How does mysql_insert_id work accurately?
=A couple of things here:
1 if the field is defined
Hi,
Is it possible that I would get the wrong ID (Not the ID I just inserted in
Auto_Increment field) by using mysql_insert_id function if someone is also
inserting record at the same time? How does mysql_insert_id work accurately?
Thanks,
Wee
--
PHP General Mailing List (http://www.php.net/)
T
In my code I have a few places where I use mysql_pconnect to open a
persistant database connection to mysql in order to reduce overhead. I also
use mysql_insert_id to fetch insert ids for various insert commands.
Since mysql_pconnect uses the SAME database connection between my php
scripts..
post your code.
- Original Message -
From: "lizlynch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 29, 2001 4:32 AM
Subject: [PHP] mysql_insert_id. need help!
hi,
i have three tables:
customer
username
classification
the user will enter
hi,
i have three tables:
customer
username
classification
the user will enter my web site enter the relevant customer details (which are
transfered to the database) (s)he will then enter their prefered username, password
and a password hint (again all sent to the database). once they are regis
hi,
i have three tables:
customer
username
classification
the user will enter my web site enter the relevant customer details (which are
transfered to the database) (s)he will then enter their prefered username, password
and a password hint (again all sent to the database). once they are regis
On 07-Jul-01 Chris Lambert - WhiteCrown Networks wrote:
> I've used integer on many occasions with auto_increment, and have had no
> problems. mysql_insert_id() returns the unique identifyer of the last record
> inserted with mysql_query(). I'm not sure what "MySQL function" you're
> referencing
turday, July 07, 2001 4:41 PM
Subject: [PHP] mysql_insert_id()
| I have been reading about this function and I have a question. The PHP
| manual warns about using it if your AUTO_INCREMENT ID field is a BIGINT.
I
| am using type INTEGER. Am I okay with this one, or should I use the MySQL
| functi
I have been reading about this function and I have a question. The PHP
manual warns about using it if your AUTO_INCREMENT ID field is a BIGINT. I
am using type INTEGER. Am I okay with this one, or should I use the MySQL
function.
John Meyer
[EMAIL PROTECTED]
Programmer
If we didn't have Mi
> When I go from using mysql_insert_id() with the module to using it with
> PHP as CGI it fails because I always provide a link identifier as the
> argument.
>
> When I remove the link identifier it works again.
>
> But that seems risky to me. If I have concurrent users couldn't one
> user finish
When I go from using mysql_insert_id() with the module to using it with
PHP as CGI it fails because I always provide a link identifier as the
argument.
When I remove the link identifier it works again.
But that seems risky to me. If I have concurrent users couldn't one
user finish a query, anot
> Instead of checking if(!$id), perhaps you would be better off to check the
> result of your query (which in this example was successful, since you got
> a return from mysql() ).
I am. I just didn't include it in my previous message as it as I was trying
to
keep extraneous code down to a mini
hp (E-mail)
Subject: RE: [PHP] mysql_insert_id()
> You probably stated this in your previous post, but what is
> the result from your call to mysql() ? Is this call failing so
> that when you get to mysql_insert_id(), the id doesn't exist?
I did. It's returning a numerical one
> You probably stated this in your previous post, but what is
> the result from your call to mysql() ? Is this call failing so
> that when you get to mysql_insert_id(), the id doesn't exist?
I did. It's returning a numerical one (1).
What I'm doing now is as follows. It's getting me the val
-
From: Boget, Chris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 4:20 PM
To: 'Sam Masiello'; Php (E-mail)
Subject: RE: [PHP] mysql_insert_id()
> When you are using mysql_insert_id, you don't want to pass it
> the result of your previous SQL statement as in:
&
> When you are using mysql_insert_id, you don't want to pass it
> the result of your previous SQL statement as in:
> $result = mysql"mydb", "My SQL statement", $my_connect) ;
> $last_id = mysql_insert_id($result)
This is what it sounds like it's looking for in the documentation. It
could be jus
ent: Wednesday, January 24, 2001 3:50 PM
To: Php (E-mail)
Subject:[PHP] mysql_insert_id()
I'm having intermittent problems with this function.
Most of the time, it returns the proper value. However,
sometimes it doesn't return anything at all even when
the insert query executes w
I'm having intermittent problems with this function.
Most of the time, it returns the proper value. However,
sometimes it doesn't return anything at all even when
the insert query executes without error and I can see the
new data in the database. I try to get the last insert id
both by supplying
33 matches
Mail list logo