MySQL - count total number of rows in php

Question

What is the best MySQL command to count the total number of rows in a table without any conditions applied to it  I m doing this through php  so maybe there is a php function which does this for me  I don t know  Here is an example of my php    lt  php  con   mysql connect  server com   user   pswd    if    con      die  Could not connect      mysql error        mysql select db  db    con     result   mysql query  some command     row   mysql fetch array  result    mysql close  con     gt

User · Answer

you can do it only in one line as below    cnt   mysql num rows mysql query  SELECT COUNT 1  FROM TABLE     echo  cnt

User · Answer

use num rows to get correct count for queries with conditions   result    connect- gt query  select   from table where id   iid      count  result- gt num rows  echo   count

User · Answer

Use COUNT in a SELECT query    result   mysql query  SELECT COUNT 1  FROM table     num rows   mysql result  result  0  0

User · Answer

for PHP 5 3 using PDO   lt  php      staff  dbh- gt prepare  SELECT count    FROM staff login         staff- gt execute         staffrow    staff- gt fetch PDO  FETCH NUM        staffcount    staffrow 0         echo  staffcount    gt

User · Answer

lt  php  con mysqli connect  localhost   my user   my password   my db       Check connection if  mysqli connect errno          echo  Failed to connect to MySQL      mysqli connect error          sql  SELECT Lastname Age FROM Persons ORDER BY Lastname    if   result mysqli query  con  sql            Return the number of rows in result set    rowcount mysqli num rows  result     echo  number of rows     rowcount       Free result set   mysqli free result  result        mysqli close  con     gt    it is best way  I think  to get the number of special row in mysql with php

User · Answer

lt  php  con   mysql connect  server com   user   pswd    if    con      die  Could not connect      mysql error        mysql select db  db    con     result   mysql query  select count 1  FROM table     row   mysql fetch array  result     total    row 0   echo  Total rows       total   mysql close  con     gt

User · Answer

lt  php  conn mysqli connect  127 0 0 1 3306   root      admin       Check connection if  mysqli connect errno      echo  Failed to connect to MySQL      mysqli connect error       sql  select count  user id   from login user    result mysqli query  conn  sql    row mysqli fetch array  result   echo   row 0    mysqli close  conn     gt    Still having problem visit my tutorial http   www studentstutorial com php php-count-rows php

User · Answer

mysqli num rows is used in php 5 and above   e g   lt  php  con mysqli connect  localhost   my user   my password   my db       Check connection if  mysqli connect errno          echo  Failed to connect to MySQL      mysqli connect error          sql  SELECT Lastname Age FROM Persons ORDER BY Lastname    if   result mysqli query  con  sql            Return the number of rows in result set    rowcount mysqli num rows  result     printf  Result set has  d rows  n   rowcount        Free result set   mysqli free result  result       mysqli close  con     gt

User · Answer

Either use COUNT in your MySQL query or do a SELECT   FROM table and do    result   mysql query  SELECT   FROM table     rows   mysql num rows  result   echo  There are      rows     rows in my table

User · Answer

sql    select count column name  as count from table

[php] MySQL - count total number of rows in php

Examples related to php

Examples related to mysql