| Newsgroups |
gmane.comp.php.database |
| Message-ID |
<[email protected]> |
Oliver,
Gah -- thank you.
James
-----Original Message-----
From: "Olivier Desmares" <[email protected]>
Sent: Saturday, June 16, 2012 10:58am
To: "[email protected]" <[email protected]>, "[email protected]" <[email protected]>
Subject: RE :[PHP-DB] MySQLi Help
Hi James,
The manual page for mysqli_stmt::execute has the following note :
When using mysqli_stmt_execute(), the [http://fr2.php.net/manual/en/mysqli-stmt.fetch.php] mysqli_stmt_fetch() function must be used to fetch the data prior to performing any additional queries.
So you cannot execute the inner (sub) query without first retrieving all the rows from the outer (main) query.
Olivier Desmares
$stmt = mysqli_prepare($db, $sql);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $authkv);
while (mysqli_stmt_fetch($stmt)) {
echo "<p>MAIN: $authkv</p>";
sub($db);
}
mysqli_stmt_close($stmt);
This simple change results in the output.
MAIN: 7
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /var/www/html/xgwebapi/mysqli.php on line 21 Warning: mysqli_stmt_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /var/www/html/xgwebapi/mysqli.php on line 22 Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /var/www/html/xgwebapi/mysqli.php on line 24 Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given in /var/www/html/xgwebapi/mysqli.php on line 28
*********************************************
James Starritt
Selago Design, Inc.
US: (312) 239 0592
[email protected]
*********************************************