Let’s Learn Prepared Statements, PDO & Building Dynamic Websites with PHP and MySQL
What you will learn
How to work with prepared statements
How to work with PDO(PHP Data Object)
Building a simple blogging website
URL’s rewriting and more…
Description
Welcome to this course!
This is practical course. That mean you will not just learn prepared statements, PDO (PHP Data Object) but we will build project from complete scratch. Let’s build awesome website with PHP and MySQL and let’s learn how to build dynamic websites.
We will build a simple blogging website with (backend) CMS (Content Management System) using PDO, PHP and MySQL. You will learn how to build a dynamic website in practice.
What do I mean by task list?
I mean, we will be building a task list that would be a task(crud operation) with a list of users!
COURSE CONTENT:
- Prepared Statements
- Building Task List with Prepared statements
- PDOÂ PHP Data Object
- Building Task List with PDO
- Simple blogging website with little CMS
See you inside!
English
language
Content
Getting Started
Introduction
Environment Setup
Basics introduction to Prepared Statements
Introduction to prepared statements
Connect to database
Reading data
Inserting data
Updating data
Deleting data
Task List Project with Prepared Statements
Project setup
Creating database and database table
Database connection and creating reuse able component
Displaying dynamic users
Adding new user
Deleting user (Bad Approach)
Deleting user (Good Approach)
Editing user
PDO : PHP Data Object
Configuration
Basics introduction to PDO
Setting up PDO, Database & Database connection
Fetching data from database using PDO
Inserting data using PDO
Updating data using PDO
Deleting data using PDO
Task List Project with PDO
Project setup
Creating database & database table
Database connection & reuse able component
Displaying user from database
Adding new user
Deleting user
Editing user
Project : Blogging System with CMS – Front End
Project Setup
Creating database and database table
Creating Reuse-able Component
Making Categories Dynamic
Working with posts
URL Rewriting
Work with single post (Post details page)
Single post continue
Work with Category posts
Category post continue
Let’s build a search engine
Pagination home
Pagination home ( Next, Prev, Active)
Pagination for search page
URL Rewriting Removing(categories)
Pagination for category page
Pagination continue
Working with comments
Post specific comments
Comments continue
Project : Blogging System with CMS – Back End
Creating Reuse-able Component
Back End Authentication
Working with posts
Inserting new post
Editing post
Editing post update
Edit post continue
Deleting post
Working with categories
Working with comments – Last Lecture