Php And MySQL 101 Yellow Belt - Introduction course, 3 days

Introduction to PHP

• Why choose PHP/MySQL/Apache
• PHP’s purpose and capabilities
• Server side VS client side scripting
• What PHP looks like – basic structure
• Setting your development environment up with your testing server
• Testing PHP installations in your server
• Which servers can use PHP
• Where to write the PHP code and using which applications
• Language basics

Structure & Syntax

• Data types in PHP
• Using variables and constants
• Processing data using operators
• Understanding arrays
• Working with combinations of data types, variables and arrays
• Arrays

Array Types

• Multi-dimensional arrays
• Getting data out of arrays
• Array operations
• Addition
• Comparing
• Counting
• Searching
• Flipping / reversing
• Deleting elements within an array
• More arrays

Sorting Arrays

• Sort
• Asort
• Ksort
• Natsort
• Shuffle
• Key sort
• Stacks and Queues
• Push/pop
• Shift/unshift
• Sets
• Array_diff
• Array_intersect
• Strings

Escape Sequences

• Variables and string combined
• Escaping literal values
• Length
• translation
• comparison
• searching
• matching
• 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 POSTmethod
• 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