This Project involves creation of Ajax based website using php and mysql. This site displays Football match results in user friendly manner. Users can easily see the match results based on Team, League, Match Date and Country. And users can search the results using keywords effectively. Most of the functionalities are created using Ajax except few which needed URL rewrite for improving SEO. Apache mod_rewrite module is used for creating pretty urls for improving search engine visibility.

The following functionalities are involved in this project,

1. htaccess (Hypertext Access) to be used to make “pretty urls”

2. Word searching using Ajax concept.

3. Pagination concept.

Here htaccess mod_rewrite concept is used to display url in user friendly way and SEO friendly, and to provide security..

Mod_rewrite is Apache extension which allows you to "rewrite" the URLs of your web pages.

Most often it is used to rewrite the URLs of dynamically generated webpages such as www.mywebsite.com/index.php?par1=1&par2=2&par3=2... This can be easily 'translated' into www.mywebsite.com/par1/par2/par3.

1. Search engine optimization.

2. User-friendliness.

3. Security.

For more details about mod_rewrite read our blog

The above screen shot shows all Leagues and Country. Each League and Country has a link. By clicking on league or country will go to next page to display league, country , teams and scores and date. The above screen shot shows the pretty url ‘http://192.168.1.7/scoreresults/all_leagues.html’

Clicking on the League will display all information related to that particular league. See below screen shot and url.

Clicking on the Country will display all information related to that particular country. See below screen shot and url.

Clicking on team link, will give the information about game detail and the team is currently playing on (hometeam or awayteam). See below screen shot and url.

Clicking on the date link will return details about the game going to play/played on that day. See below screen shot.

Clicking score results link, it will go to the Match Details page. This page shows the information about the particular match.

We are using Ajax concept for search word. The keyword entered in a box will be matched with the league, country column and the title of the team. If the keyword is matched with any one of these the corresponding result will be displayed. See the below screen shot.