4-Page Database System

search.php

  • Allow user to input search terms
  • Submit form to this same page
  • Display results with links to single.php using GET variables
  • Create this program second
single.php?id=5
-------------------->
single.php

  • Retrieve record for id passed by GET variables
  • Display data in desired format
  • Create this program first
    |
| update.php?id=5
|
v
new.php

  • Display form with all available database fields
  • INSERT new record upon submit and validation
  update.php

  • Display form with current values for record id
  • Allow user to modify values and click 'update' button