MySQL数据库没有填充

Question

I am trying to create a register/login html/php script. I created a database and I believe my html/php code is correct. I was wondering if I am missing something small. Here is my code so far.

Here is the database

<?php
         error_reporting(E_ALL);
         ini_set('display_errors', 'on');
if(isset($_POST["submit"]))
        {
        $User = "**"; 
        $Password = "**";
        $Database = "member";
        $Host = "localhost"; 
        $con = mysqli_connect($Host, $User, $Password);
        if (mysqli_connect_errno())
        {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
        }

        mysqli_select_db($con,$Database);
        $myusername = $_POST["username"];
        $mypassword = $_POST["password"];
        $sql = "INSERT INTO member (username, password) VALUES ('$myusername','$mypassword')";
        mysqli_query($con,$sql);
        mysqli_commit($con);
        mysqli_close($con);

        echo "Thank You! Information entered.";
        }
else
        {
        ?>
        <form method="post" action="proInput.php">
        Username:<input type="Text" name="username"><br>
        Password:<input type="Text" name="password"><br>
        <input type="Submit" name="submit" value="Register"></form>
        <?
        }
?>

Every time I type SELECT * FROM member; in MySQL my database is empty.

Answer 1

As you answered already in your comment,

the name of the file isn't main_login.php but proinput.php

Your form is posting it's data to main_login.php and I'm assuming you don't have the insert query on that page, your code isn't run at all.

Options:

1. Try changing the name of this php file to main_login.php and then instead of the echo redirect the user to the login page

2. Move this part of the insert to your main_login.php

   if(isset($_POST["submit"]))
       {
       $User = ""; 
       $Password = "";
       $Database = "member";
       $Host = "localhost"; 
       $con = mysqli_connect($Host, $User, $Password);
       if (mysqli_connect_errno())
       {
       echo "Failed to connect to MySQL: " . mysqli_connect_error();
       }
       mysqli_select_db($con,$Database);
       $myusername = $_POST["username"];
       $mypassword = $_POST["password"];
       $sql = "INSERT INTO member (username, password) VALUES ('$myusername','$mypassword')";
       mysqli_query($con,$sql);
       mysqli_commit($con);
       mysqli_close($con);
   
   
   
   
       echo "Thank You! Information entered.";
       }
       else
       {
       ?>
   

3. for debugging add the following to the very top of your php file right after the opening of php

    error_reporting(E_ALL);
    ini_set('display_errors', 'on');
   

This worked for me

  <?php

  error_reporting(E_ALL);
  ini_set('display_errors', 'on');

  if(isset($_POST["submit"]))
    {
    $User = "db_user"; 
    $Password = "db_password";
    $Database = "db_name";
    $Host = "db_host"; 
    $con = mysqli_connect($Host, $User, $Password);
    if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
    mysqli_select_db($con,$Database);
    $myusername = $_POST["username"];
    $mypassword = $_POST["password"];
    $sql = "INSERT INTO member (username, password) VALUES ('$myusername','$mypassword')";
    mysqli_query($con,$sql);
    mysqli_commit($con);
    mysqli_close($con);

    echo "Thank You! Information entered.";
    }
    else
    {
    ?>
    <form method="post" action="proinput.php">
    Username:<input type="Text" name="username"><br>
    Password:<input type="Text" name="password"><br>
    <input type="Submit" name="submit" value="Register"></form>
    <?php
    }
    ?>