stmt_init() seems to clear previous (possibly erroneous) results on the DB connection, which means you don't necessarily need to use it but it could make the code more robust.
In a PHPUnit test, I had a sequence of prepared queries on the same connection. One of them fetched a row from a SELECT but didn't keep fetching until it drained the connection, so it left some stale results. When the next query did this:
<?php
$db = $this->getConnection()->getDbConnection();
$preparedQuery = $db->prepare ($query);
?>
the prepare() call generated an error: "Could not prepare query: Commands out of sync; you can't run this command now." Changing to this:
<?php
$db = $this->getConnection()->getDbConnection();
$preparedQuery = $db->stmt_init();
$preparedQuery->prepare ($query);
?>
resolved the problem.
mysqli::stmt_init
mysqli_stmt_init
(PHP 5, PHP 7, PHP 8)
mysqli::stmt_init -- mysqli_stmt_init — Initialise une commande MySQL
Description
Style orienté objet
Style procédural
Alloue et initialise un objet de commande, à utiliser avec mysqli_stmt_prepare().
Note:
Tous les appels ultérieurs aux fonctions mysqli_stmt_* échoueront, si mysqli_stmt_prepare() est appelée.
Liste de paramètres
-
mysql -
Seulement en style procédural : Un objet mysqli retourné par la fonction mysqli_connect() ou mysqli_init().
Valeurs de retour
Retourne un objet.
add a note
User Contributed Notes 2 notes
Jeff C ¶
8 years ago
mamdo7 at hotmail dot com ¶
10 years ago
you can use $stmt = $mysqli->prepare(); directly without stmt-init() . i think there is no need for stmt-init .
