Differences

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

--- pdo:delete_statements [2019/12/01 22:13] – removed peter
+++ pdo:delete_statements [2020/07/15 09:30] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== PDO - Delete Statements ======
+<code php>
+<?php
+$stmt = $db->prepare("DELETE FROM table WHERE id=:id");
+$stmt->bindValue(':id', $id, PDO::PARAM_STR);
+$stmt->execute();
+$affected_rows = $stmt->rowCount();
+</code>