Cricket Rankings & Player Records Website

This project is a comprehensive cricket record and ranking website, designed to track and present players’ performances through detailed statistics and weekly updates. Built using Core PHP, MySQL, and Bootstrap, the platform delivers an accessible and intuitive experience for cricket enthusiasts.

🏏 This was my first proper project as a developer — a personal initiative inspired by the passion for cricket with friends. It helped me take my first confident steps into real-world coding.

---

📌 Features

• 📊 Player Rankings

  • Batting, bowling, and all-rounder rankings.
  • Sorted by average, strike rate, economy, and more.

• 📅 Weekly Match Reports

  • Up-to-date match results displayed in a clean interface.

• 👤 Player Profiles

  • Each player has a detailed stats page capturing all relevant performance data.

• 🔍 Search Functionality

  • Easily search for players or stats via multiple pages.

• 🧮 Statistics Tracking

  • Strike rate, dot balls, economy rate, most sixes, and more.

• 🧑‍💼 Admin Panel

  • Secure login for admins to add/edit players and weekly reports.

---

🛠 Tech Stack

• 🧠 Backend: Core PHP
• 🗂 Database: MySQL
• 🎨 Frontend: Bootstrap, Custom CSS

---

📂 Folder Structure (Simplified)

danishali22-cricket-website/
├── *.php                            # Core pages for stats and rankings
├── css/                             # Custom styling
├── database/cricket.sql             # MySQL database dump
├── admin/                           # Admin dashboard & operations
│   ├── admin_login.php              # Admin authentication
│   ├── players.php                  # Player management
│   └── weekly_report.php            # Report management
├── partials/                        # Reusable page sections (nav, footer, etc.)
└── player_profile.php               # Individual profile page

---

🚀 What I Learned

• How to structure and organize a real-world web application
• Basics of CRUD using raw PHP and MySQL
• Designing for usability and readability using Bootstrap
• Building authentication, session handling, and search features

---

💡 Challenges Faced

• Designing a relational database structure for complex player stats
• Creating reusable components (like navbars and cards) without frameworks
• Building modular admin controls while managing raw PHP includes
• Writing optimized SQL queries for ranking logic

---

📚 Future Improvements

• Mobile-responsive layout enhancements
• Filter system for ranking stats
• Graphs and charts for player trends
• User login for personal score tracking

---

🙌 Final Words

This website was not just a project — it was the beginning of my web development journey. The hands-on experience taught me how to convert an idea into a real product, and it continues to inspire my passion for building useful tools.