Certificate Course on: PHP Programming / MySQL 1500

  • Duration: 30 Hours

  • Per Day: 1-2 Hours
PHP Programming / MySQL

The Training session will be live *Recorded lectures will be available

The live trainer-led PHP training course is to train on Website Development and is the most popular server-side language used to build dynamic websites, and though it is a very robust language. Learn PHP & MySQL web development from Live Trainer by understanding PHP functions and create your very own Websites & projects using PHP & MySQL.

Week Duration Topic Contents
Week 1 1-2 Hours Introduction to PHP
  • Evaluation of PHP
  • Hardware and Software requirements
  • XAMPP server Installation
  • Basic Syntax
  • Defining variable and constant
  • Php Data type
  • Operator and Expression
Week 1 1-2 Hours Control Structure
  • If, If-else Statements
  • Comparison and Logical Operators
  • Switch Statements
  • While Loop
  • For Loop
  • Foreach Loop
Week 1 1-2 Hours Function
  • What is a function
  • Define a function
  • Returning value from function
  • User-defined functions
  • Dynamic function calls
  • Variable scope
  • Call by value and Call by reference
  • Recursive function
Week 1 1-2 Hours Array and Multidimensional Array
  • Anatomy of an Array
  • Creating index based and Associative array
  • Accessing array Element
  • Looping with Index based array
  • Looping with associative array using each() and foreach()
  • Some useful Library function
Week 1 1-2 Hours String Manipulation
  • Formatting String for Presentation
  • Formatting String for Storage
  • Joining and Splitting String
  • Comparing String
  • Matching and replace Substring
Week 2 1-2 Hours Working With The File System
  • Creating and deleting a file
  • Reading and writing text files
  • Working with directories in PHP
  • Checking for existence of file
  • Determining file size
  • Opening a file for writing, reading, or appending
  • Writing Data to the file
  • Reading characters
Week 2 1-2 Hours JavaScript (Jquery)
  • Introduction to JavaScript
  • Form validation using JavaScript
  • Email validation using JavaScript
  • Jquery
Week 2 1-2 Hours Form Processing
  • Get and Post Method
  • $_GET and $_POST Array
  • $_REQUEST Array
  • Form Validation
  • File Uploading
  • File Downloading
Week 2 1-2 Hours Mini Project Designing Website / Form with validation based on a project topic
Week 2 1-2 Hours Database Connectivity with MySql - Part I
  • Introduction to RDBMS
  • Introduction to SQL
  • Connecting to the MYSQL
  • Selecting a database
  • Adding data to a table
  • Displaying returned data on Web pages
  • Finding the number of rows
  • Looping through database
  • Inserting data
  • Deleting data
Week 2 1-2 Hours Database Connectivity with MySql-Part II
  • Entering and updating data
  • Executing multiple queries
  • Understanding Primary and Foreign Keys
  • Performing basic database operation(DML) (Insert, Delete, Update, Select)
  • Setting query parameter
  • Executing query
  • Join (Cross joins, Inner joins, Outer Joins, Self joins.)
Week 2 1-2 Hours Cookies
  • What is a Cookie?
  • Setting time in a cookie with PHP
  • Deleting a cookie
  • Creating session cookie
  • Working with the query string
Week 2 1-2 Hours Session
  • What is session?
  • Starting a session
  • Registering Session variables
  • working with session variables
  • destroying session
  • passing session Ids
  • encoding and decoding session variables
  • How to increase session expire time
  • How to work session without cookie?
Week 2 1-2 Hours PHP Project
  • Project Discussion
  • Requirements analysis of Project
  • Developing Project using PHP and MySql