Ultimate PHP & MySQL Web Development Course & OOP Coding

Best seller
0
Created By Super Admin

$ 0

50% off $ 0

Estimated Time

0 hours 0 mins

On demand video

Enrolled By

0

Students & professionals

Total

0

Resources

Full

Lifetime

Access

About this Professional course

What You Will Learn

Course content

INTRODUCTION AND SETUP

Introduction

Setup On Windows

Setup On Mac

Setup On Linux

Online Code Editor

0 hours 46 mins to complete
5 lessons

BASICS

Basic File Syntax

Printing (echo)

Comments

Variables

Variable Data Types

Variable Naming

Constants

Arrays

Associative Arrays

Multidimensional Arrays

0 hours 56 mins to complete
10 lessons

CONTROL STRUCTURES

if Statement

ifelse Statement

ifelseifelse Statement

Switch Statement

while Loop

do While Loop

for Loop

foreach Loop

Break Statement

Continue Statement

0 hours 42 mins to complete
10 lessons

FUNCTIONS

Basic Function

Passing Function Arguments

Passing Function Arguments By Reference

Default Argument Value

Function Returning Values

Dynamic Function Calls

Variable Scope

0 hours 27 mins to complete
7 lessons

FORMS

Simple HTML Form

GET vs POST

$_SERVER('PHP_SELF')

Validating Form Data With PHP

Required Fields

Display Error Messages

Validate Name

Validate Email

Validate URL

Keep The Values In The Form

0 hours 56 mins to complete
10 lessons

FILE HANDLING

Read File (readfile())

Open, Read and Close a File (fopen(), fread(), fclose())

Read Single Line (fgets())

Check End-Of-File (feof())

Read Single Character (fgetc())

Write To File (fwrite())

Configure php.ini File For File Uploading

Front End HTML Upload Form

PHP Upload Script

Check If File Exists

Limit File Size

Limit File Type

0 hours 52 mins to complete
12 lessons

MYSQL

MySQL vs MySQLi vs PDO

Creating a Database and Table (phpMyAdmin)

Connecting to a Database

Get Data Using SELECT Query

WHERE Property For Filtering

LIKE Property For Pattern Search

Sorting Results Using ORDER BY Property

Using JOINS

Insert Data Using INSERT Query

Get ID Of The Last Inserted Row

Insert Multiple Rows

Update Data Using UPDATE Query

Delete Data Using DELETE Query

Delete All Rows In A Table Using TRUNCATE Query

Delete Table Using DROP Query

Limit Data Selections Using LIMIT, ROWNUM

Create Table Using CREATE Query

Clone/Duplicate Table

Alter Table

Create Database

Drop Database

SQL Injection and Prepared Statements

1 hours 43 mins to complete
22 lessons

XML

Load and Output XML Using DOM Parser

Looping Through XML Using DOM Parser

What Is XML?

What Is SimpleXML?

Parse XML String

Parse XML File

Get Node Values

Get Node Values of Specific Elements

Get Node Values - Loop

Get Attribute Values

What Is The XML Expat Parser?

Initializing The XML Expat Parser

0 hours 47 mins to complete
12 lessons

AJAX

What Is AJAX?

Load Simple Data Using AJAX Front End

Load Simple Data Using AJAX Back End

Load Data From A Database Using AJAX

0 hours 26 mins to complete
4 lessons

EMAILS

Send A Plain Text Email

Send A HTML Email

Email Attachments

PHPMailer Setup

Send Email Using PHPMailer

Send HTML Email Using PHPMailer

Email Attachments Using PHPMailer

0 hours 42 mins to complete
7 lessons

OBJECT ORIENTED PROGRAMMING

What Is Object Oriented Programming (OOP)?

Basic Class With Variables

Functions

Constructor

Destructor

Inheritance

Multi Class Inheritance

Function Overriding

Public vs Private vs Protected

Interfaces

Constants

Abstract Class

Static Keyword

Final Keyword

Initiating Parent Contructor

