PHP & HTML (Netbeans and mysql for the database)

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 event site matchDate round player1 player2 result player1Elo player2Elo eco opening moves

INT, primary VARCHAR(32) VARCHAR(32) DATE VARCHAR(5) VARCHAR(48) VARCHAR(48) ENUM(1,2,D) INT

INT VARCHAR(3) VARCHAR(48) TEXT

(D=draw)

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

		Date >=		Date <=		Name Contains		Result
								Any Player One Player Two Draw

28 records found.

Event	Player One	Player Two	Match Date	Result
FIDE-Wch k.o.	Lautier, Joel	Kobese, Watu	07/31/1999	Player One	View Details
FIDE-Wch k.o.	Nielsen, Peter Heine	Benjamin, Joel	07/31/1999	Draw	View Details
FIDE-Wch k.o.	Benjamin, Joel	Nielsen, Peter Heine	08/01/1999	Draw	View Details
FIDE-Wch k.o.	Kobese, Watu	Lautier, Joel	08/01/1999	Player Two	View Details
FIDE-Wch k.o. g/25+10	Benjamin, Joel	Nielsen, Peter Heine	08/02/1999	Player One	View Details
FIDE-Wch k.o. g/15+10	Nielsen, Peter Heine	Benjamin, Joel	08/02/1999	Draw	View Details
FIDE-Wch k.o. g/25+10	Nielsen, Peter Heine	Benjamin, Joel	08/02/1999	Player One	View Details
FIDE-Wch k.o. g/15+10	Benjamin, Joel	Nielsen, Peter Heine	08/02/1999	Draw	View Details
FIDE-Wch k.o. Sudden Death	Nielsen, Peter Heine	Benjamin, Joel	08/02/1999	Player One	View Details
FIDE-Wch k.o.	Lautier, Joel	Sakaev, Konstantin	08/03/1999	Draw	View Details
FIDE-Wch k.o.	Sakaev, Konstantin	Lautier, Joel	08/04/1999	Draw	View Details
FIDE-Wch k.o. g/25+10	Sakaev, Konstantin	Lautier, Joel	08/05/1999	Player Two	View Details
FIDE-Wch k.o. g/25+10	Lautier, Joel	Sakaev, Konstantin	08/05/1999	Draw	View Details
FIDE-Wch k.o.	Lautier, Joel	Gelfand, Boris	08/06/1999	Draw	View Details
FIDE-Wch k.o. g/15+10	Lautier, Joel	Gelfand, Boris	08/06/1999	Player Two	View Details
FIDE-Wch k.o. g/25+10	Lautier, Joel	Gelfand, Boris	08/06/1999	Draw	View Details
FIDE-Wch k.o. g/25+10	Gelfand, Boris	Lautier, Joel	08/06/1999	Draw	View Details
FIDE-Wch k.o. g/15+10	Gelfand, Boris	Lautier, Joel	08/06/1999	Player One	View Details
FIDE-Wch k.o.	Gelfand, Boris	Lautier, Joel	08/07/1999	Draw	View Details
FIDE WCh KO	Fiorito,F	Benjamin,Joe	11/27/2000	Player Two	View Details
FIDE WCh KO	Benjamin,Joe	Fiorito,F	11/28/2000	Player One	View Details
FIDE WCh KO	Benjamin,Joe	Leitao,R	11/30/2000	Draw	View Details
FIDE WCh KO	Leitao,R	Benjamin,Joe	12/01/2000	Player One	View Details
FIDE WCh KO	Baklan,V	Benjamin,Joe	11/27/2001	Player Two	View Details
FIDE WCh KO	Benjamin,Joe	Baklan,V	11/27/2001	Player Two	View Details
FIDE WCh KO	Baklan,V	Benjamin,Joe	11/27/2001	Draw	View Details
FIDE WCh KO	Baklan,V	Benjamin,Joe	11/27/2001	Draw	View Details
FIDE WCh KO	Benjamin,Joe	Baklan,V	11/28/2001	Draw	View Details

Sample output - Page 2

Event Name	FIDE-Wch k.o. g/25+10
Event Site	Las Vegas
Date	08/02/1999
Round Number	1.4
Player One	Nielsen, Peter Heine
Player Two	Benjamin, Joel
Result	Player One
ECO and Opening	(E62) Delayed Fianchetto, KID; E62
Moves	1.d4 d6 2.g3 Nf6 3.Bg2 g6 4.Nf3 Bg7 5.O-O O-O 6.c4 c6 7.Nc3 Bf5 8.Ne1 Be6 9.d5 cxd5 10.cxd5 Bd7 11.h3 Qa5 12.e4 Bb5 13.Nxb5 Qxb5 14.Nd3 Nbd7 15.a4 Qa6 16.Re1 Rfc8 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 26.Qc1 Rc7 27.Qc2 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 38.Qe3 b5 39.Qb6 Rc8 40.Qc6 1-0