Learn Bench

Objectives

• This course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MYSQL database system and HTML.
• On completion of the course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database

The delegate will learn to

• Declare variables and initialise them
• Construct expressions with arithmetic, logical and relational operators
• Use iterative type statements
• Use conditional statements
• Read/write text and binary files
• Manipulate text using regular expression
• Use and code functions
• Use built-in library functions
• Use arrays and hashes
• Create and use external PHP Code
• Install and Test MySQL
• Basic SQL Syntax
• Connect to a MySQL Database with Error Checking
• Use PHP to Interact with a MySQL Database
• Utilise PHP with the HTML Environment
• Work with Email and Cookies
• Consider Security Implications when using PHP and MySQL

PREREQUISITES

• Programming experience with another language would be beneficial and an appreciation of HTML would be an advantage.

Module - 1

PHP Language Basics

• Programming Basics
• PHP Tags
• Output Commands
• Using Files
• Include_path
• Opening files
• Reading files
• Writing to Files

PHP Variables

• Creating and Assigning Variables
• Assigning Values to Variables
• Type Conversion
• Variable Scoping
• Global Keyword
• Static Keyword
• Super Globals
• Constants
• Variable Variables
• Operators
• Assignment Operators
• Increment/Decrement Operators
• Arithmetic Operators
• String Operators
• Comparison Operators
• Logical Operators