1 hours 3 mins to complete
15 lessons

ERROR HANDLING

die() Function

Custom Error Handler

Triggering An Exception

Exception Handling

Create Database and Table

User Class and Database Connection

Register User Form

Inserting User Data Into Database

Registation Form Field Validation

Securing User Password

Check If Username or Email Already Exists

Retain Data After Failed Registration

1 hours 29 mins to complete
12 lessons

ADVANCED

Validate an Integer Within a Range

Validate IPv6 Address

Validate URL - Must Contain QueryString

Remove Characters With ASCII Value > 127

Including and Requiring External PHP Files

0 hours 20 mins to complete
5 lessons

Top Reviews

No reviews yet

Frequently Asked Questions

How do I purchase a course?

To purchase your course online just follow the link. Online purchases can either be paid for immediately by credit/debit card, you can nominate somebody else to pay on your behalf, or an invoice can be requested.

How do I access the courses I have paid for?

On completing the online purchase process you will have immediate access to your course. 

How long do I have access to my purchased course?

You have access to the courses you have purchased indefinitely. Once the payment is made, the confirmation notice will be sent to the client via email within 24 hours of receipt of payment.

Do I have to complete a course in one go?

No, you can visit it at any time, wherever you are. Each course is made up of a number of individual modules which enables you to complete it in your own time and at times convenient to you. If you wish to return to the course at the point, you last left it at, please ensure you use the same device to access the course and do not clear your cache in between visits.

I have purchased the course online but cannot access the course?

Please contact the QH social media or by calling +97150209580.

Can I download or print a copy of the course material?

The software that we use for our eLearning does not have a download or print function, so there is no easy way to obtain this. For this reason, once you have purchased individual eLearning courses with us you have indefinite access to them so that you may return to the information and review it at any time.  

When I will receive the refund payment?

Refunds will be made onto the original mode of payment and will be processed within 10 to 45 days depending on the issuing bank of the credit card used.

What are the criteria in refund the payment for courses?

Any learner can withdraw from the programme and receive a refund based on the following Criteria:1- Online courses 24 hours Before the course starts: No refund.2- more than 24 hours before the course starts: Full refund.3- Products Full refunds within 14 days of purchase.Services As per terms and conditions in the service delivery contract.4. Payment confirmation

Can I cancel any program\course I sign in?

Customer can cancel their order/requested services within 24 hours; refunds will be made back to the payment solution used initially by the customer. Please allow for up to 45 days for the refund transfer to be completed.

If I fail a course, can I retake it?

If you did not pass the course with the grade required to earn the certificate, you can enroll in a future session.

Options for Purchasing a Program.?

There are 2 options:Option 1: purchase the program bundle:One-click bundle purchase to add all the program courses at once.Option 2: Upgrade Course by CourseYou can also purchase the program courses one by one.  

What types of certificates does SEP offers?

SEP currently offers two types of certificates:- Certificates for single courses- Program certificates for programs (series of courses)

Does SEP offer free certificates?

SEP courses do not award free certificates. Certificates are awarded only to passing students registered in the paid certificate track. The enrollment fee for this track varies by course.

Can I get a paper copy of my certificate?

SEP cannot send individual printed copies of certificates. However, you can save the certificate by downloading it as a PDF file.

I am not interested in a certificate. Can I still enroll in a course?

Yes. With the exception of professional education courses.

How do I download my certificate?

You can save your certificate on your computer by downloading it as a PDF using either the Chrome or Safari browser. 

How can I add my certificate to my LinkedIn profile?

To add your SEP certificate directly to your LinkedIn profileLog in to your LinkedIn account, then go to your profile.On the right, in the Add profile section dropdown, choose Background and then select the drop-down triangle next to Licenses & Certifications.In Name, enter the name of the course or program.In Issuing Organization, enter "SEP".(Optional) In Issue Date, enter the time period during which you earned the certification.(Optional) Select the checkbox This certification does not expire.You can leave the Credential ID field empty.In Certification URL, enter the URL for your certificate.