PHP WITH MYSQL IN ENGLISH

PHP is a Server side Scripting language that is used to develop Dynamic Web Applications. In our Online PHP Training we train the candidate to understand the PHP Concepts, Real time implementation and write programs in PHP using MySQL Database.

PHP MYSQL Training IN ENGLISH

PHP Mysql Course Content

Course Duration 40 Days Daily 1:30 Min Monday to Friday Sessions

Web Application Development Introduction to PHP & MySQL PHP Versions & Comparisons Installation & Configuration
WAMP, LAMP, MAMP, XAMPP
PHP Project Development Using IDEs

PHP Basics

Introduction to Scripting
PHP Program Structure
Basic PHP Syntax
Configuration Settings
Comments
Variables
Data Types
Variable Manipulations
String Variables
Heredoc Style
Nowdoc Style
Variable Variables
Reference Variables
Constant Variables
Errors in PHP
Operators
Condition Statements
Control Statements
Arrays
Array Functions

HTML

HTML History
Basics of HTML
Text Formatting Tags
Computer Output Tags
Citations, Quotations and Definition Tags
Working with Images
Working with Links
Working with Entities
Working with Tables
Working with Lists tags
HTML Forms & Input
HTML Frames
HTML iFrames
Audio & Video in Web Page

Cascading Style Sheets

Static & Constant Members
Scope Resolution Operator
Helper Functions
Abstract Class
Interfaces
Object Iteration
final Keyword
Object Cloning
Object Serialization
Reflections

Java Scripts

Introduction
Data types
Variables & Operators
Control & Condition Statements
Arrays
Functions
Event Handlers
Form Validations
Working with JS Objects
DOM

Web Application Development

PHP Forms & Validations
Super Global Variables of PHP
User-defined Functions
Passing arguments by Value
Passing arguments by Reference
Function overloading
Local & Global Variables
Static Variables
Built-in Functions in PHP

Date Functions
String Functions
Working with Files & Directories
PHP CSV File Read
File Uploading
Server Side Includes
include() & include_once()
require() & require_once()
Authentication Methodologies
HTTP Authentication
PHP Authentication
Session Tracking
Session Tracking using Cookies
Session Tracking using PHP Session
Session Configuration Directives
Encoding & Decoding Session Data
Auto Login
Regular Expressions
Validating text box values
Creating custom regular expressions

Object Oriented Programming in PHP

Class & Objects
Constructors & Destructors
Overloading Member Functions
Inheritance
Overriding Members
Exception Handling
try…catch..throw
User-defined Exceptions
Server Side Validations using PHP Filters
E-mail Services
Sending an Email with Attachment
Using PHP from the Command Line
PHP Zip file functions
Google Maps API

MySQL

Introduction to DBMS
RDBMS
Introduction to MySQL Database
Database Creation
Data Definition Language
Data Manipulation Language
Data Retrieval Language
TCL & DCL Commands
Storage Engines
PHP working with SQL Server etc
Using ODBC & OCI functions
MySQL Vs MySQLi in PHP
Setting up the PEAR SOAP Module
WSDL file
Create a Web Service using PHP
Consume a Web Service using PHP
Live Examples
MySQL Data Types
Constraints
PHP functions to work with MySQL
Working with Large Objects
Storing Images in Database
Sub-queries
Functions in MySQL
Stored Procedures in MySQL
Cursors
Indexing in MySQL
Joins
Views
SQL Injection
Pagination, Sorting etc

XML

Introduction to XML
DTD
XSL & XSD
XML Parsing
Tree based Parsers
Event based Parser
Reading an XML document
Creating an XML document for data in DB

Learn More Courses