Project: Web app with TODO app functionality using Core-PHP in Object Oriented model as Front End and MySQL as Backend.
Commit file details
Total time taken in this project = 60+83+70+33+72+22+74+20 = 434 mins or 7 hours 14 mins
Changes are written in chronological order. So the latest commit details are at the bottom of the file.
Changes in commit#3
Modified on: june 8, 2021 Changes made:
- Created form form_AddTask in html view
- On form submit, the control passes to form_validate.php
- form_validate.php checks if $_POST['txt_TaskDescription'] has been set
- If that is true, then the control proceeds to add a insert query to the database
- Insert query succeeds. The input value , timestamp and related values are entered into the table tbl_task which is part of db_alpha-albatross
Time taken: 83 mins
Changes in commit#4
Modified on: june 8, 2021 Changes made:
- Added bootstrap 4 styling
- Select query done.
- Dashboard shows all tasks on page load
- Add task button adds the added task to the db and once 5 seconds is over, it refreshes the page and the on page load after refresh the just now added task is also presented in the table element.
Time taken: 70 mins
Changes in commit#5
Time taken: 33 mins Modified on: june 9, 2021
Changes made:
- Added css styling to the form
- Added a select option in the form for the $taskStatus element
- Wrote code for $taskStatus functionality
- Dashboard has functionality of 'C' and 'R' in CRUD. Next need to write update and delete element code
Changes in commit#6
Time taken: 72 mins Modified on: june 9, 2021
Changes made:
- Added fontawesome icon for edit and delete to each tasks.
- Update functionality code written. the corresponding task is calculated from the edit button and the user is taken to a new form where the task can be edited/updated.
- So now 'C', 'R' and 'U' functionality of CRUD are completed.
Changes in commit#7
Time taken: 22 mins Modified on: june 10, 2021
- Added D functionality of CRUD
- Now the delete functionality of the web application also works.
- So total of all CRUD functionality's work.
Changes in commit#8
Time taken: 74 mins Modified on: june 10, 2021
- Changed the code for addTask and retrieveAllTasks in object oriented model
- Made the code more effective in C & R of CRUD
Changes in commit#9
Time taken: 20 mins Modified on: june 11, 2021
- Made the code for edit task and delete task more effective and cleaner
- now all for sections of C,R,U & D of CRUD works effectively
- Exported database from phpmyadmin into .sql file and kept it in new folder called database-files