Macjoe Umanah

PHP: Object Oriented PHP and MySQL with PDO for beginners + Project

Learn Object Oriented PHP, MySQL, PDO, Javascript, jQuery, and build a peer-to-peer (P2P) donation platform like MMM.

16 enrolled

$15.99 $26.65

Limited time offer.

watching now

3 Students

Description

What you'll learn

Build your own peer to peer(P2P) Donation Platform in PHP(OOP), MySQL, Javascript, jQuery
You will learn OOP(Object Oriented PHP)
You will learn to use forms to submit data to databases
Implement specific functionalities in any web project using selected jQuery plugins e.g Countdown timer,Background images, Gritter image for notification, Input fields validation e.t.c
How to use Sweet Alert: A Javascript code library
How to use promises in Javascript to keep track of users interaction with Sweet Alert
Account activation by email, using PHPMailer PHP library
How to use Ajax with php
You will learn how to filter and validate data that comes from HTML forms
Validate form fields with a Jquery
How to deploy a Web Application to a Production Server
Set up Cronjob to execute scripts at specific time intervals and much more ...

Watch The Free Preview Videos to Have a Feel of The Course Content

The ultimate guide to learning Object Oriented PHP and MySQL with PDO from scratch and building a 2:1 matrix Peer to Peer(P2P) Donation System in PHP and MySQL. We start with the fundamentals of Object Oriented PHP, thereafter we move on to learn the fundamentals of PDO(PHP Data Object), thereafter, we move on to create the course project where we implement all we learnt in previous sections. If you have ever wanted to create a Platform to enable people operate a mutual financial community (a system where people can give and receive help using money as the means of transaction), then this course is for you. This course will show you step by step how to create a platform where users can help one another using money as means of transaction. This is not one of those courses where you are made to write code without fully understanding how things fit together. Every line of code we write to build this web app will be explained in very simple terms, that i can guarantee you. Users of this platform will be able to do the following:

Sign up and Login(Enhanced using Ajax)
Update their profile
Opt into a package offered on the platform($10, $20, $50, $100, $150)
Make payments to users qualified to receive 100% ROI(return on investment) having paid another participant on the platform
Make payments within a stipulated period of time after which the receiving user will have access to a purge button to get rid of a non-compliant user
Get remerged or assigned another user incase of a deficit in payment from previous users merged to make payments
Recycle or opt into an entirely different package offered on the website after cycling out of the package currently enrolled in
Notify receiving user that a payment has been made to them and much more.

Wether you are completely new to Object Oriented Programming in PHP or you already have some experience using Object Oriented PHP, this course will be greatly beneficial to you. This course assumes that you know atleast a little of HTML and CSS .

WHY enrol?

Valuable Skills

This course will give you hands on experience in using Object Oriented PHP, you will learn how to use MySQL with PDO to build any dynamic website. You will also become more proficient in Javascript by creating functions to achieve specific features in the project we will be building in this course. You will become more familiar with Ajax as we will be using it to Sign up and Login a user. Also in this course you will use selected jQuery plugins to achieve functionalities like the Countdown Timer,input fields validation, gritter image for notification and much more.

After completing this course, you will have the fundamental Skills and Technical Know How to build any web application using Object Oriented PHP(OOP), MySQL and PDO.

Project Portfolio

The project we build in this course can be used as part of your portfolio project to showcase to your potential employers to bid for jobs that require the technical skills covered in this course.

Who this course is for:

Anyone who wants to master Object Oriented PHP(OOP), MySQL, PDO, little Javascript, little jQuery.

Show More Show Less

What Will You Learn?

Learn to Build Your own Peer-to-Peer website in PHP(OOP) and MySQL with PDO

Learn to Program a 2:1 Matrix Logic (Multiple Packages) in PHP and MySQL

Learn Object Oriented Programming and MySQL with PDO

Learn to Set Up Cronjob to Execute Scripts at Specific Time Intervals

Learn to Set Up a Web Application to a Production Server

Requirements

Basics of HTML and CSS

Basics of Procedural PHP Knowledge

A Text Editor to Program in (I'm using notepad++)

NFT Certificate

169 Lessons

Intermediate

English

3.7 Rating

+110 XP

Share Course on Social media

Curriculum

Course consist of total 23h 5min of content, in total.

Section 1: Introduction

03:57

03:57

Section 2: Setting up our development environment

08:54

Downloading and installing Xampp

08:54

Section 3: Object Oriented Php fundamentals

1:04:50

01:26

Classes and Properties

10:20

Access Modifiers

08:14

Constructors and Destructors

10:19

Inheritance

13:23

Static Methods and Properties

09:26

Magic Methods

11:42

Section 4: Php Data Objects Fundamentals

1:07:13

Section Intro

04:02

Creating a Database Source Name

07:09

Connecting to the database

05:47

The query method

18:28

The Prepare method with anonymous placeholders

11:12

The Prepare method with named placeholders

06:27

Using the bindParam and bindValue methods

14:08

Section 5: Setting up our files

1:06:25

Section Intro

03:38

Matrix Admin Template

Project's source code

Creating the folders for the project

05:33

Creating the files of the classes and views folder

10:19

Working on the footer,header,sidebar,logged_in.php files

05:11

Modifying the sidebar.php and logged_in.php files

08:55

Finishing touches on the logged_in file and working on the transaction.php file

08:12

working on the uptin,waiting_to_be_paid,pending,not_merged.php files

07:44

Working on the edit.php file

03:22

Working on the upline.php file

02:28

Working on the profile.php file

02:02

Working on the register.php file

03:48

Working on the downline.php file

05:01

Section 6: The Registration Class

1:38:58

Defining the registration class and its properties

06:05

Working on the not_logged_in.php file

02:27

The databaseConnection method

07:34

Creating the users table

07:25

Creating the status table

04:33

The registerNewUser method part1

10:47

The registerNewUser method part2

08:09

The registerNewUser method part3

07:02

The registerNewUser method part4

07:41

The registerNewUser method part5

06:28

The registerNewUser method part6

13:23

The registerNewUser method part7

03:22

Implementing the registerNewUser method

14:02

Section 7: The Login Class

7:09:16

Defining properties for the login class

10:21

The database connection method

05:05

The getUserData method

12:20

The getStatus method

08:02

The loginWithPostData method part 1

08:28

The loginWithPostData method part 2

17:41

The userIsLoggedIn method

05:13

Implementing the loginWithPostData method

14:23

The doLogout method

06:03

Creating the payment detail table

03:13

User dashboard finishing touch

16:17

The getPaymentDetails Method

08:40

The profile page

07:53

The edit profile page

05:43

The editProfile method part1

13:24

The editProfile method part2

04:21

Implementing the editProfile method

08:48

The password validation functionality

03:22

Working on the select_package.php file

04:22

Working on the upgrade.php file

03:27

Linking the provide help button

04:08

Some validation on the package select page

05:56

Creating the packages table

04:53

Creating the transaction table

07:19