代码用于在数据库中插入用户数据出现错误
$run = mysqli_query($con,$check_email);
注意:mysqli_result类的对象无法转换为int
和
警告:mysqli_num_rows()要求参数1为mysqli_result,布尔
<?php
$con = mysqli_connect("localhost","root","","users_db");
if (mysqli_connect_errno())
{
echo 'connection was not established'. mysqli_connect_error();
}
if(isset($_POST['submit'])){
$user_name = $_POST['name'];
$user_pass = $_POST['pass'];
$user_email = $_POST['email'];
if($user_name==''){
echo "<script>alert('please Enter your Nmae!')</script>";
exit();
}
if($user_pass==''){
echo "<script>alert('please Enter your password!')</script>";
exit();
}
if($user_email==''){
echo "<script>alert('please Enter your Email!')</script>";
exit();
}
$check_email = "select * from users where user_email='$user_email'";
$run = mysqli_query($con,$check_email);
if(mysqli_num_rows($run>0)){
echo "<script>alert('Email $user_email is already exist in database please try another one')</script>";
exit();
}
$query = "insert into users(user_name,user_pass,user_email) values ('$user_name','$user_pass','$user_email')";
if(mysqli_query($con,$query)){
echo "<script>alert('Registration completed')</script>";
}
else{
echo"<script>alert('Data not inserted')</script>";
}
}
?>
语法错误
if(mysqli_num_rows($run>0)){
这应该是
if(mysqli_num_rows($run) > 0){
^ should be moved
这将修复这两个错误。
您在mysqli_num_rows中犯了一个小错误。
更改自:
if(mysqli_num_rows($run>0)){
至
if(mysqli_num_rows($run) > 0){