In fact, many of the major distros now package the MySQL extension, the MySQLi extension and the MySQL PDO driver together in the same package. PDO and the SQLite-specific driver should be part of the default PHP installation as of version 5.1.0 and the MySQL-specific driver would still need to be installed, but most Linux distributions often have different ideas how PHP should be compiled and packaged.
#PHP PDO DRIVERS#
Drivers exist for a growing list of databases, including MySQL. As I mentioned before, PDO consists of two parts: the extension itself which exposes the interface and a low-level database-specific driver. Once you’ve decided you want to modernize your code, you’ll need to make sure PDO is properly set up and configured. I use PDO and you should too! Installing and Configuring PDO
#PHP PDO UPDATE#
Choosing to migrate to PDO now means you won’t have to migrate to it later and update your code twice. Also, while the MySQLi extension is currently maintained, there’s always the chance it may be deprecated in the future.
PDO offers a consistent API to work with a variety of databases, so you won’t have to modify your PHP code if you ever have to use another database. When possible, I recommend people skip the middle man so to speak and migrate from the MySQL extension to PDO rather than to MySQLi. A lot of discussion and work is going into PDO and it’s considered the appropriate method of working with databases in modern, professional code. The interface exposes high-level objects for the programmer to work with database connections, queries and result sets, and low-level drivers perform communication and resource handling with the database server. Then most recent extension is PDO, which stands for “PHP Data Objects.” PDO offers an API that consolidates most of the functionality that was previously spread across the major database access extensions, i.e. If PDO isn’t right for your project, then this is the extension you should be using. It takes advantage of features that are available in newer versions of the MySQL server, exposes both a function-oriented and an object-oriented interface to the developer and a does few other nifty things. MySQLi is the “improved” extension for working with MySQL databases. The extension is now being deprecated in favor of the other two alternatives because of improvements made in newer releases of both PHP and MySQL. The MySQL extension is the oldest of the three and was the original option developers used to communicate with MySQL. There are actually three ways to interface with a MySQL database from PHP: the first is with the MySQL extension, the second is with the MySQLi extension and the third is with PDO. I won’t go into all of the features available to you with PDO, but I will share with you the basic methods you will need to know and offer a few tips so your migration will be as quick and painless as possible.įirst, you should understand where PDO sits in the PHP ecosystem.
This guide is a practical overview to help you begin migrating your existing PHP code from using the older MySQL extension to the newer PDO database abstraction extension.
0 kommentar(er)
