Categories: MySQL ,  PHP

FastTrack to PHP / MySQL

Highlander's FastTrack to PHP / MySQL training course combines the 3 day instructor led FastTrack to PHP / MySQL class, with 6 months access to our Learning Management System (LMS) including course slides and demos, discussion forums, extensive PHP & MySQL glossary, additional exercises and samples, and other online learning support.

The 3 day classroom course is run monthly at our London centre or available at your own location, and is a great way to get up to speed on using the PHP Language on top of the MySQL database. The course is suitable for anybody new to PHP and MySQL, and whilst you may find it useful to attend our DreamWeaver CS3 Website Development course first is is not neccessary for attending the course.

Classroom Course Overview
Introduction to PHP
- Why choose PHP/MySQL/Apache
- PHP's purpose and capabilities
- Server Side vs. Client Side Scripting
- What PHP looks like – Basic structure
- Setting your development environment up with your testing server
- Testing PHP installations in your server
- Which servers can use php
- Where to write the php code and using which applications

Language Basics
- Structure and Syntax
- Data Types in PHP
- Using Variables and Constants
- Processing data using operators
- Understanding Arrays
- Working with combinations of Data Types, Variables and Arrays

Arrays
- Array types
- Multi-dimensional arrays
- Getting data out of arrays
- Array operations
- addition
- comparing
- Counting
- Searching
- Flipping/Reversing
- Deleting elements within an array

More Arrays
- Sorting arrays
- sort
- asort
- ksort
- natsort
- shuffle
- key sort
- Stacks and Queues
- push/pop
- shift/unshift
- Sets
- array_diff
- array_intersect

Strings
- Escape sequences
- Variables and string combined
- Escaping literal values
- Length
- translation
- comparison
- searching
- matching
- search and replace

Giving your code life – Control Structures
- Conditional decision making – if, else, and elseif
- True, false, and evaluation of expressions
- Multiple and nested conditions
- Short Circuit Evaluation – break and continue
- The ‘?’ Operator
- Decision making using the switch statement
- Iterations using while, do...while, for and for each loops
- Iterating through an array
- Terminating code using exit, return, and die

Creating Dynamic Web Content
- Embedding PHP in Web pages
- Retrieving user input through forms, using the GET and POST method
- Handling the date and time
- Dynamically including code using include and require
- mail and php
- Cookies

Using PHP's built-in functions
- Mathematical functions
- Generating random numbers

Creating custom functions
- Why write your own functions
- Syntax for defining a function
- Variable scope, and the global statement
- Adding in function parameters
- Return values from functions

Objects and Classes
- Basic OOP
- Constructors/Destructors
- Visibility & Scope
- Static
- Constants

Introduction to Databases
- Why use a database – The three-tier architecture approach
- Introducing MySQL and PHPMyAdmin
- Understanding the database structure
- Creating a simple database
- Basic SQL commands

Making PHP and MySQL work for each other
- Connecting to the database
- Displaying database content through PHP
- Inserting and deleting data into the Database
- Updating data in the Database
- Security considerations