Any proper methods for multiple INSERT command?

[genzedu777]

Hi guys,

 

I am just wondering if there is a proper method to streamline my codes, whenever I perform multiple INSERTs into tables? Probably like INNER JOIN method etc? Thanks

 

 

$query = "INSERT INTO practice_user (name, email, password, dob, category, comments) VALUES ('$name', '$email', '$password', '$dob', '$category', '$comments')";

 

  $result = mysqli_query($dbc, $query)

    or die(mysql_error());

 

$query2 = "INSERT INTO location (name) VALUES ('$location')";

 

  $result = mysqli_query($dbc, $query2)

    or die(mysql_error());

 

[BlueSkyIS]

just a note that you probably don't want to mix mysqli and mysql functions. I notice you query with mysqli_query(), but then you die with error mysql_error().

[genzedu777]

Thanks, it was a mistake.

 

Hi, do u have any suggestions of how I could streamline the INSERTs codes?

[chintansshah]

It is not possible with two different tables. for single table you can do that

 

$query = "INSERT INTO practice_user (name, email, password, dob, category, comments) VALUES ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments'), ('$name', '$email', '$password', '$dob', '$category', '$comments')";

 

  $result = mysqli_query($dbc, $query)

 

 

[genzedu777]

Thanks for the clarifications

[mikosiko]

as you are using mysqli you could consider implement your multiples Insert with mysqli_multi_query

 

examples here:

http://php.net/manual/en/mysqli.multi-query.php