This course introduces students with basic HTML skills to PHP scripting language. The course refreshes the students on webservers and how the request-response works. They are guided on how to install and run the Apache webserver-XAMPP: Apache is the PHP webserver. The students are further shown how to use the language, how it integrates with HTML and the Bootstrap framweork, how it helps connect and manipulate databases contents and how Ajax perfectly fits to make web content asynchronously dynamic with JQuery. The course further looks at implementing security on PHP web applications.

The following objectives are intended:

1. Understanding How webservers work-Apache.

2. Installation of Xampp.

3. Creating HTML webpages and linking them with PHP.

4. PHP Syntax through examples.

5. Understanding of How Ajax works.

6. Implementing Ajax using JQuery.

7. Working with JSON data.

8. Working with MySQL databases- MySQLi syntax.

9. Implementing security in PHP applications.

Section 1: Introduction To Web Servers

• 1.   Web servers: Client-Server Concept
  00:3:1
• 2.   Types of Web servers
  00:2:24
• 3.   Installing web servers
  00:04:20
• 4.   xampp installation
  00:01:52
• 5.   Web Server Testing
  00:03:23
• 6.   Creating Test Site
  00:04:53

Section 2: Introduction to PHP

• 1.   Intro to PHP
  00:01:31
• 2.   Scripting Languages
  00:01:47
• 3.   Uses of PHP
  00:01:40
• 4.   PHP Page
  00:03:44
• 5.   Comments
  00:03:13
• 6.   Variables
  00:03:25
• 7.   Conversion
  00:05:03
• 8.   Data Types
  00:04:52
• 9.   Operators
  00:01:58
• 10.   Arithmetic Operators
  00:02:46
• 11.   Comparison Operators
  00:02:49
• 12.   Logical Operators
  00:02:48
• 13.   Assignment Operators
  00:01:57
• 14.   Conditional Operators
  00:03:08
• 15.   Control Structures
  00:01:33
• 16.   Ternary Operators
  00:01:34
• 17.   If
  00:02:11
• 18.   If Else Statements
  00:02:06
• 19.   Multiple If Else
  00:04:25
• 20.   Switch Statement
  00:03:48
• 21.   Looping
  00:01:45
• 22.   For Loop
  00:03:22
• 23.   While Loop
  00:02:25
• 24.   Do While Loop
  00:03:16
• 25.   Foreach
  00:03:32
• 26.   Arrays
  00:02:23
• 27.   Array Types
  00:00:22
• 28.   Indexed Arrays
  00:03:58
• 29.   Associative Arrays
  00:03:10
• 30.   Multidimensional Arrays
  00:02:42
• 31.   Creating Arrays
  00:03:26
• 32.   Add Arrays
  00:03:53
• 33.   Remove Arrays
  00:03:03
• 34.   Merge Arrays
  00:03:02
• 35.   Implode Arrays
  00:03:01
• 36.   Explode Arrays
  00:03:19
• 37.   Other Array Methods
  00:00:44
• 38.   Error Handling
  00:01:02
• 39.   Die Error Handling
  00:03:30
• 40.   Custom Error Handling
  00:05:09
• 41.   Error Reporting
  00:02:24
• 42.   Exception Handling
  00:04:15

Section 3: PHP and HTML

• 1.   HMTL Brief
  00:01:07
• 2.   HTML5 Structure
  00:02:43
• 3.   HTML Form
  00:01:32
• 4.   HTML Forms Examples
  00:04:15
• 5.   Internal Styling
  00:04:14
• 6.   External CSS
  00:04:44
• 7.   HTML PHP Form Attributes
  00:02:30
• 8.   HTML Get
  00:04:32
• 9.   HTML Post
  00:04:03
• 10.   Display Data using GET
  00:01:23
• 11.   Display Data using POST
  00:01:00
• 12.   Introduction to Bootstrap
  00:00:49
• 13.   Bootstrap Advantages
  00:01:14
• 14.   Bootstrap Setup
  00:04:08
• 15.   Bootstrap Grid
  00:01:21
• 16.   Bootstrap in Webpage
  00:03:03
