CP Home
Database
Description
Script Index
I-5 QMC
MySQL
Database
SQL
PHP
HTML
Email

Edit Driver - Database Maintenance Scrips

Produces a webpage of drivers to select for editing,
and a webpage form for editing the selected driver, and updates
the existing driver record in the racing.drivers database table


Script: edit_drivers_menu.php

Input

From Maintenance Menu:
  1. home_club | text
  2. validate | text
From racing database:
  1. drivers.Driver_ID | integer | array
  2. drivers.First_Name | text | array
  3. drivers.Last_Name | text | array
  4. html.Head | text
  5. html.Menu_Top | text
  6. html.Tail | text
  7. validate.Mode | text
Actions



Output

To edit_driver_form.php on Edit Driver Form:
  1. Selected Driver_ID | integer
  2. home_club | text
  3. validate | text
To Display:



Script: edit_driver_form.php

Input

From edit_drivers_menu.php: See Output above

From racing database using selected drivers.Driver_ID:
  1. drivers.First_Name | text
  2. drivers.Last_Name | text
  3. drivers.Birthday | date
  4. drivers.Home_Club | text
  5. html.Club_Array | serialized array
  6. html.Head | text
  7. html.Menu_Top | text
  8. html.Tail | text
  9. validate.Mode | text
  10. validate.Home_Club | text
Actions



Output

To insert_driver_rev.php on Update Driver:
  1. drivers.First_Name | text
  2. drivers.Last_Name | text
  3. drivers.Birthday | date
  4. drivers.Home_Club | text
  5. validate.Mode | text
  6. validate.Home_Club | text
To Display:



Script: insert_driver_rev.php

Input

From edit_driver_form.php: See Output above

From racing database:
  1. html.Head | text
  2. html.Menu_Top | text
  3. html.Tail | text
  4. validate.Mode | text
Actions



Output

To racing database:
  1. Update the selected Driver_ID record in the drivers table
To Display: