Sunday 7 September 2014

PHP and MySql

PHP

  • Introduction to PHP
  • Installation and Configurations
  • LAMP, WAMP, XAMPP, MAMP
  • Comments
  • Output function
  • Data types
  • Variables
  • Declarations
  • Arrays
  • Types of arrays
  • Array functions
  • Strings
  • String functions
  • Conditional Statements
  • if
  • if...else
  • if...elseif....else
  • switch
  • Loops
  • while
  • do...while
  • for
  • foreach
  • continue
  • break
  • Functions
  • Creating Functions
  • Functions without parameters
  • Functions with parameters
  • Functions with return values
  • Date and Time Functions
  • time()
  • getdate()
  • date()
  • Super Globals
  • $_SERVER
  • $_GET
  • $_POST
  • $_SESSION
  • $_COOKIES
  • $_FILES
  • $_REQUEST
  • File uploading
  • File mime types
  • File type restriction
  • Sessions
  • Introduction to session
  • Creating session
  • Creating session variable
  • Calling session variable
  • Creating Login and Logout session
  • Destroying sessions and session variables
  • Cookies
  • Introduction to cookies
  • Types of cookies
  • Creating cookies
  • Accessing cookies
  • Destroying cookies
  • Mail Function
  • Include Require Controls
  • Encryption in PHP
  • Types of errors
  • Working with the Files
  • Opening a file
  • Reading a file
  • Writing a file
  • Closing a file
  • Directory Functions
  • MySQL

  • MySQL Introduction
  • MySQL Installation
  • MySQL PHP Syntax
  • MySQL Connection
  • MySQL Create Database
  • MySQL Drop Database
  • MySQL Select Database
  • MySQL Data Types
  • MySQL Create Tables
  • MySQL Drop Tables
  • MySQL Insert Query
  • MySQL Select Query
  • MySQL Where Clause
  • MySQL Update Query
  • MySQL Delete Query
  • MySQL Like Clause
  • MySQL Sorting Results
  • MySQL Using Join
  • MySQL NULL Values
  • MySQL Transactions
  • MySQL Alter Command
  • MySQL Indexes
  • MySQL Database Export
  • MySQL Database Import
  • Object Oriented Programming
  • Classes, Objects
  • Properties, Methods
  • Class Modifiers
  • Encapsulation
  • Class Inheritance and types
  • Constructor
  • Magic methods
  • Exceptions Handling
  • Try, Throw, Catch
  • AJAX
  • Creating AJAX Object
  • Intialising Object
  • Sending Request
  • Getting Response
  • Readystate
  • CMS

  • DRUPAL
  • JOOMLA
  • Word Press
  • Project


Duration : 45 hrs