Course Content
Introduction to PHP
- What is PHP?
- PHP Language Overview
- PHP Open Source Technology
- PHP for Web Applications
PHP Fundamentals
- PHP.ini Configuration File
- Basic Syntax
- PHP Tags
- Comments
- Running PHP program - Hello World
Variables, Datatypes, Operators
- Data Types
- Variable Names (Identifiers)
- Variable Scope
- Variable Manipulation
- Dynamic Variables
- Constants
- Operators
- Escaping Special Characters
- Changing datatype with settype
String Manipulation
- String Variables in PHP
- The Concatenation Operator
- strlen() function
- strpos() function
- Joining and splitting String
- Comparing Strings
- Upper/Lower Case, Sub Strings, Replacement
- String Formatting with printf
Conditional Statements and Loops
- If Statement
- Switch Statement
- Loops
- For Loop
- While Loop
- Foreach Loop
- Loop Control (break and continue)
- Nested Loops
Super Globals
- $_GET
- $_POST
- $_REQUEST
- $_FILES
- $_SESSION
- $_COOKIES
- $_SERVER
- $_ENV
Arrays
- What Are Arrays (definition)
- Types of Arrays
- Creating Arrays
- Accessing Arrays
- Single-Dimensional Arrays
- Multidimensional Arrays
- Casting Arrays
- Associative arrays
- Accessing arrays
- Getting the size of an array
- Looping through an array
- Looping through an associative array
- Examining arrays
- Joining arrays
- Sorting arrays
- Sorting an associative array
Functions
- What is a function?
- Defining a function
- Returning value from function
- User-defined functions
- Dynamic function calls
- Variable scope
- Accessing variable with the global statement
- Function calls with the static statement
- Setting default values for arguments
- Passing arguments to a function by value
- Passing arguments to a function by reference
- Testing for function existence
- Inbuilt Functions
- Anonymous Functions
Form Processing
- Designing a Form
- HTML Forms (check boxes, text fields, radio buttons)
- Retrieving Form Data
- The GET and POST method
- Submitting to Itself
- $_GET and $_POST
MySQL Database
- What is Database?
- RDBMS Terminology
- Database
- Table
- Column
- Row
- Redundancy
- Primary Key
- Foreign Key
- Compound Key
- Index
- Referential Integrity
- Understanding MySQL database
- Downloading MySQL
- Installing MySQL on Linux
- Installing MySQL on Windows
- Verifying MySQL installation
- Executing simple commands
- Running and shutting down MySQL server
- Setting up user account
- Administrative MySQL commands
- use
- show databases
- show tables
- show columns from
- show index from
- show table status like tablename
- Database Engines
- MySQL data types
- Numeric Data Types
- String Data Types
- Date and Time Data Types
- Spatial Data Types
- Creating tables using CREATE TABLE Statement
- Changing table structure using ALTER TABLE Statement
- Removing table using DROP TABLE Statement
- Indexes
- What are indexes
- Creating Index
- Removing Index
- Using SELECT statement to query data
- SELECT syntax
- Filtering rows using WHERE clause
- Sorting Result Set using ORDER BY clause
- Use of GROUP BY clause for grouping data
- Use of DISTINCT to eliminate duplicate rows
- DISTINCT with multiple columns
- DISTINCT and NULL values
- DISTINCT vs GROUP BY
- DISTINCT and COUNT AGGREGATE
- Working with PHPMyAdmin
PHP and MySQL
- Connecting to the MYSQL
- Selecting a database
- Finding out about errors
- Adding data to a table
- Acquiring the value
- Finding the number of rows
- Inserting data
- Entering and updating data
- Executing multiple queries.