Ultimate PHP & MySQL Web Development Course & OOP Coding
4.1 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,882 students enrolled

Ultimate PHP & MySQL Web Development Course & OOP Coding

Become an In-demand PHP & MySQL Ninja by learning all the web developments features for creating websites
4.1 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,882 students enrolled
Created by Frahaan Hussain
Last updated 11/2019
English
English [Auto]
Current price: $119.99 Original price: $199.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10 hours on-demand video
  • 9 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • PHP Programming
  • SQL Programming
  • Database Coding
  • Application Programming
  • Cross Platform Development
  • Web Development
  • Semantics of General Programming
  • The Format of Coding Applications
  • Web Design
  • All The Features of PHP & MySQL
  • Object Oriented Programming
Course content
Expand all 140 lectures 10:02:42
+ Introduction & Setup
5 lectures 43:13

Introduction to the Ultimate PHP course.

Preview 01:48

Learn how to setup on PHP on Windows.

Setup On Windows
15:10

Learn how to setup on PHP on Mac.

Setup On Mac
11:17

Learn how to setup on PHP on Linux.

Setup On Linux
12:28

Learn about the Online Code Editor to code in PHP without installing anything.

Online Code Editor
02:30
+ Basics
10 lectures 49:56

Learn about the basic format of a PHP file and how to utilise basic features.

Preview 04:46

The echo() function outputs one or more strings.

Note: The echo() function is not actually a function, so you are not required to use parentheses with it. However, if you want to pass more than one parameter to echo(), using parentheses will generate a parse error.

Preview 06:25

In computer programming, a comment is a programmer-readable explanation or annotation in the source code of a computer program. They are added with the purpose of making the source code easier for humans to understand, and are generally ignored by compilers and interpreters.

Comments
05:25

In computer programming, a variable or scalar is a storage location paired with an associated symbolic name, which contains some known or unknown quantity of information referred to as a value.

Variables
06:03

The data types that hold numeric values are: byte , short , int , long , float and double . The difference between them is the size and precision of the value they contain. Multiple characters or 'strings' (eg words and sentences) are also supported in Java through the use of String .

Preview 07:12

A variable can have a short name (like x and y) or a more descriptive name (age, carname, total_volume).

Rules for PHP variables:

  • A variable starts with the $ sign, followed by the name of the variable

  • A variable name must start with a letter or the underscore character

  • A variable name cannot start with a number

  • A variable name can only contain alpha-numeric characters and underscores (A-z, 0-9, and _ )

  • Variable names are case-sensitive ($age and $AGE are two different variables)

Variable Naming
02:59

In programming, a constant is a value that never changes. The other type of values that programs use is variables, symbols that can represent different values throughout the course of a program.

Constants
02:25

In computer science, an array data structure, or simply an array, is a data structure consisting of a collection of elements, each identified by at least one array index or key. An array is stored such that the position of each element can be computed from its index tuple by a mathematical formula.

Arrays
05:09

In computer science, an associative array, symbol table, dictionary, or collection of tuples is an abstract data type that maps a unique string to an instance of an object.

Associative Arrays
05:29

A multidimensional array is an array containing one or more arrays. PHP understands multidimensional arrays that are two, three, four, five, or more levels deep. However, arrays more than three levels deep are hard to manage for most people.

Preview 04:03

Time to test your knowledge of the basics of PHP

Quiz - Basics
5 questions
+ Control Structures
10 lectures 38:52

The if/else statement executes a block of code if a specified condition is true. If the condition is false, another block of code can be executed. The if/else statement is a part of PHP's "Conditional" Statements, which are used to perform different actions based on different conditions.

if Statement
06:02

The if/else statement executes a block of code if a specified condition is true. If the condition is false, another block of code can be executed. The if/else statement is a part of PHP's "Conditional" Statements, which are used to perform different actions based on different conditions.

Preview 01:43

The elseif statement is only executed if the preceding if expression and any preceding elseif expressions evaluated to FALSE, and the current elseif expression evaluated to TRUE .

if...elseif...else Statement
04:48

