提问者:小点点

当我试图使用php将用户数据插入数据库时,我会收到mysqli_num_rows()的错误。 我可以做些什么来纠正我的错误[重复]


我正在尝试连接我的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个答案

匿名用户

因为参数1不是传递mysqli结果,它从mysqli_query传递布尔值,检查您的查询和连接