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 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).
-
- Basic Knowledge of websites
- Introduction Of Dynamic Website
- Introduction to PHP
- Why and Scope of PHP
- XAMPP Installation
Introduction
-
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
