PHP Training Package
This package is designed for website developers who want to extend their capabilities, and learn to use PHP and MySQL to build and maintain a fully data-driven websites or web applications.
Quick Facts
$2,750 incl GST
Save $1100.00
Download Course Brochures
About the Package
Participants will learn the fundamentals of building a dynamic website based on PHP and MySQL. Students will learn to create galleries and configure and write commands, then master advanced techniques including sticky forms, form validation, database design and more.
The PHP Training Package includes the following courses:
Introduction to PHP & MySQL (4 Days)
Advanced PHP Web Development (3 days)
Prerequisites
Participants should complete the Dreamweaver CS5: Website Development course, or have equivalent experience and have understanding of HTML and CSS, before attending Introduction to PHP & MySQL. Participants should also follow the sequence of the courses listed above. More details on prerequisites can be found within individual course descriptions.
Subject to prerequisites being met, one or more participants can book into a package. Review training package conditions .
Courses Units: Introduction to PHP and MySQL
- Unit 1: Introducing the Course
- - Getting familiar with the course methodology and format
- - Understanding the course objectives and pre-requisites
- - Why PHP and MySQL?
|
- Unit 2: Installing the Software
- - Installing Notepad (text editor) and WinMerge (file comparison utility)
- - Installing Apache
- - Installing PHP
- - Configuring Apache to work with PHP and testing PHP
- - Checking your PHP settings
|
- Unit 3: Writing PHP Scripts
- - Using variables
- - Commenting scripts
- - Using arrays to store multiple values
- - Using quotes correctly
- - Loops and functions
- - Displaying PHP output
|
- Unit 4: Using Includes to Streamline your Workload
- - Including content from other files
- - Identifying the current page with PHP
- - Creating pages with variable content
- - Dealing with missing include files
- - Displaying a random image
- - Using includes securely
|
- Unit 5: Bringing Forms to Life
- - Gathering information from a form with PHP
- - Sending email from a form
- - Validating user input
- - Handling multiple choice form elements
- - Redirecting to another page
|
- Unit 6: Uploading Files
- - Checking that your server supports uploads
- - Creating an upload directory
- - Checking filenames
- - Refusing large files
- - Restricting file types
- - Preventing files from being overwritten
|
- Unit 7: Managing Files with PHP
- - Checking that PHP has the necessary permissions
- - Reading files in a single operation
- - Read/write operations
- - Replacing content in a file
- - Appending content to a file
- - Exploring the file system
|
- Unit 8: Generating Thumbnail Images
- - PHP's image manipulation functions
- - Generating a scaled down version of an image
- - Resizing an image automatically on upload
- - Giving each thumbnail a unique name
|
- Unit 9 : Simple Login and Multipage Forms
- - Session management with PHP
- - Creating and destroying session variables
- - Using sessions to restrict authentication
- - Setting a session time limit
- - Passing information through multipage forms
|
- Unit 10: Setting up MySQL and phpMyAdmin
- - Installing and configuring MySQL
- - Installing and configuring phpMyAdmin
- - Launching phpMyAdmin
- - Installing the MySQL GUI Tools
|
- Unit 11: Getting Started with the MySQL Database
- - Introduction to database management
- - Setting up the MySQL database
- - Creating MySQL user accounts
- - Connecting to MySQL with PHP
- - Finding the number of records in a database query
- - Displaying the results of a query
|
- Unit 12: Creating a Dynamic Online Gallery
- - Planning the image gallery
- - Passing information with a query string
- - Displaying database results in a multicolumn table
- - Selecting subsets of records
- - Navigating through long record sets
|
- Unit 13: Managing Content
- - Safeguarding your data from SQL injection attacks
- - Writing SQL queries
- - Setting up a content management system
- - Creating the necessary database table
- - Inserting, updating, and deleting records
|
- Unit 14: Solutions to Common PHP/MySQL Problems
- - Extracting characters, words, paragraphs, and sentences from text
- - Manipulating dates
- - Working with multiple database tables
- - Finding records with no matching foreign key
- - Using lookup tables to resolve many-to-many relationships
- - Deleting records with dependent foreign keys
|
- Unit 15: Securing your Website from Intruders
- - Encrypting methods
- - Using one-way and two-way encryption
- - Registering new users
- - Updating user details
|
Courses Units: Advanced PHP Web Development
- Unit 1: Introducing the Course
- - Getting familiar with the course methodology and format
- - Understanding the course objectives and pre-requisites
- - Why PHP and MySQL?
|
- Unit 2: Introduction to PHP
- - Basic Syntax
- - Sending Data to the Web Browser
- - Understanding PHP, HTML, and White Space
- - Writing Comments
- - What are Variables?
- - About Strings
- - About Numbers
- - About Constants
- - Single vs. Double Quotation Marks
|
- Unit 3: Programming with PHP
- - Creating an HTML Form
- - Handling an HTML Form
- - Managing Magic Quotes
- - Conditionals and Operators
- - Validating Form Data
- - What are Arrays?
- - For and While Loops
|
- Unit 4: Creating Dynamic Web Sites
- - Including Multiple Files
- - Handling HTML Forms with PHP Redux
- - Making Sticky Forms
- - Creating and Calling your Own Functions
- - Variable Scope
- - Date and Time Functions
- - Sending Email
|
- Unit 5: Introduction to SQL and MySQL
- - Choosing your Column Types
- - Choosing Other Column Properties
- - Using the mysql Client
- - Creating Databases and Tables
- - Inserting Records
- - Selecting Data
- - Using Conditionals
- - Using LIKE and NOT LIKE
- - Sorting Query Results
- - Limiting Query Results
- - Updating Data
- - Deleting Data
- - Using Functions
|
- Unit 6: Advanced SQL and MySQL
- - Database Design
- - Performing Joins
- - Grouping Selected Results
- - Creating Indexes
- - Using Different Table Types
- - Performing FULLTEXT Searches
- - Database Optimization
|
- Unit 7: Error Handling and Debugging
- - General Error Types and Debugging
- - Displaying PHP Errors
- - Adjusting Error Reporting in PHP
- - Creating Custom Error Handlers
- - Logging PHP Errors
- - PHP Debugging Techniques
- - SQL and MySQL Debugging Techniques
|
- Unit 8: Using PHP with MySQL
- - Modifying the Template
- - Connecting to MySQL and Selecting the Database
- - Executing Simple Queries
- - Retrieving Query Results
- - Ensuring Secure SQL
- - Counting Returned Records
- - Updating Records with PHP
|
- Unit 9: Web Application Development
- - Adjusting Behavior for Server Settings
- - Sending Values to a Script Manually
- - Using Hidden Form Inputs
- - Editing Existing Records
- - Paginating Query Results
- - Making Sortable Displays
- - Understanding HTTP Headers
|
- Unit 10: Cookies and Sessions
- - Using Cookies
- - Using Sessions
- - Sessions and Cookies
- - Improving Session Security
|
- Unit 11: Web Application Security
- - More Secure Form Validation
- - Handling HTML
- - Validating Data by Type
- - Form Validation with JavaScript
- - Regular Expressions
- - Database Security and Encryption
|
- Unit 12: Extended Topics
- - Handling File Uploads
- - PHP and JavaScript
- - Using Output Buffering
- - Using the Improved MySQL Extension
- - New MySQL Features
- - Using PEAR
|
- Unit 13: Example—Content Management
- - Creating the Template
- - Creating the Basic Pages
- - Managing URLs
- - Managing Files
|
- Unit 14: Example—User Registration
- - Creating the Templates
- - Writing the Configuration Scripts
- - Creating the Home Page
- - Registration
- - Activating an Account
- - Logging in and Logging Out
- - Password Management
|
- Unit 15: Example—E-Commerce
- - Creating the Database
- - The Administrative Side
- - Creating the Public Template
- - The Product Catalogue
- - The Shopping Cart
- - Recording the Orders
|
Upcoming Dates
You’ll need to check the dates for each of the individual courses within this Package.
Check our Course Dates, or contact us to discuss your specific needs.
$2,750 incl GST
Save $1100.00
