PHP&MySQL：mysqli_num_row()期望參數(shù)1是mysqli_test，布爾值給定我正在嘗試集成HTML凈化器http://htmlpurifier.org/若要篩選用戶提交的數(shù)據(jù)，請執(zhí)行以下錯誤。我在想怎樣才能解決這個問題？我得到以下錯誤。on line 22: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given第22行是。if (mysqli_num_rows($dbc) == 0) {下面是php代碼。if (isset($_POST['submitted'])) { // Handle the form.
require_once '../../htmlpurifier/library/HTMLPurifier.auto.php';
$config = HTMLPurifier_Config::createDefault();
$config->set('Core.Encoding', 'UTF-8'); // replace with your encoding
$config->set('HTML.Doctype', 'XHTML 1.0 Strict'); // replace with your doctype
$purifier = new HTMLPurifier($config);
$mysqli = mysqli_connect("localhost", "root", "", "sitename");
$dbc = mysqli_query($mysqli,"SELECT users.*, profile.*
FROM users
INNER JOIN contact_info ON contact_info.user_id = users.user_id
WHERE users.user_id=3");
$about_me = mysqli_real_escape_string($mysqli, $purifier->purify($_POST['about_me']));
$interests = mysqli_real_escape_string($mysqli, $purifier->purify($_POST['interests']));if (mysqli_num_rows($dbc) == 0) {
$mysqli = mysqli_connect("localhost", "root", "", "sitename");
$dbc = mysqli_query($mysqli,"INSERT INTO profile (user_id, about_me, interests)
VALUES ('$user_id', '$about_me', '$interests')");}if ($dbc == TRUE) {
$dbc = mysqli_query($mysqli,"UPDATE profile
SET about_me = '$about_me', interests = '$interests'
WHERE user_id = '$user_id'");
echo '<p class="changes-saved">Your changes have been saved!</p>';}if (!$dbc) {
// There was an error...do something about it here...
print mysqli_error($mysqli);
return;}}
2 回答
阿晨1998
TA貢獻2037條經(jīng)驗 獲得超6個贊
$dbc
SELECT users.*, profile.* --You do not join with profile anywhere. FROM users INNER JOIN contact_info ON contact_info.user_id = users.user_id WHERE users.user_id=3");
四季花海
TA貢獻1811條經(jīng)驗 獲得超5個贊
FALSE
if (!$dbc || mysqli_num_rows($dbc) == 0)
mysqli_num_rows:
返回值
在成功時返回true，在失敗時返回false。對于SELECT，顯示，描述或解釋mysqli_query()將返回一個結(jié)果對象。
添加回答
舉報
0/150
提交
取消