Updating or Deleting rows in PDO PHP

Discover the basics of PHP PDO

Published Feb 9, 2021

We can run our edit and delete queries with the exec method, which works in the same way as the insert method above. The only difference is this time we get the number of rows affected.

<?php
//update
$affected = DB::exec('UPDATE users SET scores = 10 WHERE id > 30');

echo $affected . ' users updated.';

//delete
$affected = DB::exec('DELETE FROM users WHERE id < 30');

echo $affected . ' users deleted.';
?>

Insert new row in PDO PHP
Return multiple rows in PDO PHP
Return single row in PDO PHP
Return single value in PDO PHP
Using Bindings in PDO PHP

You might also like