Learn PDO with MySQL with this Ultimate PHP PDO Crash Course and Build a Basic Task List

What you will learn

☑ 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


Description

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


Content

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

Post a Comment

Previous Post Next Post