HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


MySQL vs MySQLi (improved)

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#54123 (In Topic #11805)
Avatar

Honoured member

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 ...


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:
  • Object-oriented interface
  • Support for Prepared Statements
  • Support for Multiple Statements
  • Support for Transactions
  • Enhanced debugging capabilities
  • Embedded server support


Note: If you are using MySQL versions 4.1.3 or later it is strongly recommended that you use this extension.

source



Just thought I would share, and sharing is half the battle.:ninja:
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: