PHP 5.4

[RobertP]

Just to inform everyone, time to move to PDO if you have not already.

 

mysql_* functions are *soft deprecated* ...

 

[Philip]

Or mysqli if your heart desires so.

[Stooney]

The guy is right, many tutorials out there are going to break with 5.4.

[scootstah]

The guy is right, many tutorials out there are going to break with 5.4.

 

No they're not. mysql_* is not even deprecated yet. And even if it was it would still work in PHP5.4, albeit with an error message (which you can suppress).

[The Little Guy]

I have 5.4 and mysql works just fine

[Pikachu2000]

If they remove the mysql_* extension functions as quickly as they removed register_globals, we're screwed! SCREWED I TELL YOU!

[scootstah]

If they remove the mysql_* extension functions as quickly as they removed register_globals, we're screwed! SCREWED I TELL YOU!

 

Hah, yeah. When they roll out PHP7.0 there will be a lot of pissed off newbies.

[Hall of Famer]

Well those who are used to MySQL will need to live with the fact that PDO does not have an equivalent method PDO::num_rows() to replace mysql_num_rows(). Its quite annoying, but can be easily overcome with the usage of 'SELECT COUNT' statement. As far as I know, 'SELECT COUNT' is more efficient than mysql_num_rows(), although it does take much more typing.

[KevinM1]

Well those who are used to MySQL will need to live with the fact that PDO does not have an equivalent method PDO::num_rows() to replace mysql_num_rows(). Its quite annoying, but can be easily overcome with the usage of 'SELECT COUNT' statement. As far as I know, 'SELECT COUNT' is more efficient than mysql_num_rows(), although it does take much more typing.

 

Uh... http://www.php.net/manual/en/pdostatement.rowcount.php

[scootstah]

Well those who are used to MySQL will need to live with the fact that PDO does not have an equivalent method PDO::num_rows() to replace mysql_num_rows(). Its quite annoying, but can be easily overcome with the usage of 'SELECT COUNT' statement. As far as I know, 'SELECT COUNT' is more efficient than mysql_num_rows(), although it does take much more typing.

 

Uh... http://www.php.net/manual/en/pdostatement.rowcount.php

 

For most databases, PDOStatement::rowCount() does not return the number of rows affected by a SELECT statement. Instead, use PDO::query() to issue a SELECT COUNT(*) statement with the same predicates as your intended SELECT statement, then use PDOStatement::fetchColumn() to retrieve the number of rows that will be returned.

 

You can also just do count($result->fetchAll());

[Philip]

Uh... http://www.php.net/manual/en/pdostatement.rowcount.php

That won't get you a count from a select, just of recently affected rows.

 

You can also just do count($result->fetchAll());

That's about the closest thing, however if you don't want to fetch all of the rows the select count will always be there for you. In a situation like this, one less query usually == better.

[scootstah]

In a situation like this, one less query usually == better.

 

You could probably do a sub-select to get the total rows couldn't you?

 

Seems a little weird though.

[Philip]

Yeah, you could probably do.