Project:

MySQLi Assignment - To-Do List

Author:

Ayesha Fatima

Note For Instructor-To protect from Injection Attack the URL was designed as such as:

URL: http://localhost/todosql/admin/task_add.php?task_id=42&operation=complete

Purpose of the Project:

For getting competent for developing a database for To-Do App using MySQLi and PHP.

Requirements:

1. Create an ERD of your database-ERD Image was created using draw.io and Can be found in ERD Folder
2. Create an SQL file to import and create tables/seed any data (An instructor should be able to import your SQL file and be ready to go.) Note: DataBase Can be found in database folder with File name as todo_mysqli.sql and databaseName as: todo
3. A task has a due date
4. A task has a category In the screenshot above there are two categories, Chores and Homework
5. The user is able to add an item to the Active To-Do’s list by using the input field and add button
6. The user is able to move an active to-do to the Complete To-Do’s list
7. The user should be able to remove a task entirely
8. There should be three statuses a task can have: a. To do - tasks that are not complete and the due date has not passed b. Overdue - tasks that are not complete and are past the due date c. Completed - tasks that are complete

Challenge

1. The ability to add/edit/remove Task Categories
2. Styling the project to look nice
3. An unexpected feature is present (Make sure you mention what it is in your README.md file.)

Trello Link:

https://trello.com/b/L8wJf7BI/sql-todo

Citation Summary:

1. https://www.w3schools.com/php/php_mysql_intro.asp
2. https://drive.google.com/file/d/1cfKjysO-IAznZ5sUphKVgnbbMsT326M2/view
3. https://dev.mysql.com/doc/refman/8.0/en/comments.html
4. https://www.mysqltutorial.org/mysql-boolean/
5. https://riptutorial.com/php/example/13256/call-fetch-assoc-on-boolean
6. https://stackoverflow.com/questions/28253407/store-result-and-get-result-in-mysql-returns-false
7. https://www.mysqltutorial.org/mysql-now/
8. https://www.phpacademy.xyz/php_beginner/creating_a_personal_todo_list.html
9. https://www.w3schools.com/css/css3_buttons.asp
10. Peer Assistance on Bugs assistance and Review-Amr Fouad;