Introduction to PHP Training
Learning the Basics of PHP
Why Use PHP?
Structure of a PHP Page
Embedding PHP Code in an HTML Document
Variable Types
Declaring and Using Arrays
Constants
Operators
Loops and Conditional Statements
Superglobal Variables
Retrieving Form Data
Sending Emails
Hands-on Workshop: Review of core HTML tags and styling commands, setting up a template page
Creating Functions and Using Built-in Functions
Declaring Functions
Parameters and the Return Statement
Creating Function Libraries
Built-in Functions: Examples, Organization, Documentation
Functions for Dates, Arrays, and Strings
Include and Require Functions
Hands-on Workshop: Creating custom functions and using built-in functions
Processing Form Data
Creating a Form
Retrieving Form Data
File Uploads: The $_FILES Variable and Related Functions
Sending Emails
Hands-on Workshop: Building a job application form
Interacting with Users
Retrieving and Using GET Parameters
Using Cookies to Store Information
File Uploads: The $_FILES Variable and Related Functions
Sending Emails
Hands-on Workshop: Building a job application form
phpMyAdmin
Overview of phpMyAdmin
Creating a Database with phpMyAdmin
Creating Tables and Exploring Field Types
Modifying Table Structure
Hands-on Workshop: Creating a MySQL database and tables
SQL
Selecting Records (SELECT)
Inserting Records (INSERT INTO)
Updating Records (UPDATE)
Deleting Records (DELETE)
Operators and Conditions
Hands-on Workshop: Writing basic SQL queries
Using a MySQL Database with PHP
Overview of Database Management Systems
Data Types
Connecting to a MySQL Server
Populating the Database from a Form
Inserting Data into the Database with PHP
Updating Data with PHP
Deleting Data with PHP
Securing Data Before Sending to MySQL
Hands-on Workshop: Storing job application form data in the database
Cookies & Sessions
Session Overview
Advantages and Disadvantages of Cookies and Sessions
Storing and Retrieving Session Variables
Storing and Retrieving Cookie Variables
Hands-on Workshop: Building a simple shopping cart and user interface
Working with Files
Opening and Writing Files
SQL: Advanced Concepts
Tables and Relationships
Joins: INNER, LEFT, and RIGHT JOIN
Hands-on Workshop: Writing SQL queries across multiple tables
Building a Mini CMS
CMS Concepts
Existing CMS Platforms
Introduction to Data Modeling
Creating the Public Interface
Creating the Admin Interface
User Management
Hands-on Workshop: Library management application
Overview of the XML Format
Writing an XML Document
Introduction to XML
Hands-on Workshop: Creating an RSS feed and generating a sitemap for the library project
