Tel: 0844 844 2428

Training Courses

We continue to offer a popular range of computer training courses at Elstree Film Studios:

Web Site Design Courses / Web Development Courses / Print Courses

Web Marketing Courses / Search Engine Optimisation (SEO) Training Courses

Web Site Programming Courses

Web Site Management Courses

Video Editing Courses

Open Source Training Courses / Web CMS Courses / Blogging Courses

Film Production Courses / Scriptwriting Courses (in association with the Elstree Film School)


We are listed with

Elstree Film Studios - Training Courses - PHP and mySQL Programming Training Courses

Please note that this course has now been incorporated into our Database Training Course. If there are dates listed at the bottom of this page, they will relate to the new course.

PHP is a powerful server-side scripting language for creating dynamic and interactive websites. PHP is the widely-used, free, and efficient alternative to competitors such as Microsoft's ASP. PHP is perfectly suited for Web development and can be embedded directly into the HTML code. This course gives you an excellent grounding in how to harness the power of PHP and mySQL for web sites and database development applications.

This course is for developers, and designers wishing to add dynamic elements and PHP integration to their web projects. This would also be suited to those wishing to develop small web based applications and content management system. In order to get the most out of this course it is useful for candidates have at least intermediate skills in XHTML, CSS and code based page creation, basic Javascript and web hosting.

Location: 21st Century New Media Ltd (Production Offices), Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]

Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.

Courseware: The book which accompanies this course is posted to you upon payment confirmation.

Accommodation & Transport: Details of local accomodation and transport can be found here.

Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.

COURSE CONTENT

Introducing PHP

  • What is Dynamic content
  • Static vs Dynamic websites
  • Understanding Dynamic Page Elements
  • Server-side Scripting Explained
  • The Three Tier System
  • What is PHP
  • What is a Database
  • What is SQL
  • What is Apache
  • Why PHP/MySQL
  • Alternatives to PHP

PHP Technology Requirements

  • Web Hosting Explained
  • Previewing PHP files
  • Setting up MySQL databases
  • Setting up a Local Testing Server

PHP Basics

  • Basic Syntax
  • Variables in PHP
  • Outputting to a page
  • Concatenation in PHP
  • PHP Operators
  • Conditional Statements
  • Looping
  • Server Variables
  • PHP Header Function
  • PHP File Includes
  • Arrays and Array Manipulation
  • Functions

Forms & Email

  • Dealing with Forms
  • POST & GET
  • Processing Variables
  • Sending Mail with PHP
  • Formatting Mail and Error Control

Introduction to MySQL

  • Databases and Tables Explained
  • SQL DML (Data Manipulation)
  • SQL DDL (Data Definition)
  • SQL Queries Explained
  • Understanding and Using PhpMyAdmin

PHP & MySQL Together

  • Connecting to Your Database
  • SQL Queries in PHP

Project Planning, Preparation & Execution

  • Building a form driven database application
  • Effective Project Planning
  • Use Case Diagrams
  • Basic Content Architecture
  • Time To Make Our Own

File Handling

  • Reading from Files
  • Writing to Files
  • Creating Files
  • File Permissions explained
  • Dealing with Directories
  • Uploading to a server using PHP
  • PHP vs FTP/Java Applets
  • Image Uploads
  • Filtering File Parameters

Cookies, Sessions & Dates

  • What is a Cookie
  • Creating and using Cookies
  • What is a Session
  • Sessions vs Cookies
  • Session Variables and ID
  • Practical Usage Examples
  • Date and Time Functions
  • What is a UNIX Timestamp
  • Formatting Dates
  • Effective Storing of Dates

Practical Examples


At this point the course has a number of practical examples whose suitability will be assessed with regards to the applicants needs. Examples range from,
  • Basic Content Management Systems
  • Image Galleries
  • Video Galleries
  • Bulletin Boards
  • Login Systems
  • Custom Applications
  • Abstract Usage of PHP

Industry Relevance

  • Open Source CMS Systems (ModX, Wordpress, Drupal, Joomla, PHPBB etc)
  • Installing Open Source Software
  • Understanding and customizing Open Source Systems


5-20% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses.
Click here for more information on our discounts.

PHP and mySQL Programming Training Courses
Date Days Total (Excl VAT)  
July 2009
8/7/09 1 250
September 2009
2/9/09 1 250


