PHP - Web Developers Course

HTML5

• Overview of HTML

• Introduction to HTML

• Creating an HTML Document

• Formatting text with HTML

• Paragraph Formatting with HTML

• Character Formatting with HTML

• Comparing Procedural and Descriptive Formatting

• Adding local and remote links

• Adding Internal Links with the Named Anchor Tag

• Adding graphics Linking and Embedding Graphics

• Creating lists in HTML

• Creating Lists and Nested Lists

• Creating tables in HTML

• Creating and Modifying Tables

• Creating Advanced Table Elements

• Setting Body and Background Attributes

• Setting Background and Text Colors

Cascading Style Sheets

• Introduction

• CSS Syntax

• CSS Property Names and Values

• Creating CSS Style Sheets

• Grouping Selectors

• Pattern Matching Rules

• Inheritance

Javascript

Where does Javascript fit in?

• Overview of the role of browser for Javascript

• Discuss about the strengths and weaknesses of Javascript

Your First Script

• How to incorporate Javascript into HTML

• Command and command block structure in Javascript

• Output function

Working with Data and Information

• Data types

• Using and declaring variables

• Assignment expressions

• Font tag and its attributes

• Operators

Functions and Objects

• Defining functions

• Creating new objects, properties and methods

Built-in Object

• String object

• Math object

• Date object

• Built-in function

Events in Javascript

• Event and event handlers like:

• Onload

• Onclick

• Blur

• Onchange and more

Creating Interactive forms

• The forms of object

• Methods of the form object

• Working with form elements: button, checkbox, etc.

Loops

• For loop

• While loop

• If statement

• Break and continue statements

Frames, Documents and Windows

• Working with frames

• Working with the status bar

• Controlling the timing of scripts

Jquery

Introduction to Jquery

• jQuery and JavaScript

• jQuery and AJAX

• Flavours of jQuery

• Obtaining / Accessing the jQuery library

The jQuery Event Model

• Binding event handlers

• Removing event handlers

• User Interface / Mouse events

• Event Manipulation Methods

jQuery Selectors

• Identifying DOM elements

• Constructing jQuery Selectors

• Basic CSS selectors

• Positional selectors

• Custom jQuery selectors

• Chaining jQuery operations

• Escaping meta-characters

• The ready() handler

Ajax

PHP and MySql

PHP Basics

• How PHP Works

• The php.ini File

• Basic PHP Syntax

• PHP Tags

PHP Statements and White space

Comments

PHP Functions

Hello World!

• Variables

Variable Types

Variable Names (Identifiers)

Type Strength

Hello Variables!

Variable Scope

Superglobals

Constants

Variable-Testing and Manipulation

• PHP Operators

Creating Dynamic Pages

Single Quotes vs. Double Quotes

Howdy World!

• Conclusion

Flow Control

• Conditional Processing

If Conditions

• Loops

While

do...while

for

break and continue

• Conclusion

Arrays

• Enumerated Arrays

Initializing Arrays

Appending to an Array

Reading from Arrays

Looping through Arrays

• Associative Arrays

Initializing Associative Arrays

Reading from Associative Arrays

Looping through Associative Arrays

Superglobal Arrays

• Two-dimensional Arrays

Reading from Two-dimensional Arrays

Looping through Two-dimensional Arrays

• Array Manipulation Functions

• Conclusion

PHP and HTML Forms

• HTML Forms

How HTML Forms Work

A Sample HTML Form

Reading from Arrays

Form Variables

• Conclusion

String Manipulation

• Formatting Strings

Concatenation

String Manipulation Functions

Examples of String Functions

• Magic Quotes

magic_quotes_gpc

magic_quotes_runtime

Recommendation on Magic Quotes

• Conclusion

Reusing Code and Writing Functions

• Including Files

require

require_once

auto_prepend_file and auto_append_file

• User Functions

Defining and Calling Functions

Default Values

Variable Scope

By Reference vs. By Value

• Form Processing

Code Organization

Conclusion

Simple SELECTs

• Introduction to the Northwind Database

• Some Basics

Comments

Whitespace and Semi-colons

Case Sensitivity

• SELECTing All Columns in All Rows

• SELECTing Specific Columns

• Sorting Records

• Sorting By a Single Column

• Sorting By Multiple Columns

• Sorting By Column Position

• Ascending and Descending Sorts

• The WHERE Clause and Operator Symbols

Checking for Equality

Checking for Inequality

Checking for Greater or Less Than

Checking for NULL

WHERE and ORDER BY

• WHERE Clause and Operator Words

The BETWEEN Operator

The IN Operator

The LIKE Operator

The NOT Operator

• Checking Multiple Conditions

AND

OR

Order of Evaluation

• Conclusion

Subqueries, Joins and Unions

• Subqueries

• Joins

Table Aliases

Multi-table Joins

• Outer Joins

• Unions

UNION ALL

UNION Rules

• Conclusion

Inserting, Updating and Deleting Records

• INSERT

• UPDATE

• DELETE

• Conclusion

Managing Data

• Querying a Database

mysqli() Overview

mysqli Methods and Properties

Inserting and Updating Records

mysqli Prepared Statements

PEAR:DB

• Advantages and Disadvantages of PEAR DB

Why use a database abstraction layer?

When not to use a database abstraction layer?

• Using PEAR DB

Authentication with PHP and SQL

• A Database-less Login Form

• Conclusion

Regular Expressions

Perl-compatible Regular Expression Functions

• preg_match()

• preg_replace()

Regular Expression Tester

Regular Expression Syntax

Start and End ( ^ $ )

Number of Occurrences ( ? + * ,- )

Common Characters ( . \d \D \w \W \s \S )

Grouping ( *+ )

Negation ( ^ )

Subpatterns ( () )

Alternatives ( | )

Escape Character ( \ )

• Form Validation Functions with Regular Expressions

• Conclusion

Session Control and Cookies

• Sessions

Configuring Sessions

Session Functions

• Configuring Sessions

• Session Functions

• Cookies

• Conclusion

Sending Email with PHP

• mail()

Shortcomings of mail()

• PHPMailer

• Conclusion

File System Management

• Opening a File

fopen()

• Reading from a File

fgets()

• Writing to a File

fwrite()

• File Locking

flock()

• Uploading Files via an HTML Form

• Getting File Information

• More File Functions

• Directory Functions

Getting a Directory Listing

Overview of CMS

• Joomla

• Dhrupal

• Wordpress

Project development with PHP Frameworks

• Code Ignator

• Zend