#46221 [Opn]: bind_param and wrong result
| From: | dzyszla at dzyszla dot aplus dot pl | Date: | Thu, 02 Oct 2008 18:28:47 +0000 |
| Subject: | #46221 [Opn]: bind_param and wrong result | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-129427@lists.php.net to get a copy of this message | ||
ID: 46221
User updated by: dzyszla at dzyszla dot aplus dot pl
Reported By: dzyszla at dzyszla dot aplus dot pl
Status: Open
Bug Type: MySQLi related
Operating System: Linux
PHP Version: 5.2.6
New Comment:
sorry, I replaced expected and actual result above. Now is: OKOKOKOK0,
and I expect: OKOKOKOK161
Previous Comments:
------------------------------------------------------------------------
[2008-10-02 18:25:58] dzyszla at dzyszla dot aplus dot pl
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 this bug report at http://bugs.php.net/?id=46221&edit=1