• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

PHP Programming & MySQL for Web Development

30 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 31-Jul-2024
PHP Programming & MySQL for Web Development course and certification
214 Learners

About this Course

PHP Programming & MySQL for Web Development Course 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.
----------------------------------------------------------------------------------------------------------------------------------

Who will the Course Benefit?

UNIX and Windows Users, Web Developers and Programmers wishing to create web based systems utilising PHP and MySQL.
---------------------------------------------------------------------------------------------------------------------------------------

Course Objectives

On completion of the PHP Programming & MySQL for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MySQL database.
---------------------------------------------------------------------------------------------------------------------------------------
This is a PHP Programming & MySQL for Web Development course by Uplatz. 

PHP Programming & MySQL for Web Development

Course Details & Curriculum

PHP Programming & MySQL for Web Development Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: 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
  • Operators
  • Assignment Operators
  • Increment/Decrement Operators
  • Arithmetic Operators
  • String Operators
  • Comparison Operators
  • Logical Operators

Session 2: PHP VARIABLES AND ARRAYS

  • 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
  • Super Globals
  • Constants
  • Variable Variables
  • Creating/modifying indexed and associative arrays
  • Multi-Dimensional arrays
  • Using array functions
  • Sorting an array

PHP Programming & MySQL for Web Development Training Course

Session 3: CONTROL STRUCTURES

  • Statement Blocks
  • If Construct
  • Else Keyword
  • Elseif Keyword
  • Switch
  • Looping Constructs
  • While Loop
  • Do-while Loop
  • For Loop
  • Foreach Loop
  • Loop Control Words
  • Break
  • Continue

Session 4: PHP FUNCTIONS

  • Overview
  • Variable Scoping
  • Global Keyword
  • Static Keyword
  • Argument Passing by Value
  • Argument Passing by Reference
  • Returning Values
  • Including External PHP Functions
  • Conditionally Created Functions
  • Functions Created Inside Functions

Session 5: REGULAR EXPRESSIONS

  • Meta-Characters
  • Sequences
  • Sets
  • Pattern Matching with ereg and eregi
  • Pattern Matching with preg_match
  • Splitting Text – preg_split
  • Replacing Text – preg_replace

PHP Programming & MySQL for Web Development Training Course

Session 6: PHP OBJECT ORIENTED

  • PHP Object Orientated Concepts
  • Creating Classes and Objects
  • Constructor and Destructor functions
  • Inheritance
  • Access Modifiers

Session 7: PHP & PEAR

  • What is PEAR?
  • Command Line Package Installer
  • Fully-Automatic Installation
  • Semi-Automatic Installation
  • What is PECL?

Session 8: PHP & HTML

  • HTML/PHP Examples

PHP Programming & MySQL for Web Development Training Course

Session 9: PHP CONFIGURATION

  • Working with External Files
  • Error Reporting
  • Interacting with External Programs

Session 10: BASIC SQL STATEMENTS

  • Creating Databases and Tables
  • Inserting Data into Tables
  • Viewing Tables
  • UPDATE
  • Drop

Session 11: CONNECTING TO MySQL

  • mysqli_connect
  • mysqli_error
  • Die

Session 12: USING PHP TO PERFORM DATABASE FUNCTIONS

  • Inserting Data into a Database
  • Creating Queries
  • Executing Queries
  • Processing the Returned Query Data
  • Updating the Database

PHP Programming & MySQL for Web Development Training Course

Session 13: GENERATING HTML USING PHP

  • PHP Inside HTML
  • HTML Form with Embedded PHP
  • Multiple HTML Pages/Forms with PHP

Session 14: EMAIL AND COOKIES USING PHP

  • Generating Email using PHP
  • Generating Cookies using PHP
  • Using Cookies

Session 15: PHP AND DATABASE SECURITY

  • Designing Databases
  • Connecting to Database
  • Encrypted Storage Model
  • SQL Injection
  • Security Techniques
  • Error Reporting
  • User Submitted Data
----------------------------------------------------------

Didn't find what you are looking for?  Contact Us

course.php