note 109601 added to mysqli.error
| From: | jamesOnPhp at donjaime dot de | Date: | Wed, 01 Aug 2012 10:52:51 +0000 |
| Subject: | note 109601 added to mysqli.error | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-189557@lists.php.net to get a copy of this message | ||
When using prepared statements, the error and errno are reset/deleted when there is no longer any
pointer to the prepared statement. For example, this:
<?php
$DB = new mysqli(....);
$DB -> prepare('garbage');
$errors[] = $DB ->error;
$stmt = $DB -> prepare('garbage');
$errors[] = $DB ->error;
$user = getUser();
if ($DB -> error) echo '<p>Server error getting user</p>';
$errors[] = $DB ->error;
function getUser(){
global $DB, $errors;
$stmt = $DB -> prepare('garbage');
$errors[] = $DB ->error;
}
var_dump($errors);
?>
outputs this:
array(4) {
[0]=>
string(0) ""
[1]=>
string(153) "You have an error in your SQL syntax; [...]"
[2]=>
string(153) "You have an error in your SQL syntax; [...]"
[3]=>
string(0) ""
}
I'm presuming this is a feature and not a bug.
----
Server IP: 69.147.83.197
Probable Submitter: 87.187.147.17
----
Manual Page -- http://www.php.net/manual/en/mysqli.error.php
Edit -- https://master.php.net/note/edit/109601
Del: integrated -- https://master.php.net/note/delete/109601/integrated
Del: useless -- https://master.php.net/note/delete/109601/useless
Del: bad code -- https://master.php.net/note/delete/109601/bad+code
Del: spam -- https://master.php.net/note/delete/109601/spam
Del: non-english -- https://master.php.net/note/delete/109601/non-english
Del: in docs -- https://master.php.net/note/delete/109601/in+docs
Del: other reasons-- https://master.php.net/note/delete/109601
Reject -- https://master.php.net/note/reject/109601
Search -- https://master.php.net/manage/user-notes.php