May 2003
Intermediate to advanced
592 pages
14h 28m
English
Content preview from PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 6. Using PHP and MySQL
Of the available Application Programming Interfaces (APIs) that you can use with MySQL, including Perl, Java, C, C++, Python, and more, PHP may be the most common. PHP’s strong integration with MySQL is just one reason so many programmers have embraced it, along with the common open source philosophy they both share.
Support for the MySQL database, which must be built into the PHP configuration, has been included by default since the advent of PHP version 4. The current version of PHP at the time of this writing (4.3) includes a number of MySQL-specific fixes and upgrades and has support for the new MySQL 4.0.
In this chapter I will use the existing sitename database—created in Chapter 4, “Introduction to SQL and ...