Suggested reading for PHP programmers:

  1. php.ini settings suggested for production
  2. PDO (the PHP Data Objects) shipped with PHP 5.1 or later, and available as a PECL extension for PHP 5.0; this extension defines a lightweight, consistent interface for accessing databases in PHP.
    It provides adata-access abstraction layer, meaning regardless of which database in use, we can use the same functions to issue queries and fetch data.
    Prepared Statement and Stored Procendure:
    : to prevent SQL injection attacks
    PDO Persistent connections: Helps avoid the overhead of establishing a new connection every time a script needs to talk to a database, resulting in a faster web application:

  3. MySQLi: I found so many PHP programmers are still using PHP MySQL Extension. “If you are using MySQL versions 4.1.3 or later it is strongly recommended that you use the mysqli extension instead. “ ( which also shows a Comparison Table of Features of the other PHP extentions.)
    Prepared Statement:
    Some prefer PDO because they didn’t know MySQLi can also do prepared statement.
    Should we use PDO or MySQL? Going more OOP, I am switching to PDO. How to decide?
    I know, I know, MySQLi got both object-oriented interface as well as a procedural interface. And “PDO does not allow you to use MySQL’s support for Multiple Statements.”
    Check out this discussion:
  4. PHP Cheat Sheets: got some quick tips that I’d never try to memorize. See my page of all useful cheat sheets.
  5. PHP Forums & Getting Help: or programmers support programmers.