How to successfully rewrite old mysql-php code with deprecated mysql_* functions?

by

Actually, a simple, sweet and short: Yes, not necessary any longer.

Let’s review the code not that we have lost something:

  • __construct – The constructor merely contained all the configuration. PDO has a much easier concept here, a connection string containing the most information:

     mysql:host=127.0.0.1;dbname=people;charset=UTF-8

    Also PDO provides the constructor for use ready-made, so double not necessary.

  • connect – The connection function is not necessary any longer as well. This is done by instantiating PDO already. You can look for exceptions, the PHP manual has an example on it’s constructor page.

  • selectDb – This complicated function is not needed any longer as well. Wow, the third function we can just drop because of the PDO connection string. Much power with so less characters. Cheers!

  • __destruct – The destructor. Let’s be fair: MySQL did not need this as well. However with PDO we get it for free – without writing a single line of code.

Looks good! You managed to migrate from that obscure database class to PDO by removing outdated code! Congratulations:

$db = new PDO('mysql:host=127.0.0.1;dbname=people;charset=UTF-8', 'root', 'pass');

If you now think, what about if I want to have database class on my own? Well you can do that, because you can extend from PDO (yes that works!):

class DB extends PDO
{
   ... my super-new-shiny-code
}

Why you might want to do that? No idea, but maybe it’s more fluent for your code. If you’re looking for a better code-example, I have one at PHP/MySQL Table with Hyperlinks.

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. Using PHP data in MySQL [closed]
  3. which is better every user have a table or just a row [closed]
  4. save user images in MYSQL database by which method? [closed]
  5. PHP – Change value y,n in database [closed]
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Many-to-many relationships examples
  8. Deprecated: mysql_connect() [duplicate]
  9. PDO get the last ID inserted
  10. strange character encoding of stored data , old script is showing them fine new one doesn’t
  11. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  12. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  13. How to upload images into MySQL database using PHP code
  14. Importing CSV data using PHP/MySQL
  15. How to loop through a mysql result set
  16. MySQL check if a table exists without throwing an exception
  17. Maximum execution time in phpMyadmin
  18. Fetching single row, single column with PDO
  19. Mysql No connection could be made because the target machine actively refused it
  20. Replacing mysql_* functions with PDO and prepared statements
  21. Is there any way to check the performance of mysql Indexing
  22. Selecting a float in MySQL
  23. phpmyadmin automatic logout time
  24. MySQL skipping first row
  25. Fatal error: Call to undefined function mysqli_result()
  26. Laravel nested relationships
  27. Selecting all fields except only one field in mysql [duplicate]
  28. mysql injection damages?
  29. How do I save PHP session data to a database instead of in the file system?
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment