PHPackages                             leonid-slv/mysql2pdo - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. leonid-slv/mysql2pdo

ActiveLibrary[Database & ORM](/categories/database)

leonid-slv/mysql2pdo
====================

Old mysql functions surrounded by newer PHP versions

1.3.3(5y ago)02.1kGPL-3.0PHP

Since Oct 9Pushed 5y ago1 watchersCompare

[ Source](https://github.com/Leonid-SLV/mysql2pdo)[ Packagist](https://packagist.org/packages/leonid-slv/mysql2pdo)[ RSS](/packages/leonid-slv-mysql2pdo/feed)WikiDiscussions main Synced 3w ago

READMEChangelog (1)DependenciesVersions (5)Used By (0)

Old mysql methods using PDO
===========================

[](#old-mysql-methods-using-pdo)

The package provides global mysql\_\* functions old model (PHP older 5.5) that can be used when the original MySQL extension is not available.

The librarie duplicates all popular of the functionality of mysql\_\* functions. Very high speed efficiency, almost 100% compared to direct use of PDO or mysqli.

It is important to note that there is support for encryption SSL certificate.

```
PHP 7 mysql_connect
PHP 7 mysql_select_db
PHP 7 mysql_real_escape_string
PHP 7 mysql_query
PHP 7 mysql_result
PHP 7 mysql_insert_id
PHP 7 mysql_fetch_array
PHP 7 mysql_fetch_assoc
PHP 7 mysql_fetch_row
PHP 7 mysql_num_rows
PHP 7 mysql_set_charset
PHP 7 mysql_error
PHP 7 mysql_errno
PHP 7 mysql_free_result
PHP 7 mysql_close

```

Lost connection:
----------------

[](#lost-connection)

In most cases, everything is fine! But it happens when the settings of the PDO driver are strange, for example, this was found in the cloud Yandex Function. To avoid this, just at the end of the code, insert

```
//Close all connections for fast restart
mysql_close();

```

Examples:
---------

[](#examples)

Classic connection:

```
//Connect and print date
$link = mysql_connect($host, $user, $password);
if ($link == false) { exit(); };
mysql_select_db($db,$link);
mysql_query('SET NAMES "utf8"');
echo (mysql_result(mysql_query('SELECT NOW();'),0,0));

```

SSL connection:

```
//SSL connect and print date
$link = mysql_connect($host, $user, $password, 'yandex.crt');
if ($link == false) { exit(); };
mysql_select_db($db,$link);
mysql_query('SET NAMES "utf8"');
echo (mysql_result(mysql_query('SELECT NOW();'),0,0));

```

Examples:

```
$result = mysql_query('SELECT `PAYMENTS`.`ID`, `PAYMENTS`.`DATE`, `PAYMENTS`.`CONTRACT`, `PAYMENTS`.`SUM`, `PAYMENTS`.`OPERATOR`, `PAYMENTS`.`COMMENT`, `PAYMENTS`.`DELETED`, `USERS`.`GROUP` FROM `PAYMENTS`,`USERS` WHERE `USERS`.`CONTRACT`=`PAYMENTS`.`CONTRACT` AND `PAYMENTS`.`ID_MANAGER`="'.$id_manager.'"'.$payments_search.' ORDER BY `DATE` DESC LIMIT '.$payments_count.';');
for ($i=0; $i