問題描述
為什么我會收到此錯誤消息:
Why am I getting this error message:
警告:mysqli_free_result() 期望參數 1 是 mysqli_result，給出布爾值
Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given
我的代碼是:
$statement = "INSERT INTO table1 (data1, data2) VALUES ('$variable1', '$variable2')";
if ($result = mysqli_query($conn,$statement)) {
echo "New record added successfully";
} else {
echo "Error adding records: " . $result . "<br>" . mysqli_error($conn);
}
echo "Adding records finished. ";
mysqli_free_result($result);
推薦答案
如中所述mysqli_query 手冊:
失敗時返回 FALSE.對于成功的 SELECT、SHOW、DESCRIBE 或 EXPLAIN 查詢，mysqli_query() 將返回一個 mysqli_result 對象.對于其他成功的查詢，mysqli_query() 將返回 TRUE.
Returns FALSE on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query() will return a mysqli_result object. For other successful queries mysqli_query() will return TRUE.
您的插入查詢將返回 true 或 false，但不會返回對象.因此，調用 mysqli_free_result 在這里不起作用.
Your insert query will return true or false, but not an object. So, calling mysqli_free_result will not work here.
這篇關于警告:mysqli_free_result() 期望參數 1 是 mysqli_result，給定的布爾值的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！