In computer programming languages, a switch statement is a type of selection control mechanism used to allow the value of a variable or expression to change the control flow of program execution via search and map.

Switch Statement
05:59

In most computer programming languages, a while loop is a control flow statement that allows code to be executed repeatedly based on a given Boolean condition. The while loop can be thought of as a repeating if statement.

while Loop
05:37

In most computer programming languages, a do while loop is a control flow statement that executes a block of code at least once, and then repeatedly executes the block, or not, depending on a given boolean condition at the end of the block.

Preview 02:56

The for statement is used to iterate over the elements of a sequence. It's traditionally used when you have a piece of code which you want to repeat n number of time. The for loop is often distinguished by an explicit loop counter or loop variable.

for Loop
02:52

Looping in a programming language is a way to execute a statement or a set of statements multiple numbers of times depending on the result of a condition to be evaluated. The resulting condition should be true to execute statements within loops. The foreach loop is used to iterate over the elements of the collection.

foreach Loop
04:52

The break statement terminates the current loop, switch, or label statement and transfers program control to the statement following the terminated statement.

Break Statement
02:10

The continue statement is used inside loops. When a continue statement is encountered inside a loop, control jumps to the beginning of the loop for next iteration, skipping the execution of statements inside the body of loop for the current iteration.

Preview 01:53

Time to test your control structure knowledge

Quiz - Control Structures
5 questions
+ Functions
7 lectures 23:16

A function is a block of organised, reusable code that is used to perform a single, related action. Functions provide better modularity for your application and a high degree of code reusing. You have already seen various functions like printf() and main().

Basic Function
02:38

Passing arguments by reference and by value. When you pass an argument by reference, you pass a pointer to the value in memory. The function operates on the argument. When a function changes the value of an argument passed by reference, the original value changes.

Preview 03:06

Passing by reference means the called functions' parameter will be the same as the callers' passed argument (not the value, but the identity - the variable itself).Pass by value means the called functions' parameter will be a copy of the callers' passed argument.

Passing Function Arguments By Reference
03:54

A default argument is a value provided in a function declaration that is automatically assigned by the compiler if the caller of the function doesn't provide a value for the argument with a default value.

Default Argument Value
01:37

A return is a value that a function returns to the calling script or function when it completes its task. A return value can be any one of the four variable types: handle, integer, object, or string.

Preview 05:02

PHP supports the concept of variable functions. This means that if a variable name has parentheses appended to it, PHP will look for a function with the same name as whatever the variable evaluates to, and will attempt to execute it. Among other things, this can be used to implement callbacks, function tables, and so forth.

Dynamic Function Calls
02:37

Scope refers to the visibility of variables. In other words, which parts of your program can see or use it. Normally, every variable has a global scope. Once defined, every part of your program can access a variable. It is very useful to be able to limit a variable's scope to a single function.

Variable Scope
04:22

Time to test your knowledge of functions.

Quiz - Functions
4 questions
+ Forms
10 lectures 50:59

Learn about implementing simple HTML form with a PHP backend

Preview 07:03

Both GET and POST create an array (e.g. array( key1 => value1, key2 => value2, key3 => value3, ...)). This array holds key/value pairs, where keys are the names of the form controls and values are the input data from the user.

Both GET and POST are treated as $_GET and $_POST. These are superglobals, which means that they are always accessible, regardless of scope - and you can access them from any function, class or file without having to do anything special.

$_GET is an array of variables passed to the current script via the URL parameters.

$_POST is an array of variables passed to the current script via the HTTP POST method.

GET vs POST
04:30

The $_SERVER["PHP_SELF"] variable can be used by hackers!

If PHP_SELF is used in your page then a user can enter a slash (/) and then some Cross Site Scripting (XSS) commands to execute.

$_SERVER["PHP_SELF"]
06:37

The first thing we will do is to pass all variables through PHP's htmlspecialchars() function.


Validating Form Data With PHP
06:36

Some fields cannot be empty, lets cover this in this video.

Preview 04:52

