Building Database Web App PHP | OOP | PDO | AJAX | MySQL
3.8 (37 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
229 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Building Database Web App PHP | OOP | PDO | AJAX | MySQL to your Wishlist.

Add to Wishlist

Building Database Web App PHP | OOP | PDO | AJAX | MySQL

A complete solution to learning and building a fully functional Web Application Using PHP, OOP, PDO and AJAX
3.8 (37 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
229 students enrolled
Created by Paul Amissah
Last updated 8/2016
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 19 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build Database Web Applications
  • Understand Web Technologies
  • Understand how to use PDO
  • Understand how to use AJAX
  • Understand Object Oriented PHP
  • Understand how to use PHP with PDO & AJAX
  • Understand how to use PHP with MySQL Database
View Curriculum
  • Knowledge of HTML/CSS/Bootstrap is and added advantage but not required

There's no need for me to write too much here. Doing something you love doing doesn't make you a teacher and showing people what you are doing doesn't make you a teacher either. Teaching is an art, teaching is a profession. There're lots of videos out there but only few will teach you. I'm a teacher.  I want to teach you to understand and do things by yourself. This course goes straight to the point. If you want to learn how to use PHP, AJAX, OOP and PDO to build a Web Application (Database), then I recommend this course. You will learn and understand how to use: 

PHP to build web applications  

OOP to create methods (functions) to save you lots of code typing (Don't Repeat Yourself - DRY).

AJAX to post data and display data from a database without refreshing your page or browser.

PHP Data Object (PDO) to establish very secured connections to database servers and avoid SQL Injections. 

We shall be creating a real application to get you the practical knowledge on your finger tips.

This course is for anyone from beginners to  IT Professionals who want to jump start and skip all the too many confusing explanations to go right into the real world of Web Programming with PHP. 

Don't make the mistakes I made, You cannot learn everything in PHP, even the developers of PHP don't know everything because it's a community of contributors. What you need to know is to master the important concepts that will give you the confident to build your own apps. And as soon as you get to that level of confidence you will start learning and adding to you skills all the time and that is exactly what we shall be doing in this course. 

I have been teaching since I was 17 yrs. My recent teaching experience was at a college level. I have a teaching methodology that works when it comes to programming; I explain the concepts, teach you how to use it, and I show you when to use it. 


Some Comments 

From Jaiyaramakrishnan Mahendran

this course was subscribed to give it to a 6th grader to learn php, as introduction to computers and website development, the student feels absolutely comfortable with the lectures because concepts are heavily emphasized in this course followed by syntax of the language, well done author, i wish my son can learn something during this summer break and starts web development as a skill

 From  Tjasa Flis

I loved this course! The instructor really takes the time to explain everything in detail. And also by repeating himself I remembered what he said and was able to wrote my own code by the end of the course, so I really learnt a lot! Also when I had any questions the instructor answered promptly and clearly!

Who is the target audience?
  • Individuals looking forward to Understanding Web Programming
  • PHP Learners
  • Individuals looking forward to Building Professional Web Apps
  • Absolute Beginners looking forward to learning PHP
Students Who Viewed This Course Also Viewed
Curriculum For This Course
76 Lectures
Section 1 – Setting up Server Environment
5 Lectures 42:59
Section 2 – PHP Fundamentals
6 Lectures 01:27:47
PHP Introductions

Syntax – open, echo, string

PHP Variables, Logical & Comparison Operators

Statement – if, else, elseif

Array – Indexed, Associative

Exercise 1 with Solution And Explanation
Section 2 – PHP Advance
7 Lectures 01:50:28
Loops – foreach

Functions and Arguments

Include & Super Global

Super Globals $_SERVER, $_POST $GET

Filters – Validate and Sanitize

Echo & Concatenation

Exercise 2 with Solution And Explanation
Section 3 – Object Oriented Programming OOP Basics
5 Lectures 58:18




Property Declaration {Access Modifier}
Section 3 – Object Oriented Programming OOP Advance
5 Lectures 01:14:36
Static Methods and Properties {:: scope resolution operator}

Class Inheritance

Construct & Destruct methods

Exception Handling {Error Messages}

Exercise 3 with Solution and Explanation
Section 4 – MySQL Database
6 Lectures 01:32:34
Overview of MySQL

Creating Database and Tables

Connecting to Database and SQL Syntax & Functions

Inserting / Updating Data

Selecting / Deleting Data

Looping through your results and Displaying it
Section 5 – PHP Data Objects {PDO}
7 Lectures 02:00:28

Understanding PDO class and its Methods

Understanding PDO Statement Class and its Methods

Understanding PDO Statement Class Cont.. & Exception Class

Exercise: Creating our Database Class and Testing Connection

Creating our Database Helper functions and Instantiating our Class

Performing CRUD Functionalities Using PDO
Section 6 – PHP Forms
4 Lectures 01:15:24
Form Overview , Getting and Filtering (Cleaning) Data

Passing Data to Database using Our PDO functions

Getting Data from Database and Displaying in our form

Updating Data into our Database using our form
Section 7 – Asynchronous JavaScript and EXtensible Markup Language - AJAX
4 Lectures 01:07:43

Understand JQuery AJAX .ajax() & .post() Methods

Creating Functions withs JQuery AJAX .ajax() Method

Creating Functions withs JQuery AJAX .post() Method
Section 8 – Database Wep App Project – Front-End
3 Lectures 27:01
Project Overview and Dummy File Download

Creating our Database with phpAdmin

Creating our Helper Functions
3 More Sections
About the Instructor
Paul Amissah
4.2 Average rating
342 Reviews
15,647 Students
6 Courses

Paul currently lives in Dubai UAE working as an IT Contractor in Web  and Business Development. Having spent over 5 years teaching at college level, He understands the challenges students face and aims to address it with his unique style of "Straight To The Point" teaching methods. He has been teaching ever since he was 17. He is currently working on his MBA in IT Security Management and is Microsoft & Cisco Certified.