Using Insert, Select and values in php

Question

hi i'm having difficulty trying to insert multiple row of data where userid = deviceid (Which will be taken from the .php URL)

e.g. url.com/test/this.php?deviceid=abc

This are my code:

$sql = "INSERT INTO notif (message,userid) VALUES ('hi', (select userid from devices where deviceid = '" . $deviceid . "'))";

 if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

The main goal is that i want the database to insert the amount of users with the message of 'hi' as well

Here's an example

Message | userid

hi | john

hi | mary

hi | Jake

etc..

please help me.. i'll do my best to reply

thanks

Alex · Accepted Answer · 2018-01-21 18:41:20Z

1

INSERT INTO notif (message,userid)
  SELECT 'Hi', user_id 
  FROM devices WHERE
   deviceid = :deviceid

answered Jan 21, 2018 at 18:41

Alex

17.3k1 gold badge31 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Insert, Select and values in php

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