We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course PHP Programming & MySQL for Web Development
  • Course Duration5 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.

Overview
The PHP Programming & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MYSQL database system and HTML.
Prerequisites
    • Have attended Introduction to MySQL or have equivalent knowledge
    • Familiarisation with programming concepts is useful, this knowledge can be obtained by attendance on the Concepts of Programming course
Objectives
    • Demonstrate a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database
Target Audience
    • This course would benefit UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.
Skills Gained
    • Declare variables and initialise them
    • Construct expressions with arithmetic, logical and relational operators
    • Use iterative type statements
    • Use conditional statements
    • Read/write text and binary files
    • Manipulate text using regular expression
    • Use and code functions
    • Use built-in library functions
    • Use arrays and hashes
    • Create and use external PHP Code
    • PHP Configuration
    • Basic SQL Syntax
    • Connect to a MySQL Database with Error Checking
    • Use PHP to Interact with a MySQL Database
    • Utilise PHP with the HTML Environment
    • Work with Email and Cookies
    • Consider Security Implications when using PHP and MySQL
What's included
    • For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
    • Comprehensive course materials and exercises
Course Content
    • HISTORY OF PHP
      Installing PHP

      General Requirements

      UNIX based Systems

      Windows based Systems

      Integrated Development Environment (IDE)
    • PHP LANGUAGE BASICS
      Programming Basics

      Comment markers

      PHP Tags

      Output Commands

      Using STDIN STDOUT and STDERR

      Using Files

      Include_path

      Opening files

      Reading files

      Writing to Files

      RTRIM
    • PHP VARIABLES
      Naming Rules

      Data Types

      Numerical

      Integer

      Floating Point Numbers

      Floating Point Precision

      Single Quoted Strings

      Double Quoted Strings

      Creating and Assigning Variables

      Assigning Values to Variables

      Type Conversion

      Variable Scoping

      Global Keyword

      Static Keyword

      Super Globals

      Constants

      Variable Variables

      Operators

      Assignment Operators

      Increment/Decrement Operators

      Arithmetic Operators

      String Operators

      Comparison Operators

      Logical Operators
    • CONTROL STRUCTURES
      Statement Blocks

      If Construct

      Else Keyword

      Elseif Keyword

      Looping Constructs

      While Loop

      Do-while Loop

      For Loop

      Foreach Loop

      Loop Control Words

      Break

      Continue
    • REGULAR EXPRESSIONS
      Meta-Characters

      Backslash

      Unicode Character Properties

      Circumflex and Dollar

      Full Stop

      Square Brackets

      Vertical Bar

      Multipliers

      Subpatterns

      Repetition

      Pattern Matching with ereg and eregi

      Pattern Matching with preg_match

      Splitting Text

      Switch
    • PHP ARRAYS
      Syntax

      Creating/Modifying with Square-Bracket Syntax

      Array Functions

      Pitfalls when using Arrays

      Using a Return value as a Key

      Converting to Array

      Sorting an Array

      Multi-Dimensional Arrays

      Example

      Creating a new Multi-Dimensional Array
    • PHP FUNCTIONS
      Conditionally Created Functions

      Functions Created Inside Functions

      Argument Passing by Value

      Argument Passing by Reference

      Returning Values

      Including External PHP Functions
    • PHP OBJECT ORIENTED
      Classes and Inheritance

      Classes

      Inheritance

      Keywords
    • PHP & PEAR
      What is PEAR?

      Command Line Package Installer

      Fully-Automatic Installation

      Semi-Automatic Installation

      What is PECL
    • PHP & HTML
      HTML/PHP Examples
    • PHP CONFIGURATION
      Working with External Files

      Error Reporting

      Interacting with External Programs
    • BASIC SQL STATEMENTS
      Creating Databases and Tables

      Inserting Data into Tables

      Viewing Tables

      UPDATE

      Drop
    • CONNECTING TO MySQL
      mysqli_connect

      mysqli_error

      Die
    • USING PHP TO PERFORM DATABASE FUNCTIONS
      Inserting Data into a Database

      Creating Queries

      Executing Queries

      Processing the Returned Query Data

      Updating the Database
    • GENERATING HTML USING PHP
      PHP Inside HTML

      HTML Form with Embedded PHP

      Multiple HTML Pages/Forms with PHP
    • EMAIL AND COOKIES USING PHP
      Generating Email using PHP

      Generating Cookies using PHP

      Using Cookies
    • PHP AND DATABASE SECURITY
      Designing Databases

      Connecting to Database

      Encrypted Storage Model

      SQL Injection

      Security Techniques

      Error Reporting

      User Submitted Data

 

Course Dates Please contact us to discuss dates for this course, thank you

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Aug 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields