PHP P rogr amming with MySQL精品管理文档.doc

PHP Programming with MySQL (second edition) by Don Gosselin, Diana Kokoska, Robert Easterbrooks (ISBN-13: 978-0-5387-4584-0, ISBN-10: 0-5387-4584-3) Reference: /manual/en/langref.php Reference: / Chapter 8: Manipulating MySQL Databases with PHP One of PHP’s greatest strengths is its ability to access and manipulate databases. With its strong support for Open Database Connectivity (ODBC), you can use PHP to gain direct access to any database that is ODBC compliant, including Oracle, Informix, PostgreSQL, and MySQL. PHP also allows you to work directly with different types of databases without going through ODBC. PHP also supports other methods of accessing data sources, including SQLite, database abstraction layer functions, and PEAR DB. SQLite and database abstraction layer functions work with file-based databases instead of server-based databases such as MySQL. The PHP Extension and Application Repository (PEAR) is a library of open source PHP code. One of the most popular PEAR code modules is PEAR DB, which simplifies access between PHP and a database server by providing a generic interface that works with various types of database systems, similar to how ODBC works. Although PEAR DB and ODBC perform similar functions, PEAR DB is designed specifically to work with PHP, whereas ODBC is a more generic protocol used by many programming languages and database management systems. With so many database connectivity options, how do you decide which method to use for accessing databases with PHP? First, you need to select a database management system. You could start with an open source database such as PostgreSQL or MySQL, because they are free and fairly easy to learn. After you select a database, you need to determine whether PHP can access it directly or whether it must go through a layer such as ODBC or PEAR DB. Using ODBC or PEAR DB makes it easier for you to write PHP code that can be used with a variety of databases. However, your PHP script will be faster if