how can I insert multiple rows into MySQL with php so that after one single query the MySQL Table would look like:
| user_id | Message | Date | Subject |
|---|---|---|---|
| 1243 | Hello world! | 06.04.2021 | First Message |
| 5265 | Hi John! | 07.04.2021 | Second Message |
-
Both INSERT .. SELECT and INSERT .. VALUES allows to insert more than one row (rather than INSERT .. SET).Akina– Akina2021-08-23 06:31:50 +00:00Commented Aug 23, 2021 at 6:31
-
Or use foreach() loop in your PHP file. But multiple inserts are better. Something like described here stackoverflow.com/questions/1307618/…milenmk– milenmk2021-08-23 07:50:26 +00:00Commented Aug 23, 2021 at 7:50
-
1Does this answer your question? Insert multiple rows with one query MySQLmilenmk– milenmk2021-08-23 07:51:21 +00:00Commented Aug 23, 2021 at 7:51
-
1stackoverflow.com/questions/12502032/… You can follow this answer.user16731274– user167312742021-08-23 09:49:43 +00:00Commented Aug 23, 2021 at 9:49
Add a comment
|
1 Answer
You can use MYSQL prepared statement
include(your connection code...)
// prepare and bind
$stmt = $conn->prepare("INSERT INTO yourtable(user_id, message, date, subject) VALUES (?, ?, ?, ?)");
$stmt->bind_param("isss", $user_id, $message, $date, $subject);
@foreach statement for your data
// set parameters and execute
$user_id= $data->id;
$message= $data->message;
$date= $data->date;
$subject= $data->subject;
$stmt->execute();
@endforeach
this method can even secure your app from SQL injection
