Training Courses and On-Line Classes Preferred By IT Pros
Toll Free:  800.631.0410

PHP and mySQL Web Development

Course:  PHPSQL01
Duration:  5 Days
Level:  I
Course Summary

PHP and MySQL Web Development provides delegates with the knowledge and skills necessary to develop PHP code which delivers exciting dynamic pages that can be frequently updated, cater to the user needs, manipulate a MySQL database, and offer highly efficient e-commerce.

This course is a practical discussion of the features, facilities and tools of PHP and MySQL.

This course includes extensive hands-on exercises which provide practical experience in programming in PHP and MySQL, to develop effective dynamic web pages.

« Hide The Details
Topics Covered In This Course

PHP BASICS

  • How PHP Works
  • PHP Syntax
  • Variables
  • Constants
  • Operators
  • First PHP Web Page

FLOW CONTROL

  • Conditional statements - if
  • Loops - while, do...while, for, break, continue

ARRAYS

  • Enumerated arrays
  • Associative Arrays
  • Two-dimensional Arrays

PHP & HTML FORMS

  • How HTML forms work
  • Sample HTML form

STRING MANIPULATION

  • Formatting strings
  • String functions
  • Magic quotes

FUNCTIONS

  • require, require_once
  • User functions
  • Variable scope
  • Form processing

DATABASE FUNDAMENTALS

  • Database Concepts
  • Relational Databases
  • SQL
  • MySQL introduced

SELECTing DATA

  • Basic principles
  • Selecting by column
  • Sorting records
  • The where clause

SUBQUERIES, JOINS & UNIONS

  • Subqueries
  • Joins
  • Outer Joins
  • Unions

INSERTING, UPDATING & DELETING RECORDS

  • INSERT
  • UPDATE
  • DELETE

MANAGING DATA WITH MySQL

  • mysqli() query access
  • PEAR:DB

REGULAR EXPRESSIONS

  • Fundamentals of regular expressions
  • Regular Expression Syntax
  • Patterns, sub-patterns
  • Form validation with regular expressions

SESSION CONTROL

  • Sessions
  • Session Functions
  • Cookies

SENDING E-MAIL WITH PHP

  • PHP Mailer

FILE SYSTEM MANAGEMENT

  • Opening/Closing files
  • Reading/Writing files
  • Uploading files via a form
  • Directory manipulation
What You Can Expect
  • Describe the background, rationale and purpose of PHP and MySQL
  • Use the basic language constructs of PHP to develop effective dynamic web pages
  • Manage persistence with Cookies
  • Access and maintain files and directories
  • Access and maintain a MySQL database
Who Should Take This Course

This course is valuable for Web masters, web developers and web support personnel wishing to use PHP to develop highly effective web sites.

Recommended Prerequisites

Delegates should have experience of a programming language such as Java, C, C++ or Perl, or a scripting language such as JavaScript. They should also have a working knowledge of the Internet, building web pages and HTML/XHTML.

Training Style

This course is presented as a series of short tutorials with extensive practical experiences.

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com