PDO Prepared statements

Please login or create account to add a snippet.

Follow @TagMyCode

Language: PHP

Posted by: Mike MacDonald

Added: Jul 1, 2017 12:42 AM

Tags: no tags

$stmt = $db->prepare("INSERT INTO table(field1,field2,field3,field4,field5) VALUES(:field1,:field2,:field3,:field4,:field5)");
$stmt->execute(array(':field1' => $field1, ':field2' => $field2, ':field3' => $field3, ':field4' => $field4, ':field5' => $field5));
$affected_rows = $stmt->rowCount();