PHP Training With Final Year Internship

Introduction PHP and MySQL

Benifits of using PHP MySQL

Setup of PHP Environment

Administration and Course Materials

Course Structure and Agenda

Delegate and Trainer Introductions

MySQL

Installing MySQL

Testing MySQL

Basic SQL Statements

Creating Databases and Tables

Inserting Data into Tables

Viewing Tables

UPDATE

Drop

Connecting to MySQL

mysql_connect

mysql_error

mysql_select_db

Die

Tes
ting the Page

Troubleshooting Installation Errors

PHP Programming Concepts

Write your First PHP Program

Embed PHP in HTML / HTML in PHP

PHP Data Types

Variables in PHP

SuperGlobal Variables

Operators in PHP

Conditional Statements

Loops (For, While, Do While, Foreach)

PHP Functions

Using Functions in PHP

Userdefined Functions

Predefined Functions

Common Functions

String Functions

File Functions

Date Functions

Hash Functions

Mail Function

MySQL Database Training

What is Database ?

Understanding an RDBMS

Understanding Tables, Records, and Fields

SQL Language

Using the MySQL Command-Line Client

Working with MySQL Admin

Working with PHP MyAdmin

Using PHP to Perform Database Functions

Inserting Data into a Database

Creating Queries

Executing Queries

Processing the Returned Query Data

Updating the Database

Creating Databases

Types of Databases

Creating Tables in Database

Specifying Field Data Types

Selecting the Most Appropriate Data Type

Adding Field Modifiers and Keys

Selecting a Table Type Altering Tables

Altering Table and Field Names

Altering Field Properties

Adding and Removing Fields and Keys

Altering Table Types

Backing Up and Restoring Databases and Tables

Backing Up Databases and Tables

Restoring Databases and Tables from Backup

Dropping Databases and Tables

Viewing Database, Table, and Field Information

SQL Queries

Inserting Records

Editing and Deleting Records

Performing Queries

Retrieving Specific Columns

Filtering Records with a WHERE Clause

Using Operators

Sorting Records and Eliminating Duplicates

Limiting Results

Using Built-In Functions

Grouping Records

Joining Tables

Using Subqueries

Using Table and Column Aliases

Arrays and Array Functions

Why use Arrays

Types of Arrays

Creating Arrays

Accessing Arrays

Array Functions

Generating HTML using PHP

PHP Inside HTML

HTML Form with Embedded PHP

Multiple HTML Pages/Forms with PHP

Email and Cookies using PHP

Generating Email using PHP

Generating Cookies using PHP

Using Cookies

PHP and Database Security

Designing Databases

Connecting to Database

Encrypted Storage Model

Security Techniques

Error Reporting

User Submitted Data