I'll go over the broad topics we'll cover in the course, as well as the finish product of the system that we will develop in this course. I'll also covered what is required to take this course, target audience and the benefits that will be derived from taking this course.
In this lecture you will gain an introductory understanding of PHP Data Objects (PDO) and know why you should learn how to use it.
In this lecture you will learn how to create a PDO object and make a persistent connection to MySQL database with PHP. You will also gain an understanding of the PDO Class.
In this lecture you will learn how to handle database connection errors with PDO.
In this lecture, we shall create the table that will be used in the next section.
In this lecture you will learn how to perform basic insert statement to create new record with PDO.
In this lecture you will learn how to retrieve record from database table using basic PDO select statement.
In this lecture you will learn how to update record in a database table using basic update statement with PDO.
In this lecture you will learn how to delete record from a database table using basic delete statement with PDO.
In this lecture you will learn about PDO prepared statement use to protect against SQL injection and parameters. You will also learn how to use named and unnamed parameters.
In this lecture you will earn how to bind parameters to PDO prepared statement.
In this lecture you will learn how to quickly retrieve the unique identification number ID at the same time the record was created. This method works on all common database platforms that uses the auto increment feature or the equivalent.
In this lecture you will learn how to check the number of rows affected by a query.
9:34
In this lecture, you will learn how to take advantage of the transaction feature available is PDO, you will also learn how to check if your database supports transaction and how to change the storage engine for your database table.
In this lecture you will learn about some of the most useful data fetching modes available in PDO.
in this video a I'll walk you through the project directory structure and general overview.
In this lecture we shall create a table to hold task information.
In this lecture, we prep the interface for create task, display task and style the message alert div.
In this lecture you will learn how to create a task using jQuery Ajax to send request to a PHP script for processing in order to avoid page refresh.
Displaying Existing Tasks with JQuery and PHP
In this lecture you will learn how to update task details using jQuery Ajax to send request to a PHP script. You will learn how to make HTML elements editable, so that you don't need to create a separate form to edit a task, you simply click and start editing when you're done the request will be sent to PHP script for processing via Ajax.
In this lecture you will learn how to delete a task using jQuery Ajax to send request to a PHP script for processing to avoid page refresh.
2:39
In this lecture you'll learn how to check if a record was updated or not and display appropriate message. I also talk about validation and what to do if you need help.
In this lecture you will learn how to validate form data using Ajax and PHP.
In this lecture I will teach you how to easily optimize the Ajax and PHP code for updating task.
12:44
In this lecture you will learn how to set up pagination for any PHP project using a lightweight package and also separate HTML from PHP login.