問題描述
我對收到以下消息的原因感到困惑:
I am confused about why I am received the following message:
mysqli_num_rows() 期望參數 1 是 mysqli_result，給定布爾值
mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given
這個問題與之前的查詢不同，因為我的查詢實際上正確執行(值確實輸入到數據庫中).因此，我希望 MySQL 返回結果集而不是布爾值.
This question is different from previous queries because my query actually executes correctly (values were indeed entered into the database). So, I would expect MySQL to return a result set and NOT A BOOLIAN.
以下是我的功能:
function join_main_newsletter($firstName = null, $email)
{
global $dbc;
$valuesEntered = "values entered";
$insert = "INSERT INTO newsletter (first_name, email ) VALUES ('name', 'testemail@yahoo.com')";
$R3 = mysqli_query($dbc, $insert) or trigger_error("Query Failed! SQL: $sql - Error: " . mysqli_error(db_conx), E_USER_ERROR);
if (mysqli_num_rows($R3) == 1) {
return $valueentered;
} else {
}
}
這是錯誤結果的一部分:
[valuesEntered] => values entered
[insert] => INSERT INTO newsletter (first_name, email )
VALUES ('name', 'testemail@yahoo.com')
[R3] => 1
推薦答案
mysqli_num_rows() 函數返回結果集中的行數.對于插入、更新和刪除使用 mysqli_affected_rows
The mysqli_num_rows() function returns the number of rows in a result set. For insert, update and delete use mysqli_affected_rows
這篇關于INSERT 查詢產生“警告:mysqli_num_rows() 期望參數 1 為 mysqli_result，給出布爾值"；的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！