how to get the number of rows of mysql db with php

Question

i would like to get the number of rows of a mysql database table with one single statement or a function

include "opendatabase.php"; //opens database

while (NUMBEROFROWS > 0){
    //do something
}

the NUMBEROFROWS should be replaced with the statement that returns the number of rows

i already tried to create a function

function getRowNumber(){
    $query = "SELECT COUNT(*) FROM  `votes`";
    $result = mysql_query($query, $connect);

    list($length) = mysql_fetch_row($result);
    return $length;

}

but it does not work if i dont put the include "opendatabase.php"; in it.

what am i doing wrong

Initialize the database connection in opendatabase.php and pass the connection link as a parameter to your function. — Amal
– Amal, Commented Mar 11, 2014 at 15:34
It's a scope issue. Your DB connection should be made global (which is not recommended) or passed through the function itself. — Funk Forty Niner
– Funk Forty Niner, Commented Mar 11, 2014 at 15:36
what error do you get when you dont use include "opendatabase.php"; — Shairyar
– Shairyar, Commented Mar 11, 2014 at 15:36

BMN · Accepted Answer · 2014-03-11 16:44:32Z

1

$result = mysql_query("SELECT * FROM tablename");

if (mysql_num_rows($result) > 0) {
    // rows found..
}

edited Mar 11, 2014 at 16:44

BMN

8,57614 gold badges51 silver badges80 bronze badges

answered Mar 11, 2014 at 16:39

Vincent

4,4101 gold badge40 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Friedrich · Accepted Answer · 2014-03-11 15:36:54Z

1

the problem is that include "opendatabase.php"; runs in another scope like described here

http://www.php.net/manual/en/language.variables.scope.php

there is a global $connect missing within the function

answered Mar 11, 2014 at 15:36

Friedrich

2,3302 gold badges22 silver badges43 bronze badges

Comments

Zy0n · Accepted Answer · 2014-03-11 15:33:38Z

0

Here you go:

function num(){
 $data = mysql_query("SELECT * FROM table");
  if(mysql_num_rows($data) > 0){
    while($row = mysql_fetch_assoc($data)){
      // do something with your data..
    }
  }
}

answered Mar 11, 2014 at 15:33

Zy0n

7852 gold badges15 silver badges33 bronze badges

Comments

echo_Me · Accepted Answer · 2014-03-11 15:47:17Z

0

would this work for you ?

  function getRowNumber()
{
   $query = "SELECT COUNT(*) as counts FROM  `votes`";
   $result = mysql_query($query, $connect);
   $row = mysql_fetch_array($result);
   $counts = $row['counts'];
return $counts;

}

edited Mar 11, 2014 at 15:47

answered Mar 11, 2014 at 15:34

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Collectives™ on Stack Overflow

how to get the number of rows of mysql db with php

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related