Suggested reading for PHP programmers:

  1. php.ini settings suggested for production http://www.dokuwiki.org/install:php
  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. http://us.php.net/manual/en/intro.pdo.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:

    <?php
    $dbh=newPDO('mysql:host=localhost;dbname=test',$user,$pass,array(
    PDO::ATTR_PERSISTENT=>true
    ));
    ?>
  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. “ ( http://www.php.net/manual/en/mysqli.overview.php which also shows a Comparison Table of Features of the other PHP extentions.)
    Prepared Statement: http://php.net/manual/en/mysqli.prepare.php
    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: http://stackoverflow.com/questions/13569/mysqli-or-pdo-what-are-the-pros-and-cons
  4. PHP Cheat Sheets: http://www.gosquared.com/liquidicity/archives/501 got some quick tips that I’d never try to memorize. See my page of all useful cheat sheets.
  5. PHP Forums & Getting Help:http://www.phpbuilder.com/board/ or http://stackoverflow.com/questions/tagged/php5 programmers support programmers.