PHP Web Development with MySQL

Name: PHP Web Development with MySQL
Rating: 4.4 (44 reviews)

Web Application Development with PHP & MySQL

Created byAli Raza Sardar Ali

Last updated 2/2020

English

What you'll learn

The students can be able to create web applications using PHP and MySQL
The students can be able to understand the concepts of client and server
The students get hands on experience of how things happen in PHP?
The students get in depth learning of MySQL relational database management system.
The students get be able to perform form handling using PHP.
The students will learn about state management in PHP [SESSIONS & COOKIES]
The student will learn how to connect PHP web application with MySQL database.
The student will be able to send and receive data to and from database.

Course content

13 sections • 101 lectures • 19h 31m total length

Course Outline8:09
This is the course outline of what we are going to learn , the thing that are not in video are listed here in detail
I am going to cover the following thing in detail:

Introduction to PHP
What is PHP
Need of PHP
Versions of PHP
PHP Installation
WAMP Server & XAMPP Server
Getting Started
Creating First PHP script
Where to store PHP page.
Things to remember when saving PHP page.
Server configuration of Adobe Dreamweaver
Variables in PHP
Operators in PHP
Types
Unary
Binary
Ternary
Classifications
Arithmetic
Relational
Logical
Assignment
Bitwise
String
Operands and Expressions
Conditional Statements in PHP
If-Else
Switch-Case
Loops in PHP
for
while
do-while
foreach
Functions in PHP
Built-in Functions
User defined functions
Form Handling
GET
POST
Email Sending
State Management
Cookies
Sessions
PHP Sanitization / Filters
Validations in PHP
Introduction to MySQL
MySQL database connectivity with PHP
Creating database
Creating tables
Creating columns and other constraints
Creating Views,Stored Procedures and triggers
Joins and relationships
CRUD Operations using PHP and MySQL
Object Oriented PHP
Other things can be added if possible
Introduction To PHP12:39
This lecture will give you detailed understanding of PHP and its related content
Installing XAMPP & WAMP [Setting Up Environment]15:16
This lecture will give you hands on experience about installation of XAMPP and WAMP software packages. also PORT configuration is demonstrated here
Create Your First PHP Page & Directory Structure11:22
This video will help you to create your first php page and it will help you how to run that php page. Also how to configure Dreamweaver for server based web site.
Merging HTML & CSS with PHP4:47
This video will help you to learn how to add HTML & CSS with PHP.
HTTP Header() in PHP8:25
This lecture will give you understanding about HTTP Headers and header() function in PHP and how redirection takes place?
PHP Form Handling using GET & POST26:21
This lecture will help you to learn the following :
What is a form?
How to send data from one page to another in PHP?
What methods are used to send data from one page to another?
What is the difference between GET & POST method.
Practical GET method demonstration
Practical POST method demonstration
Implementation of Bootstrap with PHP and HTML
Variables in PHP Part 126:05
This video will help you to learn:
What are variables in PHP?
What are Data Types?
What are identifiers?
What is a constant and how it is created in PHP?
What are the rules when creating variable naming conventions?
Variables in PHP (Scope of variable) Part II14:54
This lecture will help you to learn about scope and boundaries of a variable life time through out PHP page execution. Following are the scopes that are demonstrated with example in detail.
Local
Global
Static
HTTP Environment Variables10:14
This lecture will help you to learn what are Environment variables and how you can you them in side PHP
?
Section 1 Assignment

Operators in PHP Part 118:08
This lecture will give you complete guide of every type of operators along with precedence of operators evaluation in an expression.
Unary Operators5:33
This video will help you to learn practically how unary operators are performing operations on operands.
Binary + Arithmetic Operators11:38
This video will help you to learn practically how binary and arithmetic operators are performing operations on operands.
Ternary Operators7:32
This video will help you understand how ternary operators are performing its operations similar to if-else.
Precedence Of Operators7:08
This video will help you learn the order in which an expression can be evaluated in PHP.
Relational Operators9:42
This video will help you to understand the behavior of relational operators in PHP.
Logical Operators11:22
This lecture will help you to learn about logical operators in PHP i.e AND, OR, NOT with practical implementation.
Bitwise Operators15:30
This video lecture helps you to understand bitwise operators and how calculation is being performed using bitwise AND, OR, COMPLEMENT, LEFT SHIFT & RIGHT SHIFT Operators along with XOR.
Assignment Operators5:18
This video is demonstrating the use of assignment operators in PHP and it tell you the way to use shorter way of assignments in PHP.
Pre increments & Post increments3:44
This video will help you to grasp understanding about the change in behavior of expression when we prefix or post fix increment and decrement operators in PHP

