note 78117 deleted from function.mysqli-insert-id by jani
| From: | jani@php.net | Date: | Mon, 15 Oct 2007 10:08:26 +0000 |
| Subject: | note 78117 deleted from function.mysqli-insert-id by jani | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-131391@lists.php.net to get a copy of this message | ||
Note Submitter: dizyn at hotmail dot com
----
I tired with stored procedures and it did not worked out.
here is what i tried:
$mysqli = connection1();
$mysqli->autocommit(FALSE);
$user = "call insert_user('hello', 'mypass','myemail')";
$mysqli->query($user);
printf ("New Record has id %d.\n", $mysqli->insert_id);
$mysqli->commit();
exit;
Output:
New Record has id 0.
which is not correct, may be problem is with stored procedures.