Php MySQL Training Centers, Institutes & Training Course Classes in Nandanam- Listings as of April 20, 2018.

Institute reviewed : SRI SASTHA TECHNOLOGIES in Chennai for Php MySQL training in Chennai

1.PHP Basics
a.How PHP Works
b.The php.ini File
c.Basic PHP Syntax
i.PHP Tags
ii.PHP Statements and Whitespace
iii.Comments
iv.PHP Functions
v.Hello World!
d.Variables
i.Variable Types
ii.Variable Names Identifiers
iii.Type Strength
iv.Hello Variables
v.Variable Scope
vi.Superglobals
vii.Constants
viii.Variable-Testing and Manipulation Functions
e.PHP Operators
f.Creating Dynamic Pages
g.Single Quotes vs. Double Quotes
h.Howdy World

2.Flow Control
a.Conditional Processing
i.If Conditions
b.Loops
i.while
ii.do while
iii.for
iv.break and continue

3.Arrays
a.Enumerated Arrays
i.Initializing Arrays
ii.Appending to an Array
iii.Reading from Arrays
iv.Looping through Arrays
b.Associative Arrays
i.Initializing Associative Arrays
ii.Reading from Associative Arrays
iii.Looping through Associative Arrays
iv.Superglobal Arrays
c.Two-dimensional Arrays
i.leading from Two dimensional Arrays
ii.Looping through Two dimensional Arrays
d.Array Manipulation Functions

4.PHP and HTML Forms
a.HTML Forms
i.How HTML Forms Work
ii.A Sample HTML Form
iii.Form Variables

5.String Manipulation
a.Formatting Strings
i.Concatenation
ii.String Manipulation Functions
iii.Examples of String Functions
b.Magic Quotes
i.magic quotes gpc
ii.magic quotes runtime
iii.Recommendation on Magic Quotes

6.Reusing Code and Writing Functions
a.Including Files
i.require
ii.require once
iii.auto prepend file and auto append file
b.User Functions
i.Defining and Calling Functions
ii.Default Values
iii.Variable Scope
iv.By Reference vs. By Value
c.Form Processing
i.Code Organization

7.Simple SELECTs
a.Introduction to the Northwind Database
b.Some Basics
i.Comments
ii.Whitespace and Semi colons
iii.Case Sensitivity
c.SELECTing All Columns in All Rows
d.SELECTing Specific Columns
e.Sorting Records
i.Sorting By a Single Column
ii.Sorting By Multiple Columns
iii.Sorting By Column Position
iv.Ascending and Descending Sorts
f.The WHERE Clause and Operator Symbols
i.Checking for Equality
ii.Checking for Inequality
iii.Checking for Greater or Less Than
iv.Checking for NULL
v.WHERE and ORDER BY
g.The WHERE Clause and Operator Words
i.The BETWEEN Operator
ii.The IN Operator
iii.The LIKE Operator
iv.The NOT Operator
h.Checking Multiple Conditions
i.AND
ii.OR
iii.Order of Evaluation

8.Subqueries, Joins and Unions
a.Subqueries
b.Joins
i.Table Aliases
ii.Multi table Joins
c.Outer Joins
d.Unions
i.UNION ALL
ii.UNION Rules

9.Inserting, Updating and Deleting Records
a.INSERT
b.UPDATE
c.DELETE

10.Managing Data
a.Querying a Database
i.mysqli Overview
ii.mysqli Methods and Properties
iii.Inserting and Updating Records
iv.mysqli Prepared Statements

11.MDB2
a.Advantages and Disadvantages of MDB2
i.Why use a database abstraction layer
ii.When not to use a database abstraction layer
b.Using MDB2

12.Authentication with PHP and SQL
a.A Database less Login Form

13.Regular Expressions
a.Perl-compatible Regular Expression Functions
i.preg_match
ii.preg_replace
iii.Regular Expression Tester
b.Regular Expression Syntax
i.Start and End
ii.Number of Occurrences
iii.Common Characters
iv.Grouping
v.Negation
vi.Subpatterns
vii.Alternatives
viii.Escape Character
c.Form Validation Functions with Regular Expressions

14.Session Control and Cookies
a.Sessions
i.Configuring Sessions
ii.Session Functions
b.Cookies

15.Sending Email with PHP
a.mail
i.Shortcomings of mail
b.PHPMailer

16.File System Management
a.Opening a File
i.fopen
b.Reading from a File
i.fgets
c.Writing to a File
i.fwrite
d.File Locking
i.flock
e.Uploading Files via an HTML Form
f.Getting File Information
g.More File Functions
h.Directory Functions
i.Getting a Directory Listing