#36919 [Opn->Asn]: Strange MySQLi Behaviour

From: Date: Thu, 30 Mar 2006 09:07:22 +0000
Subject: #36919 [Opn->Asn]: Strange MySQLi Behaviour
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-95108@lists.php.net to get a copy of this message 
 ID:               36919
 Updated by:       tony2001@php.net
 Reported By:      antimon at gmail dot com
-Status:           Open
+Status:           Assigned
 Bug Type:         MySQLi related
 Operating System: Win32
 PHP Version:      5.1.2
-Assigned To:      
+Assigned To:      georg


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

[2006-03-30 10:59:59] antimon at gmail dot com

Tried latest win32 snapshot. Same results. BTW, store_result() call
crashes on TEXT fields i think. Not sure.

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

[2006-03-30 10:22:47] tony2001@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip



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

[2006-03-30 02:00:32] antimon at gmail dot com

Description:
------------
Hi,
I use apache 2.0.55 with php 5.1.2. And this is my simple php source:

$m = mysqli_connect("localhost", "root", "253263",
"dictsite");
$st = $m->prepare($sql);

$p = "page ismi";
$st->bind_param("s", $p);
$st->execute();

$st->bind_result($c1, $c2, $c3, $c4, $c5);

while ($st->fetch()) {
print_r($c1);
}

This runs ok. But if i add
$sp->store_result(); after execute call, it causes apache to restart
itself noting this:
"[Thu Mar 30 02:53:15 2006] [notice] Parent: child process exited with
status 0 -- Restarting."

One other issue is the known multiple recordsets returned from stored
procedure queries.

So, i used the latest libmysql from mysql distro, it did not even
pushed any variables to bind_result parameters.

And i used mysqli and libmysql from
"http://dev.mysql.com/downloads/connector/php/"
and eveything works
fine. (http://bugs.mysql.com/bug.php?id=14993 is fixed too)



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


-- 
Edit this bug report at http://bugs.php.net/?id=36919&edit=1

Thread (5 messages)

« previous php.bugs (#95108) next »