PHP MySQL to MySQLi: Replace mysql functions using the mysqli extension

Recommend this page to a friend!

Download .zip

Info

Example

View files (4)

Download .zip

Reputation

Support forum (40)

Blog (3)

Links

Ratings				Unique User Downloads		Download Rankings
76%				Total: 7,048 This week: 8		All time: 276 This week: 16

Version		License		PHP version		Categories
`mydql2i` 1.6		Public Domain		5		PHP 5, Databases

Description

Author

Dave Smith

This class can replace the mysql functions using the mysqli extension.

It provides equivalent functions that perform the same operations as the mysql extension when this is not available.

An auxiliary script is provided to provide global functions with the same names and parameters as mysql extension functions except that they call the class to use the mysqli extension.

Recommendations

PDO Class
I need a class to connect to my db (mysql). Now my code is a old

PHP MySQL to MySQLi: Replace mysql functions using the mysqli ex
how to Replace mysql with MySQLi functions using the mysqli

Mysql 2 msqli
How to use msqli on mysql scripts

Best PHP mysql to mysqli or PDO solution
How to convert mysql code to use mysqli?

mysql to mysqli
looking for mysql2i

Innovation Award

June 2015
Winner

Prize: One downloadable copy of PhpED Professional

The original MySQL extension is being deprecated and will be removed from the core starting from PHP 7.

There is a lot of legacy applications that need to be updated to either move to mysqli or PDO extensions so they can work on PHP 7.

However, this process is not always trivial, as it is not just a matter of replacing the names of functions that are called.

This package provides a quick replacement of the mysql extension functions that use the mysqli extension functions instead. This way the legacy application can continue to work on PHP 7 or later with minimal changes.

Manuel Lemos

Dave Smith

Performance

Level

Name:	Dave Smith is available for providing paid consulting. Contact Dave Smith .
Classes:	51 packages by Dave Smith
Country:	United States
Age:	58
All time rank:	61	8 in United States
Week rank:	12	2 in United States

Level 7

Innovation award

Nominee: 32x

Winner: 7x

Example


<?php


  /*


  The mysql2i class is intened to provide seemless cross over when new versions of PHP,


  which no longer have the mysql extension, are installed. This is a temporary stop gap


  measure to allow developers time to update their code to mysqli or PDO::mysql extensions.


  


  The mysql2i class is a drop and go replacement for the PHP mysql extension. It uses a


  mysqli wrapper to handle mysql function calls.


  


  Place the mysql2i.class.php and mysql2i.func.php files in a web accessible folder and


  include the mysql2i.class.php file before any mysql function calls a made, usually from


  within your initialization files.


  


  The mysql2i.class.php file will include the functions file when the mysql extension is


  not found, so this class can be included anytime, even in installations where the mysql


  extension still exists.


  */


  include_once('mysql2i.class.php');


?>

Files

File	Role	Description
`example.php`	Example	Example Usage
`mysql2i.class.php`	Class	Main Class
`mysql2i.func.php`	Aux.	Functions
`readme.md`	Doc.	Additional Information

	mydql2i-2017-09-06.zip 4KB
	mydql2i-2017-09-06.tar.gz 3KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

Total:	7,048
This week:	8

All time:	276
This week:	16

User Ratings

User Comments (14)

	All time
Utility:	98%
Consistency:	95%
Documentation:	88%
Examples:	89%
Tests:	-
Videos:	-
Overall:	76%
Rank:	100

very good one 3 years ago (chap man)	80%
Really a great class for emergency cases! Thanks Dave 3 years ago (Mauro)	77%
Thank you so much for this package! My host decided to upgrad... 4 years ago (Ron Gaba)	80%
Thank you! One minor change, in mysql2i. 4 years ago (Manuel Guzman)	80%
Very usefull package. 5 years ago (zinsou A.A.E.Mo�se)	77%
Worked on an old piece of complex rats nest coding very well 6 years ago (jon washtell)	80%
Perfect! 6 years ago (Pedro Garcia)	80%
nice 6 years ago (muabshir)	80%
Thanks a lot for this code!! 7 years ago (Thierry Lemaire)	72%
Thanks for your great work. 7 years ago (Paco Perez)	80%
"does what is says on the tin" thanks. 7 years ago (Fred Mac Donald)	80%
Excellent support by the author 8 years ago (Heinz Ernst)	65%
Great and very useful! Thank you for sharing this. 8 years ago (Terry Woody)	80%
Thanks for the class, its really useful. 8 years ago (Saahisht Paul)	70%