Todo List

Introduction

Todo list web application is easy to use, help you manage tasks effectively, and work smoothly.

Technologies

• html / css
• php
• mySQL

DB Operations

• `users` :
  • Create new user "login"
  • Check user exist "register"
• `tasks` :
  • Create new task "INSERT"
  • Delete exist task "DELETE"
  • Update exist task "Update"
  • Insert tasks in page UI "SELECT"
  • Set task to a specific user

Usage

1. Lance server XAMPP WAMP MAMP ...

2. Create Database "todo_app"

   CREATE DATABASE todo_app;
   use todo_app;

3. Create mySQL Tables users && tasks

   CREATE TABLE users(
     id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
     username VARCHAR(255) NOT NULL,
     pass VARCHAR(255) NOT NULL
   );
   
   CREATE TABLE tasks(
     id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
     user VARCHAR(255) NOT NULL,
     task VARCHAR(255) NOT NULL,
     finish BOOLEAN NOT NULL
   );

4. Config youn db connection ./db/connect.php

   $USERNAME = "YOUR_USERNAME";    // "root"
   $PASSWORD = "YOUR_PASSWORD";    // ""

5. Lance the app in localhost/index.php