Microsoft Package CCNA Package CCIE Hardware and Networking CCNA and MCSA Linux and CCNA Web and Android MCSA Special Linux and MCSA CCNP Arduino 14 Th Anniversary Cisco CEH Linux Magento


Course Name Schedule Duration Fee
PHP-MySQL 2017-12-02(Saturdayat09.00am-05.30pm) 45 hrs 18,000/-

PHP and MySQL Training

This PHP and MySQL course will provide you with the skills and knowledge necessary to create dynamic database-driven websites / online applications using PHP and MySQL


Unit 1: Setting Up the PHP Development Environment

  • Introduction to Apache, MySQL, and PHP
  • Stable/Production vs. Development Releases
  • Understanding how PHP Works
  • Server-Side vs. Client-Side Scripting
  • Installing PHP, Apache, and MySQL 

Unit 2: Understanding PHP: Language Basics

  • Embedding PHP Scripts
  • Output data to a browser

  1. Using the print() statement
  2. Working with the echo() statement
  3. Using the printf() statement
  4. sing The sprintf() statement

  • Commenting your PHP Code
  • Creating variables and setting data types
  • Storing data in variables

  1. Creating variables and setting data types
  2. Creating and storing string variables (Text)
  3. Working with Integers (Whole Numbers)
  4. Understanding Floating point numbers (Decimals)
  5. Creating and working with Boolean values

  • Types of operators

  1. Utilizing Arithmetic Operators
  2. Utilizing Arithmetic Assignment Operators
  3. Utilizing Comparison Operators
  4. Utilizing Error Control Operators
  5. Utilizing Incrementing/Decrementing Operators
  6. Utilizing Logical Operators
  7. Understanding String 
  8. perators

Unit 3: PHP Control Structures

  1. If Statement
  2. Else Statement
  3. Elseif  Statement
  4. Switch Statement
  5. While Statement
  6. Do.. While Statement
  7. For Statement
  8. Foreach Statement
  9. Break Statement
  10. Continue Statement


Unit 4: PHP Arrays
  •      Enumerated Arrays
  •      Initializing Arrays
  •      Appending to an Array
  •      Reading from Arrays
  •      Looping through Arrays
  •      Associative Arrays
  •      Initializing Associative Arrays
  •      Reading from Associative Arrays
  •      Looping through Associative Arrays
  •      Superglobal Arrays
  •     Two-dimensional Arrays
  •      Reading from Two-dimensional Arrays
  •      Looping through Two-dimensional Arrays
  •      Array Manipulation Functions

Unit 5 : Handling Html Form with Php

  • Capturing Form data 
  • Understanding Form elements
  • Dealing with multi-value filed
  • Generating File uploaded form 
  • Redirecting a form after submission 
  • PHP Form Validation
  • PHP Form URL/E-mail

Unit 6 : Passing Information with PHP

  •      Superglobal Arrays
  •      Understanding variable scope
  •      $GLOBALS
  •      $_SERVER
  •      $_GET
  •      Retrieving URL variables
  •      $_POST
  •      $_REQUEST
  •      $_FILES
  •      $_SESSION
  •      Implementing session_destroy()
  •      $_COOKIE

Unit 7 : Working with file and Directories

  • Understanding file & directory 
  • Opening and closing a file 
  • Coping, renaming and deleting a file 
  • working with directories
  • File Uploading & Downloading 

Unit 8 : Reusing Code and Writing Functions

  • Including Files
  • Require / Require_once
  • User Functions
  • Defining and calling Functions
  • Default Values
  • Variable Scope
  • By Reference vs. By Value

Unit 9 : OOPS

  • Introduction 
  • Objects
  • Declaring a class
  • The new keyword and constructor
  • Destructor
  • Access method and properties using $this variable 
  • Public ,private, protected properties and methods
  • Static properties and method
  • Class constant
  • Inheritance & code reusability
  • Polymorphism
  • Parent:: & self:: keyword
  • Abstract method and class
  • Interface
  • Final 

Unit 10 : Debugging and Error Handling

  •          General Error Types when Debugging
  •          Displaying PHP Errors
  •          Adjusting PHP Error Reporting
  •          Creating a Custom Error Handler
  •          Logging Errors in PHP
  •          Debugging Techniques in PHP

Unit 11 : Intro to MySQL and SQL

  • Setting Column Types
  • Setting Column Properties
  • Working with the MySQL Client
  • Creating a Database
  • Creating Tables
  • Inserting Records
  • Selecting data using SELECT Statement
  • Using conditionals in SQL
  • LIKE and NOT LIKE with Wildcards
  • Sorting the results of a Query
  • Filtering Query results
  • Updating data
  • Deleting data
  • Using Functions in Queries

Unit 12 : Advanced SQL in MySQL

  • Relational Database Design
  • Performing Joins in Queries
  • Grouping Results
  • Creating Indexes in MySQL
  • Utilizing Different Table Types 
Duration : 45 hrs
Fee          : 18,000/-

PHP and MySQL Training


Privacy | Contact Us | Trade Marks
Copyright © Winsys Networks All right reserved 2003 - 2017
Web solution by winsys.lk