Ratings | | Unique User Downloads | | Download Rankings |
76% | | Total: 7,100 This week: 4 | | All time: 273 This week: 18 |
|
Description | | Author |
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. 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 |
| |
|
|
Innovation award
Nominee: 32x
Winner: 7x |
|
Recommendations
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');
?>
|
Details
The problem
PHP has deprecated the mysql extension which will be removed in PHP 7. Even though it was recommended to use the improved extension, mysqli, many developers continued to use mysql.
The effect
Once PHP 7 is released in mid November of this year, 2015, many hosted servers will upgrade and scripts still relying on the old mysql extension will fail.
There are lot of web sites using legacy packages that are no longer supported by the developer and not all developers have had time to update their current packages to the improved mysqli extension.
The solution
The PHP mysql to mysqli package was developed to be the stop gap to keep everything working smoothly.
It can be placed in any PHP script, at anytime, and when the mysql extension disappears, it will take over. It works by defining functions using the old mysql function names and passing the arguments to the class methods that will use the improved mysqli extension.
|
Applications that use this package |
|
No pages of applications that use this class were specified.
If you know an application of this package, send a message to the author to add a link here.