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.

Download Tutorial

Database
Create
Drop

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.

Code Listing : nav.php

<!-- The html, head and body tags are not included here because this code
     is always embedded inside another page that will contain these tags. -->

<h1>PHP and MySQL Library Tutorial</h1>
<table border="1" cellpadding="2" cellspacing="0">
  <tr valign="top"> 
    <td> 
      <p><strong>General</strong><br>
        <a href="/">Site Root</a><br>
        <a href="index.php">Database Home </a><br>
        <a href="connect.php">Conect&nbsp;to&nbsp;MySQL</a> <br>
        <a href="secureish.php">MySQL_Login.php</a> <br>
        <a href="navShow.php">nav.php</a><br>
        <a href="dumpShow.php">dump.php</a></p>
      <p> <a href="cleanUp.php">Clean Up</a> resets the<br>
        database to contain <br>
        a few sensible <br>
        records.</p>
      <p>
        <a href="download.php">Download Tutorial</a>
      </p>
    </td>
    <td>
      <p><strong>Database <br>
        </strong><a href="DBcreate.php">Create</a> <br>
        <a href="DBdrop.php">Drop</a>
      </p>
    </td>
    <td> <p><strong>Person Table</strong><br>
        <a href="personCreateTable.php">Create</a><br>
        <a href="personDropTable.php">Drop</a> <br>
        <br>
        <a href="personInsertForm.php">Insert</a> <br>
        <a href="personDelete.php">Delete</a> <br>
        <a href="personUpdate.php">Update</a> <br>
        <a href="personSearch.php">Search</a> <br>
        <a href="personDateSearch.php">Date-Search</a><br>
        <br>
        <a href="personSelect1.php">Row Dump<br>
        </a><a href="personSelect2.php">Better View</a>&nbsp;<br>
        <a href="personSelect3.php">Table View</a>&nbsp;<br>
        <a href="personSelect4.php">Form View</a> </p>
    </td>
    <td> <p><strong>Book Table</strong><br>
        <a href="bookCreateTable.php">Create</a><br>
        <a href="bookDropTable.php">Drop</a> <br>
        <br>
        <a href="bookInsertForm.php">Insert</a> <br>
        <a href="bookDelete.php">Delete</a> <br>
        <a href="bookUpdate.php">Update</a> <br>
        <a href="bookSearch.php">Search</a> <br>
        <br>
        <br>
        <br>
        <br>
        <a href="bookSelect3.php">Table View</a>&nbsp;<br>
        <a href="bookSelect4.php">Form View</a><br>
      </p>
    </td>
    <td> <p><strong>Loan Table</strong><br>
        <a href="loanCreateTable.php">Create</a><br>
        <a href="loanDropTable.php">Drop</a><br>
        <br>
        <a href="loanInsertForm.php">Insert</a><br>
        <a href="loanDelete.php">Delete</a> <br>
        <br>
        <a href="loanSearch.php">Search</a><br>
        <br>
        <br>
        <br>
        <br>
        <a href="loanSelect3.php">Table View</a> </p>	
    </td>
    <td>
      <p><strong>Documentation</strong><br>
        <a href="docDataRequirements.php">Data Requirements</a><br>
        <a href="docUI.php">User Interface Design</a><br>
        <a href="docERD.php">Entity&nbsp;Relationship&nbsp;Diagrams</a><br>
        <a href="docDFD.php">Data Flow Diagrams</a><br>
        <a href="docDateDict.php">Data&nbsp;Dictionary</a><br>
        <a href="docNotes.php">Implementation Notes</a><br>
        <a href="docTableDesigns.php">Table Designs</a><br>
        <a href="docGoals.php">Goals,&nbsp;Testing&nbsp;and&nbsp;Appraisal</a>
      </p>
    </td>
  </tr>
  <tr valign="top"> 
    <td colspan="6">
      <p><strong>Note - </strong>Create, Drop and Clean Up would be 
        hidden on a real life system.<br>
        <strong>Contact - </strong>nbauers at samphire dot demon dot co dot uk<br>
        <strong>Copyright &copy; - </strong>You may use and reproduce this material 
        in a &quot;not for profit&quot; setting.
      </p>
    </td>
  </tr>
</table>

<!-- The /html, /head and /body tags are not included here because this code
     is always embedded inside another page that will contain these tags. -->