MySQL versus PDO [duplicate]

by

PDO has the following advantages over the mysql_* functions:

  • It’s cross database, meaning it’s the same interface for different relational databases.
  • It helps protect against SQL injections.
  • It’s much cleaner (uses an object-oriented approach).

This question has been asked before, you may want to take a look at the answers:

If you are starting a new project, I would strictly suggest using PDO or a higher-level library/ORM. If you already have a lot of code written without it, it may not be worth it.

More Related Contents:

  1. Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
  2. MySQL remote connection fails with “unknown authentication method”
  3. MySQL and PDO: Could PDO::lastInsertId theoretically fail?
  4. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  5. SELECTING with multiple WHERE conditions on same column
  6. JDBC batch insert performance
  7. How to find gaps in sequential numbering in mysql?
  8. Can I create view with parameter in MySQL?
  9. MySQL: Invalid use of group function
  10. Combining UNION and LIMIT operations in MySQL query
  11. How to get only Digits from String in mysql?
  12. Exporting results of a Mysql query to excel?
  13. use mysql SUM() in a WHERE clause
  14. A constraint to prevent the insert of an empty string in MySQL
  15. Case statement in MySQL
  16. MySQL: Inner join vs Where [duplicate]
  17. MySQL ‘UPDATE ON DUPLICATE KEY’ without a unique column?
  18. Selecting from two tables with inner join and limit [duplicate]
  19. MySQL substring extraction using delimiter
  20. MySQL : retrieve a large select by chunks
  21. Import MySQL dump to PostgreSQL database
  22. Database corruption with MariaDB : Table doesn’t exist in engine
  23. How to SELECT by MAX(date)?
  24. MYSQL declaring variables
  25. get a recursive parent list
  26. MYSQL – Split Data Into Multiple Rows
  27. Automatic Rollback if COMMIT TRANSACTION is not reached
  28. MySQL cartesian product between two SELECT statements
  29. Sum until certain point – MySql
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment