A web-based application will be built to do the following: In SQL format

MAKE Listing Page A table will display data for all matches. Table will include the following columns:

-Event

-Player 1

-Player 2

-Match Date (Date must be in mm/dd/YYYY format )

-Result

Within each row will be a link to send user to the Details Screen for the selected game.

Date must be in mm/dd/YYYY format. No more than 25 records will be displayed at a time. Above the table will be a Filter mechanism to enable the user to alter the list (see next requirement)

Listing Filter The filter will be an HTML form directly above the table. It will contain the following inputs:

Date Range two text input fields, defaulting blank. When dates are entered in mm/dd/ YYYY format the listing will be limited to matched in that time range.

Name search one text field to search for player names. The string must perform a wildcard search of both player columns. Defaults blank Result a dropdown selector will allow the user the select from the following four conditions (first is default)

Any Player 1

Player 2

Draw Submit Button clicking this button will submit the form

-- When filter information is submitted, the data set must be filtered by all relevant filters.

-- When filter information is submitted, the user-supplied data must be repopulated in the form. Details Screen

-- A separate screen will provide details of a given game.

-- This screen will display the following information about a single chess game: Event Name Event Site Date Round Number Player 1 name Player 2 name The result of the game The ECO and opening. (Append these together.)

The moves See the class materials page for an example of the output.

Sample output-Page 1 Name Contains Search 28 records found Event Player One Player Two Match Date Result k obese. Watu 07/31/1999 Player One ie sen, Peter Heine Benjamin, Joe 07/31/1999 ID FIDE-Woh k.o Nielsen, Peter Heine!08/01/1999 Draw Kobese. Watu Lautier, Joel 08.01/1999 PlayerTwo FIDE-Wch k.o. g/25+10 Benamin, Joel Nielsen, Peter Heine 08.02/1999 Player One FIDE-Wch k.o. g/15+10 Nielsen, Peter Heine Benamin, Joel 08/02/1999 Draw FIDE-Vich k.o. g/25+10 Nielsen, Peter Heine! Benjamin, Joel 08.02/199g Player One FIDE-Wch k.0 g/15+10 Benjamin, Joel Nielsen, Peter Heine|08/02/1999 Draw ch k.o. Sudden Death! Nielsen, Peter Heine Benjamin, Joe! 08/02/1999 Player One Sakaev, Konstantin 0803, 1999 Draw Sakae, Konstantin Lautier, Joel 08/04/1999 |Dr FIDE-woh k o, g/25+10 Sakae. Konstantin Lauter Joe 08/05/1999 PlayerT ch k.o. g/25+10 Sakaev, Konstantin 0805/ 1999 Draw Lautier, Joel Gelfand, Boris 08 08/199g Draw FIDE-Wch k.o. g/15+10 Lautier, Joel Gelfand, Boris 08/08/1999 Playe r Two FIDE-Wch k.o, g/25+10 Lautier, Joel Gelfand, Boris 08/08/1999 Draw ch k.o. g/25+ 10 Gelfand, Boris Lautier, Joel 08/08/1999 Draw ch k.. g/15+10 Gelfand, Bons Lautier, Joel 08.08.1999 | Player One Gelfand, Boris Lautier, Joel 08 07/199g Draw 1/28/2000 Player One Benjamin,Joe Leitao,R Benjamin,Joe 12/01/2000 Player One Baklan.V Benamin,Joe 11/27/2001 PlayeTwo Benamin,Joe Baklan,V 11/27/2001 Playe r Two Ballan Benjamin,Joe 11/27/2001 Draw Balkan Benjamin,Joe 11/27/2001 |Draw FIDE WC h KO Benjamin,Joe Baklan,V 11/28/2001 |Draw Sample output-Page 1 Name Contains Search 28 records found Event Player One Player Two Match Date Result k obese. Watu 07/31/1999 Player One ie sen, Peter Heine Benjamin, Joe 07/31/1999 ID FIDE-Woh k.o Nielsen, Peter Heine!08/01/1999 Draw Kobese. Watu Lautier, Joel 08.01/1999 PlayerTwo FIDE-Wch k.o. g/25+10 Benamin, Joel Nielsen, Peter Heine 08.02/1999 Player One FIDE-Wch k.o. g/15+10 Nielsen, Peter Heine Benamin, Joel 08/02/1999 Draw FIDE-Vich k.o. g/25+10 Nielsen, Peter Heine! Benjamin, Joel 08.02/199g Player One FIDE-Wch k.0 g/15+10 Benjamin, Joel Nielsen, Peter Heine|08/02/1999 Draw ch k.o. Sudden Death! Nielsen, Peter Heine Benjamin, Joe! 08/02/1999 Player One Sakaev, Konstantin 0803, 1999 Draw Sakae, Konstantin Lautier, Joel 08/04/1999 |Dr FIDE-woh k o, g/25+10 Sakae. Konstantin Lauter Joe 08/05/1999 PlayerT ch k.o. g/25+10 Sakaev, Konstantin 0805/ 1999 Draw Lautier, Joel Gelfand, Boris 08 08/199g Draw FIDE-Wch k.o. g/15+10 Lautier, Joel Gelfand, Boris 08/08/1999 Playe r Two FIDE-Wch k.o, g/25+10 Lautier, Joel Gelfand, Boris 08/08/1999 Draw ch k.o. g/25+ 10 Gelfand, Boris Lautier, Joel 08/08/1999 Draw ch k.. g/15+10 Gelfand, Bons Lautier, Joel 08.08.1999 | Player One Gelfand, Boris Lautier, Joel 08 07/199g Draw 1/28/2000 Player One Benjamin,Joe Leitao,R Benjamin,Joe 12/01/2000 Player One Baklan.V Benamin,Joe 11/27/2001 PlayeTwo Benamin,Joe Baklan,V 11/27/2001 Playe r Two Ballan Benjamin,Joe 11/27/2001 Draw Balkan Benjamin,Joe 11/27/2001 |Draw FIDE WC h KO Benjamin,Joe Baklan,V 11/28/2001 |Draw