Apart from MySQL, PHP supports almost all relevant (and some not-so-relevant ones, as well) databases on Earth. This chapter features the basic techniques used with many of those systems, especially connecting to the database, executing SQL statements, and retrieving the return data. As in Chapter 8, “Working with MySQL Databases,” we are using a sample database called
phrasebook and a sample schema/table from within it called
quotes, with the following four fields:
• id—An integer value that is increased by one for each new entry entered into the database. Depending on the database system, the data type is either called
auto_increment, or something similar.
• quote—The quote, as a
VARCHAR(255); this ...