Assignment 03 Chess Database Your client is a web site devoted to chess and chess championships. They need a web-based interface to manage a database of matches from recent chess championships. No changes need to be made to the database, but it must be searchable and must also provide a screen of match details. They will provide a database in SQL format, and will pay $975 for a complete application. Database Structure: id INT, primary event VARCHAR(32) site VARCHAR(32) matchDate DATE round VARCHAR(5) player1 VARCHAR(48) player2 VARCHAR(48) result ENUM(1,2,D) (D=draw) player1Elo INT player2Elo INT eco VARCHAR(3) opening VARCHAR(48) moves TEXT This data should be imported into MySQL. A web-based application will be built to do the following: 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 28 records found. Event Player One Player Two Match rate Result FIDE Wchko Lautier Joel Kobese Watu 07/31 1900 Payer One Details 0713111999 Draw 08/01 1999 Player Two FIDE Wchko g/25+10 Benamin. Joel Nielsen, Peter Heine 1303 Payer One heALDetaila 08/02 1999 Draw FIDE-Wch k g/25+10 Nielsen, Peter Heine Benjamin, Joel Payer One ViEADetails FIDE Wchko. Sudden Death Nielsen, Peter HeineBenjamin, Joel 08/02 1999 Player One View Details FIDE-Nch k.o. g/25+10 Lautier Joel Sakaev. Konstantin 08/0519g3 FIDE-Wich k.o. g/15+10 08/06 1999 Player Two Mea Details FIDE-Nch k.o. g/25+10 Celand. Boris Lautier. Joel 19g3 nDr WCh KO Benjamin 112TI2000 Payer Two FIDE wch Ko Benjamin Joe FiontoF 11/29/2000 payer One ViEADetails WCh KO Benjamin Joe Leitao R 1130 2000 DaW FIDE WCh KO Leilac.R Benyamin Joe 12012000 Player One MewDetails FIDE Wch Ko Benjamin Joe Bakan.V 11/27/2001 Player Two MEA Delais WCh KO Baklar Benjamin Joe 11/2TI2001 DaW FIDE Wch Ko Baklamv Benyamin Joe 11/27/2001 ViEADeLails Sample output Page 2 FIDE-Weh k.o. g/25+10 Event Number Player Nielsen, Peter Heine Player Player One (E62) Delayed F anchetto, KI E62 ECO Opening Mov d4 d6 2. g3 Nf6 3.Bg2 g6 4 Nf3 Bg7 5.0-0 O-O 6.c4 c6 7.Nc3 BfS 8 Net Be6 9.d5 cxd5 10.cxd5 Bd7 h3 Qa5 12 e4 Bb5 13 Nxb5 Qxb5 14 Nd3 Nbd7 15 a4 Qab 16 R21 Rt 8 17 Be3 Nb6 18 Bf1 Qc4 19 a5 Nbd7 20.Nc5 Qb4 21. Ra4 Qxe1 22.Qxe1 Nxc5 23.Rc4 Nfd7 24.Bd4 Ne5 25. Bxe5 Bxe5 23.Qc 1 Rc7 27.Q:2 b5 28.axb6 axb6 29. Qe2 Ra2 30 Rc2 Kg7 31.b4 Rxc2 32.Qxc2 Ne6 33 Qd3 Nd4 34.Qa6 Nf3+ 35.Kg2 Ne1+ 36 Kh1 Bd4 37.Qe2 Bc3 30, Qe3 b5 39.Qb6 Rc8 40 Qc6 1-0 Sample output Page 1 28 records found. Event Player One Player Two Match rate Result FIDE Wchko Lautier Joel Kobese Watu 07/31 1900 Payer One Details 0713111999 Draw 08/01 1999 Player Two FIDE Wchko g/25+10 Benamin. Joel Nielsen, Peter Heine 1303 Payer One heALDetaila 08/02 1999 Draw FIDE-Wch k g/25+10 Nielsen, Peter Heine Benjamin, Joel Payer One ViEADetails FIDE Wchko. Sudden Death Nielsen, Peter HeineBenjamin, Joel 08/02 1999 Player One View Details FIDE-Nch k.o. g/25+10 Lautier Joel Sakaev. Konstantin 08/0519g3 FIDE-Wich k.o. g/15+10 08/06 1999 Player Two Mea Details FIDE-Nch k.o. g/25+10 Celand. Boris Lautier. Joel 19g3 nDr WCh KO Benjamin 112TI2000 Payer Two FIDE wch Ko Benjamin Joe FiontoF 11/29/2000 payer One ViEADetails WCh KO Benjamin Joe Leitao R 1130 2000 DaW FIDE WCh KO Leilac.R Benyamin Joe 12012000 Player One MewDetails FIDE Wch Ko Benjamin Joe Bakan.V 11/27/2001 Player Two MEA Delais WCh KO Baklar Benjamin Joe 11/2TI2001 DaW FIDE Wch Ko Baklamv Benyamin Joe 11/27/2001 ViEADeLails Sample output Page 2 FIDE-Weh k.o. g/25+10 Event Number Player Nielsen, Peter Heine Player Player One (E62) Delayed F anchetto, KI E62 ECO Opening Mov d4 d6 2. g3 Nf6 3.Bg2 g6 4 Nf3 Bg7 5.0-0 O-O 6.c4 c6 7.Nc3 BfS 8 Net Be6 9.d5 cxd5 10.cxd5 Bd7 h3 Qa5 12 e4 Bb5 13 Nxb5 Qxb5 14 Nd3 Nbd7 15 a4 Qab 16 R21 Rt 8 17 Be3 Nb6 18 Bf1 Qc4 19 a5 Nbd7 20.Nc5 Qb4 21. Ra4 Qxe1 22.Qxe1 Nxc5 23.Rc4 Nfd7 24.Bd4 Ne5 25. Bxe5 Bxe5 23.Qc 1 Rc7 27.Q:2 b5 28.axb6 axb6 29. Qe2 Ra2 30 Rc2 Kg7 31.b4 Rxc2 32.Qxc2 Ne6 33 Qd3 Nd4 34.Qa6 Nf3+ 35.Kg2 Ne1+ 36 Kh1 Bd4 37.Qe2 Bc3 30, Qe3 b5 39.Qb6 Rc8 40 Qc6 1-0