PHP: PHP & MySQL (Fast Track)

Course Overview

This intensive course is designed to give delegates an introduction of the fundamentals of PHP as an open-source server-side scripting language in combination with MySQL relational database.

This course is designed to provide delegates with the ability to start to create dynamic web sites using this powerful combination.

Audience

Every new and existing web developer who wishes to gain the knowledge needed to begin to build dynamic web sites and web applications using PHP and MySQL. No previous programming experience is assumed.

Course Outline

Components Required

• PHP
• MySQL
• Web server choices
• Shell choices K

Working with MySQL

• Setting Up the database
• Creating the Sample table
• Field data types
• Drop Table
• Update fields
• Delete fields

Getting Started with PHP

• Basic Syntax
• Sending Text & Data to the Browser
• Testing your script
• Sending HTML to the browser
• Adding comments

Databases

• Creating in PHP
• Connecting to the database
• Creating a table
• Selecting the database
• Executing commands
• Inserting data

Displaying Data

• HTML Input
• Outputting data
• Counting Rows
• Setting up a loop
• Assigning values to Variables
• Predefined Variables
• Combining the script so far

Formatting Output

• Selecting data items
• Error Trapping
• Ordering data
• Sorting

Selecting records

• Selecting single records
• Selecting many records
• Links for single records

HTML forms and PHP

• Creating a simple Form
• Using Get and Post
• Receiving data from a Form
• Inputting data manually

Updating the database

• Deleting records
• Loops

Using Numbers

• Basic Arithmetic
• Formatting
• Incrementing/Decrementing
• Multiple Operators
• Built-in math functions

Using strings

• Trimming
• Concatenation
• Encryption
• Subsection extraction