IF-ELSE Statements14:25
This chapter will help you to understand how if-else and if-else-if conditions are working with PHP
Switch Case13:39
This video will help you to learn in depths about a=switch case statements in PHP
Nested If-Else [LOGIN PAGE Example] with self page submission of data24:31
This video will help you to learn about the following things in PHP.

1. Nested If-Else
2. Self page data submission
3. What is isset() function and how to use it?
Nested Switch Case [A Calculator Example]24:19
This lecture will help you to do work with nested switch case

Introduction to loops in PHP2:47
This is an introductory lecture that help you to understand what are loops and why we use it.
FOR Loop [Syntax and Method of writing]13:03
This video will help you how to write FOR loop and what are way in which we can use for loop.
Reverse For Loop3:38
This video will help you to create a reverse for loop with practical implemetation
Optional & Infinite For Loop6:35
This video will give you more insights of for loop and its behavior whether optional or infinite
Nested For Loop with Pattern generation15:19
This video will help you to learn in-depth about for loop and nested for loop along with pattern program to improve logic building.
While Loop5:27
This video will help you to grasp detailed understanding about while loop in PHP.
While with If-Else3:36
This video lecture helps you to learn while loop along with if-else with practical implementation
Nested While Loop8:00
This video lecture helps you to learn nested while loop with pattern programs.
Do-While Loop7:14
This lecture will tell you about do-while loops and what makes it different from FOR and WHILE loops
Jump Statements7:20
This video will help you to understand the working of jump statements break, continue and exit with practical implementation.

Introduction to Functions9:07
This video will help you to learn what are functions in PHP in details along with it types.
Mathematical Functions in PHP15:00
This video will help you to learn mathematical function in PHP with practical demonstration. Following are the functions that we study:

abs()
max()
min()
sqrt()
pow()
rand()
round()
ceil()
floor()
String Functions in PHP31:41
This video will help you to learn what are strings and how to manipulate strings with built in functions of PHP
Date Functions in PHP16:05
This video will help you to learn how to manipulate dates in PHP using builtin date functions
Error Handling Functions in PHP14:51
This lecture will help you to understand how customized error messages can be displayed and how to handle errors in PHP.
User Defined Functions in PHP18:29
This video helps you to create your own function according to your requirements and this lecture helps you to create different type of user defined functions like parameterized, non parameterized function and returning and non returning functions.
Nested User Define Functions in PHP4:30
This lecture helps you to learn how nesting of functions can be performed or how can you pass a function as input to other functions in PHP.
Default Parameters in User Defined Functions3:42
This video will help you to learn what are default arguments / parameters and how they benefit us.
Recursive Functions11:41
This lecture helps you to understood recursion process with functions. Recursion mean calling of function itself within it self.

Introduction to arrays10:00
This session will guide you what is an array and why we use it.
Array Initialization3:37
This video will help you to learn how array is initialized in PHP.
Associative Arrays4:58
This video will give you insights of what are associative array in PHP.
Merging of Arrays5:34
This video will help you to understand how multiple array can be merged in PHP
Multidimensional Array6:47
This video will help you to learn multidimensional associative array in PHP
Arrays with FOREACH loop5:12
This lecture will help you to learn how array can be created in simple manner and how to use foreach loop.
Multidimensional Indexed Arrays11:02
This video will help you to learn how multidimensional indexed arrays are created.
Array Functions25:05
This lecture will help you to learn about the following functions in PHP.

