Open Source PHP Web Design and Development Training Courses

Introduction to PHP

• Basic syntax
• Sending data to web browser
• Understanding PHP, HTML, and white space
• Writing comments
• What are variables?
• About strings
• About numbers and constants
• Single vs. double quotation marks

Programming with PHP

• Creating an HTML form
• Handling an HTML form
• Managing magic quotes
• Conditionals and operators
• Validating form data
• What are arrays?
• For and while loops

Creating Dynamic Web Sites

• Including multiple files
• Handling HTML forms with PHP redux
• Making sticky forms
• Creating and calling your own functions
• Variable scope
• Date and time functions
• Sending email

Introduction to SQL and MySQL

• Choosing your column properties
• Using the mysql client
• Creating databases and tables
• Inserting records
• Selecting data
• Using conditionals
• Using LIKE and NOT LIKE
• Sorting query results
• Limiting query results
• Updating and deleting data
• Using functions

Error Handling and Debugging

• General error types and debugging
• Displaying PHP errors
• Adjusting error reporting in PHP
• Creating custom error handlers
• Logging PHP errors
• PHP debugging techniques
• SQL and MySQL debugging techniques

Using PHP with MySQL

• Modifying the template
• Connecting to MySQL and selecting the database
• Executing simple queries
• Retrieving query results
• Ensuring secure SQL
• Counting returned records
• Updating records with PHP

Advanced PHP and MySQL

• Database design
• Performing joints
• Grouping selected results
• Creating indexes
• Using different table types
• Performing FULLTEXT searches
• Database optimisation

Web Application Developement

• Adjusting behaviour for server settings
• Sending values to a script manually
• Using hidden form inputs
• Editing existing records
• Paginating query results
• Making sortable displays
• Understanding HTTP headers

Web Application Security

• More secure form validation
• Handling HTML
• Validating data by type
• Form validation with JavaScript
• Regular expressions
• Database security and encryption

Sessions

• Cookies vs Sessions
• Creating a Session
• Storing & Accessing Simple Variables
• Storing Objects

Objects & Classes

• Object Oriented Programming
• Creating Classes
• Class Inheritance
• Manipulating Objects
• PHP4 vs PHP5

Images

• Getting Image Info
• Reading Images
• Outputting Images
• Resizing Images
• Basic Geometry & Text

Cron Jobs

• Setting Up Cron Jobs
• Differences to Web
• Hidden Dangers

Online Catalogue

• Catalogue Tables
• Items & Categories
• Single vs Multiple Categories
• Browsing Categories
• Detail Page

Content Management

• Creating the templates
• Creating the basic pages
• Managing URLs
• Managing files

User Registration

• Creating the templates
• Writing the configuration scripts
• Creating the home page
• Registration
• Actiavting an account
• Identification methods
• Logging in & out
• Password management

E-Commerce Basics

• Creating the database
• The administrative side
• Payment gateways
• Tracking Online & Offline Payments
• Recording orders
• Invoicing
• Reports

Shopping Cart

• Cookies vs Sessions Revisited
• Adding Items to Cart
• Editing Cart Contents
• Checkout
• Submitting Data

Introduction to JavaScript

• What JavaScript can and can't do
• Origin of JavaScript
• Client Side vs Server Side Code
• Versions of JavaScript
• Browser considerations
• Compatibility issues

The Language

• Understanding functions
• Working with variables
• Manipulating variables
• Object oriented programming

Working with HTML

• Contextual events
• The Document Object Model (DOM)
• The ID attribute
• Element Properties

Capturing User Input

• Dialogue boxes
• Working with forms
• Simple form validation
• Navigation and control

Controlling the browser

• Determining platform
• Pop-up elements
• Navigation roll-overs
• Additional techniques

Introducing XML

• A brief history of XML
• The great SGML
• XML vs. HTML What’s the difference?
• Structure vs. presentation
• Structuring information with XML

The structure of XML

• Tags and attributes
• Tag naming Rules
• Valid nesting and hierarchy
• Processing and parsing
• Entity and characterrReferences

XML CSS Primer

• Stylesheet languages
• Formatting with rules
• Defining elements as blocks
• Styling colour and fonts
• Page Layout with CSS

XSLT and Xpath

• Understanding XSLT and Xpath
• XSL Transformations
• Extracting element values
• Choosing specific cases
• Multiple element transformation
• Sorting elements

Namespaces

• Understanding XML Namespaces
• Working with prefixes
• Default namespaces
• URLs and URNs
• When to use Namespaces

The Document Object Model (DOM)

• Understanding the DOM
• Browser interfaces
• The DOM core

Document Type Definitions

• Introducing XML DTDs
• Element Type
• Attributes
• Internal and external DTDs
• Schemas vs. DTDs

Understanding Ajax

• What is Ajax?
• JavaScript and XML
• Loading Data Inline
• Client v. server-side scripting
• Synchronous and Asynchronous interaction

Using HTTP methods

• Understanding HTTP
• The XMLHttpRequest Object
• Sending a Request
• Setting up Response

The Document Object Model

• Understanding the DOM
• Accessing Nodes
• Element and Attribute Nodes
• Removing Nodes
• The ‘style’ property
• Display versus visibility
• Adding and removing tree elements

Working with XML

• XML and the DOM
• Understanding XML nodes
• Accessing and editing XML nodes
• Creating new nodes

XSLT and JavaScript

• Understanding XSLT
• XSLT transformations with JavaScript
• XSLT and browser compatibility

Ajax Applied

• Processing PHP and MySQL queries
• Drag and Drop basics
• Inline editing
• Details on demand
• Auto-logout
• Auto-completion