php - 注册在 php 中不起作用

Question

嗨，我正在尝试使用 html 和 php 创建一个注册页面，数据库是 mysql。我使用的IDE是cloud9。我的表单的代码如下:

<form action="signup_code.php" method="post">
                        <p>Name<br/><input type="text" name="name" maxlength="20"  ></p>
                        <p>Phone Number<br/><input type="number" name="phone" maxlength="20"  ></p>
                        <p>Email<br/><input type="email" name="email" maxlength="50" ></p>
                        <p>Password<br/><input type="password" name="pass1" maxlength="20" ></p>
                        <p>Confirm Password<br/><input type="password" name="pass2" maxlength="20" ></p>
                        <p>Address<br/><input type="text" name="address" maxlength="20"  ></p>


                            <button type="submit" class="btn btn-default">Signup

                                </button>
                        </form>

signup_code .php 中的代码是:

<?php
$IP = "0.0.0.0";
$dbuser = "bhaskey";

$conn = mysqli_connect($IP, $dbuser, "","trydb");
if(! $conn )
{
  die('Could not connect: ' . mysqli_error());
}

$name = $_POST['name'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$pass1 = $_POST['pass1'];
$pass2 = $_POST['pass2'];
$address = $_POST['address'];


$query = "SELECT email FROM user_main where email='".$email."'";
$result = mysqli_query($conn,$query);
$numResults = mysqli_num_rows($result);

if (!filter_var($email, FILTER_VALIDATE_EMAIL)) // Validate email address
        {
            $message =  "Invalid email address please type a valid email!!";
        }
        elseif($numResults>=1)
        {
            $message = $email." Email already exist!!";
        }


else
        {
            mysqli_query("(insert into user_main(name,phone, email,pass1, pass2, address) values
            ('".$name."','".$phone."', '".$email."', '".pass1."','",$pass2."','".$address."')");


            echo $message = "Signup Sucessfully!!";
        }
mysqli_close($conn);
?>

但是，当我执行代码时，即单击表单中的注册按钮时，它给出了以下结果“无法发布/bhaskey/eshopper/signup_code.php”

我哪里出错了。我确信这一定是一个愚蠢的错误。但由于我还很新，仍处于学习阶段，这对我来说变得很麻烦。

编辑:我尝试将 .php 文件的整个路径传递给表单中的操作。但是当我点击提交按钮后，页面变成白色，并且不再显示任何内容。我尝试清除浏览器缓存，但没有帮助。

Answer 1

您必须替换此代码

$conn = mysql_connect($IP, $dbuser, "","trydb");  

到此代码

$conn = new mysqli($IP, $dbuser, "","trydb");

并替换此代码

mysql_close($conn);

这段代码

mysqli_close($conn);