count
sizeof
array_count_values
array_flip
array_intersect
array_keys
array_reverse
array_shift
array_key_exists
array_push
array_pop
Sorting Arrays6:08
This lecture will help you to understand how sorting is done in arrays in PHP using sort() , rsort() and arsort() functions

Introduction to state management6:05
This video will help you to understand the concept of state management in PHP
Cookies in PHP20:34
Deleting a Cookie5:53
This lecture will describe how to remove cookie using user interaction on website.
[NOTE Cookies are not recommended for authentication purposes]
Sessions in PHP17:11
This video will help you to learn how session are created and utilized in PHP with Login and Logout example.
Configuration File [php.ini]13:42
This lecture describes the php.ini file and its importance

What are Validations?4:43
This lecture will help you to understand how to get rid of erroneous data.
FILTER_VALIDATE_INT6:35
FILTER_VALIDATE_FLOAT2:41
FILTER_VALIDATE_EMAIL0:56
FILTER_VALIDATE_URL1:30
FILTER_VALIDATE_IP3:16
Sanitization in PHP7:41
This lecture will help you to secure your web application from malicious user input at run-time using sanitization .
Securing forms in PHP18:47
This video will help you to validate your form data w.r.t Cross Site Scripting Attacks on your web application

Introduction to Object Oriented Programming with PHP21:37
This lecture give you a synopsis about OOP and help you to understand why OOP is good for programming.
Class in PHP9:55
Object in PHP9:45
Constructors9:01
This video will guide to to distinguish difference between normal function and constructors.
Abstraction5:28
This video will make you learn how to achieve abstraction in OOP in PHP.
Encapsulation8:21
This video will make you learn how to achieve encapsulation in OOP in PHP.
Inheritance and Access Specifiers9:47
This video will make you learn how to achieve inheritance in OOP in PHP and what are access specifiers.

Requirements

HTML
Web Design Concepts

Description

Hi students,

welcome to my course Web Development with PHP & MySQL

This course will be an all in one solution that helps you to learn how to create a web application using PHP and MySQL, all at one place. This course is a complete mixture of multiple technologies like HTML, CSS, JavaScript, JQuery, Bootstrap and AJAX along with PHP and MySQL.

I am going to cover the following thing in detail:

Introduction to PHP
1. What is PHP
2. Need of PHP
3. Versions of PHP
4. PHP Installation
5. WAMP Server & XAMPP Server
Getting Started
1. Creating First PHP script
2. Where to store PHP page.
3. Things to remember when saving PHP page.
4. Server configuration of Adobe Dreamweaver
Variables in PHP
Operators in PHP
1. Types
  1. Unary
  2. Binary
  3. Ternary
2. Classifications
  1. Arithmetic
  2. Relational
  3. Logical
  4. Assignment
  5. Bitwise
  6. String
3. Operands and Expressions
Conditional Statements in PHP
1. If-Else
2. Switch-Case
Loops in PHP
1. for
2. while
3. do-while
4. foreach
Functions in PHP
1. Built-in Functions
2. User defined functions
Form Handling
1. GET
2. POST
Email Sending
State Management
1. Cookies
2. Sessions
PHP Sanitization / Filters
Validations in PHP
Introduction to MySQL
MySQL database connectivity with PHP
Creating database
Creating tables
Creating columns and other constraints
Creating Views,Stored Procedures and triggers
Joins and relationships
CRUD Operations using PHP and MySQL
Object Oriented PHP
Other things can be added if possible

Who this course is for:

Beginner web designers
Intermediate web designers
Any one who want to learn web application development.

PHP Web Development with MySQL

What you'll learn

Explore related topics

Course content

PHP [A Complete Guide]10 lectures • 2hr 18min

PHP Operators10 lectures • 1hr 36min

Conditional Statements4 lectures • 1hr 17min

Loops in PHP10 lectures • 1hr 13min

Functions in PHP9 lectures • 2hr 5min

Arrays in PHP9 lectures • 1hr 18min

State Management in PHP5 lectures • 1hr 3min

Validations in PHP8 lectures • 46min

File Uploads2 lectures • 37min

Object Oriented Programming with PHP7 lectures • 1hr 14min

Requirements

Description

Who this course is for: