Learn PDO with MySQL with this Ultimate PHP PDO Crash Course and Build a Basic Task List
☑ Learn PDO from the basics to the advanced concepts
☑ Grasp the concept of secured database connections
☑ Learn to pull your data from the database like a pro
☑ Prevent SQL injections with minimal effort with prepared statements
☑ Learn some advanced PDO concepts like transactions
☑ Utilize what you have learned by building an app from the ground up
Get ready for the best learning experience you will have with this PHP PDO course.
In this course, I did everything for you and fully explained PDO from the basics like connecting the database more securely and efficiently to advanced concepts like using transaction and so on.
So why basically choose this course from the rest of the courses about the same topic? Well, I made sure that you fully understand everything in detail, and while creating this course I used a lot of recourses including whole documentation just to bring you the best and finest content.
Let me show you what you are actually going to learn:
-Securely Connect to a database of your chosen with PDO and of course because PDO supports a wide range of Database
-Catching errors while connecting to your database
-Pulling the data and tweaking it as you like with the most known PDO methods like (query, fetch, fetchall, fetchcolumn)
-Securing insertion to the database with prepared statements which prevents SQL injections
-Using fancy and sophisticated methods to add more security and efficacy to your code with transactions
-Terminating the connection to your database the easy and simple way
-Build an app with the common backend functionality using what you have learned
And so much more. Don’t believe me? Just take a look inside 🙂
English
Language
Introduction
Introduction
Installation
Installing Xampp
Installing Sublime
Connecting to DB
Connecting to DB with PDO
Catching Errors
Connecting to DB
The Many Ways of Fetching Data with PDO
Getting Data with Query and Fetch pt.1
Getting Data with Query and Foreach
Getting Data with Query and Fetch pt.2
Getting Data with FetchColumn
Getting Data with FetchAll
Getting Data with Query and Fetch
Getting Data with FetchColumn
Getting Data with FetchAll
Prepared Statements and Performing Crud Operations
Prepared Statements
Update and Delete
Prepared Statements
Delete
Update
More Crucial Parts of PHP PDO
Getting RowCount
Getting LastInsertId
Transactions
Closing the Connection
Getting RowCount
Getting LastInsertId
Closing the Connection
PDO in Action: Build a Complete Dynamic App with PHP and PDO
Setting Up
Inserting into DB
Pulling the Data
Deleting the Data