If you are having problems with your PHP web application and need to display all the errors and warnings, you are in the right place. In this tutorial, we will explain all the different ways to enable PHP errors and warnings.

Preview 05:16

If the name syntax is not valid, then lets show an error message:

Preview 02:37

If the email address syntax is not valid, then lets show an error message:

Validate Email
03:15

If the URL address syntax is not valid, then lets show an error message:

Validate URL
06:35

To show the values in the input fields after the user hits the submit button, we add a little PHP script inside the value attribute.

Keep The Values In The Form
03:38

Time to test your knowledge on forms.

Quiz - Forms
3 questions
+ File Handling
12 lectures 47:54

The readfile() function reads a file and writes it to the output buffer.

Read File (readfile())
02:22

A better method to open files is with the fopen() function. This function gives you more options than the readfile() function.


The fread() function reads from an open file.

The first parameter of fread() contains the name of the file to read from and the second parameter specifies the maximum number of bytes to read.


The fclose() function is used to close an open file.

Preview 03:55

The fgets() function is used to read a single line from a file.

Read Single Line (fgets())
02:35

The feof() function checks if the "end-of-file" (EOF) has been reached.

The feof() function is useful for looping through data of unknown length.

Check End-Of-File (feof())
01:58

The fgetc() function is used to read a single character from a file.

Preview 01:51

The fwrite() function is used to write to a file.

The first parameter of fwrite() contains the name of the file to write to and the second parameter is the string to be written.

Write To File (fwrite())
03:16

First, ensure that PHP is configured to allow file uploads.

In your "php.ini" file, search for the file_uploads directive, and set it to On:

Configure php.ini File For File Uploading
02:20

Next, let's create an HTML form that allow users to choose the image file they want to upload.

Front End HTML Upload Form
03:38

Let's create the PHP backend for uploading files.

PHP Upload Script
14:48

Now lets check if the file exists and prevent replacing the file.

Check If File Exists
02:56

Now, we want to check the size of the file.

Limit File Size
04:36

Now we will restrict the type of images acceptable.

Preview 03:39

Time to test your file handling knowledge

Quiz - File Handling
5 questions
+ MySQL
22 lectures 01:30:13

The MySQLi is an extension to work with MySQL version 4.1.13 or newer. MySQLi is introduced with PHP Version 5.0 and is a replacement for the mysql functions, with object-oriented and procedural versions. ... PDO (PHP Data Objects) is a general database abstraction layer with support for MySQL among many other databases.

Preview 05:18

Let's create a database and table for our PHP web application.

Creating A Database & Table (phpMyAdmin)
05:39

Database connection. A Database connection is a facility in computer science that allows client software to talk to database server software, whether on the same machine or not. ... The Connection String is composed of a set of key/value pairs as dictated by the data access interface and data provider being used.

Connecting To A Database
06:14

The SELECT statement is used to select data from a database.

The data returned is stored in a result table, called the result-set.

Preview 09:58

The WHERE clause is used to filter records.

The WHERE clause is used to extract only those records that fulfill a specified condition.

WHERE Property For Filtering
02:45

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are two wildcards often used in conjunction with the LIKE operator:

  • % - The percent sign represents zero, one, or multiple characters

  • _ - The underscore represents a single character

LIKE Property For Pattern Search
02:27

The ORDER BY keyword is used to sort the result-set in ascending or descending order.

The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

Sorting Results Using ORDER BY Property
01:08

A JOIN clause is used to combine rows from two or more tables, based on a related column between them.

Using JOINS
07:32

The INSERT INTO statement is used to insert new records in a table.

Insert Data Using INSERT Query
04:00

Get the primary key/id of the last inserted row.

Get ID Of The Last Inserted Row
02:26

If you want to insert more rows than that, you should consider using multiple INSERT statements, BULK INSERT or a derived table.

Insert Multiple Rows
05:03

The UPDATE statement is used to modify the existing records in a table.

Update Data Using UPDATE Query
03:18

The DELETE statement is used to delete existing records in a table.

Delete Data Using DELETE Query
02:21

The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.

Delete All Rows In A Table Using TRUNCATE Query
01:52

