A full system of Indian Premier League
- Fork the repository.
- Clone the project in your machine.
- Commit changes to developer branch.
- Push your work back up to your fork.
- Submit a Pull request so that I can review your changes.
- HTML
- CSS
- JavaScript
- Create database
CREATE DATABASE ipl
- Create table fixture
CREATE TABLE fixture (
date DATE NOT NULL,
team1 VARCHAR(50) NOT NULL,
team2 VARCHAR(50) NOT NULL,
time INT(5) NOT NULL,
venue VARCHAR(20) NOT NULL,
team VARCHAR(50) NOT NULL,
che INT(10) NOT NULL,
team1s INT(4) NOT NULL,
team2s INT(4) NOT NULL
);
- Create table points
CREATE TABLE points (
team VARCHAR(50) NOT NULL,
pld INT(20) NOT NULL,
won INT(20) NOT NULL,
lost INT(20) NOT NULL,
tied INT(20) NOT NULL,
pts INT(20) NOT NULL,
);
- Create table users
CREATE TABLE users (
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
c_password VARCHAR(50) NOT NULL
);
Download xampp.
Put the repository to xampp directory. (example: C:\xampp\htdocs)
Open the xampp-contol and start MySQL and Apache.
Open browser and put the url: http://localhost/IPL-Management-System/ press enter.