troubleshooting Question

Multiple inserts with PDO

Avatar of narmi2
narmi2 asked on
PHPMySQL Server
4 Comments1 Solution483 ViewsLast Modified:
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.
$preparedStatement = $db->prepare('INSERT INTO table (column) VALUES (:column)');

$preparedStatement->execute(array(':column' => $unsafeValue));
ASKER CERTIFIED SOLUTION
virmaior

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros