Php and MySQL: Beginner

• search and replace
• Giving your code life – Control Structures

Conditional Decision Making – IF, ELSE, and ELSEIF

• True, false, and evaluation of expressions
• Multiple and nested conditions
• Short circuit evaluation – break and continue
• The ‘?’ operator
• Decision making using the switch statement
• Iterations using while, do…while, for and for each loops
• Iterating through an array
• Terminating code using exit, return, and die
• Creating dynamic web content

Embedding PHP in Web pages

• Retrieving user input through forms, using the GET and POST method
• Handling the date and time
• Dynamically including code using include and require
• mail and php
• Cookies
• Using PHP’s built-in functions

Mathematical Functions

• Generating random numbers
• Creating custom functions

Why Write Your Own Functions

• Syntax for defining a function
• Variable scope, and the global statement
• Adding in function parameters
• Return values from functions
• Objects and classes

Basic OOP

• Constructors/destructors
• Visibility and scope
• Static
• Constants
• Introduction to databases

Why Use a Database – The Three-tier Architecture Approach

• Introducing MySQL and PHPMyAdmin
• Understanding the database structure
• Creating a simple database
• Basic SQL commands
• Making PHP and MySQL work for each other

Connecting to the Database

• Displaying database content through PHP
• Inserting and deleting data into the database
• Updating data in the database
• Security considerations