Have most of you upgraded to MySQLi ?

[jeddi]

A very powerful change appears to be the buffering:

PHP applications can navigate freely through buffered results.
Navigation is fast because the result sets are held in client memory. Please, keep in
mind that it is often easier to scale by client than it is to scale the server.

But now this is something new to get my head around ( as if I didn't have enough to do )

Did you re-write all your scripts ?


.

[Fou-Lu]

Yep, fully converted my mysql aggregate drivers to mysqli with version 5.1. Also have a PDO one to be used with things like oracle. So the only script I rewrote was creating the mysqli driver, then changing the configs to load the mysqli driver instead of the mysql. Done and done.
Unless something has *drastically* changed with HTTP (which it hasn't), than I think you may be interpreting that quote differently than you should be. The "client" here is the server processing the PHP code, while the "server" here is the MySQL server. So this isn't the same as a remote client connect to your web server. So there's really nothing new for you to worry about, as your visitors wouldn't see any changes on their end whatsoever. This is just a fancy way of saying that it will, on average, perform better than the mysql did, which in turn would perform better than PDO would.

[felgall]

I had started using mysqli_ for new scripts a while ago taking advantage of some of the additional functionality that interface provides such as OO rather than procedural and PREPARE/BIND.

Just recently finished doing quick conversions of all my old scripts - basically just adding the 'i' and switching the parameters around the other way.

[jeddi]

Thanks for your comments.

I shall start trying to right in OOP but I hope that my
current scripts can be converted to MySQLi without too much hassle

.

[elem]

so is MySQLi better than PDO ? if so, how ? I'm after changing myself to PDO, is there any advantage that MySQLi has over PDO ?

[Fou-Lu]

See the link in my sig for which to use. There will be a table that shows some of the feature comparisons.

MySQLi uses native drivers, so it is more feature rich and will provide better performance overall. PDO is an abstraction layer, so as long as you stick to non-proprietary SQL code, than you can swap the drivers to use on different database types. So the answer is, if you plan to stick completely with mysql, than use the mysqli. If you have potential to use oracle or sqlserver as well as mysql, than use PDO.

[elem]

I see .. and how about SQL injection ? cause that was primary reason I went for PDO, is MySQLi handling that in a similar way ?

[Fou-Lu]

Originally Posted by elem

I see .. and how about SQL injection ? cause that was primary reason I went for PDO, is MySQLi handling that in a similar way ?

PDO and MySQLi both provide prepared statements which are immune to SQL Injection.