PHP MYSQL Training

PHP Course Content

Did you know that ‘Open Source Programming’ with PHP / MySQL is one of the most lucrative opportunities in the job scene today? Going through a good PHP/MySQL training course in Nagpur can take you places in one of the best IT Companies.

Module 1 : Basics and Installation

  • Basics of php
  • Why php and where it stands in Web environment
  • Job Scope

Introduction PHP and Mysql

  • PHP Installation
  • MySQL Installation
  • Apache Installation

Module 2 : Core php

    Overview Of PHP

  • Static vs. Dynamic Web Sites
  • Dynamic Content from Databases
  • Developing Dynamic Internet Applications
  • Client-Side Scripting vs. Server-Side Scripting
  • Overview of PHP Advantages and Capabilities
  • Configuring PHP.INI
  • PHP vs. ASP
    Basic Scripting and Looping Constructs

  • PHP Scripting Fundamentals
  • Print Statement
  • Code Blocks
  • Primitive Data Types
  • Defining Constants and Variables
  • Looping Constructs
  • While, Do… While, For, Exit & Break
    Conditional Constructs

  • True and False Expressions
  • If, Else and Elseif
  • Switch/Case Statement
  • The ? (Ternary) Operator
    Introduction to the Apache Web Server

  • Apache Configuration Files
  • Configuring Apache for PHP
  • WWW Sites within Apache
  • Apache Virtual Hosts
  • Website Properties
    PHP Functions

  • Introduction to Functions
  • Declaring Functions
  • Scope
  • Passing Arguments to Functions
  • Local and Global Scope
  • Passing Arguments to Functions by Value and Reference
  • Returning Values from a Function
  • Using Include Files
  • The Require Statement
  • Recursion
  • Dynamic Function Calls
  • Predefined PHP Functions
  • PHP Operators

  • Logical Operators
  • Relational Operators
  • Bitwise Operators
  • Other Operators
    Arrays in PHP

  • What are Arrays?
  • Usage of Arrays in PHP
  • Array Indexing
  • Initializing Arrays
  • Operating on Arrays
  • Sorting Arrays
  • One-Dimensional Arrays
  • Multi-Dimensional Arrays
  • Associative Arrays
  • Array Functions
  • Forms and Arrays in Web Applications
    Using Cookies with PHP

  • Purpose of Cookies
  • Cookie Myths
  • Setting Cookies
  • Retrieving Cookies
  • Expiring Cookies
  • Deleting Cookies
  • Storing Arrays in Cookies
    Working with Databases and Forms

  • Configuring PHP For Database Support
  • PHP’s Database APIs
  • PHP’s SQL API
  • MySQL vs. Access
  • MySQL vs. SQL Server
  • Simple SQL Queries via PHP
  • Tracking Visitors with Session IDs
  • Populating Forms
  • Retrieving Data from Forms
    Configuring and Using MySQL

  • MySQL as a Client/Server Solution
  • Introduction to MySQL Capabilities as a Powerful RDBMS
  • Installing and Configuring MySQL
  • Connecting to MySQL
  • PHP Functions Specific to MySQL
  • Executing SQL Calls
  • Select
  • Insert
  • Fetch
  • Update
  • Delete
  • Using PHP MyAdmin to configure MySQL
    Miscellaneous PHP Tasks

  • Error Logging
  • Session Management & Maintaining State
  • Web Application Architecture
  • Using Environment Variables
  • Changing Execution by Redirecting to Other URLs
  • Embedding JavaScript within PHP
  • Using the HTTP Protocols to Pass Data
  • Showing Different Content to Different Browsers
  • Getting IP Addresses from Visitors
    Working with Data Files in PHP

  • Searching File Contents With Regular Expressions
  • Changing and Editing File Contents
  • Splitting and Joining Information Inside Files
  • String Functions
  • Regular Expression Functions
  • Reading, Writing and Deleting Files
  • Handling File Permissions
  • File Locking
  • Reading Directory Contents
  • Creating and Deleting Directories
    Enabling E-Commerce

  • Required Characteristics of an E-Commerce Site
  • Authentication and Authorization
  • Data Validation
  • Building a Custom Shopping Cart
  • Persisting Shopping Cart Data Over Multiple Pages
  • Criteria for Evaluating Third Party Shopping Cart Solutions
  • Open Source vs. Commercial Shopping Cart Solutions
  • Order Processing via the Web
  • Implementing Order System Security using SSL
  • Using Mail Servers (SMTP and Sendmail) for Client Communication
  • Configuring E-mail Output Parameters

Module 3: Live international Projects

    This level will provide the students with the ‘hands-on’ experience, an active involvement with live international projects under the guidance of the industry experts alongside the company’s working professionals.
    Introduction to CMS (Content Management System)

  • Joomla
  • WordPress
    Introduction to open Source CMF (Content management framework)

  • Codeigniter

Domain Registration and Domain Cpanel

Web Hosting (Cpanel, WHM – web host manager)
Seo Seminar (Search Engine Optimization)

    1 Live Project

    Minimum Eligibility Requirement

  • Graduate
  • Knowledge of C or C++
    Course Duration: 3 and half months

    Timings: may vary for each batch. Generally it will be either in morning or in evening.

    Visit Office or call 0712-6470508 for more details.