PHP注册页面 - PHP警告：mysqli_num_rows（）期望参数1为mysqli_result，给定布尔值 [英] PHP Signup page - PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

问题描述

大家好，所以我正在尝试创建一个PHP注册页面，其中我虽然做得很好但是一旦我在表单上单击注册而不是在数据库中创建用户，它会生成以下内容错误：



PHP警告：mysqli_num_rows（）期望参数1为mysqli_result，在/var/www/davarie.com/public_html/pages/signup.php中给出布尔值在第53行，参考者：http：//davarie.com/pages/signup.php



我是通过Bootstrap创建这个联系表单，并通过以下方式了解到我正在读书。



以下是我的Signup.php文件：

Hi guys, So I'm trying to create a PHP Signup page, of which I though I was doing well, but once I click Register on the Form instead of hte User being created in the database, it instead produces the following error:

PHP Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www/davarie.com/public_html/pages/signup.php on line 53, referer: http://davarie.com/pages/signup.php

I was creating this contact form via Bootstrap, and learnt the below via a book I was reading.

Below is my Signup.php file:

<?php
include('header.php');

if ($_SERVER['REQUEST_METHOD']=='POST')
{
#statements to run
require ('../connect_db.php');
$error = array();

#Requires First_name
if ( empty($_POST['first_name']))
{$errors[] = 'Enter your first name.';}
else
{$fn = mysqli_real_escape_string($dbc,
                       trim($_POST['first_name']));}

#Requires surname
if ( empty($_POST['surname']))
{$errors[] = 'Enter your surname.';}
else
{$sn = mysqli_real_escape_string($dbc,
                       trim($_POST['surname']));}

#Requires email_address
if ( empty($_POST['email']))
{$errors[] = 'Enter your email_address.';}
else
{$ea = mysqli_real_escape_string($dbc,
                       trim($_POST['email']));}

#Requires password, also the checks to ensure that password and password confirmation match starts here.
if ( !empty( $_POST['password']))
{
 if ( $_POST['password']!= $_POST['password_confirmation'])
 { $errors[] = '<div class="alert alert-danger">
    <a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
    Warning! Passwords do not match.
<a href="login.php">Login</a> </div>';}

 else
 {$p = mysqli_real_escape_string($dbc,
                       trim($_POST['password']));}
}
else { $errors[] ='Enter your password.';}

#Checks to ensure email address isn't already in use.
if (empty($errors))
{
 $q = "SELECT user_id FROM users WHERE email='$ea'";
 $r = mysqli_query ($dbc,$q);
 if ( mysqli_num_rows($r)!=0)
 { $errors[] = '<div class="alert alert-danger">
    <a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
    Warning! Email Address already registered.
<a href="login.php">Login</a> </div>';}
}

#Inserts the registration data into the database
if ( empty($errors))
{
$q = "INSERT INTO users
      (frist_name, surname, email, password, reg_date)
       VALUES ('$fn','$sn','$ea', SHA1('$p'), NOW())";
$r = mysqli_query ($dbc, $q);

if ($r)
{
 echo '<div class="alert alert-success">
  Success! Account has been created.
<br>
  <p1> <a href="login.php">Login</a></p>
</div>';
}

#Closes the Database connection
mysqli_close( $dbc);
exit();
}

#Displays any errors with the registration.
else
{
 echo '  <div class="alert alert-danger">
    Error! <p id="err_msg">The following error(s) occurred:<br>';
        foreach ( $errors as $msg)
        {
         echo "- $msg<br>";
        }
        echo'Please try again.</p>
  </div>';
        mysqli_close( $dbc);
}
}
?>
<br>
<br>
<br>
<div class="container">
        <div class="row centered-form">
        <div class="col-sm-10">
                <div class="panel panel-default">
                        <div class="panel-heading">
                                        <h1 class="panel-title">Sign-up <small>please fill in the details below accurately</small></h1>
                                                </div>
                                                <div class="panel-body">
                                        <form role="form" method="post">
                                                <div class="row">
                                                        <div class="col-xs-6 col-sm-6 col-md-6">
                                                                <div class="form-group">
                                        <input type="text" name="first_name" id="first_name" class="form-control input-sm" placeholder="First Name">
                                                                </div>
                                                        </div>
                                                        <div class="col-xs-6 col-sm-6 col-md-6">
                                                                <div class="form-group">
                                                                        <input type="text" name="surname" id="surname" class="form-control input-sm" placeholder="Surname">
                                                                </div>
                                                        </div>
                                                </div>

                                                <div class="form-group">
                                                        <input type="email" name="email" id="email" class="form-control input-sm" placeholder="Email Address">
                                                </div>

                                                <div class="row">
                                                        <div class="col-xs-6 col-sm-6 col-md-6">
                                                                <div class="form-group">
                                                                        <input type="password" name="password" id="password" class="form-control input-sm" placeholder="Password">
                                                                </div>
                                                        </div>
                                                        <div class="col-sm-6">
                                                                <div class="form-group">
                                                                        <input type="password" name="password_confirmation" id="password_confirmation" class="form-control input-sm" placeholder="Confirm Password">
                                                                </div>
                                                        </div>
                                                </div>

                                                <input type="submit" value="Register" class="btn btn-success btn-block">

                                        </form>
                                </div>
                        </div>
                </div>
        </div>
    </div>
  </body>

<?php include('footer.php');?>

推荐答案

_SERVER [' REQUEST_METHOD'] == ' POST'）
{
#statements to run
require（' ../ connect_db.php'）;

_SERVER['REQUEST_METHOD']=='POST') { #statements to run require ('../connect_db.php');

error = array（）;

#Requires First_name
if （空（

_POST [' first_name']））
{

_POST['first_name'])) {

这篇关于PHP注册页面 - PHP警告：mysqli_num_rows（）期望参数1为mysqli_result，给定布尔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！