我正在尝试连接我的php脚本和数据库,我无法识别“warning:mysqli_num_rows()期望参数1是mysqli_result,bool给定在。。。。” 列计数与第1行的值计数不匹配,如何纠正这些错误?
`<?php
require 'includes/common.php';
$name = mysqli_real_escape_string($con, $_POST['name']);
$email = mysqli_real_escape_string($con, $_POST['email']);
$password = mysqli_real_escape_string($con, $_POST['password']);
$phone = mysqli_real_escape_string($con,$_POST['contact']);
$city = mysqli_real_escape_string($con,$_POST['city']);
$address = mysqli_real_escape_string($con,$_POST['address']);
$user_query = "select id, email_id from users where email = ['$email']";
$user_details = mysqli_query($con, $user_query);
$check_data = mysqli_num_rows($user_details);
if ($check_data >0){
{
echo 'user already exists';
}
}else{
$user_registration_query = "insert into users(name, email_id, password, contact_number, city,
address) values ('$name', '$email', '$password','$phone' '$city','$address')";
$user_registration_submit = mysqli_query($con, $user_registration_query) or
die(mysqli_error($con));
header("location: includes/product.php");
}
$_SESSION['email_id'] = '$email';
$_SESSION['id'] = mysqli_insert_id($con);
?>`
因为参数1不是传递mysqli结果,它从mysqli_query传递布尔值,检查您的查询和连接