Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Bonsai Boy of New York Bonsai Trees and Accessories

BlueHost Web Hosting

Liquid Web iThemes WordPress Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

DreamHost Web Hosting


getResponse autofunnels

Liquid Web Cloud VPS Hosting

11,407 questions

15,557 answers

573 users

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 by avibootz
...