Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and work.

aviboots(AT)netvision.net.il

Instant Grammar Checker - Correct all grammar errors and enhance your writing

Most popular tags

BlueHost Web Hosting

Bonsai Boy of New York Bonsai Trees and Accessories

Website Domains Names & Hosting | Domain.com

Instant Grammar Checker - Correct all grammar errors and enhance your writing

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

DreamHost Web Hosting


Liquid Web Cloud VPS Hosting

Disclosure We are a professional Programming & Software Q&A website, that receives compensation from some of the links whose we show you with Information. It means that my content may contain affiliate links.

13,252 questions

18,038 answers

573 users

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



10 views
asked Oct 9, 2019 by avibootz
Share on
share on gp share on fb share on tw share on li share on re share via email

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
 | Snow Theme by Q2A Market
Powered by Question2Answer
...