Build Real World Website with PHP, PDO & MySQL
4.1 (24 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,431 students enrolled

Build Real World Website with PHP, PDO & MySQL

Let's Learn Prepared Statements, PDO & Building Dynamic Websites with PHP and MySQL
4.1 (24 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,431 students enrolled
Created by Md. A. Barik
Last updated 12/2019
English
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 12 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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...
Course content
Expand all 60 lectures 07:55:36
+ Basics introduction to Prepared Statements
6 lectures 30:34
Introduction to prepared statements
01:46
Connect to database
05:03
Inserting data
05:24
Updating data
05:41
Deleting data
04:36
+ Task List Project with Prepared Statements
8 lectures 01:06:26
Project setup
01:37
Creating database and database table
02:43
Database connection and creating reuse able component
07:57
Displaying dynamic users
07:57
Adding new user
08:05
Deleting user (Bad Approach)
07:52
Deleting user (Good Approach)
06:03
Editing user
24:12
+ PDO : PHP Data Object
7 lectures 30:28
Configuration
00:52
Basics introduction to PDO
01:04
Setting up PDO, Database & Database connection
06:16
Fetching data from database using PDO
12:32
Inserting data using PDO
03:42
Updating data using PDO
03:51
Deleting data using PDO
02:11
+ Task List Project with PDO
7 lectures 47:54
Project setup
01:20
Creating database & database table
02:19
Database connection & reuse able component
05:19
Displaying user from database
05:04
Adding new user
08:38
Deleting user
06:54
Editing user
18:20
+ Project : Blogging System with CMS - Front End
20 lectures 02:42:02
Project Setup
03:19
Creating database and database table
05:59
Creating Reuse-able Component
06:49
Making Categories Dynamic
06:00
Working with posts
09:22
URL Rewriting
11:10
Work with single post (Post details page)
10:17
Single post continue
02:02
Work with Category posts
18:52
Category post continue
01:02
Let's build a search engine
12:01
Pagination home
08:58
Pagination home ( Next, Prev, Active)
05:45
Pagination for search page
08:37
URL Rewriting Removing(categories)
03:35
Pagination for category page
05:44
Pagination continue
15:03
Working with comments
08:43
Post specific comments
02:46
Comments continue
15:58
+ Project : Blogging System with CMS - Back End
10 lectures 02:05:33
Creating Reuse-able Component
08:34
Back End Authentication
17:26
Working with posts
11:38
Inserting new post
17:24
Editing post
24:27
Editing post update
00:34
Edit post continue
02:45
Deleting post
04:23
Working with categories
17:37
Working with comments - Last Lecture
20:45
Requirements
  • Basics PHP Knowledge's
  • A computer with internet connection
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!

Who this course is for:
  • Want to learn how to implement prepared statements
  • Want to learn and implement PDO
  • Curious about building dynamic website