PHP MySQL Training Course Guwahati

PHP & MySQL Training Course

Total Classes Required: 36
Normal Duration: 3 month (3days a week)
Fast Track: 2 month (4days a week)
Eligibility: B.E/B.Tech, MCA, B.Sc-IT ( prior programming experience is expected )
Prerequisites: HTML/CSS

PHP MySQL Training Objectives

PHP is the general purpose Scripting language that is especially suited for web development to produce dynamic web pages and can be embedded into HTML. PHP originally called as Personal Home Page, but now it is called as Hypertext preprocessor. MySQL is a database server, free open source project ideal for both small to large applications and supports standard SQL. PHP enabled web pages are treated just like a regular HTML pages so you can create and edit them the same way you normally create regular HTML pages with proper PHP tags.

This course will take you through all the essentials concepts and usages you need to know to use PHP & MySQL in an effective professional way for creating an incredible dynamic web site. In this course we will also show you the advance concept fully explaining and working with PHP object oriented programming approach to handle complex web base application. Thus this course will also set you in confidence and comfortable in working and customizing with popular open source cms applications like – Drupal, Joomla etc as well as Zend Frame Work

PHP MySQL Training Course Outline

Understanding the Fundamentals

• Introduction to PHP / MySQL and Apache fundamentals
• Server preparation, setup and configuring PHP, MySQL and Apache environment
• Discussing various text editor and about syntax highlighter
• Introducing phpMyAdmin
• Viewing PHP configuration information
• Our first PHP program – “Hello World!”
• Introduction to Nesting concept

Exploring Data Types

• Variables
• Strings
• String functions
• Numbers: Integers, Floating points
• Arrays
• Array functions
• Booleans and NULL
• Type switching and casting
• Constants

Control Structures and Logical Expressions

• If statements
• Else and elseif statements
• Logical operators
• Switch statements

Exploring Loops

• While loops
• For loops
• Foreach loops
• Continue
• Break
• Understanding array pointers

Elements of PHP – Review

• PHP variables and arrays Control flow
• Understanding $_GET, $_POST, $_SESSION and other PHP super global
• Maintaining page state – Session Vs. Cookies
• Patterns for processing HTML forms

Functions

• Introduction to PHP functions
• Discussing and work with Native functions
• Examples with numbers, strings and dates
• string functions Vs. regular expressions

User-Defined Functions

• Defining functions and concept of arguments
• Using functions comfortably
• Returning values from a function
• Variables scope – Local Vs. Global
• Setting default values
• Parameters: Passing ‘by value’ Vs. ‘by reference’

Working in depth with Strings

• Quoting String Constants
• Printing Strings
• Accessing Individual Characters
• Cleaning Strings
• Encoding and Escaping
• Comparing Strings
• Manipulating and Searching Strings
• Regular Expressions

Working in depth with Arrays

• Array types – Indexed Vs. Associative
• Identifying Elements of an Array
• Storing and Retrieving Data in Arrays
• Multidimensional Arrays
• Nested Array
• Extracting Multiple Values
• Converting Between Arrays and Variables
• Traversing and Sorting Arrays
• Usages of Arrays

Building PHP Pages

• Links and URLs
• Using GET values
• Encoding GET values
• Encoding for HTML
• Building forms
• Setting cookies
• Establishing sessions
• Headers and page redirection
• Including and requiring pages

MySQL Fundamentals

• MySQL introduction
• Creating a database in MySQL
• Populating a MySQL database
• Working with phpMyAdmin
• Connecting to MySQL with PHP
• Understanding the CRUD operation
• Accessing data in MySQL with PHP

Introducing PHP 5.x Object-Oriented Programming (OOP)

• Introducing the concept and basics of OOP
• Defining classes, methods and properties
• Public Vs. Private properties
• Instantiating a class
• Referencing an instance

OOP in Practice

• Understanding class inheritance
• Setting access modifiers
• Using setters and getters
• Working with the static modifier
• Reviewing the scope resolution operator
• Referencing the Parent class
• Using constructors and destructors
• Cloning objects
• Comparing objects

Miscellaneous PHP tasks

• Understanding system basics and permissions
• Working with Files and Directories
• Configuring PHP for email
• Sending email with mail()
• Using headers
• Using PHPMailer

Project – Building a Content Management System

• Introducing & Explaining the CMS concept with Drupal and Joomla
• Blueprinting our first CMS application
• Building the CMS database
• Understanding relational databases
• Establishing work area
• Creating our first page
• Making page assets reusable
• Connecting site to a database
• Building dynamic navigation
• Refactoring the navigation
• Adding links to navigation
• Determining which page is selected
• Displaying HTML based on the selection