Chapter Objectives

• Add rows to a table with SQL's INSERT statement
• Build automatically incrementing sequences

Topics

• Nile dot Com
• Database schema
• INSERT syntax
• Automatic incrementing

Lab: A CGI script that:

• Reads and validates fields from a form.
• Opens the database.
• INSERTs the form data as a new row in a table.
• Auto-increments the ID field.

Summary