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

Focused View

Paul Amissah

19:03:35

451 View

1 - Section 1 Setting up Server Environment

1 - Building-App-Files.zip

1 - Course Introduction and File Download.mp4

06:51

1 - Working-Files.zip

2 - Fixing Admin Dashboard Error Solution.mp4

03:33

3 - Downloading and Installing Local Server.mp4

12:35

4 - Downloading and Installing Code Editor plugins.mp4

11:12

5 - Setting up the Environment Final Step.mp4

08:48

2 - Section 2 PHP Fundamentals

6 - PHP Introductions.mp4

09:37

7 - Syntax open echo string.mp4

09:22

8 - PHP Variables Logical Comparison Operators.mp4

14:55

9 - Statement if else elseif.mp4

14:57

10 - Array Indexed Associative.mp4

19:24

11 - Exercise1.zip

11 - Exercise 1 with Solution And Explanation.mp4

19:34

3 - Section 2 PHP Advance

12 - Loops foreach.mp4

11:34

13 - Functions and Arguments.mp4

13:47

14 - Include Super Global.mp4

18:21

15 - Super Globals SERVER POST GET.mp4

16:07

16 - Filters Validate and Sanitize.mp4

13:13

17 - Echo Concatenation.mp4

17:31

18 - Exercise2.zip

18 - Exercise 2 with Solution And Explanation.mp4

19:56

4 - Section 3 Object Oriented Programming OOP Basics

19 - OOP Overview.mp4

09:12

20 - Object.mp4

13:42

21 - Classes.mp4

09:10

22 - Properties.mp4

14:43

23 - Property Declaration Access Modifier.mp4

11:31

5 - Section 3 Object Oriented Programming OOP Advance

24 - Static Methods and Properties scope resolution operator.mp4

15:01

25 - Class Inheritance.mp4

17:06

26 - Construct Destruct methods.mp4

09:34

27 - Exception Handling Error Messages.mp4

12:59

28 - Exercise3.zip

28 - Exercise 3 with Solution and Explanation.mp4

19:57

6 - Section 4 MySQL Database

29 - Overview of MySQL.mp4

09:18

30 - Creating Database and Tables.mp4

10:00

31 - Connecting to Database and SQL Syntax Functions.mp4

17:50

32 - Inserting Updating Data.mp4

19:33

33 - Selecting Deleting Data.mp4

16:10

34 - Looping through your results and Displaying it.mp4

19:45

7 - Section 5 PHP Data Objects PDO

35 - Overview of PDO Database abstraction layer.mp4

15:01

36 - Understanding PDO class and its Methods.mp4

16:53

37 - Understanding PDO Statement Class and its Methods.mp4

19:36

38 - Understanding PDO Statement Class Cont Exception Class.mp4

09:51

39 - Exercise Creating our Database Class and Testing Connection.mp4

19:52

39 - PDO-Class.zip

40 - Creating our Database Helper functions and Instantiating our Class.mp4

19:40

40 - PDO-Class.zip

41 - Performing CRUD Functionalities Using PDO.mp4

19:36

8 - Section 6 PHP Forms

42 - Form Overview Getting and Filtering Cleaning Data.mp4

18:06

43 - Passing Data to Database using Our PDO functions.mp4

18:19

44 - Getting Data from Database and Displaying in our form.mp4

19:13

45 - Updating Data into our Database using our form.mp4

19:47

9 - Section 7 Asynchronous JavaScript and EXtensibleMarkupLanguage AJAX

46 - AJAX Overview.mp4

19:51

47 - Understand JQuery AJAX ajax post Methods.mp4

12:46

48 - Creating Functions withs JQuery AJAX ajax Method.mp4

15:07

49 - Creating Functions withs JQuery AJAX post Method.mp4

20:01

10 - Section 8 Database Wep App Project FrontEnd

50 - Building-App-Files.zip

50 - Completed-App-Files.zip

50 - Project Overview and Dummy File Download.mp4

04:17

51 - Creating our Database with phpAdmin.mp4

04:48

52 - Creating our Helper Functions.mp4

17:56

11 - Section 9 Database Wep App Project Admin Section

53 - Admin Registrations Collecting and Cleaning Form Data.mp4

19:37

54 - Admin Registration Processing Form Data.mp4

17:35

55 - Collecting Data and Processing Login.mp4

19:37

56 - Creating Sessions data for Logged in Users.mp4

19:46

57 - Using our sessions to control pages and display profile images.mp4

19:45

58 - Working on myadmin account after login.mp4

19:49

59 - Processing Admin Account Deletion.mp4

19:42

60 - Processing Admin Updating Editing.mp4

19:47

61 - Wrapping up Admin Section.mp4

10:00

12 - Section 10 Database Wep App Project Customers Section

62 - Fixing Links and Securing Pages.mp4

09:56

63 - Registering New Customer.mp4

18:48

64 - Avoiding Duplicates and Displaying all Customers.mp4

17:27

65 - Editing Customers.mp4

19:56

66 - Deleting Customers.mp4

13:33

67 - Reports Fetching results using AJAX ajax Method.mp4

14:12

68 - Reports Displaying Customer Information using AJAX get Method.mp4

12:58

69 - Reports Posting Form Data using AJAX post Method.mp4

19:51

70 - Emailing our customers.mp4

19:57

71 - Wrapping up and Testing Our App in Local Environment.mp4

15:47

13 - Section 10 Upload File to Servers

72 - Overview of Hosting.mp4

06:42

72 - Relaible Web Hosting Account.txt

72 - Reliable Domain Registration Account Under 2 first Year.txt

73 - Using File Zilla to Transfers files to online hosting account.mp4

09:58

74 - Exporting and Importing Database to online Database.mp4

14:07

75 - Testing our Application Fixing all Issues.mp4

15:59

76 - Fixing File Upload Security Issue.mp4

11:18

Description

A complete solution to learning and building a fully functional Web Application Using PHP, OOP, PDO, Bootstrap and AJAX

What You'll 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
Understand how to use Bootstrap
Understand how to integrate PHP Codes with HTLM to display dynamic content

Who is this for?

Individuals looking forward to Understanding Web Programming

PHP Learners

Individuals looking forward to Building Professional Web Apps

Absolute Beginners looking forward to learning PHP

Individuals looking for jobs as Web Developers

What You Need to Know?

Knowledge of HTML/CSS/Bootstrap is an added advantage but not required

More details

Description
There's no need for me to write too much here. Doing something you love 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 confidenceÂ 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 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 this course is for:
Individuals looking forward to Understanding Web Programming
PHP Learners
Individuals looking forward to Building Professional Web Apps
Absolute Beginners looking forward to learning PHP
Individuals looking for jobs as Web Developers

User Reviews

Rating

average 0

Total votes0

Focused display

Paul Amissah (MBA) is an IT Technologist specializing in Web App Development, Data Analytics & Cybersecurity. He has over 10 years of teaching experience. He understands the challenges students face and aims to address them with his unique "Straight To The Point" teaching method. One of his courses; "Building Database Web App PHP | OOP | PDO | AJAX | MySQL" is Bestseller on E-Learning Platforms.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.