MYSQL TUTORIAL III
- This is a tutorial for building dynamic web pages to implement
the function of user registration by using html and programming
languages.It covers the basics of CGI programming with C, Perl,
PHP, Java or Python. After this tutorial, you should be able to
use CGI programming languages to create simple dynamic web
- Basic knowledge about html, especially html form.
- Basic knowledge about the programming language your want to
- Basic knowledge about how to connect to a Linux Server using
- Log into the EECS Linux Server cycle1.eecs.ku.edu
a) You can log into cycle1 from a Linux machine by using
"ssh" command to securely shell to cycle1. For example:
[xli72@1005-11 ~]$ ssh -l < YourEECS
Last login: Tue Aug 26 17:20:54 2013 from 1005-11.eecs.ku.edu
b)You can log into cycle1 from a windows machine by using
SSH client for Windows. If you are using a EECS widows machine,
you can use PuTTY, which has been already installed on the
If you don't have a SSH client, you need download and
install one(It is required to log into EECS website by using your
EECS account before you can download)
- Change your current directory to public_html under your home
directory by executing command: cd public_html.
Then begin your tasks.
- Create a web page with a html form so that users may input
their registration information in this form and submit it. The
registration information should include: name, phone
number and address. All these fields should be filled
in by users.
- Write a CGI program to get the registration information
submitted by a user from the user registration page and then
give the user feedback on his or her registration. Your program
should be able to handle two cases of registration:
- If the user has filled in all the fields in the first web
page, display a message for successful submission with the
- If the user did not fill in all the fields, your program
should display a warning message asking the user to fill in
all necessary fields.
Note:You should create web pages in the directory: public_html.
All your CGI programms should be in the directory public_html/cgi-bin, other than php scripts. Php scirpts should NOT be stored at the cgi-bin directory.
For example, if your EECS user name is jhuan, then you should
create html files in the directory /home/jhuan/public_html and
put your CGI programs in the directory
You may download an example program from: CGI
examples in C, Perl, PHP, Java and Python and modify it
following the instructions to complete the above tasks. Before
you modify the program, make sure that the program can work by
(compiling and) running it.
- You should submit a Lab report including the following parts:
- A short description of your code
- User screen shots of your webpages
to show how you test your program
- The url of your web page for user
- The source code of your program,
including source code for your html pages.
ALL YOUR MATERIALS SHOULD BE SUBMITTED AS A PART OF YOUR
HOMEWORK, WHICH MUST BE A SINGLE FILE.
- If you have any further questions
regarding your MySQL account or MySQL, please feel free to
contact the instructor.