RE :[PHP-DB] MySQLi Help
| From: | Olivier Desmares | Date: | Sat, 16 Jun 2012 14:58:38 +0000 |
| Subject: | RE :[PHP-DB] MySQLi Help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-48311@lists.php.net to get a copy of this message | ||
Hi James,
The manual page for mysqli_stmt::execute has the following note :
When using mysqli_stmt_execute(), the
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