Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Student Learning Environment on the World Wide Web PowerPoint Presentation
Download Presentation
Student Learning Environment on the World Wide Web

Student Learning Environment on the World Wide Web

81 Views Download Presentation
Download Presentation

Student Learning Environment on the World Wide Web

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. 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

  2. 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

  3. 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

  4. 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

  5. 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