Advanced PHP Web Development

Dynamic Web Training Pty Ltd.
Adelaide, Brisbane, Canberra, Melbourne, Sydney, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' The combination of PHP and the MySQL database now provides the most widely used solution for creating dynamic websites. Together with the Apache web server, these free software applications provide the foundation for many standard web hosting plans. During the course you will learn how to hand-code a dynamic website, using a development environment on your local computer that matches the server environment where your site will eventually be hosted.

Who should do this course?
Anyone looking to expand their current PHP knowledge level to that of an Advanced PHP developer. To gain the most from this class, you should already have:

* Completion of the "Introduction to PHP and MySQL" course or equivalent experience from building PHP/MySQL applications
* Experience developing web applications using PHP & MySQL for at least six weeks after taking the "Introduction to PHP and MySQL" course
* Practical experience using PHP syntax, functions, and variables
* Practical experience with the SQL command set, including SELECT, INSERT, and UPDATE


About the course:
During the 3 days, this course will introduce you to a range of advanced PHP and MySQL techniques, including:

* Sticky forms
* Database design, creation, and optimization
* FULLTEXT searches
* Sortable display of database results
* Secure form validation
* Using HTTP headers
* Regular expressions

By the end of the course you will have created a basic content management , user registration, and simple e-commerce systems.


Content:

Unit 1: Introducing the Course

* Getting familiar with the course methodology and format
* Understanding the course objectives and prerequisites
* 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 Catalog
* The Shopping Cart
* Recording the Orders

...''

Phone:1300 888 724, +61 2 9957 1366

School Address:

Level 11
32 Walker Street
North Sydney NSW 2060

Level 12
379 Collins Street
Melbourne VIC 3000

C/- Support Technology
Level 6, 371 Queen St
Brisbane QLD 4000

C/- Training Choice
Level 12, 15 London Circuit
Canberra ACT 2600

C/- Hire Intelligence
Level 4, 74 Pirie Street
Adelaide SA 5000

Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Travel Agencies: Brisbane, Melbourne, Sydney

Search other schools for Advanced PHP Web Development training resources.

Advanced ColdFusion MX 7 Development
Fireworks CS3: Web Graphic Creation
Authorware 7
Advanced Authorware Development
Captivate 3.0
Adobe RoboHelp 7
Freehand
Contribute 3
HTML
PHP & MySQL
Advanced Website Design Using CSS
CSS Masterclass
Acrobat 8
Photoshop CS3
Illustrator CS3
InDesign CS3
Excel 2007 Level 1
Excel 2007 Level 2
Excel 2007 Level 3

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.