Database Work

I l @ ve RuBoard

You work with the data in a database via a standard language called SQL (Structured Query Language). SQL lets you add, delete, and edit the tables in a database, as well as query, update, delete, and add records in a table of a database. PHP, like all languages that work with databases, uses SQL to work with the database. All PHP does is pass the SQL command to the database. If a query is being run, the database returns the result of the query to PHP. PHP can be used not only to query data from a database, but also to perform all the functions SQL can carry out.

Note

SQL has many permutations across the different DBMSs. For portability, this book uses ANSI SQL92 ”and I recommend that you do as well.

I l @ ve RuBoard