Create A To-Do-List Using PHP, MySQLI and Javascript

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Prerequisites

Lecture 3: What You Will Learn

Lecture 4: Overview Of Pages

Lecture 5: SQL Tables

Chapter 2: PHP And MySQLi Review

Lecture 1: Creating A Database And Table Using PHPMyAdmin

Lecture 2: How To Connect To A Database

Lecture 3: Isset() And !Empty(): What's The Difference?

Lecture 4: Isset() vs !Empty(): An Example

Lecture 5: SQL Review

Lecture 6: Using INSERT with Query()

Lecture 7: Using SELECT with Query()

Lecture 8: Using DELETE with Query()

Lecture 9: Using UPDATE with Query()

Lecture 10: Inserting SQL Using Prepared Statement

Lecture 11: Selecting SQL Using Prepared Statement

Lecture 12: Deleting SQL Using Prepared Statement

Lecture 13: Updating SQL Using Prepared Statement

Lecture 14: Closing Your Statements And Connections

Chapter 3: Signup.php

Lecture 1: Overview

Lecture 2: Adding The HTML

Lecture 3: Adding Ids And Classes

Lecture 4: Error Message

Lecture 5: Add The CSS

Chapter 4: Check_signup.php

Lecture 1: Overview

Lecture 2: Creating A Connection

Lecture 3: Checking For Duplicates

Lecture 4: Inserting Into Table

Lecture 5: Preventing Direct Access

Chapter 5: Login.php

Lecture 1: Overview

Lecture 2: Adding The HTML

Lecture 3: Add Ids And Classes

Lecture 4: Adding The CSS

Chapter 6: Check_login.php

Lecture 1: Overview

Lecture 2: Creating The Connection

Lecture 3: Selecting The Username

Lecture 4: Getting Out The Password

Lecture 5: Verifying The Password

Lecture 6: Preventing Direct Access

Chapter 7: Display_task.php

Lecture 1: Overview

Lecture 2: Creating The Connection

Lecture 3: Selecting Out The User's Tasks

Lecture 4: Displaying The Tasks

Lecture 5: Adding The HTML

Lecture 6: Adding The Ids and Classes

Lecture 7: Adding The CSS

Lecture 8: Date() Function part 1

Lecture 9: Date() Function part 2

Lecture 10: Date() Function part 3

Lecture 11: Date() Function part 4

Lecture 12: Preventing Direct Access

Chapter 8: Task_added.php

Lecture 1: Overview

Lecture 2: Creating The Connection

Lecture 3: Ensuring Fields Are Filled In

Lecture 4: Inserting Task Into Task Table

Lecture 5: Preventing Direct Access

Chapter 9: Task_deleted.php

Lecture 1: Overview

Lecture 2: Creating The Connection

Lecture 3: Deleting Task From Task Table

Lecture 4: Preventing Direct Access

Chapter 10: Update_task.php

Lecture 1: Overview

Lecture 2: Adding The HTML

Lecture 3: Adding The HTML Part 2

Lecture 4: Adding Ids And Classes

Lecture 5: Adding The CSS

Lecture 6: Preventing Direct Access

Chapter 11: Task_updated.php

Lecture 1: Overview

Lecture 2: Creating The Connection

Lecture 3: Main Code

Lecture 4: Preventing Direct Access

Chapter 12: Logout

Lecture 1: Creating The Logout Screen

Chapter 13: Conclusion

Lecture 1: Conclusion