The DROP TABLE statement is used to drop an existing table in a database.

Delete Table Using DROP Query
02:08

The SQL SELECT LIMIT statement is used to retrieve records from one or more tables in a database and limit the number of records returned based on a limit value.

Limit Data Selections Using LIMIT, ROWNUM
04:03

The CREATE TABLE statement is used to create a new table in a database.

Create Table Using CREATE Query
03:25

In this tutorial you will learn how to create a duplicate copy of an existing table.

Clone/Duplicate Table
03:02

The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.

The ALTER TABLE statement is also used to add and drop various constraints on an existing table.

Alter Table
04:36

The SQL CREATE DATABASE statement is used to create a new SQL database.

Create Database
02:00

DROP DATABASE drops all tables in the database and deletes the database.

Drop Database
01:50

In a nutshell, with prepared statements malicious code introduced via user input will not be executed! In SQL Server, using a prepared statement is definitely injection-proof because the input parameters don't form the query. It means that the executed query is not a dynamic query.

SQL Injection & Prepared Statements
09:08

Time to test your knowledge on MySQL

Quiz - MySQL
5 questions
+ XML
12 lectures 40:27

XML stands for eXtensible Markup Language. XML is a markup language much like HTML. XML was designed to store and transport data. XML was designed to be self-descriptive. XML is a W3C Recommendation.

What Is XML?
02:15

SimpleXML is an extension that allows us to easily manipulate and get XML data.

SimpleXML provides an easy way of getting an element's name, attributes and textual content if you know the XML document's structure or layout.

SimpleXML turns an XML document into a data structure you can iterate through like a collection of arrays and objects.

Preview 02:05

The PHP simplexml_load_string() function is used to read XML data from a string.

Parse XML String
07:42

The PHP simplexml_load_file() function is used to read XML data from a file.

Parse XML File
01:59

Get the Value of an Element

The text value of an element node is stored in a child node. This node is called a text node. To retrieve the text value of an element, you must retrieve the value of the elements' text node.

Get Node Values
02:13

When there are multiple nodes on the same level we can access specific nodes.

Get Node Values of Specific Elements
03:03

We can loop over all of the nodes in an XML file to aid in the traversal of XML nodes.

Preview 02:42

In the DOM, attributes are nodes. Unlike element nodes, attribute nodes have text values. The way to get the value of an attribute, is to get its text value.

Get Attribute Values
02:24

Expat is a stream-oriented XML 1.0 parser library, written in C. As one of the first available open-source XML parsers, Expat has found a place in many open-source projects. Such projects include the Apache HTTP Server, Mozilla, Perl, Python and PHP. It is also bound in many other languages.

What Is The XML Expat Parser?
01:46

The built-in XML Expat Parser makes it possible to process XML documents in PHP.

Initializing the XML Expat Parser
09:30

The built-in DOM parser makes it possible to process XML documents in PHP.

Load and Output XML Using The Dom Parser
01:34

Looping means traversing through or traveling across the node tree.

Looping through XML Using The Dom Parser
03:14

Time to test your XML knowledge

Quiz - XML
5 questions
+ AJAX
4 lectures 23:25

Ajax is short for Asynchronous JavaScript and XML, which refers to a set of web development techniques rather than an actual programming language. Ajax however, is widely used in client-side programming (e.g. JavaScript) to allow for data to be sent and received to and from a database / server.

What Is AJAX?
01:42

AJAX is used to create more interactive applications.

Let's implement the HTML/JavaScript frontend.

Load Simple Data Using AJAX Front End
08:26

AJAX is used to create more interactive applications.

Let's implement the PHP backend.

Load Simple Data Using AJAX Back End
05:02

AJAX can be used for interactive communication with a database.

Load Data From A Database Using AJAX
08:15

Time to test your knowledge of AJAX

Quiz - AJAX
3 questions
+ Emails
7 lectures 39:11

There are two main types of email you can send and receive: plain text emails(these are exactly what they sound like -- any email that contains just plain old text with no formatting) and HTML emails, which are formatted and styled using HTML and inline CSS.

