Bug #54444 [Opn->Bgs]: Multiple Queries on a single conenction
Edit report at http://bugs.php.net/bug.php?id=54444&edit=1
ID: 54444
Updated by: uw@php.net
Reported by: peter dot colclough at toolstation dot com
Summary: Multiple Queries on a single conenction
-Status: Open
+Status: Bogus
Type: Bug
Package: MySQLi related
Operating System: Ubuntu 10 64 bit
PHP Version: 5.3SVN-2011-04-01 (SVN)
Block user comment: N
Private report: N
New Comment:
You can answer this question yourself by adding a bit of error handling
to your script such as ...
$mysqli = new mysqli("localhost", "root", "root", "test");
$stmt1 = $mysqli->prepare("SELECT 1 AS _one FROM DUAL");
$stmt2 = $mysqli->prepare("SELECT 2 AS _two FROM DUAL");
if (!$stmt1->execute() || !($meta1 = $stmt2->result_metadata()))
printf("[001] [%d] %s\n", $stmt1->errno, $stmt1->error);
if (!$stmt2->execute() || !($meta2 = $stmt2->result_metadata()))
printf("[002] [%d] %s\n", $stmt2->errno, $stmt2->error);
... and the answer is:
[002] [2014] Commands out of sync; you can't run this command now
Previous Comments:
------------------------------------------------------------------------
[2011-04-01 16:13:48] peter dot colclough at toolstation dot com
Description:
------------
Hi, trying to build a generic DB object handler for mySqli, and have hit
an issue where we can't have more than one open query on the same
connection. Is this a bug or 'expected behaviour'?
Looking at the mysqli.c source code, it looks like it should have been
possible, but it looks like the second object overwrites the first...
I have put a sample snippet below of what I am trying to achieve.... if
this helps.
Any help greatly appreciated....
OS: 2.6.32-21-generic #32-Ubuntu SMP Fri Apr 16 08:09:38 UTC 2010 x86_64
GNU/Linux
PHP Version => 5.3.2-1ubuntu4.5
Test script:
---------------
-------------- Code Snippet -----------------------------
$sqlstock = 'select foo1 from bar1 where foo1 =?';
$sqltime = 'select foo2, foo3 from bar2 where foo4 =?';
$varinp = "XXXXXXXXXXXX";
$abindVars = array(0=>$varinp);
$varProd = '';
$conn = dbi->db_conn;
$sprod = '';
$timestart = microtime_float();
// Get a statement
$aRes = array();
$aRes2 = array();
// Init 2 Statements
$stmt = mysqli_stmt_init($conn);
$stmt2 = mysqli_stmt_init($conn);
// Prepare 2 statements
mysqli_stmt_prepare($stmt,$sqlstock);
mysqli_stmt_prepare($stmt2,$sqltime);
// Set the bind variable
$varinp = "PXX00019263";
// Bind the statements
mysqli_stmt_bind_param($stmt,'s', &$varinp);
mysqli_stmt_bind_param($stmt2,'s', &$varinp);
// Execute - Second one fails
mysqli_stmt_execute($stmt);
mysqli_stmt_execute($stmt2);
// Set up field Defs
$aFieldDefs = array();
$aFieldDefs2 = array();
// Get result Metadata
$result = mysqli_stmt_result_metadata($stmt);
$result2 = mysqli_stmt_result_metadata($stmt2);
$nCount = 0;
while($aFieldDefs[$nCount] = mysqli_fetch_field($result)){
echo('Field = '.print_r($aFieldDefs, true)."\r\n");
$aRes[$aFieldDefs[$nCount++]->name] = null;
}
$nCount = 0;
while($aFieldDefs2[$nCount] = mysqli_fetch_field($result2)){
echo('Field = '.print_r($aFieldDefs2, true)."\r\n");
$aRes2[$aFieldDefs2[$nCount++]->name] = null;
}
// Bind Results
mysqli_stmt_bind_result($stmt, &$aRes['foo1']);
mysqli_stmt_bind_result($stmt2, &$aRes2['foo2'], &$aRes2['foo3'])
// Fetch Results
mysqli_stmt_fetch($stmt);
mysqli_stmt_fetch($stmt2);
echo(print_r($aRes, true)."\r\n");
echo(print_r($aRes2, true)."\r\n");
--------------- End Code Snippet ----------------------
Expected result:
----------------
Array
(
[foo1] => 'PXX00019263'
)
Array
(
[foo2] => 2009-09-15 12:05:02
[foo3] => 0000-00-00 00:00:00
)
Actual result:
--------------
Array
(
[foo1] =>
)
Array
(
[foo2] => 2009-09-15 12:05:02
[foo3] => 0000-00-00 00:00:00
)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=54444&edit=1
Thread (8 messages)