PHP & MySQL – ELLIOTS INFOTECH

PHP & MySQL Training

Beginner & Advanced level Classes.
Hands-On Learning in PHP & MySQL.
Best Practice for interview Preparation Techniques in PHP & MySQL.
Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question.
Affordable Fees with Best curriculum Designed by Industrial PHP & MySQL Expert.
Delivered by 9+ years of PHP & MySQL Certified Expert | 12402+ Students Trained & 350+ Recruiting Clients.
Next PHP & MySQL Batch to Begin this week – Enroll Your Name Now!

About PHP & MySQL Training in Chennai

PHP is a fast and feature-rich open source scripting language used to develop Web Applications or Internet / Intranet Applications.MySQL is a powerful open source database server built based on a relational database management system (RDBMS) and is capable of handling a large concurrent database connection.When combined together, talented PHP and MySQL developers can build very powerful and scalable Web / Internet / Intranet Applications.PHP and MySQL are Open Source, meaning that they are free development tools, and there is a large community of dedicated volunteer programmers who contribute to make improvements and are continuously adding features to it.

Most Job Oriented PHP & MySQL Topics Covered

1.Variables

Arrays , Conditionals

2.Loops

Custom PHP Functions , Server File I\O

3.Sending Email With PHP

MySQL Database , Useful PHP Classes and Objects

Syllabus of PHP & MySQL Course in Chennai

Module 1:Introduction of Web & PHP

What is PHP?
The history of PHP
Why choose PHP?
Installation overview

Module 2: First Steps

Embedding PHP code on a page
Outputting dynamic text
The operational trail
Inserting code comments

Module 3: Exploring Data Types

Variables
Strings
String functions
Numbers part one: Integers
Numbers part two: Floating points
Arrays
Associative arrays
Array functions
Booleans
NULL and empty
Type juggling and casting
Constants

Module 4: Control Structures: Logical Expressions

If statements
Else and elseif statements
Logical operators
Switch statements

Module 5: Control Structures: Loops

While loops
For loops
Foreach loops
Continue
Break
Understanding array pointers

Module 6: User-Defined Functions

Defining functions
Function arguments
Returning values from a function
Multiple return values
Scope and global variables
Setting default argument values

Module 7: Debugging

Common problems
Warnings and errors
Debugging and troubleshooting

Module 8: Building Web Pages with PHP

Links and URLs
Using GET values
Encoding GET values
Encoding for HTML
Including and requiring files
Modifying headers
Page redirection
Output buffering

Module 9: Working with Forms and Form Data

Building forms
Detecting form submissions
Single-page form processing
Validating form values
Problems with validation logic
Displaying validation errors
Custom validation functions
Single-page form with validations

Module 10: Working with Cookies and Sessions

Working with cookies
Setting cookie values
Reading cookie values
Unsetting cookie values
Working with sessions

Module 11: MySQL Basics

MySQL introduction
Creating a database
Creating a database table
CRUD in MySQL
Populating a MySQL database
Relational database tables
Populating the relational table

Module 12: Using PHP to Access MySQL

Database APIs in PHP
Connecting to MySQL with PHP
Retrieving data from MySQL
Working with retrieved data
Creating records with PHP
Updating and deleting records with PHP
SQL injection
Escaping strings for MySQL
Introducing prepared statements

Module 13: Building a Content Management System (CMS)

Blueprinting the application
Building the CMS database
Establishing your work area
Creating and styling the first page
Making page assets reusable
Connecting the application to the database

Module 14: Using Site Navigation to Choose Content

Adding pages to the navigation subjects
Refactoring the navigation
Selecting pages from the navigation
Highlighting the current page
Moving the navigation to a function

Module 15: Application CRUD

Finding a subject in the database
Refactoring the page selection
Creating a new subject form
Processing form values and adding subjects
Passing data in the session
Validating form values
Creating an edit subject form
Using single-page submission
Deleting a subject
Cleaning up
Assignment: Pages CRUD
Assignment results: Pages CRUD

Module 16: Building the Public Area

The public appearance
Using a context for conditional code
Adding a default subject behaviour
The public content area
Protecting page visibility

Module 17: Regulating Page Access

User authentication overview
Admin CRUD
Encrypting passwords
Salting passwords
Adding password encryption to CMS
New PHP password functions
Creating a login system
Checking for authorization
Creating a logout page

Module 18: Advanced PHP Techniques

Using variable variables
Applying more array functions
Building dates and times: Epoch/Unix
Formatting dates and times: Strings and SQL
Setting server and request variables
Establishing global and static variable scope
Making a reference assignment
Using references as function arguments
Using references as function return values

Module 19: Introduction to Object-Oriented Programming (OOP)

Introducing the concept and basics of OOP
Defining classes
Defining class methods
Instantiating a class
Referencing an instance
Defining class properties

Module 20: OOP in Practice

Understanding class inheritance
Setting access modifiers
Using setters and getters
Working with the static modifier
Reviewing the scope resolution operator
Referencing the Parent class
Using constructors and destructors
Cloning objects
Comparing objects

Module 21: Working with Files and Directories

File system basics
Understanding file permissions
Setting file permissions
PHP permissions
Accessing files
Writing to files
Deleting files
Moving the file pointer
Reading files
Examining file details
Working with directories
Viewing directory content

Module 22: Sending Emails

Configuring PHP for email
Sending email with mail()
Using headers
Reviewing SMTP
Using PHPMailer