PHP - 基本选择查询仅返回mysql数据库的第一行

Question

I've been running the query oh phpMyAdmin and it shows all the rows, but my query in php only returns the first row.

$result = $mydb -> query("SELECT * FROM music_sheet WHERE category='".$_REQUEST["submitter"]."'"); 

print(count($result)); //always returns 1

for ($x = 0; $x < count($result); $x++) {
    $row = mysqli_fetch_row($result);
}

Answer 1

For reference, here's why count() is returning 1. From the manual:

If the parameter is not an array or not an object with implemented Countable interface, 1 will be returned. There is one exception, if array_or_countable [the parameter] is NULL, 0 will be returned.

Since $result is a resource (object) that is returned from your query, not an array which you would get within your loop getting the actual data out of the resource, count($resource) will return 1.

Your solution is of course to use mysqli_num_rows(). To retrieve data from this resource, you need to loop over it as you are doing, but either use mysqli_num_rows() in place of count(), or other (more common) ways of looping through a result set, like so:

while($row = mysqli_fetch_row($result)) {
    // do stuff
}