PHP MySQL Training

Using PHP we can develop dynamic websites within our budget but we can also develop real-time web applications that have a great UI.

Originally designed by Rasmus Lerdorf,Personal Home Pages or PHP is a parsing language that runs on Linux and Unix servers, making it a popular choice for web developers and is in fact, one of the most popularly used languages for web development as well as web application development.

PHP is a programming language that can do all sorts of things:evaluate form data sent from a browser,build custom web content to serve the browser,talk to a database,and even send and receive cookies(little packets of data that your browser uses to remember things.

Content:

• Introduction
• Basic Knowledge of websites
• Introduction Of Dynamic Website
• Introduction to PHP
• Why and Scope of PHP
• XAMPP Installation
• Handling Html Form With Php
• Hypertext Markup Languages
• Structure of HTML
• Basic HTML Tags
• Advanced HTML Tags
• Introduction to Doc Types Web Design with CSS
• Introduction to Cascading Style Sheets
• Programming Basics
• Syntax of PHP
• Embedding PHP in HTML
• Embedding HTML in PHP
• Introduction to PHP Variable
• Understanding Data Types
• Using Operators
• Writing Statements and Comments
• Using Conditional Statements
• If(),else if()and else if condition Statement
• Switch()Statements
• Using the while()Loop
• Using the for()Loop
•  
• Php Function
• PHP Functions
• Creating an Array
• Modifying Array Elements
• Processing Arrays with Loops
• Grouping Form Selections with Arrays
• Using Array Functions
• Using Predefined PHP Functions
• Creating User-Defined Functions
• Advanced Concepts
• Reading and Writing Files
• Reading Data from a File
• Managing Sessions and Using Session Variables
• Creating a Session and Registering Session Variables
• Destroying a Session
• Storing Data in Cookies
• Setting Cookies
• Dealing with Dates and Times
• Executing External Programs
• Introduction To Database-MYSQL
• Understanding a Relational Database
• Introduction to MySQL Database
• Understanding Tables,Records,and Fields
• Understanding Primary and Foreign Keys
• Understanding SQL and SQL Queries
• Understanding Database Normalization
• Dealing with Dates and Times
• Executing External Programs
• MYSQL Database & Tables
• Creating MySQL Databases
• Creating Tables
• Selecting the Most Appropriate Data Type
• Adding Field Modifiers and Keys
• Selecting a Table Type
• Understanding Database Normalization
• Altering Table and Field Names
• Altering Table and Field Names
• Altering Field Properties
• Backing Up and Restoring Databases and Tables
• Dropping Databases and Table Viewing Database,Table,and Field Information
• SQL & Performing 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 Table and Column Aliases
•  
• Working With PHP & MySQL
• Managing Database Connections
• Processing Result Sets
• Queries Which Return Data
• Queries That Alter Data
• Handling Errors
• PHP Project
• Project Discussion
• Requirements analysis of Project
• Project code Execution
• Project Testing