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
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Knowledge of HTML/CSS/Bootstrap is and added advantage but not required
Description

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
19:03:23
+
Section 1 – Setting up Server Environment
5 Lectures 42:59
+
Section 2 – PHP Fundamentals
6 Lectures 01:27:47
PHP Introductions
09:37

Syntax – open, echo, string
09:21

PHP Variables, Logical & Comparison Operators
14:55

Statement – if, else, elseif
14:57

Array – Indexed, Associative
19:23

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

Functions and Arguments
13:46

Include & Super Global
18:21

Super Globals $_SERVER, $_POST $GET
16:07

Filters – Validate and Sanitize
13:13

Echo & Concatenation
17:31

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

Object
13:42

Classes
09:10

Properties
14:43

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

Class Inheritance
17:06

Construct & Destruct methods
09:33

Exception Handling {Error Messages}
12:59

Exercise 3 with Solution and Explanation
19:57
+
Section 4 – MySQL Database
6 Lectures 01:32:34
Overview of MySQL
09:18

Creating Database and Tables
10:00

Connecting to Database and SQL Syntax & Functions
17:50

Inserting / Updating Data
19:33

Selecting / Deleting Data
16:09

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

Understanding PDO class and its Methods
16:53

Understanding PDO Statement Class and its Methods
19:36

Understanding PDO Statement Class Cont.. & Exception Class
09:51

Exercise: Creating our Database Class and Testing Connection
19:52

Creating our Database Helper functions and Instantiating our Class
19:39

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

Passing Data to Database using Our PDO functions
18:18

Getting Data from Database and Displaying in our form
19:13

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

Understand JQuery AJAX .ajax() & .post() Methods
12:45

Creating Functions withs JQuery AJAX .ajax() Method
15:06

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

Creating our Database with phpAdmin
04:48

Creating our Helper Functions
17:56
3 More Sections
About the Instructor
Paul Amissah
4.2 Average rating
342 Reviews
15,647 Students
6 Courses
WEB APP DEVELOPER | IT TRAINER

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.