We are working on the assumption that XYZ company has a server say www.abc.com with a certain IP address (assumed 202.54.27.226). When any client connects to this server, an html page comes across to his computer. This page contains tags that are required to build a good user interface. Strictly speaking it's a form that comes over and the client has to key in some data. When the user clicks on a button of type 'submit', the information entered by the user is retransmitted back to the server for processing. Processing could mean either inserting it as a record into its database or querying the database or anything which is more of data management. Validation and error checks are built in for right options to be selected. The first part of this project focuses on addition of records into the database whereas the second half deals with querying the database.
Requirements
Database Format:
Create a database named bdata.mdb in the cgi directory. Insert a table named bd. The format for this table is as follows
| id | number | 4 |
| title | char | 3 |
| fname | char | 40 |
| desig | char | 40 |
| company | char | 40 |
| address | char | 150 |
| tele | char | 15 |
| fax | char | 15 |
| char | 40 | |
| flag | char | 1 |
| quali | char | 150 |
| prgm | number | 4 |
| analysis | number | 4 |
| prjmgmt | number | 4 |
| workarea | char | 150 |
| tools | char | 100 |
| os | char | 100 |
| expert | char | 40 |
Validation: id is a counter and must be unique
ODBC Setup
To setup ODBC , click on the
Start -> Settings
Control Panel -> 32bit ODBC
A dialogbox titled ODBC Data Source Administrator pops up on the screen . For the title - USER DSN click on Add. All this is basically to create a Data Source Name (DSN) that will represent the Driver program and the database name. Since it needs the Driver program , another box comes up on the screen asking you to select the driver for the new DSN. Double click on Microsoft Access Driver and it will lead you to another box , where you have to key in the name . If you are trying to execute the program as is, then the DSN must be sonal. This name now needs the database file , so select the bdata.mdb file present in the cgi directory. Description is not important and can be ignored comfortably.
So, sonal now represents bdata.mdb and MS Access driver . The drivers are intelligent programs that convert the SQL statements they receive into the right syntax of the databases.
Inserting Records into the Database
Querying the Database
Back to CGI Page
Back to the Cornucopia Page
Vijay Mukhi's Computer
Institute
VMCI, B-13, Everest Building, Tardeo, Mumbai 400 034, India
Tel : 91-22-496 4335 /6/7/8/9
Fax : 91-22-307 28 59
e-mail : vmukhi@giasbm01.vsnl.net.in
http://www.vijaymukhi.com