Getting a PHP PDO connection from a mysql_connect()?

by

Both extensions internally use EG(persistent_list) to store the persistent connection handle. But they create different hashes/keys for this list, so they can’t find entries of the respective other extension.

The mysql extension creates keys of the form "mysql_<host&port>_<user>..." while pdo builds "PDO:DBH:DSN=<dsn>:<user>:....". The hashes are used almost like array-keys in a php script. (Over-)simplyfied example:

function pconnect($host,$user,$pass) {
  global $persistent_list;
  $hashkey = sprintf("extensionname_%s_%s_%s", $host, $user, $pass);
  if ( isset($persistent_list[$hashkey]) ) {
    // use stored connection
  }
  else {
    // create new connection
  }
}

So the answer is: No, the connections will not be shared between and re-used by the mysql extension and PDO.

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. Insert form in MySQL with PDO [duplicate]
  4. PHP – Using PDO with IN clause array
  5. How to properly set up a PDO connection
  6. PHP PDO prepared statements
  7. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  8. PDO binding values for MySQL IN statement [duplicate]
  9. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  10. PDO mysql: How to know if insert was successful
  11. mysql PDO how to bind LIKE
  12. implement LIKE query in PDO
  13. PHP PDO prepared statement — MySQL LIKE query
  14. Fetching single row, single column with PDO
  15. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  16. How to install pdo driver in php docker image?
  17. How do I loop through a MySQL query via PDO in PHP?
  18. MySQL retrieve variable from Stored Procedure in PHP PDO
  19. Understanding pdo mysql transactions
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Use of PDO in classes [duplicate]
  24. How to handle PDO exceptions [duplicate]
  25. Check if row exists in the database before inserting
  26. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  27. PDO and MySQL Fulltext searches
  28. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  29. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment