Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Student Learning Environment on the World Wide Web • CGI-programming in Perl for the connection of databases over the Internet. • Web authoring using Frontpage 98 • Supervisor 1: Dr. P. Filmore • Supervisor 2: Dr. P. Culverhouse • Author: Bernd Pratschke • Plymouth, 21 April, 1999
CGI programming for the World Wide Web Client Using Web Browser 1. Browser contacts server using HTTP connection over the Internet 5. Web server software sends browser the HTML prepared by the CGI programme Web Server Hardware Web Server Software 2. Web server software executes a CGI script 4. CGI script creates HTML page with dynamically obtained data CGI Script 3. CGI script uses other server hardware resources Email Database OS Commands
DBI - The Perl database interface Common Gateway Interface DBI Interface DBD Interface Driver Interface Database Interface HTTP Protocol Web Browser Web Server CGI Script DBI Module DBD ODBC Module Access Database Driver Database (Access) DBD Oracle Module Oracle Database Driver Database (Oracle) Programme Code • allows users to access multiple database types transparently • ability to connect to two different databases within one Perl script • database server can be upgraded in the background with no changes to the CGI scripts
Submitting data to the Graduates contact database SECEE Graduates Registration form (name and birthday) Parse registration form Compare with registration text file Name and birthday correct ? no Create error message Link back to registration form yes Create Graduate contact form Maintain state no Input correct ? Create error message Link back to Graduates contact form yes Parse Contact form Create e-mail with the information Store information in database Create thank you message Link back to SECEE Graduates site
Retrieving data from the Graduates contact database SECEE Graduates Database search form (name, birthday, company, year of graduation, programme of study) Parse database search form Connect to database Search database for entries no Found entries? Create error message Display another search form Link back to SECEE Graduates yes Display results Display another search form Link back to SECEE Graduates