mysql commands out of sync
<?php
/**
* Free all resultsets from $dbCon. Object Oriented
* Originally from https://falseisnotnull.wordpress.com/2013/06/02/mariadbmysql-commands-out-of-sync-error/
* @param mysqli $dbCon mysqli object.
* @return void
*/
function free_all_results(mysqli $dbCon)
{
do {
if ($res = $dbCon->store_result()) {
$res->fetch_all(MYSQLI_ASSOC);
$res->free();
}
} while ($dbCon->more_results() && $dbCon->next_result());
}
/**
* Free all resultsets from $dbCon. Procedural
* @param mysqli $dbCon mysqli object.
* @return void
*/
function free_all_results(mysqli $dbCon): void {
do {
if ($res = mysqli_store_result($dbCon)) {
// $res->fetch_all(MYSQLI_ASSOC);
mysqli_fetch_all($res, MYSQLI_ASSOC);
mysqli_free_result($res);
}
} while (mysqli_more_results($dbCon) && mysqli_next_result($dbCon));
}
?>
Are there any code examples left?
New code examples in category PHP
-
PHP 2022-03-27 22:40:03 index:of curiosa 2019 mp4
-
PHP 2022-03-27 22:35:13 Dijkstra’s algorithm php
-
PHP 2022-03-27 22:35:12 get_declared_classes
-
PHP 2022-03-27 22:30:23 php move index of a value to first position in array
-
PHP 2022-03-27 22:25:01 wordpress get_date
-
PHP 2022-03-27 21:30:38 php shorten string with dots
-
PHP 2022-03-27 21:10:46 php header 500
-
PHP 2022-03-27 21:05:06 laravel schedule run
-
PHP 2022-03-27 20:25:12 Get page title, excerpt or content by id
-
PHP 2022-03-27 20:00:27 php convert date from dd/mm/yyyy to yyyy-mm-dd