Facebook Twitter google plus LinkedIn

Email:contact@psntrainings.com
india:Whatsapp No+91 86860 29160 USA:+1 228 586 3560

PHP-Mysql Training



Course Description

An Introduction to PHP

  • History
  • Versions and differences between them
  • Installation and configuring Apache and PHP
  • PHP Basics

  • Default Syntax
  • Styles of PHP tags
  • Comments in PHP
  • Output functions in PHP
  • Data types in PHP
  • Configuration Settings
  • Error Types
  • Variables in PHP

  • Variable Declarations
  • Variable Scope
  • PHP’s Super global Variables
  • Variable Variables
  • Constants in PHP

  • Magic Constants
  • Standard Pre-defined Constants
  • Core Pre-defined Languages
  • User defined Constants
  • Control Structures

  • Execution Control Statements
  • Conditional Statements
  • Looping Statements with Real-time Examples
  • Functions

  • Creating Functions
  • Passing Arguments by Value(call by value)
  • Passing Arguments by Reference(call by reference)
  • Recursive Functions
  • Arrays

  • What is an Array?
  • How to create an Array
  • Traversing Arrays
  • Array Functions
  • Include Functions

  • Include, Include_once
  • Require, Require_once
  • Regular Expressions

  • Validating Text boxes, Emails, Phone number,
  • Creating custom regular expressions
  • Object Oriented Programming in PHP

  • Classes, Objects, Fields, Properties, _set(), Constants, Methods
  • Encapsulation
  • Inheritance and types
  • Polymorphism
  • Constructor and Destructor
  • Static Class Members, Instance of Keyword, Helper Functions
  • Object Cloning and Copy
  • Reflections
  • Scope Resolution Operator
  • Final Keyword
  • PHP with MySQL

  • What is MySQL
  • Integration with MySQL
  • MySQL functions
  • Gmail Data Grid options
  • SQL Injection
  • Uploading and downloading images in Database
  • Registration and Login forms with validations
  • Pagging,Sorting,etc..
  • Strings and Regular Expressions

  • Declarations styles of String Variables
  • Heredoc style
  • String Functions
  • Regular Expression Stntax(POSIX)
  • PHP’s Regular Expression Functions(POSIX Extended)
  • Working with the Files and Operating System

  • File Functions
  • Open, Create and Delete files
  • Create Directories and Manipulate them
  • Information about Hard Disk
  • Directory Functions
  • Calculating File, Directory and Disk Sizes
  • Error and Exception Handling

  • Error Logging
  • Configuration Directives
  • PHP’s Exception Class
  • Throw New Exception
  • Custom Exceptions
  • Date and Time Functions

    Authentication

  • HTTP Authentication
  • PHP Authentication
  • Authentication Methodologies
  • Cookies

  • Why Cookies
  • Types of Cookies
  • How to Create and Access Cookies
  • Sessions

  • Session Variables
  • Creating and Destroying a Session
  • Retriving and Setting the Session ID
  • Encoding and Decoding Session Data
  • Auto-Login
  • Recently Viewed Document Index
  • Web Services

  • Why Web Services
  • RSS Syntax
  • SOAP
  • How to Access Web Services
  • XML Integration

  • What is XML
  • Create a XML file from PHP with Database records
  • Reading Information from XML File
  • MySQL Concepts

  • Introduction
  • Storage Engines
  • Functions
  • Operators
  • Constraints
  • DDL commands
  • DML Commands
  • DCL Command
  • TCL Commands
  • Views
  • Joins
  • Cursors
  • Indexing
  • Stored Procedures
  • Mysql with PHP Programming
  • Mysql with Sqlserver(Optional)
  • PHP & AJAX

  • AJAX Introduction
  • XMLHttpRequest
  • AJAX Examples
  • jQuery

  • Introduction
  • jQuery Selectors
  • jQuery Event functions
  • jQuery Effects
  • jQuery Custom Animations
  • jQuery Callback Functions
  • jQuery HTML Manipulations
  • AJAX and jQuery
  • jQuery UI
  • Word press

  • Introduction
  • Installation
  • Posts, Category, Comments
  • Themes
  • Word press Plug-ins
  • Joomla

  • Content Management System
  • Installation
  • Setting up a JOOMLA Site
  • Module Manager
  • User Administration
  • Plug-in Manager
  • Template Manager
  • JOOMLA Extensions
  • Backing up and/or Restoring JOOMLA Site
We are offered Bigdata online training also


Enquiry