Plain text emails are easy to spot -- they are just simple text, no styling, all the same size.

Preview 03:55

There are two main types of email you can send and receive: plain text emails(these are exactly what they sound like -- any email that contains just plain old text with no formatting) and HTML emails, which are formatted and styled using HTML and inline CSS.

HTML emails are easy to spot -- most of the styled, multimedia marketing emails in your inbox are HTML emails.

Send A HTML Email
05:37

The mail() function doesn’t support attachment or HTML mail by default. You need to use different headers and MIME mail parts to make this possible.

Email Attachments
16:54

PHPMailer is a code library to send emails safely and easily via PHP code from a web server. Sending emails directly by PHP code requires a high-level familiarity to SMTP standard protocol and related issues and vulnerabilities about Email injection for spamming.

PHPMailer Setup
02:38

There are two main types of email you can send and receive: plain text emails(these are exactly what they sound like -- any email that contains just plain old text with no formatting) and HTML emails, which are formatted and styled using HTML and inline CSS.

Plain text emails are easy to spot -- they are just simple text, no styling, all the same size.

Send Email Using PHPMailer
04:13

There are two main types of email you can send and receive: plain text emails(these are exactly what they sound like -- any email that contains just plain old text with no formatting) and HTML emails, which are formatted and styled using HTML and inline CSS.

HTML emails are easy to spot -- most of the styled, multimedia marketing emails in your inbox are HTML emails.

Send HTML Email Using PHPMailer
03:35

The mail() function doesn’t support attachment or HTML mail by default. It is better to use PHPMailer.

Email Attachments Using PHPMailer
02:19

Time to test your knowledge of email functionality in PHP

Quiz - Emails
3 questions
Requirements
  • Passion For Learning Web Development
  • Basic Computer Knowledge and Skills
  • Passion For Learning PHP Programming
  • Basic Knowledge of Computer Science Is Optional
Description

Learn about everything there is to know about PHP & MySQL Web Development. A step by step process is used to explain every facet of these topics.

NOTE: This course includes information on web programming, design, OOP, SQL!

Gain a good understanding of the following concepts with this course:

  1. What PHP & MySQL is?

  2. Web Certifications

  3. How to develop websites/applications using PHP & MySQL

  4. Features of the PHP & MySQL programming language

  5. Coding semantics

  6. Application programming

  7. Network programming

PHP is one the most popular languages in the world. It is requested by all companies such as Google, Facebook and Microsoft for development. It powers Facebook and many other popular websites. This course will ensure you are not left out as more and more companies request this awesome and powerful language. This course will teach you everything about programming PHP & MySQL applications.

You will receive all the knowledge to use and leverage the powerful technology behind these amazing and wonderful platforms.

Over 455,000 students have enrolled on my courses and all of them are extremely satisfied. You will also be satisfied with this course. If you do not like the course, remember that within 30 days you can request a full refundI guarantee you satisfaction.

If you have any questions regarding the topics covered in this course, please feel free to ask. I'm always happy to help those who want to learn.


To summarise this is what you get:

• Lifetime access to HD quality videos. No monthly subscription. Learn at your own pace, whenever you want.

• All videos are downloadable. Learn wherever you want, even without an internet connection!

• Downloadable starter code and final code for each section.

• Free helpful support in the course Q&A when you have questions or get stuck.

• Multiple coding challenges to practice your new skills (solutions included).

Sounds great? Then start this adventure today by clicking the “Take this course" button, and join me in the only PHP & MySQL Programming course that you will need!

Who this course is for:
  • Anyone Looking To Learn About PHP Coding
  • Developers Looking To Learn The Skills Needed To Utilise PHP Features
  • PHP Developers
  • Web Developers
  • Application Programmers
  • Web Designers
  • People Looking To Learn About Programming
  • Those Seeking To Understand How PHP Programming Works
  • People Seeking Guidance On How To Create PHP & MySQL Websites/Application
  • Beginners & Experts In This Field
  • People With a Desire To Improve Their Programming Knowledge