PHP/SQL Multi INSERT INTO 不起作用

Question

我不能一次插入 2 个标签。它只插入其中的一个(在这个例子中，它插入第一个)

   function addNewUser($username, $password, $email){
      $time = time();
      /* If admin sign up, give admin user level */
      if(strcasecmp($username, ADMIN_NAME) == 0){
         $ulevel = ADMIN_LEVEL;
      }else{
         $ulevel = USER_LEVEL;
      }
    $datumregistrationbla = date("d.m.Y");
      $q = "INSERT INTO ".TBL_USERS." (username, password, email, userlevel, register_date) VALUES ('$username', '$password', '$email', '$ulevel', '$datumregistrationbla')";
      return mysql_query($q, $this->connection);
      $q = "INSERT INTO `post` (`post_id`, `from`, `to`, `betreff`, `text`, `datum`, `active`) VALUES ('', 'Fuchsfeuer', '$username', 'Test', 'Test2', '$datumregistrationbla', '0')";
      return mysql_query($q, $this->connection);
   }

Answer 1

问题是因为你return第一个mysql_query，其余的不会被执行。尝试像这样删除它。

function addNewUser($username, $password, $email){
      $time = time();
      /* If admin sign up, give admin user level */
      if(strcasecmp($username, ADMIN_NAME) == 0){
         $ulevel = ADMIN_LEVEL;
      }else{
         $ulevel = USER_LEVEL;
      }
    $datumregistrationbla = date("d.m.Y");
      $q = "INSERT INTO ".TBL_USERS." (username, password, email, userlevel, register_date) VALUES ('$username', '$password', '$email', '$ulevel', '$datumregistrationbla')";
      mysql_query($q, $this->connection);
      $q = "INSERT INTO `post` (`post_id`, `from`, `to`, `betreff`, `text`, `datum`, `active`) VALUES ('', 'Fuchsfeuer', '$username', 'Test', 'Test2', '$datumregistrationbla', '0')";
      mysql_query($q, $this->connection);
   }

请忘记使用 mysql_*，因为它已被弃用并且在 php 7 中已被删除。
尝试使用 mysqli或 pdo