Php pdo rowcount

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:\n");
$count = $del->rowCount();
print("Deleted $count rows.\n");
?>

Source: php.net

Php pdo rowcount

$stmt = $db->query('SELECT * FROM table');
$row_count = $stmt->rowCount();

Source: stackoverflow.com

Similar codes

0 vote212 views1 answer
Wp add menu page and subpage
PHP
-1 vote193 views1 answer
Php get index in foreach
PHP
0 vote240 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP
2 votes213 views1 answer
Wordpress plugin deactivate from database
PHP Wordpress
1 vote221 views2 answers
Laravel Cannot add foreign key constraint
PHP Laravel
35 votes179 views6 answers
Convert string to lowercase in php
PHP
2 votes230 views1 answer
Carbon time ago laravel
PHP
0 vote223 views1 answer
Laravel collection pipe
PHP Laravel
10 votes208 views3 answers
How to get week start date in php
PHP
0 vote172 views1 answer
Laravel search user details by specific role
PHP