Griffin Software Home
Training ServicesCoursesFacilitiesConsultancy Services
Course List
Linux & Unix
Solaris TM
HPUX TM
Oracle TM
Development
Contact Us
home

Development


Introduction to PHP and MySQL

Back to main Introduction to PHP and MySQL page

PHP LogoMySQL Logo

Course Content:

PHP Basics Flow Control
How PHP works
The php.ini file
Basic PHP syntax
Variables
PHP Operators
Creating Dynamic Pages
Single Quotes Vs Double Quotes
Hello World!
Conditional Processing
Loops
Arrays PHP and HTML Forms
Enumerated Arrays
Associative Arrays
Two-Dimensional Arrays
Array Manipulation Functions
HTML Forms
String Manipulation Reusing Code and writing Functions
Formatting Strings
Magic Quotes
Including Files
User Functions
Form Processing
MySQL - Simple SELECTs MySQL - Subqueries, JOINs and UNIONs
Introduction to the Northwind Database
Some Basics
Selecting all Columns in all Rows
Selecting specific Columns
Sorting Records
The WHERE Clause and Operator Symbols
The WHERE Clause and Operator Words
Checking Multiple Conditions
Subqueries
Joins
Outer Joins
Unions
MySQL - Inserting, Updating and Deleting Records MySQL - Managing Data
INSERT
UPDATE
DELETE
Querying a Database
MDB2 Authentication with PHP and SQL
Advantages and Disadvantages of MDB2
Using MDB2
A Database-less Login Form
Regular Expressions Session Control and Cookies
Perl Compatible Regular Expression Functions
Regular Expression Syntax
Form Validation Functions with Regular Expressions
Sessions
Cookies
Sending EMail with PHP File System Management
mail()
PHPMailer
Opening a File
Reading from a File
Writing to a File
File Locking
Uploading Files via a HTML Form
Getting File Information
More File Functions
Directory Functions

Prerequisites:
  1. Experience with HTML and, preferably, some experience with any other programming language


Back to top
© 2018 Griffin Software Ltd - All Trademarks acknowledged (3.16). Griffin Software Ltd, Tel: +353 (1) 4622277