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.

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.

Implementation:

In your bootstrap, include:

// 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):

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:

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.

Why was the mysql extension removed?

Lack of:

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

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

and GitHub: https://github.com/AzizSaleh/mysql

I will try my best to keep them updated.

Drawbacks of this library

Unfortunately due to limitations, there are some things you should know before implementing this library.

Resources

Since it is not possible to create resources on the fly in PHP. The following methods will not work as intended:

is_resource and get_resource_type

on the following mysql functions:

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:

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)):

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:

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:

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

Associating an existing PDO instance

Simple pass in your PDO object to mysql_add_existing_connection method:

$dbh = new PDO('mysql:dbname=testdb;host=127.0.0.1', 'root', 'password');

$ourCustomInstance = mysql_add_existing_connection($dbh);

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.

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

Version History:

1.0 - September 2013 * Initial release. * Tested via unit testing on PHP 5.0

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

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.

1.3 - October 2019 * When calling a bad instance, a MySQL2PDOException will be thrown instead of a die statement. * Fixed a bug where it was returning the wrong instance id in mysql_connect. * Added a new method mysql_add_existing_connection which allows you to associate an existing PDO instance to the code. See above for implementation. * Thanks to Matthew Baggett (matthew@baggett.me), also located at: https://github.com/matthewbaggett/MySQL2PDO for contributing all of above three changes. * Added unit test for new methods and fixed existing failing unit tests.

1.4 - October 2019 * Updated mysql_num_rows to use PDO's rowCount method to return data. Thanks to Benjamin Schanzel for the contribution. * Update mysql_unbuffered_query to correctly set the PDO attribute. * Fix a bug in mysql_connect which was not getting the existing link on same connections. Pointed out by Matthew Baggett. * Update unit tests.