Infoschool

Skeleton of the Course PHP / MYSQL

Introduction to PHP Training (3 days)

PHP Training Overview

In this PHP training course, students will learn to create database-driven websites using PHP and MySQL.

PHP Training Class Goals

Learn how PHP works
Learn the basic syntax of PHP
Learn to create dynamic interactive pages with PHP
Learn to manipulate files with PHP
Learn to work with arrays in PHP
Learn to validate forms with PHP
Learn to write functions in PHP
Learn to manipulate and manage database data with PHP
Learn to authenticate users with PHP
Learn to manage sessions with PHP
Learn to work with the PEAR:DB module
Learn advanced form validation with regular expressions
Learn to send email with PHP

PHP Courseware

PHP Basics
- How PHP Works
- The php.ini File
- Basic PHP Syntax
  - PHP Tags
  - PHP Statements and Whitespace
  - Comments
  - PHP Functions
  - Hello World!
- Variables
  - Variable Types
  - Variable Names(Identifiers)
  - Type Strength
  - Hello Variables!
  - Variable Scope
  - SuperGlobals
  - Constants
  - Variable-Testing and Manipulation Functions
- First PHP Script
- PHP Operators
- Creating Dynamic Pages
  - Single Quotes vs. Double Quotes
  - Passing Variables on the URL
- Passing Variables via the Query String
Flow Control
- Conditional Processing
  - If Conditions
- Working with Conditions
- Loops
  - While
  - Do-While
  - For
  - Break and Continue
- Working with Loops
Arrays
- Enumerated Arrays
  - Initializing Arrays
  - Appending to an Array
  - Reading from Arrays
  - Looping through Arrays
- Working with Enumerated Arrays
- Associative Arrays
  - Initializing Associative Arrays
  - Reading from Associative Arrays
  - Looping through Associative Arrays
  - SuperGlobal Arrays
- Working with Associative Arrays
- Two Dimensional Arrays
  - Reading From Two Dimensional Arrays
  - Looping through Two Dimensional Arrays
- Array Manipulation Functions
PHP and HTML Forms
- HTML Forms
  - How HTML Forms Work
  - A Sample HTML Form
  - Form Variables
- Processing Form Input
String Manipulation
- Formatting Strings
  - Concatenation
  - String Manipulation Functions
  - Examples of String Functions
- Working with String Manipulation Functions
- Magic Quotes
  - magic quotes gpc
  - magic quotes runtime
  - Recommendation on magic quotes
Reusing Code and Writing Functions
- Including Files
  - require
  - require_once
  - auto_prepend file and auto_append file
- Adding a Header and Footer
- User Functions
  - Defining and Calling Functions
  - Default Values
  - Variable Scope
  - By Reference vs. By Value
- Form Processing
  - Code Organization
- Form Validation and Presentation Functions
Managing Data
- Querying a Database
  - mysqli Overview
  - mysqli methods and properties
  - Inserting and Updating Records
  - mysqli Prepared Statements
- Inserting Records
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
- Creating a Customer Report
Authentication with PHP and SQL
- A Database Less Login Form
- Authenticating Users
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
Session Control and Cookies
- Sessions
  - Configuring Sessions
  - Session Functions
- Cookies
- Authentication with Session Control
Sending E-Mail with PHP
- mail()
  - Short Comings of mail()
- PHPMailer
- Sending a Password by Email
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
- Creating a Resume Management Page

Email:

Join this course now

E-Mail:*	Enter correct e-post adress Enter e-post adress
Password:*	Enter Password
	register

Contact counselors

Training @ infoschool

Success stories

I got the opportunity of getting a practical experience on SAS couse from InfoSchool. It helped me in learning new analytical tools and their applications, today I am in my dream job. Thanks to InfoSchool for giving this opportunity.

By Vidya,
SAS Developer, PowerSoft Technologies,