Build Real World Website with PHP, PDO & MySQL

Let's Learn Prepared Statements, PDO & Building Dynamic Websites with PHP and MySQL

4.05 (109 reviews)
Udemy
platform
English
language
Web Development
category
instructor
Build Real World Website with PHP, PDO & MySQL
31,906
students
8 hours
content
Dec 2019
last update
$64.99
regular price

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!

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

Reviews

Gillian
December 19, 2020
The presenter's English is almost impossible to understand as evidenced by the automatic captions - they are mostly nonsensical. The course would be rated much more highly if it was re-voiced by someone with better English skills or manually captioned by the author. As it is now, I am simply unable to follow it.
Neuro
November 20, 2020
This is not pretty, I will prefer talking to you. You can comment with your WhatsApp ID or other means of communication..
MudasRee
April 3, 2020
Great Course for beginners you will learn a lot from this course the only thing that could be improved is instructor accent which sometimes is hard to understand....other than that good course with explanations.
Tad
March 2, 2020
Really sharp and concise with some tiredness at the end. Also some code isn't showed but very rarely. Thanks !
Kartik
February 26, 2020
THIS course is one of the best course in the list of php and the way of teaching is too good without wasting anyone want join the course

Coupons

DateDiscountStatus
10/11/2019100% OFF
expired
8/28/2020100% OFF
expired
11/19/2020100% OFF
expired
12/18/2020100% OFF
expired
7/4/2023100% OFF
expired
7/17/2023100% OFF
expired
7/17/2023100% OFF
expired
8/18/2023100% OFF
expired
8/18/2023100% OFF
expired
8/18/2023100% OFF
expired

Charts

Price

Build Real World Website with PHP, PDO & MySQL - Price chart

Rating

Build Real World Website with PHP, PDO & MySQL - Ratings chart

Enrollment distribution

Build Real World Website with PHP, PDO & MySQL - Distribution chart
2441324
udemy ID
7/3/2019
course created date
10/11/2019
course indexed date
Bot
course submited by