php - 使用php插入mysql数据库时出错

Question

我在尝试使用函数插入数据库时​​出错!我首先尝试从我的“包含的 connect.php”传递 $connection 变量，但它给我一个错误无法传递对象或类似的东西。现在我在函数中重复了连接部分，但仍然无法添加用户!

现在不显示错误了，只是跳转到else ... 例如

 <?php
  function enterToDb($user, $pass, $email, $gender){
    // take those and insert into users

    $dbname = "mydb";
    $connection = mysqli_connect("localhost", "root", "root", $dbname);
    //query
    $query= "insert into users";
    $query.=" (`username`, `password`, `email`)";
    $query.= " values ('".$user."','".$pass."','".$email."','".$gender."')";
    if(mysqli_query($connection, $query)){
      ?>
          <div class="alert alert-success" role="alert">Congratulations! you're a member of E-Bridge community!
          </br>

          </div>

        <?php
    }else{
      ?>
      <div class="alert alert-danger" role="alert">Error signing you up! Please try again! 
      </div>
      <?php
    }



  }

如上图是函数，进入函数后直接跳转到else

这里是我引用函数的地方

<?php
 echo"in sign up pages";
    $yes=0;
    if(isset($_POST['submit'])){
      // get all the info from the form
      $username= $_POST['username'];
      $password= $_POST['password'];
      $email= $_POST['email'];
      $gender=$_POST["radioGroup"];
      // check if the user already exists in the db
      $query= "select * from users where ";
      $query.= "username =\"".$username."\"";
      $query.= " or email=\"". $email."\"";
      //echo $query;
      $select= mysqli_query($connection, $query);
      if(mysqli_num_rows($select)>=1){ // checking if rows exist
        // if so
        ?>
          <div class="alert alert-danger" role="alert">Credential already exists, please try another name or email.</div>
        <?php

        display();



      }else{
         //echo $username." ".$password." ".$email." ".$gender; 
        enterToDb($username, $password, $email, $gender);

      //display();
      }


      // if not there > error
      // else = exitst >> start session and direct to topics or profile ;)



    }else{


      display();

    }

 ?>

Answer 1

$query.=" (`username`, `password`, `email`)";
$query.= " values ('".$user."','".$pass."','".$email."','".$gender."')";

3 个字段名称，插入 4 个值。我认为您会发现您需要将性别添加到您的字段中。