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, 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.
Software Versions: All of our Adobe courses include lessons generic to both CS3 and CS4 versions of the Adobe suite: whichever version you use is covered in detail. In addition, we also now preview the functionality of the new Adobe CS5 suite. Our Apple training courses utilise the latest versions of Final Cut Studio HD (also known of as version 3 or FCS 2009).
Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.
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
