PHP / MySQL Insert Multiple Records Based On Previous Query Results

Question

I'm trying to develop a PHP script that notifies premium members of changes made to certain features of my website but I'm not sure how to add the multiple records to the notifications table. What I have is:

    $get_pro_sql = "SELECT id FROM members WHERE pro = '1'";
    $get_pro_res = mysqli_query($con, $get_pro_sql);

while($row = mysqli_fetch_assoc($get_pro_res){
    $memberid = $row["id"];
}
$message = "My New Message";
foreach($row){



    $insert_note_sql = "INSERT INTO notes(id, recipient, message, ..., ...) VALUES('', 'Member_Id__Returned_From_Previous_Query', '$message')";
    $insert_note_res = mysqli_query($con, $insert_note_sql);
    // Inserts 5 Records

Any ideas on how this can be achieved?

Community · Accepted Answer · 2017-05-23 12:03:44Z

1

You could this by using a sub query to insert multiple rows.

Actually you can achieve it like this:

INSERT INTO Results (People, names )
   SELECT d.id, 'Henry'
   FROM Names f
   JOIN People d ON d.id  = f.id

In the subquery you can select the actual values to be inserted.

Collectives™ on Stack Overflow

PHP / MySQL Insert Multiple Records Based On Previous Query Results

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related