Make WordPress Core

Opened 14 years ago

Closed 11 years ago

#11828 closed enhancement (duplicate)

switch to mysqli_* functions

Reported by: denis-de-bernardy's profile Denis-de-Bernardy Owned by: ryan's profile ryan
Milestone: Priority: normal
Severity: normal Version: 3.0
Component: Database Keywords:
Focuses: Cc:


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

Change History (7)

#1 @Denis-de-Bernardy
14 years ago

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

#2 @ryan
14 years ago

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?

#3 @ryan
14 years ago

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.

#4 @Denis-de-Bernardy
14 years ago

MySQLi also requires PHP 5.0 indeed. :-(

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.

#5 follow-up: @Denis-de-Bernardy
14 years ago

  • Milestone 3.0 deleted
  • Resolution set to invalid
  • Status changed from new to closed

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

#6 in reply to: ↑ 5 @ericlewis
11 years ago

  • Resolution invalid deleted
  • Status changed from closed to reopened

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.

#7 @markoheijnen
11 years ago

  • Resolution set to duplicate
  • Status changed from reopened to closed

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

Note: See TracTickets for help on using tickets.