matthewbaggett/mysql2pdo

MySQL2PDO adaptor

mysql methods using PDO

This package can be used to access MySQL databases using PDO wrapper functions. It provides a class with functions that can access a MySQL database in a way that is compatible with the original MySQL extension. The package provides global mysql_* functions that can be used when the original MySQL extension is not available with PDO as a backend., _(*1)

The object duplicates all of the functionality of mysql_* functions except for mysql_info method which I tried to duplicate as best as I can, but due to PDO limitations/my knowledge I can’t do it exact., _(*2)

Implementation:

In your bootstrap, include:, _(*3)

// Include the definitions
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'MySQL_Definitions.php');

// Include the object
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'MySQL.php');

// Include the mysql_* functions
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'MySQL_Functions.php');

// Now all of the mysql_* methods will work on a PHP version that has them removed.

(OPTIONAL : SEE DRAWBACKS) Update your error reporting to (depending on environment):, _(*4)

error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT); // Production
error_reporting(E_ALL & ~E_STRICT); // Development

(OPTIONAL : SEE DRAWBACKS) If you are using is_resource / get_resource_type for mysql_ methods you will need to replace them with the following functions: is_resource_custom / get_resource_type_custom. You can use your IDE to search replace or the following two lines in your project base:, _(*5)

find ./ -type f | xargs sed -i 's/is_resource( /is_resource_custom(/'
find ./ -type f | xargs sed -i 's/get_resource_type( /get_resource_type_custom(/'

Who is this for?

This package is for site owners/developers who want to upgrade their PHP version to a version that has the mysql_connect/mysql_* functions removed without having to re-write their entire codebase to replace those functions to PDO or MySQLI., _(*6)

Why were the mysql extension removed?

Lack of:, _(*7)

• Stored Procedures (can’t handle multiple result sets)
• Prepared Statements
• Encryption (SSL)
• Compression
• Full Charset support
• Security

mysql_* methods are easy to understand, but hard to secure. Since it does not provide Prepared Statements, more developers (beginners in particular) are prone to security risks. Not that mysql_* methods are insecure, but it makes it easier for beginner coders to make insecure queries., _(*8)

Alternative host:

This project can also be found on phpclasses.org: http://www.phpclasses.org/package/8221-PHP-Access-MySQL-databases-using-PDO-wrapper-functions.html, _(*9)

and GitHub: https://github.com/AzizSaleh/mysql, _(*10)

I will try my best to keep them updated., _(*11)

Drawbacks of this library

Unfortunately due to limitations, there are some things you should know before implementing this library., _(*12)

Resources

Since it is not possible to create resources on the fly in PHP. The following methods will not work as intended:, _(*13)

is_resource get_resource_type, _(*14)

on the following mysql functions:, _(*15)

Function Name (resource type) (our library type)
mysql_connect (mysql link) (int)
mysql_pconnect (mysql link persistent) (int)
mysql_db_query (mysql result) (PDO Statement)
mysql_list_dbs (mysql result) (PDO Statement)
mysql_list_fields (mysql result) (PDO Statement)
mysql_list_processors (mysql result) (PDO Statement)
mysql_list_dbs (mysql result) (PDO Statement)
mysql_query (mysql result) (PDO Statement)
mysql_unbuffered_query (mysql result) (PDO Statement)

To fix, you you will need to replace them with the following functions: is_resource_custom / get_resource_type_custom. You can use your IDE to search replace or the following two lines in your project base:, _(*16)

find ./ -type f | xargs sed -i 's/is_resource( /is_resource_custom(/'
find ./ -type f | xargs sed -i 's/get_resource_type( /get_resource_type_custom(/'

Error Reporting

If you pass a constant to the following methods (ex: string), you will trigger the following error "PHP Strict Standards: Only variables should be passed by reference" in PHP strict error mode (errro_reporting(>= 30720)):, _(*17)

mysql_fetch_array
mysql_fetch_assoc
mysql_fetch_row
mysql_fetch_object
mysql_db_name
mysql_dbname
mysql_tablename
mysql_result
mysql_free_result
mysql_freeresult
mysql_field_len
mysql_fieldlen
mysql_field_flags
mysql_fieldflags
mysql_field_name
mysql_fieldname
mysql_field_type
mysql_fieldtype
mysql_field_table
mysql_fieldtable
mysql_field_seek
mysql_fetch_field

To fix, you will need to change your error reporting hide strict standards (anything <= 30719). Examples:, _(*18)

error_reporting(30719); // <= 30719
error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT); // Production
error_reporting(E_ALL & ~E_STRICT); // Development

Unit Testing

There are 2 unit tests available in this project:, _(*19)

• MySQL_Test.php - Run this test is you are using PHP with mysql_connect() enabled.
• MySQL_Test_After.php - Run this test if the PHP version you have does not have mysql_connect() enabled.

About:

If you run into any issues, bugs, features or make things better please send them to me and I will get them in as soon as I can., _(*20)

@author    Aziz S. Hussain <azizsaleh@gmail.com>
@copyright GPL license 
@license   http://www.gnu.org/copyleft/gpl.html 
@link      http://www.AzizSaleh.com

Versions:

Current Version

Version 1.1, _(*21)

Version History:

1.0 - September 2013 * Initial release. * Tested via unit testing on PHP 5.0, _(*22)

1.1 - February 2014 * Initial Github release. * Sever Bugs reported by Domenic LaRosa fixed. * Tested on PHP 5.5.59 * Added is_resource_custom/get_resource_type_custom functions. * Added unit test for PHP >= 5.5.5 * Fixed some logical issues not tested on PHP >= 5.5.5, _(*23)

1.2 - September 2014 * Fixed an issue (Thanks to Martijn Spruit) where the script was breaking on PHP V <= 5.3.8 * Updated unit test for MySQL_Stat_Test to allow a <= 10 difference between the numbers., _(*24)