With mysql_fetch_array I can easily count the rows returned. Can I do something similar with mysql_fetch_object?

Question

(Apologies if necessary--my first Stack Overflow question. I'll be happy to modify it if anyone has suggestions. I have looked for an answer but I'm afraid my grasp of the terminology isn't good enough to make a complete search.)

I'm accustomed to using mysql_fetch_array to get records from a database. When getting records that way, mysql_num_rows gives me a count of the rows. On my current project, however, I'm using mysql_fetch_object. mysql_num_rows doesn't seem to work with this function, and when I do a 'count' on the results of the query I get the expected answer: 1 (one object).

Is there a way to 'see into' the object and count the elements inside it?

nice, but you should ditch mysql_* function, replace it with mysqli, pdo (`mysqli->num_rows` is a property set to number of rows returned) — ajreal, Jan 03 '11 at 20:44

score 14 · Accepted Answer · edited Jun 20 '20 at 09:12

14

The function mysql_num_rows works on your result resource, not your object row.

Example

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$sql = "SELECT id, name FROM myTable";

$result = mysql_query($sql, $link);

$rowCount = mysql_num_rows($result);

while($row = mysql_fetch_object){
    echo "id: ".$row->id." name: ".$row->name."<BR>";
}
echo "total: ".$rowCount;

edited Jun 20 '20 at 09:12

Community

1
1

answered Jan 03 '11 at 20:47

ehudokai

1,928
12
9

1

I think `mysql_fetch_object` in your `while()` should actually be `mysql_fetch_object($result)` – Francis Booth Dec 12 '14 at 22:41

score 2 · Answer 2 · answered Jan 03 '11 at 20:41

2

Try count( (array)$object ).

answered Jan 03 '11 at 20:41

simshaun

21,263
1
57
73

This gave me a different answer. It returned the number of fields in my SELECT query. – David Rhoden Jan 06 '11 at 13:07

score 0 · Answer 3 · answered Jan 03 '11 at 20:42

0

If you're using it in procedural style (i.e. mysql_fetch_object() vs. $result->fetch_object()), mysql_num_rows should work exactly the same way as when using mysql_fetch_array(). Could you post some sample code?

answered Jan 03 '11 at 20:42

Mitch Grande

351
1
5

I am using it this way (in procedural style). Should I not be? – David Rhoden Jan 06 '11 at 13:08
No, using it procedurally is OK. Could you post a snippet of your code? – Mitch Grande Jan 06 '11 at 15:45
At this point the code has changed so much it wouldn't be relevant. Thanks for asking. – David Rhoden Jan 23 '11 at 22:13

score 0 · Answer 4 · answered Jan 03 '11 at 21:11

0

<?php
mysql_connect("localhost", "user", "password");
mysql_select_db("database");

$result = mysql_query("SELECT SQL_CALC_FOUND_ROWS * FROM table");
$countQuery = mysql_query("SELECT found_rows() AS totalRows");
$rows = mysql_fetch_object($countQuery);
echo $rows->totalRows;
?>

I hope this is useful :)

answered Jan 03 '11 at 21:11

ElSqueleto

1

It's interesting (I wasn't aware of this kind of SELECT SQL_CALC_FOUND_ROWS), but I want to do other things besides just count the rows. – David Rhoden Jan 09 '11 at 05:58

With mysql_fetch_array I can easily count the rows returned. Can I do something similar with mysql_fetch_object?

4 Answers4

Example