How to get the total rows from a MySQL table with SQL in PHP & PDO

1 Answer

0 votes
$sql = "SELECT COUNT(*) as total_rows FROM your_table_name";

$result = $con->prepare($sql);
$result->execute();
$row = $result->fetch(PDO::FETCH_ASSOC);
        
echo $row['total_rows'];


/*
run:

3002275

*/

 



answered Oct 9, 2019 by avibootz
...