Two-Day PHP-MySQL Course

You will learn:.

Day 1:

• What is PHP
• Static vs. Dynamic Web Pages
• Static Web Page
• Dynamic Web Page
• PHP runs on the server side
• Advantages of PHP
• Similar Technology
• Test and run PHP in Windows 2000 or XP
• Install IIS in Windows XP
• Installation of PHP in Windows XP
• Writing PHP
• Using Canonical tags
• Using Short-open tags
• Using HTML script tags
• Comment in PHP
• Print Text
• Variables
• Different Variable types
• Arithmetic Operators
• Assignment Operators
• Comparison Operators
• IF Statements
• The WHILE Loop
• Control Structure - for loop
• For loop (Using empty expressions)
• For loop (All in one line)
• For loop - using the alternate colon syntax
• Constants
• Differences between constants and variables
• Predefined constants
• Using (condition)? $expression2 : $expression
• Single quoted string
• Double-quoted String
• String concatenation
• String functions
• Arrays
• Using Arrays with Numeric Keys
• Using Arrays with Numeric Keys (Store values of String type)
• Using Arrays with Numeric Keys (Store values of Mixed Types)
• Associative arrays
• Using foreach
• Array Functions and Predefined Constants
• A form and its action page
• Print Format
• Using Date and Time
• CGI environment variables
• Define your own function
• Function with input parameter
• PHP Built-in functions
• Mathematics in php
• Some Predefined Math Constants and Built-in Math Functions

Day 2:

• What is mysql
• What is sql
• Overview of mysql database management system
• Why mysql database server?
• The technical features of mysql server
• Download and installation of mysql in windows
• Use of the mysql client program
• Connecting to and disconnecting from the server
• Prompts and their meaning
• Adding new records in a table
• Data type of fields
• Primary keys
• Timestamp
• Constraint not null and default values
• Sql queries
• Using parentheses to form complex expressions
• Sql update
• Delete rows in a table 
• Using in and not in 
• Create table
• Table constraints 
• Sql built-in functions
• Functions related to date and time
• Using table and field aliases
• Working with more than one tables
• Using joins
• Left join
• Right join
• Unions
• Database access
• Start and run mysql server in Windows 2000 or XP
• Database access using PHP
• Insert records in a database 
• Mysql administration 
• Create a php file to list out all the records, each record with a link to update and a checkbox to delete
• Create the page to list the record for user to edit  
• Create the action page to update 
• Create a page to list the record to delete 
• Create an action file to delete the record 
• Create a page for a user to add record  
• Create the action file to add record

Date: Wednesday 8 September and Thursday 9 September 2010

Cost: $660 (Australian dollars) including morning tea, lunch, afternoon tea, notes and lots of hands on exercises

Time: 9 am - 5pm

Place: 600 Collins Street or at a place close to the Monash freeway about 25 minutes drive from Melbourne city in Australia

Enquiries or Enrolment:

Email: melbourne@expert.com.hk

We also offer on-site training courses at your place anywhere in Australia, email to us for details: melbourne@expert.com.hk