PHP PDO vs normal mysql_connect

by

PDO is a bit slower than the mysql_*
But it has great portability. PDO provides single interface across multiple databases. That means you can use multiple DB without using mysql_query for mysql, mssql_query for MS sql etc. Just use something like $db->query(“INSERT INTO…”) always. No matter what DB driver you are using.

So, for larger or portable project PDO is preferable. Even zend framework use PDO.

More Related Contents:

  1. PDO Fetch statement only retrieves first column
  2. Insert form in MySQL with PDO [duplicate]
  3. Undefined index $_POST
  4. PHP – Using PDO with IN clause array
  5. Getting raw SQL query string from PDO prepared statements
  6. How do I set ORDER BY params using prepared PDO statement?
  7. “Invalid parameter number: parameter was not defined” Inserting data
  8. Having issue with matching rows in the database using PDO
  9. PDO binding values for MySQL IN statement [duplicate]
  10. PDO mysql: How to know if insert was successful
  11. How can I properly use a PDO object for a parameterized SELECT query
  12. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  13. PDO with INSERT INTO through prepared statements [closed]
  14. implement LIKE query in PDO
  15. PHP PDO prepared statement — MySQL LIKE query
  16. Fetching single row, single column with PDO
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. PDO Connection Test
  19. Can I create a database using PDO in PHP?
  20. PDO::PARAM for type decimal?
  21. PHP PDO and MySQLi [duplicate]
  22. PDO fetch one column from table into 1-dimensional array
  23. Getting a PHP PDO connection from a mysql_connect()?
  24. PDO error: SQLSTATE[HY000]: General error: 2031
  25. Having issue with matching rows in the database
  26. Set PDO to throw exceptions by default [duplicate]
  27. Use of PDO in classes [duplicate]
  28. Check if row exists in the database before inserting
  29. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment