From: dzyszla at dzyszla dot aplus dot pl
Operating system: Linux
PHP version: 5.2.6
PHP Bug Type: MySQLi related
Bug description: bind_param and wrong result
Description:
------------
My webserver provider changed the mysqli module to the newest version (I
don't wont, what number). And my code with mysqli_stmt_bind_param dosen't
work correctly, but i get no error message (by mysqli_stmt_error after each
command too). I do something wrong?
Reproduce code:
---------------
$stmt=mysqli_stmt_init($sql);
if(mysqli_stmt_prepare($stmt,'SELECT COUNT(*) FROM posts WHERE
`parent`=?'))
{
$parent=1;
if (mysqli_stmt_bind_param($stmt,'i',$parent)) echo 'OK'; else echo
'FALSE';
if (mysqli_stmt_bind_result($stmt,$enters)) echo 'OK'; else echo
'FALSE';
if(mysqli_stmt_execute($stmt)) echo 'OK'; else echo 'FALSE';
if (mysqli_stmt_fetch($stmt)) echo 'OK'; else echo 'FALSE';
echo $enters;
}
mysqli_stmt_close($stmt);
Expected result:
----------------
OKOKOKOK0
Actual result:
--------------
OKOKOKOK161
--
Edit bug report at http://bugs.php.net/?id=46221&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=46221&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=46221&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=46221&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=46221&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=46221&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=46221&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=46221&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=46221&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=46221&r=support
Expected behavior: http://bugs.php.net/fix.php?id=46221&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=46221&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=46221&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=46221&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=46221&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=46221&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=46221&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=46221&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=46221&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=46221&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=46221&r=mysqlcfg
