Search With Seek4Info.com
Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Secure & Reliable Web Hosting, Free Domain, Free SSL, 1-Click WordPress Install, Expert 24/7 Support

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

Semrush - keyword research tool

Linux Foundation Training and Certification

Most popular tags

python java c c# javascript cpp php vb# typescript nodejs go rust scala swift html kotlin pascal dart ruby r css bootstrap groovy sql win32 mysql winapi jquery lua winforms bash f# opengl pascal-string cobol kotlin-string go-string reactjs swift-string vbnet-string c-string cpp-string c-windows c#-string scala-string rust-string php-string javascript-string pascal-array php-array cpp-vector javascript-array typescript-string java-string python-string c-array swift-array sdl2 typescript-array python-list go-array scala-array nodejs-array nodejs-express rust-vector sdl3 angularjs nodejs-string kotlin-array raylib glfw cpp-array html5 c#-array java-array javascript-regex vbnet-array typescript-regex kotlin-list postgresql perl swift-matrix c#-matrix pascal-matrix cpp-matrix scala-list c#-list nodejs-regex php-regex cpp-regex dom freeglut kotlin-matrix php-matrix c-matrix vbnet-list swift-regex kotlin-regex scala-regex python-regex
Disclosure: My content contains affiliate links.

37,083 questions

48,461 answers

573 users

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



211 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

Related questions

1 answer 198 views
198 views
How to get the total rows from a MySQL table with SQL
asked Oct 9, 2019 by avibootz
 | Search With Seek4Info.com
Powered by Question2Answer
...