MySQL vs MySQLi (improved)
Login / Search
#54123 (In Topic #11805)
Which to pick? some insight
So here I am right, installing ocp 4.2 rc2 !!!! sheez don't touch me, I'm still quivering.:o
But I get to STEP 3 of the install wizard
: mysql4+ traditional < default
but... *dun dun dun*
There is also MySQL4+ mysqli driver!
Why does this even matter you may ask...
Well, I'm glad you did ask.
Rather than vomit it all here, you can get acquainted with mysqli here in all it's glory
Ah yes, but you probably don't care about that right... You want the goods.
Alright, I got the MOTTS ...
The mysql (TRADITIONAL) extension provides a procedural interface and is intended for use only with MySQL versions older than 4.1.3. This extension can be used with versions of MySQL 4.1.3 or newer, but not all of the latest MySQL server features will be available.
The mysqli extension, or as it is sometimes known, the MySQL improved extension, was developed to take advantage of new features found in MySQL systems versions 4.1.3 and newer. The mysqli extension is included with PHP versions 5 and later.
The mysqli extension has a number of benefits, the key enhancements over the mysql extension being:
Note: If you are using MySQL versions 4.1.3 or later it is strongly recommended that you use this extension.
Just thought I would share, and sharing is half the battle.:ninja:
There are too many online users to list.