PHP and MySQL Library Tutorial

General
Site Root
Database Home
Conect to MySQL
MySQL_Login.php
nav.php
dump.php

Clean Up resets the
database to contain
a few sensible
records.

Person Table
Create
Drop

Insert
Delete
Update
Search
Date-Search

Row Dump
Better View
Table View
Form View

Book Table
Create
Drop

Insert
Delete
Update
Search

Table View
Form View

Loan Table
Create
Drop

Insert
Delete

Search

Table View

Documentation
Data Requirements
User Interface Design
Entity Relationship Diagrams
Data Flow Diagrams
Data Dictionary
Implementation Notes
Table Designs
Goals, Testing and Appraisal

Note - Create, Drop and Clean Up would be hidden on a real life system.
Contact - nbauers at samphire dot demon dot co dot uk
Copyright © - You may use and reproduce this material in a "not for profit" setting.

User Interface

Menu and Module Structure

DDL - SQL Data Definition Language - Used to manage the database and tables.
DML - SQL Data Manipulation Language - Used to select, insert, delete or update data in the tables.

1	Repeat: All options are available until the user quits the site or browser.
2	Navigation: User selects a general menu option.
3	Navigation: User selects a database menu option.
4	Navigation: User selects a person menu option.
5	Navigation: User selects a general book option.
6	Navigation: User selects a general loan option.
7	Navigation: User selects a documentation menu option.
8	Quit: User quits the site by closing the browser window or navigating away from the site.
9	DDL: A page to create the loan table. In real life this would be password protected and available only to the database administrator.
10	DDL: A page to drop (delete) the loan table. In real life this would be password protected and available only to the database administrator.
11	DML - Input: A page to insert a new loan record.
12	DML - Delete Process: A page to delete a loan record.
13	DML Select Process and Output Result: A page to search for a loan record.
14	DML Select Process and Output Result: A page to view all the loan records.
15	DDL: A page to create the book table. In real life this would be password protected and available only to the database administrator.
16	DDL: A page to drop (delete) the book table. In real life this would be password protected and available only to the database administrator.
17	DML - Input: A page to insert a new book record.
18	DML Delete Process: A page to delete a book record.
19	DML Update Process: A page to edit an existing book record.
20	DML Select Process and Output Result: A page to search for a book record.
21	DML Select Process and Output Result: A page to view all the book records.
22	DDL: A page to create the person table. In real life this would be password protected and available only to the database administrator.
23	DML - Delete Process: A page to drop (delete) the person table. In real life this would be password protected and available only to the database administrator.
24	DML - Input: A page to insert a new person record.
25	DML - Delete Process: A page to delete a person record.
26	DML Update Process: A page to edit an existing person record.
27	DML Select Process and Output Result:A page to search for a person record.
28	DML Select Process and Output Result:A page to view all the person records.
29	DML - Delete Process: A page to demonstrate and execute the code used to drop the entire database.
30	DDL: A page to demonstrate and execute the code used to create the database (but not the tables).
31	Documentation: Data requirements documentation.
32	Documentation: The Entity Relationship Diagram for this database.
33	Documentation: A data dictionary. This contains information about every named object, its data type and its location or scope within the project.
34	Documentation: Implementation Notes: A log of the software tools and programming techniques used.
35	Documentation: Table documentation and the links between the tables.
36	Documentation: A table that summarises the project goals, how they are to be tested, a summary of the test results and an appraisal of the success of each goal.
37	Navigation: User navigates to the home page.
38	Process: A page to test the connection to the MySQL server.
39	Documentation: This page documents the MySQL security and login details. This would not normally be made public.
40	Documentation: This page documents the HTML code used for the site navigation.
41	Documentation: This page documents the code used to display the SQL, HTML anf PHP code of the web pages.
42	DDL amd DML: This page executes SQL statements to restore the database to its initial state. In a real life system, a page similar to this could be used to install the database.
43	Download: A page with a tutorial download link and installation instructions.