• 17.   Grid Tier Classes
  00:01:46
• 18.   Grid Tier Classes on Webpage
  00:03:11
• 19.   Bootstrap Navigation Bar
  00:02:21
• 20.   Adding Bootstrap Navigation Bar
  00:05:08
• 21.   Bootstrap Form
  00:04:08
• 22.   Bootstrap and HTTP Methods
  00:00:34

Section 4: Connection to Databases

• 1.   Checking Database Server(XAMP)
  00:02:31
• 2.   Create Database
  00:01:17
• 3.   Rename and Drop Database
  00:02:46
• 4.   MySQL Create DB
  00:02:06
• 5.   MySQL Drop-Rename Table
  00:01:36
• 6.   MySQL Server Connection Status
  00:00:56
• 7.   MySQLI
  00:02:37
• 8.   MySQLI PHP Connection
  00:05:06
• 9.   MySQL Data Types
  00:02:29
• 10.   MySQL Table in Xampp
  00:04:13
• 11.   MySQL Table in Commands
  00:04:17
• 12.   MySQL Insert
  00:02:14
• 13.   Insert using PHP
  00:05:09
• 14.   MySQL Select
  00:03:13
• 15.   MySQL Select and PHP
  00:05:09
• 16.   Mysql Select Table PHP
  00:02:58
• 17.   Bootstrap Form PHP
  00:05:11
• 18.   Bootstrap Better Response
  00:04:48
• 19.   Adding Navigation
  00:02:21
• 20.   Bootstrap Tables
  00:03:55
• 21.   Bootstrap Tables and PHP
  00:03:31
• 22.   Update Records Bootstrap PHP
  00:04:57
• 23.   Delete Records Bootstrap PHP
  00:04:26
• 24.   CRUD On Tables
  00:02:25
• 25.   CRUD edit and delete
  00:05:09

Section 5: AJAX in PHP Applications

• 1.   Introduction to Ajax
  00:02:40
• 2.   How Ajax Works
  00:01:40
• 3.   XML HTTP Request Object
  00:02:18
• 4.   Ajax and Server
  00:05:39
• 5.   Ajax and Server Explained
  00:01:53
• 6.   JSON
  00:02:29
• 7.   Send using Ajax
  00:05:11
• 8.   JQuery
  00:00:51
• 9.   JQuery Example
  00:03:11
• 10.   JQuery Explained
  00:01:26
• 11.   Ajax JQuery
  00:05:03
• 12.   Console.log
  00:01:20
• 13.   JSON Parse
  00:03:15
• 14.   JQuery Validation
  00:00:48
• 15.   JQuery Form Validator Plugin
  00:00:46
• 16.   JQuery Validation and Bootstrap
  00:04:35
• 17.   Send Validated Data
  00:02:16

Section 6: Security in PHP Applications

• 1.   PHP Security Introduction
  00:01:54
• 2.   Authentication vs Authorization
  00:00:52
• 3.   Login Application Create
  00:02:14
• 4.   Authentication Registration
  00:05:05
• 5.   Processing Login
  00:04:23
• 6.   Welcome Page
  00:03:38
• 7.   Sessions
  00:04:51
• 8.   Implementing Logout
  00:02:27
• 9.   Hashing and Verifying Passwords
  00:02:36
• 10.   Hashing Examples
  00:02:17
• 11.   Hashing Registration Forms
  00:02:27
• 12.   Verification in Login Forms
  00:01:27
• 13.   Role Based Authentication
  00:02:17
• 14.   Role Modication on Login Script
  00:02:19
• 15.   Roles Redirection
  00:04:40
• 16.   Cross Site Scriptin (XSS)
  00:00:56
• 17.   Implenting XSS
  00:03:21
• 18.   Preventing XSS
  00:03:23
• 19.   Cross Site Request Forgery (CSRF)
  00:01:32
• 20.   Implementing CSRF
  00:03:43
• 21.   SQL Injection
  00:01:18
• 22.   MySQL Escape String
  00:01:26
• 23.   Enabling and Working with PDO
  00:01:57
• 24.   PDO Implementation
  00:01:13