PHP Classes

mysql_* functions using PDO: Access MySQL databases using PDO wrapper functions

Recommend this page to a friend!
  Info   View files View files (11)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 869 All time: 4,028 This week: 156Up
Version License PHP version Categories
mysql_connect 1.1GNU General Publi...3.0PHP 5, Databases
Collaborate with this project Author

mysql - github.com

Description

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.

Innovation Award
PHP Programming Innovation award nominee
September 2013
Number 3
The original PHP MySQL extension is being deprecated in favor of the MySQLi or PDO extensions.

This packages implements a wrapper that provides the MySQLi extension functions using the PDO extension, so existing applications that rely on the MySQL extension can still work.

Manuel Lemos
Picture of Aziz S. Hussain
  Performance   Level  
Name: Aziz S. Hussain <contact>
Classes: 8 packages by
Country: United States United States
Age: 40
All time rank: 51165 in United States United States
Week rank: 287 Up26 in United States United States Up
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

Details
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 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): 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 were 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 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. 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.1 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.
  Files folder image Files  
File Role Description
Accessible without login Plain text file MySQL.php Class Main PDO Functionality
Accessible without login Plain text file MySQL_Definitions.php Aux. MYSQL Constants Definitions
Accessible without login Plain text file MySQL_Functions.php Aux. mysql_* method declarations
Accessible without login Plain text file MySQL_Example.php Example Example usage
Accessible without login Plain text file MySQL_Test_Schema.sql Data SQL data required for unit test
Accessible without login Plain text file MySQL_Test.php Test Unit test
Accessible without login Plain text file MySQL_Test_Results.txt Data Unit test results on my localhost
Accessible without login Plain text file MySQL2PDOException.php Class Class source
Accessible without login Plain text file MySQL_Test_After.php Test Unit test on PHP 5.5.9
Accessible without login Plain text file README Doc. Read me file
Accessible without login Plain text file README.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 90%
Total:869
This week:0
All time:4,028
This week:156Up
User Comments (3)
Thank you! I was in the midst of writing my own version of m...
7 years ago (Arn B)
85%StarStarStarStarStar
I needed something that I could bundle with my software (open...
7 years ago (Nicholas Maietta)
72%StarStarStarStar
good
9 years ago (Rahul Shambharkar)
80%StarStarStarStarStar