Download the PHP package mattbit/mysql-compat without Composer
On this page you can find all versions of the php package mattbit/mysql-compat. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download mattbit/mysql-compat
More information about mattbit/mysql-compat
Files in mattbit/mysql-compat
Package mysql-compat
Short Description Backward compatibility for old mysql_* functions with PDO
License MIT
Homepage https://github.com/mattbit/mysql-compat
Informations about the package mysql-compat
Old mysql functions compatibility for PHP5.6 and PHP7
This library tries to provide backward compatibility with the deprecated mysql_*
functions.
Caveat
You really should not use this unless strictly needed: it's much better to refactor the existing code to use PDO
and prepared statements directly or an ORM like Eloquent.
Although library provides an hackish replacement for mysql_real_escape_string
, you ought to refactor your code to use prepared statements.
Requirements
PHP >= 5.6
with the PDO
driver is required (PHP 7
is supported).
Installation
You can install mysql-compat
via composer:
Usage
The mysql_
-equivalent functions are available through the facade class Mattbit\MysqlCompat\Mysql
.
Note that the static methods are named in a camel-case like version of the original functions, e.g. mysql_fetch_array
becomes Mysql::fetchArray
.
If you are using PHP7 and want to re-define the old global functions and constants without touching existing code, you can use the Mysql::defineGlobals
method:
If you need more control over the connections, the database manager allows you to access the underlying objects.
This is particularly useful if you need to customize connection's DSN (e.g. to specify the charset):
To do
- [X]
mysql_affected_rows
- [ ]
mysql_client_encoding
- [X]
mysql_close
- [X]
mysql_connect
- [ ]
mysql_create_db
- [X]
mysqldataseek(not supported) - [ ]
mysql_db_name
- [ ]
mysql_db_query
- [ ]
mysql_drop_db
- [X]
mysql_errno
- [X]
mysql_error
- [X]
mysql_escape_string
- [X]
mysql_fetch_array
- [X]
mysql_fetch_assoc
- [X]
mysql_fetch_field
- [X]
mysql_fetch_lengths
- [X]
mysql_fetch_object
- [X]
mysql_fetch_row
- [ ]
mysql_field_flags
- [ ]
mysql_field_len
- [ ]
mysql_field_name
- [ ]
mysql_field_seek
- [ ]
mysql_field_table
- [ ]
mysql_field_type
- [ ]
mysql_free_result
- [ ]
mysql_get_client_info
- [ ]
mysql_get_host_info
- [ ]
mysql_get_proto_info
- [ ]
mysql_get_server_info
- [ ]
mysql_info
- [X]
mysql_insert_id
- [ ]
mysql_list_dbs
- [ ]
mysql_list_fields
- [ ]
mysql_list_processes
- [ ]
mysql_list_tables
- [ ]
mysql_num_fields
- [X]
mysql_num_rows
- [ ]
mysql_pconnect
- [ ]
mysql_ping
- [X]
mysql_query
- [X]
mysql_real_escape_string
- [X]
mysql_result
- [ ]
mysql_select_db
- [X]
(see issue #7 for information)mysql_set_charset
- [ ]
mysql_stat
- [ ]
mysql_tablename
- [ ]
mysql_thread_id
- [ ]
mysql_unbuffered_query
All versions of mysql-compat with dependencies
ext-pdo Version *