GSAtrain

​

Connecting to ODBC Databases with PHP

• Setting up ODBC DSNs (Data Source Names)
• Understanding DSN-less connection strings
• Connecting to MS Access and SQL Server

Functions and Variable Scope

• Defining a function and passing arguments
• Declaring global variables
• Passing arguments by reference

Object-Oriented PHP

• OO Concepts: classes, Methods, and Properties
• Defining methods and properties
• Extending classes

Pattern-Matching

• Matching and replacing based on patterns
• Special characters
• Matching one or more occurrences of a pattern; matching zero or more occurrences
• Memorizing and re-using matched patterns

Extending PHP with PEAR

• Installing and managing packages
• Useful PEAR modules

MySQL/PHP Integration

• Examine ways to connect to MySQL using PHP
• How to trap and display errors
• How to perform inserts, updates and deletes from form inputs
• How to retrieve recordsets based on user provided criteria

MS Access/PHP Integration

• How to connect with MS Access and execute PHP queries using an ODBC connection

Sessions

• How to manage and use sessions within dynamic web pages

File Input/Output

• How to create, read and write XML compatible text files

Practical PHP - Useful PHP Features

• Subtleties of single or double quotes
• Conversion of form input tags to PHP variables
• Escaping special characters