Speak to one
of our advisors
today

0845 686 2888

PHP 5 and MySQL

Duration: 2 days
Next Public Courses : TBC

In House Course: Call to arrange

Cost: £295 + VAT

1-to-1 price: £345.00 + vat per day

Times: 10am - 5pm

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.

Our Approach:

We keep our classes small so that there is a better learning experience and therefore there are always limited spaces available. Alternatively, we can train you at your site anywhere in the UK.
Train at your premises... Call us for further info.

Ring 0208 443 2888 or 0845 686 2888 and talk to one of our course advisors or email courses@futuretrend.co.uk
or complete our online enquiries form

Course outline:

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

 

Book now by calling 020 8443 2888 or complete the online enquiries form


Back to Top