I very like the syntax :
$result = $db_connect->query("SELECT * FROM table")->fetch_assoc();
instead of more verbose
$query = $db_connect->query("SELECT * FROM table");
$result = $query->fetch_assoc();
$query->free();
My question is how do I free results from memory in case 1 ?
In other words : Do assigning a new value to the variable does automatically free the results ?
I've searched for that on stackExchange / Google with no success...and I found it's an interesting question.
分享 Method Chaining (your first example) works by executing each following function on the object returned by the previous function. So you can do $db_connect->query("SELECT * FROM table")->fetch_assoc(); because query() returns a mysqli_result object and that object supports the fetch_assoc() method.
fetch_assoc(), in turn, returns...
... an associative array of strings representing the fetched row in the result set, where each key in the array represents the name of one of the result set's columns or NULL if there are no more rows in resultset.
Since this result is an array (or NULL) and not an object, no further methods can be added to the chain after it.
分享
