PHP 5 and MySQL

Training

In Enfield

£ 250 + VAT

Description

  • Type

    Training

  • Location

    Enfield

  • Duration

    1 Day

This course is designed to enable web developers and others with limited programming experience to build dynamic web sites using the PHP programming language with a MySQL database. Since PHP is such a rich and task-specific language, the course covers the most important range of functions in depth, and equips delegates to understand all the essential aspects. Suitable for: Designers who want to advance their skills and develop data driven web sites. Developers that want to get to grips with php programming language and mysql databases.

Facilities

Location

Start date

Enfield (London)
See map
81 Southbury Road, EN1 1PJ

Start date

On request

About this course

Experience of programming in any other type of language, i.e.HTML, Java, Javascript, C/C++, VisualBasic, etc

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Teachers and trainers (1)

P  Rae

P Rae

Trainer

Course programme

PHP 5 and MySQL

Course Features:

Introduction to PHP

  • PHP tools and set up
  • Creating a basic PHP script
  • Server variables

Variables and Expressions in PHP

  • Identifiers (names for variables)
  • Data types (integers, floats,strings)
  • Creating variables
  • Variable assignment and scope
  • Constants

Operators

  • Arithmetic, Logical and Relational Operators
  • Assignment Operators

Conditional Tests and Events

  • If and else statement
  • The switch statement

Flow Control

  • The for loop
  • The while loop
  • The do… while loop
  • break and continue statements

Storing & retrieving data with Arrays

  • What are arrays?
  • How and when to use arrays
  • Indexed and Associative arrays
  • Multi-dimensional arrays
  • Loops with arrays
  • Predefined arrays

PHP Functions

  • What are functions?
  • Built-in functions
  • Declaring functions
  • Functions and arguments
  • The return keyword
  • Global and local scope
  • Variable function calls

Working with Strings

  • Prebuilt string functions
  • Regular Expressions
  • Escaping strings
  • echo vs print
  • printf and sprintf

Dates and Times

  • The date() function
  • The getdate() function
  • The mktime() function
  • Using timestamps

Session Management

  • What is a session?
  • Understanding session variables

Using Cookies with PHP

  • Cookie properties
  • Setting and retrieving cookies
  • Expiring/Deleting cookies

File and Directory Access

  • Include and require
  • Opening, reading and writing files

Handling Databases with PHP

  • PHP's database APIs
  • Error-handling strategies
  • Connection/disconnection
  • Common access functions
  • Simple SQL queries

Objects in PHP

  • Understanding Objects
  • The Class Definition
  • Class Inheritance
  • Constructors and destructors
  • __toString method
  • Getter and Setter functions
  • Accessing instance data and methods

Workshop

Creating a simple web application

Additional information

Students per class: 8

PHP 5 and MySQL

£ 250 + VAT