php-pdoGet affected rows with PHP PDO

$st = $pdo->prepare('UPDATE test SET updated_at = NOW()');
$st->execute();
$updated = $st->rowCount();ctrl + cgithub

`$pdo->prepare` prepare given query to execute	`UPDATE test` sample query affecting multiple rows
`$st->execute(` run query on the server	`rowCount` returns affected rows
`$updated` will contain affected rows

Usage example

<?php

$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');

$st = $pdo->prepare('UPDATE test SET age = age - 1');
$st->execute();
echo $st->rowCount();

output

More of Php Pdo

Set charset in PHP PDO
Fetch single column value with PHP PDO
Commit transaction in PHP PDO
How to get results after PHP PDO statement execute()
Set execution timeout with PHP PDO
Bind current datetime with PHP PDO
Get last query error with PHP PDO
Escape string with PHP PDO
Insert JSON into table with PHP PDO
Get current database name with PHP PDO

See more codes...