Pera Cricket Database

Overview

This document provides an overview and detailed instructions for the web page created using PHP, HTML, CSS, Bootstrap, and MySQL. The web page serves as a platform for the University of Peradeniya cricket team to keep track of their match performances. It caters to two types of users: logged-in users and public users.

Technologies Used

• PHP: Server-side scripting language used for creating dynamic web pages.
• HTML: Markup language used for structuring the content on the web.
• CSS: Style sheet language used for describing the presentation of the web page.
• Bootstrap: Front-end framework used for responsive and modern web design.
• MySQL: Database management system used for storing and managing data.

User Roles

• Public User

  Public users can:

  • View player details
  • View match summaries
  • View match details
  • View player rankings and records based on formats

• Logged-in User ###L ogged-in users can:

  • Add/manage players
  • Add match details (normal and home matches)
  • Change their password

Features

Public User Features

• View Player Details Public users can access the player details page, which lists all players along with their information.
• View Match Summaries Public users can view summaries of all matches, including scorecards and highlights.
• View Match Details Detailed view of each match is available, showing full match statistics and information.
• View Player Rankings and Records Rankings and records of players based on different formats (e.g., T20, ODI, Test) are accessible.

Logged-in User Features

• Add/Manage Players Logged-in users can add new players to the database and update or delete existing player information.
• Add Match Details Logged-in users can add details for new matches, including normal and home matches. This includes inputting scores, player performances, and other relevant data.
• Change Password Logged-in users can change their account password for security purposes

Screenshots of the site

.

Security

• Passwords are hashed using a secure hashing algorithm. (MD5)
• User sessions are managed to prevent unauthorized access.

Future Enhancements

• Implement user registration and email verification.
• Add advanced search and filtering options for matches and players.
• Enhance the UI with additional interactive elements.

Support

For support, please contact [[email protected]].