CODEWITHSUNDEEP
phpmysqlsql-insert
user15580703
user15580703

Reputation:

Insert multiple rows into MySQL Table ( PHP problem )

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

Upvotes: 0

Views: 127

Answers (1)

adam
adam

Reputation: 367

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

Upvotes: 1

Related Questions