PHP MYSQL Training

Php mysql live project in Nagpur

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

Introduction of  PHP and Mysql

  • Basics of PHP
  • Why PHP and where it stands in Web environment?
  • Job Scope
  • 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 file
  • 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
  • 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-6511400 for more details.