Email Notifications
If you cannot make any of the dates above, you can also register with us to be notified when future courses in this subject are planned by filling in the following form.

First Name *
Last Name *
Email Address *



Clients

No joke ... but we have taught (in many cases, more than once) to all of these companies:

(Click here to see some testimonials as well)

* Accolade Publishing
* Accurate Solutions Ltd
* Ace4Training
* ACS-APT Computer Systems Ltd
* Active Silicon
* Active Solutions Europe Ltd
* Allied Manufacturing
* Amerex
* American Express Travel
* Antonmanor
* Arity Limited
* ArtiCAD Ltd
* Aston Taylor Ltd
* aura
* Autumn and May
* Award Learning Services Ltd
* Aztec Marketing
* BCIM London South Bank University
* BE Aerospace UK Ltd
* Bechtel
* Bechtel Ltd
* Biggerfish Design
* Bio-Rad Laboratories Ltd
* Bluefrog Ltd
* Boltblue
* Bond Hotel
* Bourne Leisure Ltd
* Bournemouth University
* BP
* BPP Learning Media
* Brasher Leisure Ltd T/A Sweatshop
* British Medical Journal
* Brunel University
* BskyB
* Building Research Establishment Ltd
* C&C Technology Consulting
* CADinteractive
* Cambridge ESOL
* Cannes Lions
* Casterbridge
* Castle Computing Services Ltd
* Chelsea Football Club
* Chroland Associates Ltd
* Church House Conference Centre Ltd
* CIMA
* City Interactive Media
* Claire Lobel Design
* CNET Networks UK Ltd
* Cognac Uk
* Comet Group
* Comic Relief
* Community Server Ltd
* Concep Group Limited
* Concern Worldwide
* Control Techniques
* Copenhagen International School
* Corporation of Lloyd`s
* Crystalblue Solutions
* Cultoon Television Limited
* Custom Carpentry
* Customer Interaction
* Czech Centre
* Dare Digital
* Data Lateral Limited
* David Richards Limited
* DBT
* Defaqto Ltd.
* dept of economics, maths & stats
* Discovery Communications Europe Ltd
* Discovery Communications Ltd
* DMG World Media
* Dog Store
* Donmar Warehouse
* DS & TE RAF Brampton
* Dubai College
* Dubai Heaven On Earth
* East and North Hertfordshire NHS Trust
* EDCTP-EEIG
* Enterprise Insight
* Europa Components
* Event Merchandising Ltd
* Families for Children
* FERN
* Findaplaceabroad.com
* FIRA International Ltd
* Firetoys Ltd
* FISU Meditation
* FL1 Solutions
* Flixmedia Limited
* FMC
* FMC Ltd
* FMC Partnership
* Foremost Curreny Group
* Fuss3 Solutions Ltd
* GE HEALTHCARE
* Giles & Posner Ltd
* Glint Facilities
* Global Beach
* Global Volume Marketing LLP
* Grass Roots Ltd
* H Bauer Publishing
* Harley Cosmetic Consultancy Ltd
* Harrow College
* Hasbro
* Hays
* Healthcare Education Services
* Hertfordshire County Council
* Hertfordshire Partnership NHS Foundation Trust
* Herts Sports Partnership
* Holland Park School
* HP Foods Ltd
* HWTMA
* I Want One Of Those.com
* i-2-k
* i2k Ltd
* Impact Marcom
* Indigo
* Inlightin Ltd
* Inspirational PR
* Inspired Gaming Group
* Interdirect Ltd
* International Greetings
* International University Link
* ISA Retail
* ITFC
* ITV
* J.A.Steel and Son Ltd
* James Eckhardt
* Jog Ltd
* John Fleming
* JollofTutors
* Jon Nash Photography
* JWT London
* Kent County Council
* kerbsideprophet.com
* Keziah Design Ltd
* Kier Islington
* Kiuki
* KLC School of Design
* Kuwait Petroleum International Ltd
* Lee Valley Regional Park Authority
* Lehmann Communications
* Lloyds
* London Borough of Southwark
* London Fertility Centre
* Loudspeaker/ Lateral Group
* Luton Sixth Form College
* Lynn Simpson
* M&G Investments
* Maconomy
* Maltings Academy
* Man Investments
* Man Investments AG
* Marcus Evans
* mbc
* MCS CREATIVE LTD
* Medina High School
* Merton College
* Metadigm
* Metropolitan Police
* MGPA
* Millbrook Beds Ltd
* Minerva Computer Services
* Mining Communications Ltd
* MOD, DASA(CS0)
* Modernisation Initiative
* Monarch Airlines
* Monks Walk School
* Mothercare
* Mothercare Uk Limited
* MSA GB Ltd
* Multilingualvacancies.com
* My Mustard
* Mystic Online Media
* National Children`s Bureau
* NATS c/o Business Training Partnership
* NCCHTA at University of Southampton
* Network Data Holdings PLC
* Nichols plc
* Nokia UK Ltd
* Norgren
* North Oxfordshire Academy
* North Yorkshire Police
* Norwich City Football Club
* Oakwood School
* Office Diner
* Office of Jean Lambert MEP
* OHL GROUP LIMITED
* Oil Technics Ltd
* OILspace
* OmniLedger Ltd
* onezerosix
* Orantez
* Otsuka Pharmaceutical Europe Ltd
* Out of the Blue Print Ltd
* OV Productions
* Owners Direct
* Oxford University Press
* P&O Ferries
* Partnerships for Schools
* PartyGaming Marketing (UK)
* Pentagon IT
* PETCHEY HOLDINGS PLC
* PFA Consulting
* Pfizer Limited
* Phoebe Stewart Marketing
* Powergen / E.ON
* Praxis Limited
* PreScript Communications Ltd
* Princes Trust
* Proactive UK Ltd
* Promega
* PruHealth
* Punchline Media & Events LTD
* R P Europe Limited
* R.A.G.S.
* Rainmaker Advertising Ltd
* RDS Networks Ltd
* Red Letter Days
* Reed Learning
* Reed`s School
* Research Now
* RNIB
* Rocketseed
* Ronly Holdings Ltd
* Rosabel Leo Burnett
* Rothamsted Research
* Royal Academy Of Music
* RP Europe
* Same World Ltd
* Same World Trading Ltd
* Sandwell and Birmingham Hospitals
* Saxon Industries
* SCP Designs
* Serco TTI
* Sesame
* Sesame Ltd
* Severndroog Castle Building Preservation Trust
* Shine Marketing UK Limited
* Silverfish Media
* Silverfish Production Ltd.
* Snap Surveys
* Something Graphic Ltd
* Sort IT.biz Ltd
* south kent college
* South West of England Regional Development Agency
* Southampton City Council
* Southampton Solent University
* SPAN
* Spring Fine Foods
* Squeeze Digital Ltd
* SR Media Ltd
* ST JOHN FISHER CATHOLIC HIGH SCHOOL
* St Matthew Academy
* Standout
* Stevenage 14-19 Partnership
* Stiefel Laboratories
* Stocklin Ltd
* Stoke-on-Trent City Council
* Style Coaching Institute
* Surrey Police
* Systex Ltd
* Tanzania Institute of Education
* Tectura UK
* Telmanage Limited
* Tesco
* The Camping and Caravanning Club
* The Deeping School
* The Grimsby Institute of Higher And Further Education
* The Mobile Music Company
* The Mobile Music Company Ltd
* The MotivAction Group plc
* The National Autistic Society
* the National Deaf Children`s Society
* The PD Group
* The Virtual Office Group
* The Works International
* TimePlan Education Group Ltd
* TimePlan Education Ltd
* TMN Media
* Toshiba
* Tourdesign Ltd
* Trust The Process
* Trust The Process Counselling
* TW Digital Media
* TW Podcasts
* Twyford C of E High School
* UK Association of National Park Authorities
* UNICEF UK
* Unilever
* United Utilities
* University of Hertfordshire
* University of Southampton
* URBAN PUMPKIN
* V2 Music Group
* VillaCentre Limited
* VINCI PLC
* Virgin Games
* Vocal Limited
* Vokera Limited
* waterwhileaway
* Web Editors Ltd
* West Herts College
* West Nottinghamshire College
* Weston Homes Plc
* Whisper Design Consultants
* X Games LTD
* Yamaha Electronics (UK) Ltd
* YouNique Photos
* Youth Sport Trust