PHP & MySQL Training

PHP stands for Hypertext Preprocessor. It is a server side technology like ASP. Unlike HTML, PHP needs server to run. You can freely download this software from the internet. It is open source software; you can easily customize this software according to your requirement. There are lots of plug-in available in the market that makes its development faster. Currently most of the sites are built in PHP rather than others technologies because of shorter time of development. There are a number of technologies that used PHP like Word Press, OS Commerce, Joomla, Magento etc. PHP supports many databases (MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, Generic ODBC, etc.)

My SQL is an ORACLE product and usually used in PHP and JAVA. It is used to store, update, delete and retrieve data. It is very powerful software and used in big and small application. It is a free software. MySQL is also used in large application including , Google and Facebook. MySQL is very flexible and its performance is very high.

Course Outline

  • Introduction of different Web Technology
  • Introduction of PHP
  • PHP Architecture
  • Popular code editors
  • Installing Apache http server
  • Installation of PHP
  • Introduction, History, Web Brower, Web Server, Xampp, Installation and Configuration files.
  • Basic of HTML, CSS and JavaScript
  • Language conventions
  • Variables & Data Types
  • Constants
  • Superglobals
  • HTTP Request / Response cycle
  • Forms and User Input
  • Control Structures
    • If, Else, If-Else
    • While, Do-while
    • For
  • Creating Functions
  • Using Parameters
  • Closures
  • Strings & Strings Manipulations
  • Arrays
  • Iterating
  • Array Indexing
  • Array Content
  • Reusability of code
  • Overview of Objects & Classes
  • Namespaces
  • Encapsulation
  • Inheritance
  • Autoloading
  • Closures in an OO context
  • Data Source Names (DSN)
  • PHP Data Objects (PDO)
  • SQL querying with PDO
  • Sanitizing data and binding parameters
  • Displaying the results
  • Exiting gracefully
  • Creating a custom exception handler
  • Terminating Statements
  • Reporting
  • Authenticating against a database
  • Password hashing and security
  • Working with sessions
  • Persisting authentication with Cookies
  • Introduction to Composer
  • Importing packages from Packagist
  • Composer autoloading
  • Installation of MY SQL
  • Introduction about Database, Data Types, DML, DDL, Aggregate functions, Data Time functions, Stored Procedure, Sub query and join
  • MySQL Introduction
  • MySQL Connect
  • MySQL Create
  • MySQL Insert
  • MySQL Select
  • MySQL Where
  • MySQL Order By
  • MySQL Update
  • MySQL Delete
  • Required Field Validator Control
  • Regular Expression Validator Control
  • Compare Field Validator Control
  • Range Validator Control
  • Validation Summary Control
  • Custom Validator Control
  • About Ajax
  • Setting up and implementing Ajax
  • PHP and AJAX
  • AJAX Intro
  • AJAX Database
  • AJAX Live Search
  • AJAX RSS Reader
  • AJAX Poll
  • Encoding and decoding JSON
  • Making HTTP requests
  • Project
  • Project Case Study

Course Registration



Subscribe to Our Newsletter to get Important News & Offers