Page 525 - Computer_Science_F5

Computer Science Building a task management web (b) Within task_manager, create a table
Activity 8.28:
application with PHP, PDO, and
MySQL
FOR ONLINE READING ONLY
Aim:
To develop proficiency in PHP
and PDO for performing CRUD
operations on a MySQL database
while creating a functional web-based
task management application.
Materials:
1. Computers with Internet access
2. Web server environment (Such as
XAMPP, WAMP, or any web server
with PHP and MySQL support)
3. Text editor or IDE for PHP
development
4. MySQL database management tool
(Such as phpMyAdmin)
5. Sample data for testing (optional)
Instructions
Create a practical web application
using PHP and PDO to perform
CRUD operations on a MySQL
database. Develop a “Task List”
application where users can manage
tasks by adding new tasks, viewing a
list of tasks with status, updating task
status, and deleting tasks. This activity
aims to understand PHP and PDO for
database interactions, practice CRUD
operations, and build a basic but
functional web application using PHP.
Step 1: Database setup
(a) Create a MySQL database named
task_manager.
516
Computer Science Form 5.indd 516
named tasks with fields: id (INT,
Primary Key, Auto Increment),
task_name (VARCHAR(255)),
TINYINT defaulting to 0).
and is_completed (BOOLEAN or
Step 2: PHP application setup:
(a) Create index.php for listing tasks.
(b) Create add_task.php for adding new
tasks.
(c) Create update_task.php for updating
task completion status.
(d) Create delete_task.php for deleting
tasks.
Step 3: CRUD Operations:
(a) Create (Add new task): Implement
a form in add_task.php to insert
new tasks into the tasks table using
PDO.
(b) Read (List tasks): Query all tasks
in index.php and display them
in a list format showing task
names and completion status.
Include functionality for “Mark
as Completed/Not Completed”,
“Edit”, and “Delete”.
(c) Update (Mark task as completed/
not completed): Develop logic
in update_task.php to toggle the
completion status of tasks based
on user interaction.
(d) Delete (Remove a Task): Implement
functionality in delete_task.php to
delete tasks from the tasks table.
for Advanced Secondary Schools
23/07/2024 12:35