select count from table of mysql in php

Question

I am able to get both the value and row of the mysql query result   But I am struggling to get the single output of a query  e g     result   mysql query  SELECT COUNT    FROM Students       I need the result to display  But I am not getting the result   I have tried with the following methods    mysql fetch assoc   mysql free result   mysql fetch row     But I didn t succeed to display  get  the actual value

User · Answer

Please start using PDO  mysql   is deprecated as of PHP 5 5 0 and will be removed entirely in 7  Let s make it easier to upgrade and start using it now   dbh   new  PDO  dsn   user   password    sth    dbh- gt prepare  SELECT count    as total from Students     sth- gt execute    print r  sth- gt fetchColumn

User · Answer

howmanyuser query  conn- gt query  SELECT COUNT uno   FROM userentry       howmanyuser  howmanyuser query- gt fetch array MYSQLI NUM     echo  howmanyuser 0     after the so many hours excellent

User · Answer

You can as well use this and upgrade to mysqli   stop using mysql   extension      result   mysqli query  conn   quot SELECT COUNT    AS  count  FROM  Students  quot     row   mysqli fetch array  result    count    row  count    echo  count

User · Answer

With mysql v5 7 20  here is how I was able to get the row count from a table using PHP v7 0 22    query    select count    from bigtable    qresult   mysqli query  this- gt conn   query    row   mysqli fetch assoc  qresult    count    row  count       echo  count    The third line will return a structure that looks like this   array 1         count       gt string 4   1570      In which case the ending echo statement will return   1570

User · Answer

num result   mysql query  SELECT count    as total count from Students    or exit mysql error      row   mysql fetch object  num result   echo  row- gt total count

User · Answer

db    new PDO  mysql host localhost dbname java db    root    pass     Sql    quot SELECT count    as  total  FROM users quot    stmt    db- gt query  Sql    stmt- gt execute     total    stmt- gt fetch PDO  FETCH ASSOC   print   lt pre gt    print r  total   print   lt  pre gt     Result

User · Answer

You need to alias the aggregate using the as keyword in order to call it from mysqli fetch assoc   result mysqli query  conn  SELECT count    as total from Students     data mysqli fetch assoc  result   echo  data  total

User · Answer

here is the code for showing no of rows in the table with PHP   sql  select count    as total from student table    result mysqli query  con  sql    data mysqli fetch assoc  result   echo  data  total

User · Answer

result   mysql query  SELECT COUNT    AS  count  FROM  Students      row   mysql fetch assoc  result    count    row  count      Try this code

User · Answer

If you only need the value    result   mysql query  SELECT count    from Students     echo mysql result  result  0

User · Answer

You need to alias the aggregate using the as keyword in order to call it from mysql fetch assoc   result mysql query  SELECT count    as total from Students     data mysql fetch assoc  result   echo  data  total

User · Answer

For mysqli users  the code will look like this    mysqli   new mysqli  db host   db user   db pass   db name     result    mysqli- gt query  SELECT COUNT    AS Students count FROM Students  - gt fetch array    var dump  result  Students count       or    mysqli   new mysqli  db host   db user   db pass   db name     result    mysqli- gt query  SELECT COUNT    FROM Students  - gt fetch array    var dump  result 0

[php] select count(*) from table of mysql in php

Examples related to php

Examples related to mysql

Examples related to count