ToDo WebApp testing

This is a simple project to manage tasks using HTML, CSS, JS, PHP and MySQL.

Table of Contents

• Installation
• Usage

Installation

To get a local copy up and running, follow these simple steps:

Prerequisites

• PHP >= 7.0
• MySQL
• Web server (e.g.,XAMPP, Apache, Nginx)

Clone the Repo

git clone https://github.com/Pranav-raja/todoapp_testing.git

Database Setup

1. Create a database named todoapp.
2. Import the following SQL to create the users table:

   
   CREATE TABLE tasks (
       user_id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
       name VARCHAR(50) NOT NULL,
       password VARCHAR(255) NOT NULL,
       email VARCHAR(50) NOT NULL UNIQUE
   );
                   

3. Import the following SQL to insert the rows into users table:

   
   insertDataSQL = "INSERT INTO users (name, password, email) VALUES
   ('admin', '".md5('admin')."', 'alice@example.com'),
   ('bob', '".md5('bob')."', 'bob@example.com'),
   ('Charlie', '".md5('pass')."', 'charlie@example.com'),
   ('David', '".md5('password')."', 'david@example.com'),
   ('Eve', '".md5('password')."', 'eve@example.com')";
   

4. Import the following SQL to create the tasks table:

   
   CREATE TABLE tasks (
       task_id int AUTO_INCREMENT PRIMARY KEY,
       user_id int,
       task varchar(50),
       date date,
       dline date,
       category varchar(32)
   );
     

Usage

To run the project, follow these steps:

1. Ensure your web server is running.
2. Navigate to the project directory and open index.php in your browser.

You should see a form to add tasks and a list of existing tasks.

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement".

Don't forget to give the project a star! Thanks again!

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

Contact

pranavraja - @mail

Project Link: https://github.com/Pranav-raja/todoapp_testing