mysql_num_rows replacement to recommend?

Question

I read that mysql_num_rows is deprecated as of PHP 5.5.0, and will be removed in the future. So what is best replacement by your opinion?

$KatalogVrstaID = $redak_katalog['KatalogVrstaID'];
$rezultat_podvrsta=mysql_query("SELECT * FROM katalog_podvrsta WHERE KatalogPodvrstaVrsta='$KatalogVrstaID' ORDER BY KatalogPodvrstaID ASC");
if (mysql_num_rows($rezultat_podvrsta)==0){ ?>

You should first change mysql_* functions to mysqli or PDO. Because the whole mysql_* functions will be deprecated in the coming versions. — Shankar Narayana Damodaran
– Shankar Narayana Damodaran, Commented Dec 5, 2013 at 10:03

Hugo Tunius · Accepted Answer · 2013-12-05 10:04:04Z

1

The mysql functions as a whole are deprecated, it is not only mysql_num_rows. You should switch to mysqli or POD database library. In short all mysql_* functions are deprecated.

You can read more about picking a database API here.

answered Dec 5, 2013 at 10:04

Hugo Tunius

2,88926 silver badges32 bronze badges

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

Comments

Ali · Accepted Answer · 2013-12-05 10:04:10Z

1

Mysqli is the new library you should use. they use the same function names but instead of mysql you write mysqli.. you also need to add one more parameter which is the link.

answered Dec 5, 2013 at 10:04

Ali

3,4364 gold badges19 silver badges31 bronze badges

Comments

Community · Accepted Answer · 2023-11-14 22:21:32Z

1

mysql extension is deprecated as of PHP 5.5.0. Instead, either the mysqli or PDO_MySQL extension should be used https://www.php.net/class.mysqli

edited Nov 14, 2023 at 22:21

CommunityBot

11 silver badge

answered Dec 5, 2013 at 10:05

naveen goyal

4,6272 gold badges18 silver badges26 bronze badges

Comments

tyteen4a03 · Accepted Answer · 2013-12-05 10:06:08Z

1

The only replacement is to stop using mysql_* altogether, because the whole library is deprecated.

PDO provides PDOStatement::rowCount() which you use on result objects, and MySQLi provides mysqli_result::$num_rows or mysqli_num_rows().

answered Dec 5, 2013 at 10:06

tyteen4a03

1,9432 gold badges27 silver badges51 bronze badges

Comments

Lustknylch · Accepted Answer · 2013-12-05 10:46:53Z

1

1) Use MySQLi / PDO, like the Authors above me said. 2) I read in a book that rowCount() is not 100% reliable for Select statements in some DBMS, but their are alternatives to count all rows

a) use fetchAll() <- not recommend for large results. b) use COUNT(*) in the Select-Statement and work with the result.

answered Dec 5, 2013 at 10:46

Lustknylch

214 bronze badges

Collectives™ on Stack Overflow

mysql_num_rows replacement to recommend?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related