switch to mysqli_* functions

[Denis-de-Bernardy]

now that we're requiring MySQL 4.1, how about we start using the mysqli functions instead?

[Denis-de-Bernardy]

​http://www.php.net/manual/en/mysqli.overview.php

The mysqli extension has a number of benefits, the key enhancements over the mysql extension being:

• Object-oriented interface

• Support for Prepared Statements

• Support for Multiple Statements

• Support for Transactions

• Enhanced debugging capabilities

• Embedded server support

[ryan]

​http://www.php.net/manual/en/mysqli.requirements.php

If using MySQL5 you must have >=5.0.7. That probably kills it right there. Bumping to 4.1.2 stranded a surprising number of people.

Also, isn't mysqli PHP 5 only?

[ryan]

It would probably be more useful to conditionally use the new native drive for PHP 5.3 and greater and leave < 5.3 on the old mysql extension. mysqli is an unloved middle child.

​http://dev.mysql.com/downloads/connector/php-mysqlnd/

[Denis-de-Bernardy]

MySQLi also requires PHP 5.0 indeed. :-(

​http://www.php.net/manual/en/mysqli.connect.php

My understanding of the mysqlnd is that it's for use by mysqli or pdo; it's just an extra configuration at the server level.

[Denis-de-Bernardy]

I'll just close this, pending sunnier days...

[ericlewis]

Replying to Denis-de-Bernardy:

I'll just close this, pending sunnier days...

The sun has been up for a year now since 3.2 dropped and required PHP 5, let's do this.

[markoheijnen]

The sun has been shinning already with ticket #21663 so closing this one.