Question

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

Answer 1

$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

*/

 

70+ SQL courses for beginners and professionals