#46221 [Fbk->Opn]: bind_param and wrong result

From: Date: Mon, 27 Oct 2008 19:12:26 +0000
Subject: #46221 [Fbk->Opn]: bind_param and wrong result
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-130222@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:           Feedback
+Status:           Open
 Bug Type:         MySQLi related
 Operating System: Linux (CentOS 5.2)
 PHP Version:      5.2.6
 New Comment:

Because problem is on public server, my web service provider sad, that
can't test any unofficial version. :(


Previous Comments:
------------------------------------------------------------------------

[2008-10-26 17:49:29] felipe@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/

I can't reproduce it.

------------------------------------------------------------------------

[2008-10-02 19:50:15] dzyszla at dzyszla dot aplus dot pl

(updated information about OS)
(one more correct: I wrote: "don't wont", of course will be: "don't
know" ;) eh, my language...)
bind_result work 100% good. Before update this script work correctly.

------------------------------------------------------------------------

[2008-10-02 18:28:47] dzyszla at dzyszla dot aplus dot pl

sorry, I replaced expected and actual result above. Now is: OKOKOKOK0,
and I expect: OKOKOKOK161

------------------------------------------------------------------------

[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

Thread (6 messages)

« previous php.bugs (#130222) next »