Class Description
This 2-day hands-on training class is designed to cover the more advanced PHP and MySQL features that will enable Participants to build powerful database-driven Web applications. Participants learn how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area.
Course Benefits
- Connecting to MySQL
- SQL Select – Subqueries, Joins, and Unions
- Inserting, Updating, and Deleting Records
- Regular Expressions
- Session Control and Cookies
- Sending Email and File System Management
Suggested Prerequisites
Knowledge of your operating system and basic computer navigation is required for all classes.
Course Outline
- Introduction to the Northwind Database
- The WHERE Clause and Operator Symbols
- Inserting, Updating, and Deleting Records
- Subqueries, Joins and Unions
- Table Aliases
- mysqli Methods and Properties
- Inserting, Updating and Deleting Records
- Perl-compatible Regular Expression
- Configuring Sessions
- File System Management
Related Classes
- Acrobat 201 – Adobe Acrobat – eForms Introduction
- Animate 101 – Adobe Animate Essentials
- Animate 201 – Adobe Animate Advanced
- Animate 501 – Adobe Animate Bootcamp
- ColdFusion 101 – Adobe ColdFusion – Fast Track to ColdFusion
- ColdFusion 201 – Adobe ColdFusion – Advanced ColdFusion Development
- ColdFusion 301 – Adobe ColdFusion – Advanced: Java for ColdFusion Programmers
- ColdFusion 501 – Adobe ColdFusion – Developers Bootcamp
- Creative Cloud Web 110 – Adobe Creative Cloud Web QuickStart
- CSS 101 – Advanced CSS (Cascading Style Sheets)
Our goal is to make sure your class meets your objectives, not ours. Therefore, all of our outlines are treated as guides to help steer the workshop. This outline does not guarantee that all the topics listed will be covered in the time allowed. The amount of material covered is based on the skill level of the student audience. We may change or alter course topics to best suit the classroom situation.
Locations