PHP With MYSQL Training In Pitampura Delhi

Introduction

  • PHP Fundamentals
  • PHP.ini Configuration File
  • Basic Syntax
  • Mixing PHP and HTML
  • About Comments

HTML 5.0

  • Html All Tags
  • How To Design Page
  • Form Creation in HTML
  • Tables in HTML Etc.

Basics of PHP

  • Quick Start for Programmers
  • PHP Language Overview
  • Variables, Datatypes, Operators
  • Escaping Special Characters
  • Conditional Statement
  • Conditionals
  • If Statement
  • Switch Statement

Loops

  • For Loop
  • While Loop
  • For-Each Loop
  • Loop Control (break and continue)
  • Nested Loops

Functions

  •  Function Definition
  • Function Scope

Array

  • Arguments and Return Values
  • Indexed Versus Associative Arrays
  • Identifying Elements of an Array
  • Storing Data in Arrays
  • Multidimensional Arrays
  • Extracting Multiple Values
  • Converting Between Arrays and Variables
  • Traversing Arrays
  • Sorting
  • Acting on Entire Arrays

Form with PHP

  • Form Processing
  • Review of HTML Forms (check boxes, text fields, radio buttons)
  • Retrieving Form Data
  • The GET and POST method
  • Submitting to Itself

Regular Expression

  • Validating User Input with Regular Expressions
  • Intro to Regular Expression  Metacharacters
  • Verifying Email Addresses, ZIP code, Phone Numbers, Credit Cards
  • PCRE Functions

String

  • Quoting String Constants
  • Printing Strings
  • Table of Contents
  • Accessing Individual Characters
  • Cleaning Strings
  • Encoding and Escaping
  • Comparing Strings
  • Manipulating and Searching Strings
  • Regular Expressions
  • POSIX-Style Regular Expressions
  • Perl-Compatible Regular Expressions

File Handling

  • Files and Directories
  • Read and Writing Files
  • Working with Directories
  • Working with CSV Files
  • About File Permissions

PHP OOPS

  • Objects and Classes in PHP
  • Inheritance & Access Modifiers
  • This & Scope Resolulation operators
  • Class constants, Parent , Self
  • Static Members & Static Methods
  • Final Methods & Final classes
  • Abstract Method & Abstract Classess

MYSQL (Database) with PHP

  • Introduction to SQL
  • Connecting to the MYSQL
  • Selecting a database
  • Finding out about errors
  • Adding data to a table
  • Acquiring the value
  • Finding the number of rows
  • Inserting data
  • Entering and updating data
  • Executing multiple queries
  •  Ascending and Descending Sorts
  • The WHERE Clause and Operator Symbols
  • Checking for Equality
  • Checking for Inequality
  • Checking for Greater or Less Than
  • Checking for NULL
  • WHERE and ORDER BY
  • The WHERE Clause and Operator Words
  • The BETWEEN Operator
  • The IN Operator
  • The LIKE Operator
  • The NOT Operator
  • Checking Multiple Conditions (cont…. )
  • AND
  • OR
  • Order of Evaluation
  • Sub queries, Joins and Unions
  • Sub queries
  • Joins
  • Table Aliases
  • Multi-table Joins
  • Outer Joins
  • Unions
  • UNION ALL
  • UNION Rules
  • Inserting, Updating and Deleting Records
  • INSERT
  • UPDATE
  • DELETE

PHP COOKIE

  • Managing Data
  • The anatomy of a cookie
  • Setting a cookie with PHP
  • Deleting a cookie
  • Creating session cookie
  • Working with the query string
  • Creating query string

Session

  • What is session
  • Starting a session
  • Working with session variables
  • Destroying session
  • Passing session Ids
  • Encoding and decoding session variables
  • Introduction to Sessions and Cookies
  • Password-protecting Pages

Exception Handling

  • Try & Catch
  • Throw & Throws
  • CustomeExcepetions

CSS With PHP

  • How to put CSS in PHP Coding
  • How To create CSS File

Javascript with PHP

  • About Javascript and version
  • Variable in Javascript
  • Javascript operator
  • If else statement
  • Switch statement
  • While Loop
  • Do while Loop
  • For Loop
  • Function
  • Array
  • Error Handling
  • Event Handling
  • Javascript Objects
  • Window Object
  • Document Object
  • Date Object
  • String Object
  • Math Object
  • Array Object
  • Custom Object

Cpanel

  • How to Create Database and Tables in Server
  • How To Manage Server

FTP

  • How to Update Files on Server
  • How To upload Site on server

Ajax

  • AJAX (Asynchronous JavaScript and XML)
  • Introduction to AJAX
  • Introduction to XMLHttpRequest Object
  • Method and Properties of XMLHttpRequest
  • Application of AJAX in web application
  • Ajax and PHP
  • Work with SetRequestMethod
  • Some Ajax examples
  • Enquiry Form
  • Image gallery
  • Check user existence

Admin Panel

  • Project Overview
  • Analysis Project Module in Logical terms
  • Design Project Module in programming terms
  • Design client side and admin side
  • create admin login & logout
  • change admin password
  • create category,edit,view and delete
  • create subcategory,edit,view and delete
  • create products,edit,view and delete
  • Searching products
  • Viwe Users,
  • How to Block or unblock users
  • Client Side
  • show category
  • show product category wise
  • work with pagination
  • Live chat
  • search products

PHP PDO

  • What is PDO?
  • Installing PDO
  • Predefined Constants
  • Supported Databases
  • Sample database, table, table structure, table records for various examples
  • The PDO class
  • Details of the PDO class methods
  • Details of PDOStatement class

Website Security

  • Input data validation
  • Guarding against XSS attacks
  • Guarding against CSRF attacks
  • Preventing SQL Injection attacks
  • Protecting the file system
  • Protecting session data
  • Proper error handling
  • Guarding included files
  • INTEGRATION OF Payment Gateway

(SHOPING CART)

  • INTEGRATION OF SMS API
  •  ONLINE CHAT APPLICATION

CMS INTRODUCTION

  • Joomla Introduction
  • Drupal Introduction
  • WordPress Introduction
  • Cake PHP Introduction
    • # LIVE PROJECT TRAINING (DEVELOPING AN e-COMMERCE WEBSITE)

Quick Contact

Are You Looking PHP With MYSQL Training ?
Open chat