Before we start on the process of securing the data it seems essential to describe where we will start from.
First it is necessary to select a DataBase. My natural, emotional, choice for a DataBase would have been dBase. However for a whole set of reasons that I will gloss over at this point, I have opted for a much more widely used DataBase - it is Microsoft Access. A few clues about the reasons are shown below:-
- It uses a version of SQL (Structured Query Language) that can be used for other bigger capacity types of DataBase with minimal changes;
- It is simple to use in ASP files (Active Server Pages);
- Active Server Pages are supported in IIS (Internet Information Server) on Microsoft Servers;
- Microsoft Windows Servers are quick and fairly straightford to set-up.
This story is based on a supposition that the reader knows about creating and using HTML (Hyper Text Markup Language) web pages with forms.
The script below is for an imaginary page called 'Record a Full Name'
<html> <head> </head> <body bgcolor="#ffffbb"> <center> <b><u><font size=+2>ADD a PERSON NAME</font></u></b> <br> <FORM NAME="theForm" METHOD=POST ACTION="doaddName.asp"> <TABLE BORDER="2" WIDTH="650"> <TR> <TD colspan="4"> <INPUT TYPE="checkbox" SIZE=48 NAME="public_cb" CHECKED> Public (Tick for yes) <B>This tells us if other folk can see this name.</B> </TD> </TR> <TR> <TD> Title<BR><INPUT TYPE="TEXT" SIZE=7 NAME="title"> </TD> <TD> Forenames<BR><INPUT TYPE="TEXT" SIZE=30 NAME="forenames"> </TD> <TD> Surname<BR><INPUT TYPE="TEXT" SIZE=30 NAME="surname"> </TD> <TD> Honours<BR><INPUT TYPE="TEXT" SIZE=20 NAME="honours"> </TD> </TR> </TABLE> <BR> <TABLE BORDER="2" WIDTH="650"> <TR> <TD> <CENTER><BR> <INPUT TYPE=SUBMIT VALUE="To add this Name, Point and Click here"> </CENTER> </TD> </TR> </TABLE> </FORM> </center> </body> </html>
You can see the Web Page by Clicking here
Now we need to create a file called 'doaddName.asp' to process the information from the Web Page.
In the past, I have written such stories on one web page. One of the readers printed one out on paper - the paper was over fifty foot long. This time, Im using several pages to make it easier for readers to deal with. This page is just an Introduction to set the scene.
An index and links to the other pages is given below.