CODE EXAMPLE FOR PHP

sql row count php pdo

<?php
/* Delete all rows from the FRUIT table */
$del = $dbh->prepare('DELETE FROM fruit');
$del->execute();

/* Return number of rows that were deleted */
print("Return number of rows that were deleted:
");
$count = $del->rowCount();
print("Deleted $count rows.
");
?>