|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2010-01-12 00:11 UTC] lodeclaassen at gmail dot com
Description:
------------
I open a mysqli connection that failes (in the tested case wrong password). After that when I try to get the affected rows (mysqli->affected_rows) PHP exits and I only get a blank screen.
The configure command from phpinfo:
'./configure' '--with-apxs2' '--with-curl=/usr/local/lib' '--with-gd' '--enable-gd-native-ttf' '--with-ttf' '--with-gettext' '--with-jpeg-dir=/usr/local/lib' '--with-freetype-dir=/usr/local/lib' '--with-kerberos' '--with-openssl' '--with-mcrypt' '--with-mhash' '--with-mysql=/usr/local/mysql' '--with-mysqli=/usr/local/mysql/bin/mysql_config' '--with-pdo-mysql=/usr/local/mysql' '--with-pear' '--with-png-dir=/usr/local/lib' '--with-zlib' '--with-zlib-dir=/usr/local/lib' '--enable-zip' '--with-iconv=/usr/local' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-mbstring'
Other settings I don't know, I don't operate the host.
Reproduce code:
---------------
<?php
echo 'startup<br />';
if (isset($_GET['try']) && $_GET['try'] == 1) {
$connection = new mysqli('localhost', 'user', 'wrong password', 'SomeExistingTable');
$connection->query("SELECT `id` FROM `SomeExistingTable` LIMIT 1");
echo 'affected rows: '.$connection->affected_rows.'<br />';
}
echo 'ending<br />';
?>
Expected result:
----------------
If I request the file with ?try=0 I expect:
startup
ending
When I request ?try=1 I get nothing, a blank screen.
Actual result:
--------------
With ?try=1 I expect to see:
startup
affected rows:
ending
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Oct 25 02:00:01 2025 UTC |
Fixed in 5.3. Can reproduce in 5.2. A simple fix for this might be Index: ext/mysqli/mysqli_prop.c =================================================================== --- ext/mysqli/mysqli_prop.c (revision 293046) +++ ext/mysqli/mysqli_prop.c (working copy) @@ -162,7 +162,7 @@ mysql = (MY_MYSQL *)((MYSQLI_RESOURCE *)(obj->ptr))->ptr; - if (!mysql) { + if (!mysql || !mysql->mysql) { ZVAL_NULL(*retval); } else { CHECK_STATUS(MYSQLI_STATUS_VALID); Untested and other properties might be affected - might be better to backport the fix from 5.3.