PHP Programming & MySQL for Web Development

Summary
p
Length: 5 days
Price: 1,395 GBP excl. VAT
Training Provider: StayAhead Training plus
Location: Edinburgh, London
Training Method: Open / Scheduled
Startdate:
Edinburgh: 18/06/2012 09:30
London: 11/06/2012 09:30, 30/07/2012 09:30, 17/09/2012 09:30
StayAhead Training

PHP Programming & MySQL for Web Development

PHP Programming & MySQL for Web Development Course Overview

The PHP Programming & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MYSQL database system and HTML.

Skills Gained

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
Who will the Course Benefit?

UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.

Course Objectives

On completion of the PHP Programming & MySQL for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database.

Requirements

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

Follow-On Courses
  • Apache Web Server
  • Introduction to MySQL
  • Perl Programming

NOTE: Course technical content is subject to change without notice.

PHP Programming & MySQL for Web Development Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions
Session 1: HISTORY OF PHP
  • Installing PHP
  • General Requirements
  • UNIX based Systems
  • Windows based Systems
  • Integrated Development Environment (IDE)
Session 2: PHP LANGUAGE BASICS
  • Programming Basics
  • Comment markers
  • PHP Tags
  • Output Commands
  • Using STDIN STDOUT and STDERR
  • Using Files
  • Include_path
  • Opening files
  • Reading files
  • Writing to Files
  • RTRIM
Session 3: PHP VARIABLES
  • Naming Rules
  • Data Types
  • Numerical
  • Integer
  • Floating Point Numbers
  • Floating Point Precision
  • Single Quoted Strings
  • Double Quoted Strings
  • 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
PHP Programming & MySQL for Web Development Training Course
Course Contents - DAY 2
Session 4: CONTROL STRUCTURES
  • Statement Blocks
  • If Construct
  • Else Keyword
  • Elseif Keyword
  • Looping Constructs
  • While Loop
  • Do-while Loop
  • For Loop
  • Foreach Loop
  • Loop Control Words
  • Break
  • Continue
Session 5: REGULAR EXPRESSIONS
  • Meta-Characters
  • Backslash
  • Unicode Character Properties
  • Circumflex and Dollar
  • Full Stop
  • Square Brackets
  • Vertical Bar
  • Multipliers
  • Subpatterns
  • Repetition
  • Pattern Matching with ereg and eregi
  • Pattern Matching with preg_match
  • Splitting Text
  • Switch
Session 6: PHP ARRAYS
  • Syntax
  • Creating/Modifying with Square-Bracket Syntax
  • Array Functions
  • Pitfalls when using Arrays
  • Using a Return value as a Key
  • Converting to Array
  • Sorting an Array
  • Multi-Dimensional Arrays
  • Example
  • Creating a new Multi-Dimensional Array
PHP Programming & MySQL for Web Development Training Course
Course Contents - DAY 3
Session 7: PHP FUNCTIONS
  • Conditionally Created Functions
  • Functions Created Inside Functions
  • Argument Passing by Value
  • Argument Passing by Reference
  • Returning Values
  • Including External PHP Functions
Session 8: PHP OBJECT ORIENTED
  • Classes and Inheritance
  • Classes
  • Inheritance
  • Keywords
Session 9: PHP & PEAR
  • What is PEAR?
  • Command Line Package Installer
  • Fully-Automatic Installation
  • Semi-Automatic Installation
  • What is PECL
Session 10: PHP & HTML
  • HTML/PHP Examples
PHP Programming & MySQL for Web Development Training Course
Course Contents - DAY 4
Session 11: MySQL
  • Installing MySQL
  • Testing MySQL
Session 12: BASIC SQL STATEMENTS
  • Creating Databases and Tables
  • Inserting Data into Tables
  • Viewing Tables
  • UPDATE
  • Drop
Session 13: CONNECTING TO MySQL
  • mysql_connect
  • mysql_error
  • mysql_select_db
  • Die
Session 14: USING PHP TO PERFORM DATABASE FUNCTIONS
  • Inserting Data into a Database
  • Creating Queries
  • Executing Queries
  • Processing the Returned Query Data
  • Updating the Database
PHP Programming & MySQL for Web Development Training Course
Course Contents - DAY 5
Session 15: GENERATING HTML USING PHP
  • PHP Inside HTML
  • HTML Form with Embedded PHP
  • Multiple HTML Pages/Forms with PHP
Session 16: EMAIL AND COOKIES USING PHP
  • Generating Email using PHP
  • Generating Cookies using PHP
  • Using Cookies
Session 17: PHP AND DATABASE SECURITY
  • Designing Databases
  • Connecting to Database
  • Encrypted Storage Model
  • SQL Injection
  • Security Techniques
  • Error Reporting
  • User Submitted Data



If you want to find out more about PHP Programming & MySQL for Web Development, you can make an information request below and the school will contact you with further information.

Expenses

£1,395.00

StayAhead Training

technical it training

StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

unix, linux, oracle, sql, javaSpecialist IT training for professionals

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.

UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

In-house Professional IT training for your organisation

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

Request Information here to learn more about StayAhead Training and how their professional IT training courses can help you Request Information here to learn more about StayAhead Training and how their professional IT training courses can help you

specialist it training


plusShow all courses with StayAhead Training

Request information - obligation free

To request information from PHP Programming & MySQL for Web Development, please fill out the following details:

* =  Required field
Errors
*
*
*
*
*
*
» What happens now?
This field is used for controlling automatic form submits. Please leave it blank:

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: +44 (0)20 7600 6116
www.stayahead.com

Contact StayAhead Training
More Information
 
Request Information

To request information from PHP Programming & MySQL for Web Development, please fill out the following details:

This field is used for controlling automatic form submits. Please leave it blank:
» What happens now?
Reviews
Write a review!
Need help finding the right course?
  
By submitting your e-mail, you become a member of Trainingforit.co.uk
Please fill out all required fields

Please fill out all required fields