首頁(yè) 猿問(wèn) 警告 :: 無(wú)效對(duì)象或資源...

警告 :: 無(wú)效對(duì)象或資源 mysqli_stmt。什么意思和解決方案？

PHP

GCT1015 2023-05-12 15:41:31

以下代碼拋出神秘的警告。我不明白他們的意思。這些錯(cuò)誤表明什么以及如何消除它們？require "conn.php";$q = mysqli_stmt_init($dbconn);$query = "SELECT users.userid FROM users WHERE users.email = ? ";mysqli_stmt_prepare($q, $query);mysqli_stmt_bind_param($q, "s", $email);mysqli_stmt_execute($q);$result = mysqli_stmt_get_result($q);if (mysqli_num_rows($result) == 0) { $q = mysqli_stmt_init($dbconn); $query = "INSERT INTO users ( users.first_name, users.last_name, users.mobile_no, users.email, users.password, users.reg_date) VALUES (? ,? ,? ,? ,? ,NOW() )"; mysqli_stmt_prepare($q, $query); mysqli_stmt_bind_param($q, "sssss", $first_name, $last_name, $mobile_number, $email, $password); mysqli_stmt_execute($q); if (mysqli_stmt_affected_rows($q) == 1) { echo "data inserted <br>"; foreach ($_POST as $key => $val) { echo "$key - - - > $val <br>"; } }} else { echo "email is already registered";}每當(dāng)我在出現(xiàn)警告后運(yùn)行這段代碼時(shí)Warning: mysqli_stmt_bind_param(): invalid object or resource mysqli_stmt in /storage/emulated/0/htdocs/registration_process.php on line 66Warning: mysqli_stmt_execute(): invalid object or resource mysqli_stmt in /storage/emulated/0/htdocs/registration_process.php on line 67Warning: mysqli_stmt_get_result(): invalid object or resource mysqli_stmt in /storage/emulated/0/htdocs/registration_process.php on line 68Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /storage/emulated/0/htdocs/registration_process.php on line 70

查看完整描述

1 回答

www說(shuō)

TA貢獻(xiàn)1775條經(jīng)驗(yàn) 獲得超8個(gè)贊

這里的問(wèn)題很奇特。這聽(tīng)起來(lái)無(wú)關(guān)緊要，但此錯(cuò)誤消息是不可靠語(yǔ)法變體的結(jié)果。

與對(duì)象語(yǔ)法相比，過(guò)程性 mysqli 語(yǔ)法不僅過(guò)于冗長(zhǎng)，而且具有欺騙性，不是在真正發(fā)生時(shí)引發(fā)錯(cuò)誤，而是在已經(jīng)為時(shí)已晚時(shí)引發(fā)錯(cuò)誤，更不用說(shuō)此錯(cuò)誤消息的神秘性質(zhì)。

您的查詢(xún)存在一些問(wèn)題，您需要按照此答案中的說(shuō)明從 MySQL獲取真正的錯(cuò)誤消息，但為了實(shí)現(xiàn)它，您必須更改語(yǔ)法。

外賣(mài)：解決你的問(wèn)題

conn.php如本文所示重寫(xiě)您的內(nèi)容以設(shè)置正確的連接設(shè)置

將程序 mysqli 重寫(xiě)為對(duì)象語(yǔ)法，例如

$query?=?"SELECT?userid?FROM?users?WHERE?email?=??";
$stmt?=?$dbconn->prepare($query);$stmt->bind_param("s",?$email);
$stmt->execute();
$result?=?$stmt->get_result();