PHP and MySQL

Basic computer literacy

Who should attend?

This course is designed for delegates with knowledge of HTML and some programming experience. No knowledge of PHP and databases is required.

DAY 1

Introduction

• Introduction to dynamic web sites
• What is PHP?
• Installing a web server
• Installing PHP,MySQL and PhpMyAdmin

Using PhpMyAdmin

• Understanding Database Basics
• Setting up your MySQL database
• Using SQL in MySQL

MySQL data types
Basic SQL syntax elements
MySQL built-in functions

Sample Database

• Building simple relational tables

DAY 2

Site Set up

• Set up your site folder
• Your first PHP script

Introduction to PHP

• PHP basics
• Working with PHP variables & data type
• Handling information from users.

PHP Programming

• PHP Operators and Comparators
• PHP Conditionals
• PHP Loops
• Writing PHP Functions
• Arrays

Understanding Dynamic Issues 

• Understanding HTTP Statelessness
• Using Forms
• Using URL parameters
• Introduction to Sessions and Cookies
• Using Server Side includes (SSI)

DAY 3

Building simple Dynamic pages

• Setting up the Project Template
• Connecting PHP with MySQL
• Reading data from a MySQL
• Using an SSI file with the connection details
• Creating a home page
• Creating an Employee List page
• Creating a Log In page
• Login Failed and Login Success
• Securing your pages

All courses authorised by Adobe and delivered by Adobe certified trainers.

Symbiosis offer a range of standard and bespoke courses for individuals and companies from our Authorised Adobe Training Centres located throughout the UK. Three training options are available

• Public Courses: Our authorised Adobe courses are run from our training centres in Bristol, Leamington Spa, Leeds, London or Manchester
• Bespoke Courses: In addition to our listed Bespoke Courses, any of our Essentials or Advanced Courses can be tailored to meet your specific needs and run as a bespoke course. Please call for pricing
• Venue of your Choice: If preferred, a Symbiosis trainer can deliver our Adobe InDesign course at a venue of your choice using either your computers or our own mobile solution. Travel and expenses will be charged as extra. Please call for pricing. 

As part of your training package you will receive:

• Training from an Adobe Certified instructor at an authorised Adobe Training Centre
• A course manual 
• Refreshments throughout the day 
• 6 month post-training email and telephone support from your trainer
• A certificate upon completion of the course  

Symbiosis: authorised Adobe and Apple training courses

Since 1996 Symbiosis have been delivering authorised Adobe and Apple training courses  in the Midlands, Leeds, Manchester, Bristol and London areas.  

At Symbiosis the training is based on a wealth of ‘real-world’ experience and our aim is to provide appropriate, professional training in the use of the leading creative software packages - whether for print, interactive media, the web, video or mobile applications. Whether you are an individual or a company, Symbiosis's authorised status guarantees the quality of their training facilities and ensures you have access to qualified trainers, new computers, legal software, approved training materials and the provision of snacks and drinks.

Our aim - to provide great training at a competitive price from central locations, in the following areas:

            • Adobe Authorised Training Centre
            • Apple Authorized Training Center
            • Edexcel Approved
            • Filemaker Business Alliance Member
            • Quark Alliance Partner
            • Skillset Approved

Symbiosis - Look our Way... 

Whatever kind of training you are looking to achieve we can help you find your way, our accredited status can provide in-house team training to help you improve your working practice. We take pride in our authorised status and prior to accepting a booking, we take the time to check that a course is appropriate to your skill level and requirements.

Our commitment to quality means that we guarantee the following:

• Authorised Courses are limited to a maximum of 8 delegates
• All training is delivered by authorised instructors 
• All training is delivered using the most recent version of the software available (unless stated)
• Training is available on the Mac or PC platform
• Prices include a training manual

Click here to request information and learn more about Symbiosis