PHP & MySQL Query

I need a form creating that does the following, the form should be on the left hand side of the page and the results appear on the right hand side so there is only 1 page in total. Don’t worry about styling the html.

I have already created the database and filled it with data so I can export and supply you with that.

The main aspect of the work is putting the query together to produce the results.

The query can be run even if all form fields are not filled in and only the team is selected.

The form should look like what is explained below

1. This is selected from the teamdata table

<select name="team">

<option value="Arsenal">Arsenal</option>

<option value="Aston Villa">Aston Villa</option>

<option value="Chelsea">Chelsea</option>

<option value="Everton">Everton</option>

</select>

This is the default option and the user can just submit the form with only a team selected.

So all the extra steps below just bolt further criteria onto the query.

2. The next section allows you to limit the grouping to show results against certain teams which is a multiple select. But doesn’t have to be selected.

<select name="opponents" multiple="multiple">

<option value="Arsenal">Arsenal</option>

<option value="Aston Villa">Aston Villa</option>

<option value="Chelsea">Chelsea</option>

<option value="Everton">Everton</option>

</select>

3. The following section allows the user the option to select multiple seasons, which should match the season field that is in the results-data table.

<select name="season" multiple="multiple">

<option value="2009 - 2010">2009 - 2010</option>

<option value="2010 - 2011">2010 - 2011</option>

<option value="2011 - 2012">2011 - 2012</option>

</select>

4. The next section allows the option to filter the results section by selecting only the games where the team (selected from number 1 section) is the home or away team in the results-data table. The default is that it brings back all results.

Home Matches<input type="checkbox" value="y" name="home-matches">

Away Matches<input type="checkbox" value="y" name="away-matches">

5. The next section allows a user to limit the results page to only show results from teams that match the grouping letter from the team-data table.

<select name="grouping">

<option value="A">A</option>

<option value="B">B</option>

<option value="C">C</option>

<option value="D">D</option>

<option value="E">E</option>

</select>

6. Then there needs to be a section where the user can limit the amount of rows that are returned. The limit should be a text box where the user can type in a number that then limits the results to that amount of rows.

The results should be in a table and each row should have an alternating colour for sample purposes just use red and black.

I have attached a word document which shows what the results page should like as well.

HTML MySQL PHP

Project ID: #1167894

About the project