MySQL Standard vs MySQLi Enhanced

[MysteriousD]

I've wondered this for awhile now, which MySQL driver is more recommended to use?

MySQL Standard or MySQLi Enhanced and what are the differences between the two.. :confused:

A noob friendly explanation is greatly appreciated.

[Seker]

The noobiest explanation ever:

1) The "i" stands for "improved."

2) Deprecation on MySQL has already started.

3) Use MySQLi

[Guest]

The only real option is MySQLi, MySQL is being depreciated, sure it will be a while before they get rid of it however, "build for the future"

[john.]

MySQL is like already mentioned a deprecated API as of PHP 5.5.0 and will be removed in a future version. Why? Well, it's insecure, lacking implementations of great features and is procedural.

[Guest]

MySQL is like already mentioned a deprecated API as of PHP 5.5.0 and will be removed in a future version. Why? Well, it's insecure, lacking implementations of great features and is procedural.

Where do you get insecure and procedural from? How is procedural even a reason? Mysqli is "procedural"

[dnenb]

Using PHP? Use mysql with PDO!

[KyleMassacre]

mysqli_query($c, "update some_table set some_column = {$_POST['text']}");

You mean secure like that?

[john.]

Where do you get insecure and procedural from? How is procedural even a reason? Mysqli is "procedural"

Yeah, it's definitely not bulletproof. Here's a pretty good question that covers http://stackoverflow.com/questions/5741187/sql-injection-that-gets-around-mysql-real-escape-string my thoughts on the matters.

Well, there is nothing wrong that it's procedural, however it still sucks because it lacks an object-oriented interface.

[Barrikor]

The main difference is that Mysqli has 2 big new improvements: prepared statements and built-in transactions.

 

Both of them have big flaws and gotchas, but at least they exist. The "it's more secure" thing is true, but over-hyped; people who wrote secure Mysql_ will write secure Mysqli, the people who wrote insecure Mysql_ will manage to write insecure Mysqli, you can be sure of that.

 

There's a lot of little things that I just don't like about Mysqli so I've been making a wrapper for Mysqli for my framework, I might make a post about it here sometime after I finish writing the online documentation for it.