Chapter 4

Using the Database


check Adding new data to your tables

check Updating existing data in your tables

check Finding data quickly

check Working with backups and restores

The preceding chapter covers how to create databases and tables for your dynamic web application. That’s all well and good, but databases and tables don’t really do anything until you start placing data in them.

This chapter explores the different methods you have available for adding, changing, and removing data in your application tables. After that, it walks through possibly the most important feature of any database: how to quickly retrieve the data that your application needs. The chapter closes by discussing the important jobs of backing up and restoring database data.

Working with Data

The ability to easily manage application data is the whole reason dynamic web applications use databases. So it stands to reason that the SQL language has quite a few options for working with data. There are four basic functions that we need to do with the data in our application:

  • Add new data records to tables.
  • Modify existing ...

Get PHP, MySQL, & JavaScript All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.