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.

Home

PHP and MySQL Library Booking System Example. Each page in this site makes its own HTML, PHP and MySQL code visible.

Learn SQL to ...

CREATE databases and tables
DROP databases and tables
INSERT INTO tables
UPDATE tables
DELETE FROM tables
SELECT FROM tables
JOIN two or more tables
Take action WHERE conditions apply
Search

Learn HTML to ...

Create input forms
Submit data from a form to another web page

Learn PHP to ...

Use data submitted to a web page
Display results in form layout
Display results in table layout

This site has a very spartan user interface. This prevents the database functionality being buried under fancy HTML and style sheet features.

Hint: When developing applications, get then to work first and make them look nice last.