database using mysql and pymysql

If you have not done so, install XAMPP so you can have Apache in your computer. Follow the steps in the class lecture notes to ensure that Apache supports Python CGI.

(1) Write a Python CGI application, h10q1.py to accept two HTTP parameters:

sid: Swimmer Id

mid: Meet Id

The Web application displays the events the swimmer signed up for participation in the meet. For examples:

http://.../h10q1.py?sid=1&mid=2

http://.../h10q1.py?sid=3&mid=1

Host the Python application in your dcm account. Note that dcm server may have problems in using dbconfig.py and dbconfig.ini, so you may include your dam's Myself credential directly in h10q1.py. Mail in your URL for the Web application and the Python code.

Your program filenames should be h10q1.py.

The swimmer signed up for the following events for the meetShell Trial: 2016-08-04 Event 100M Butterfly: 10:10:00 to 10:30:00 Event 200M Freestyle: 10:40:00 to 10:50:00 The swimmer signed up for the following events for the meetUHCL Open: 2016-03-03 Event 50M Butterfly: 9:10:00 to 9:30:00 Event 100M Freestyle: 9:40:00 to 9:50:00