Dear Experts,
The following script allows me to insert a single row into the database:
This is because of the array:
array(':column' => $unsafeValue)
Which is a single key:value array. How can I modify this array so it inserts more than 1 rows into the database in one statement.
Something like this?
array(':column' => $unsafeValue, ':column' => $unsafeValue, ':column' => $unsafeValue, )
???
Please help.
The following script allows me to insert a single row into the database:
This is because of the array:
array(':column' => $unsafeValue)
Which is a single key:value array. How can I modify this array so it inserts more than 1 rows into the database in one statement.
Something like this?
array(':column' => $unsafeValue, ':column' => $unsafeValue, ':column' => $unsafeValue, )
???
Please help.
$preparedStatement = $db->prepare('INSERT INTO table (column) VALUES (:column)');
$preparedStatement->execute(array(':column' => $unsafeValue));
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.