Blottos Select-A-Wine Assignment

(Accessing a mysql database using Perl and Php.)

Overview

Blotto wishes to spend more time in his product testing department of his wine business.

He wants you to turn Blotto's Select-a-Wine into a web-based operation.

Specifically clients should be able to use a web based interface to select the wine of their choice from Blottos current stock.
(Blotto, in one of his more lucid moments, has recently loaded his wines onto a mysql database.)

Your task is to implement his plans in two different technologies, perl and php so that he can compare the two techniques.

There is a sample solution of a perl/mysql implementation on cybil (cybil.tafeitltn.com.au/~lastf/blotto2.htm)

Perl Solution - How does this work ?

Blotto2.htm calls a perl script, sqllist.pl, which creates a web page containing two select boxes and a Submit button.

The Select boxes must be populated from the mysql database, test_1. (The table is called wines.)

Selection from both Select boxes and pressing the Submit button calls the perl script sqlwine2.pl which then displays the wines the customer has selected.

1. Blotto2.htm

2. sqllist.pl

3. sqlwine2.pl

You are required to create both a perl and php implementation of the above.

That is all that is required at this stage. There is no need to provide order or purchase facilities.

---