Differences

This shows you the differences between two versions of the page.

--- pdo:update_statements [2016/10/14 08:55] – created peter
+++ pdo:update_statements [2020/07/15 09:30] (current) – external edit 127.0.0.1
@@ Line 7: / Line 7: @@
 </code>
+===== Prepared Statements =====
+<code php>
+<?php
+$stmt = $db->prepare("UPDATE table SET name=? WHERE id=?");
+$stmt->execute(array($name, $id));
+$affected_rows = $stmt->rowCount();
+</code>