PHP and MYSQL Introduction Course Outline
Page 1 of 3
tel 011 782 4297
fax 086 511 3343
109 3rd street, linden, 2195
po box 44007, linden, 2104
e-mail: [email protected]
website: www.imsd.co.za
PHP and MYSQL Introduction Course Outline
Introduction
■■ Why use PHP and MySQL?
■■ The PHP programming environment
■■ Overview of SQL
Setting up a Test Bed
■■ Decisions about a testing environment
Duration: 3 Days ■■ WAMP/MAMP
■■ Installing Apache, PHP and MySQL on your computer
■■ Testing on a remote Server
Course Overview and
■■ Deciding on Development tools
Objectives ■■ Using PHPMyAdmin
PHP is a widely used
programming language which
works on the principal of server Overview of PHP
side scripting to produce ■■ Setting up a PHP page
dynamic Web pages. It can be ■■ The phpinfo() function
easily integrated with HTML and ■■ Learning basic syntax
SQL to produce these dynamic ■■ Echoing HTML output to the browser
web pages, and is often used to ■■ The importance of comments
process the contents of a Web ■■ Using single and double quotes
page form as it is more secure and
reliable than JavaScript. Variables in PHP
■■ Using loose typed variables
You will learn how PHP can be ■■ Assigning variables
combined with MySQL to create ■■ Overview of numeric, string and other types
a very powerful online database ■■ Assigning a variable to itself
engine. This free online PHP
programming course will be Logical operators
of great interest to IT and Web ■■ Arithmetic operators
development professionals who ■■ Logical operators
would like to learn more about ■■ Comparisons
using PHP and MySQL to integrate ■■ Operator precedence
database functions into Websites,
and to learners who would like to
learn more about the functionality Numbers in PHP
of PHP and MySQL. ■■ Making calculations
■■ Using built-in numeric functions
■■ Incrementing and decrementing
Pre Requisites:
Practical working knowledge of
Mac OS X Strings in PHP
■■ Concatenating strings
■■ Trimming strings
■■ Removing slashes and other harmful characters
■■ String functions
Control structures in PHP
■■ The If statement
Page 2 of 3
tel 011 782 4297
fax 086 511 3343
109 3rd street, linden, 2195
po box 44007, linden, 2104
e-mail: [email protected]
website: www.imsd.co.za
■■ 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
Getting PHP to connect to MySQL
■■ Using the mysql_connect() function
■■ Using the mysql_select_db() function
■■ Testing a connection
■■ 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
■■ Creating pages to:
■■ Add entries
■■ Modify entries
■■ List entries
■■ Filter entries
Security features
■■ Validating entries
*Please note that we offer free electronic support to clients on content
covered on our courses.
Page 3 of 3
