开发者

Do I've to free mysql result after storing it?

开发者 https://www.devze.com 2023-01-04 21:26 出处:网络
I was wondering whether or not I\'ve to call the $stmt->free_result() for after I\'ve stored it\'s result with $stmt->store_result()? Could I rather just call $stmt->close() on the end?

I was wondering whether or not I've to call the $stmt->free_result() for after I've stored it's result with $stmt->store_result()? Could I rather just call $stmt->close() on the end?

The reason why I'm asking it is because when I call the $stmt->num_rows I've to call the $stmt->store_result() as said here: http开发者_Go百科://www.php.net/manual/en/mysqli-stmt.num-rows.php, but they don't call the $stmt->free_result() in their example. However, on the $stmt->store_result() they do: http://www.php.net/manual/en/mysqli-stmt.store-result.php.


You do not have to expressly free the result, but you can if you'd wish. If you don't, the result will be freed when the statement handle goes out of scope.


PHP is pretty lenient with freeing resources. Any resources used by your script, such as SQL connections, will be freed when the script exits. Although it's good programming practice, unless you have many concurrent users there will be very little difference in performance.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号