mysql_num_rows depreciation/removal

[Q695]

Does anyone know what mysql_num_rows has been changed to, and how to write it out for newer versions of PHP base?

 

[Jessica]

Yes. It's actually in the manual.

[litebearer]

rough idea...

 

$db = new mysqli($dbserver,$dbuser, $dbpass, $dbname);
$query = "SELECT field FROM tablename";
$results = $db->query($query);
$num_row = $results->num_rows;

 

[Q695]

Yes. It's actually in the manual.

The primary manual I use is: http://us.php.net/, and it didn't seem to be there.

[Jessica]

Really? The big bright red box telling you it's deprecated and with the option of two new extensions to use, with specific links to their pages in the manual...you don't see that big ole box? :-P

[Q695]

Really? The big bright red box telling you it's deprecated and with the option of two new extensions to use, with specific links to their pages in the manual...you don't see that big ole box? :-P

 

It's counting the fields in that array, not the number of arrays.

Edited April 25, 2013 by Q695

[Q695]

I guess what I'm looking for is how to apply a counting mechanism to count $row after the mysql_fetch_assoc, but for some reason it's giving me errors.

[Jessica]

Count what?

[Q695]

It's grabbing unique data for a page to load different products, and there is a handfull of almost identical products on the page they'll be linked to.  I want it to be top down for new adds, not bottom up with a maximum number of options allowed to create a new product, unless hacked.

Edited April 25, 2013 by Q695

[seandisanti]

If you use PDO with OO approach, you can just call $statement->rowCount()

[seandisanti]

Really? The big bright red box telling you it's deprecated and with the option of two new extensions to use, with specific links to their pages in the manual...you don't see that big ole box? :-P

Have to give them SOME credit though, it sounds like they're still putting in a bit more effort than people still asking for help to make their mysql_ calls work. 

[Q695]

This:

$count=$statement->rowCount();

Gives:

( ! ) Fatal error: Call to a member function rowCount() on a non-object in _________ on line _________

When added.

 

statement: mysql_fetch_assoc(___________);

Edited April 25, 2013 by Q695

[Jessica]

Either learn to read documentation, use classes and do basic debugging, or stick with your version 5.3.whatevs copypasta that is working. 

[seandisanti]

http://jream.com/learning/videos/php-oop/php-oop-tutorial-22-pdo-examples

 

12 minute video to show you how to use PDO, it should help you out.

[Q695]

 

Apache Version :

 

2.2.17  

 

PHP Version :

 

5.3.4 

 

[Q695]

finally got it for now: $count=mysql_num_rows($result);

 

will need to update it later.

[seandisanti]

Resorting to the deprecated function you were trying to replace in the first line of the thread is not getting it.  Just saying.