Dreamweaver course in north London

PHP & MySQL Training

Do you currently develop static websites, i.e using HTML and CSS only? Are you looking for your next challenge: to produce dynamic web content through data driven pages, using PHP & MySQL?

Have you used other people's PHP scripts before but not fully understood how and why they do what they do?
This hands-on PHP/MySQL Training course is designed to get you started and introduce you to features that will enable you to build powerful database-driven web applications.
Rather than use expensive development tools,we show you how to make use of free open-source tools (such as WAMP, Xampp, notepad++) allowing you to 'develop on a shoestring' following the course.

PHP has gained a massive following among non-technical web designers who need to add interactive aspects to their sites. Offering a gentle learning curve, PHP is an accessible yet powerful language for creating dynamic web pages.

PHP is a language which was designed with web in mind. It is a web-specialized language.
It is ubiquitous - you can deploy your php applications anywhere on the web and they will run.
With the availability of vast documentation, libraries, frameworks, and online community support PHP is a must-learn programming language for the web development enthusiast..

Web enthusiasts who need to develop dynamic web content through data driven pages, using PHP. Experienced users will also benefit from the many tips and tricks, and special exercises.

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

Course outline

Session One
Introduction to PHP and Open Source
  • PHP tools and set up (install and configure WAMP, XAMPP)
  • 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
Working with Strings
  • Prebuilt string functions
  • Regular Expressions
  • Escaping strings
  • echo vs print
  • printf and sprintf
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 statementss
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
Dates and Times
  • The date() function
  • The getdate() function
  • The mktime() function
  • Using timestamps
Session 2
 
Dates and Times (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 MySQL Databases with PHP
  • Simple Database Connectivity
  • Database design and manipulation by
phpMyAdmin
  • Integrating PHP+MySQL using web forms
  • Use of $_GET super-global
  • Use of $_POST super-global
  • Validating forms using PHP
  • Use of mail() function
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
 

Class time is 10:00 a.m.- 4:30/5:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

We recommend the following courses that relate to this class:HTML & CSS WordPress , HTML 5 & PHP & MySQL Intermediate

Course Duration 2 Days
Course Price £250
Scheduled Dates Please call us on 02084432888 to arrange dates
Course Times 10:00 till 16:30

If you can't come to us we can come to you! This course is available as individual 1:1 tuition or small groups at your office as well as at our centre. Please click here for more information.