PHP course for Intermediate trainees by frendstech

Introduction
Why use PHP and MySQL?
The PHP programming environment
Overview of SQL

Setting up a Test Server
Decisions about a testing environment
WAMP/MAMP
Installing Apache, PHP and MySQL on your computer
Testing on a remote Server
Deciding on Development tools
Using PHPMyAdmin

Overview of PHP
Setting up a PHP page
The phpinfo() function
Learning basic syntax
Echoing HTML output to the browser
The importance of comments
Using single and double quotes

Variables in PHP
Using loose typed variables
Assigning variables
Overview of numeric, string and other types
Assigning a variable to itself

Logical operators
Arithmetic operators
Logical operators
Comparisons
Operator precedence

Numbers in PHP
Making calculations
Using built-in numeric functions
Incrementing and decrementing

Strings in PHP
Concatenating strings
Trimming strings
Removing slashes and other harmful characters
String functions

Control structures in PHP
The If statement
FOR loops
While loops
The Switch

Transferring information between PHP pages
GET and POST
Different form field types
Self-referencing forms
Form handlers

Database fundamentals
Structuring a database
Using tables
Table relationships
Common data types

Creating a database
Using PHPmyAdmin
Adding a table
Populating a table with types and data
Browsing a table with SQL

Getting PHP to connect to MySQL
PHP5 and MySQL5 security features
Using mysqli_connect()
Testing a connnection
Mysqli and prepared statements
Using a positional placeholder
Writing a sample error trap

Querying MySQL using PHP
Writing SQL queries
Using Select, Insert, Update and Delete
Querying MySQL and returning results
Interpreting the returned array

Building a Web Application
Manipulating dynamic pages:
- Add entries
- Modify entries
- List entries
- Filter entries
- PHP and XML

Security features
Validating entries