PHP/SQL Multi INSERT INTO dont work

Question

I cant insert 2 tabs at once. It only insert 1 of them (In this example, it inserts the first one)

   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);
   }

jameshwart lopez · Accepted Answer · 2016-03-05 06:24:39Z

The problem is because you return the first mysql_query and the rest will not be executed.Try removing it like this.

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);
   }

Please forget using mysql_* because it is deprecated and in php 7 it was already removed.
Try to use mysqli or pdo

Collectives™ on Stack Overflow

PHP/SQL Multi INSERT INTO dont work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related