Section V

Using a Database

  • Lesson 18: Introducing Databases
  • Lesson 19: Introducing MySQL
  • Lesson 20: Creating and Connecting to the Database
  • Lesson 21: Creating Tables
  • Lesson 22: Entering Data
  • Lesson 23: Selecting Data
  • Lesson 24: Using Multiple Tables
  • Lesson 25: Changing Data
  • Lesson 26: Deleting Data
  • Lesson 27: Preventing Database Security Issues

Variables in PHP hold information, but only for the length of the program. You can fill in a form to get information, but you need to store it somewhere. You need a place to hold your data that is still there after the program ends. This section introduces you to what databases are and how to design a database. You learn how to create a MySQL database, how to set up the appropriate tables, and how to use the MySQL scripting language within PHP to create, update, query, and delete information.

Get PHP and MySQL® 24-Hour Trainer 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.