This course introduces PHP and MySQL, two fundamental technologies for server-side web development. It highlights PHP as a scripting language that is adept at creating dynamic content for web pages, and MySQL as a reliable and scalable relational database management system. The focus is on PHP’s syntax and how it integrates with MySQL to perform database operations, such as creating, reading, updating, and deleting data. Participants learn to harness PHP’s server-side capabilities to handle form submissions, manage sessions, and build CRUD applications, while also gaining proficiency in designing and querying MySQL databases to store and retrieve web application data efficiently. The course lays the groundwork for developing data-driven websites and applications using PHP and MySQL.
Overview
COURSE DIFFICULTY
Skills Learned
After completing this online training course, students will be able to:
Install PHP and set up the environment
Create and execute PHP files
Work with PHP variables and constants
Manipulate strings in PHP
Perform calculations with numbers
Define and use arrays
Utilize multi-dimensional arrays
Implement loops (for, foreach, while, do-while)
Make use of booleans and comparison operators
Apply conditional statements
Control loop execution with continue and break
Create and call functions
Understand variable scope
Include and require files
Manage project structure with header and footer
Process forms and handle user input
01. PHP Basics
- Course Introduction
- Installing PHP
- Your First PHP File
- Variables & Constants
- Strings
- Numbers
- Arrays
- Multi-Dimensional Arrays
- Loops
- Booleans & Comparisons
- Conditional Statements
- Continue & Break
- Functions
- Variable Scope
- Include & Require
- Project Header & Footer
02. Forms & User Input
- Forms in PHP
- XSS Attacks
- Basic Form Validation
- Filters & More Validation
- Showing Form Errors
- Redirecting Users
03. MySQL Databases
- MySQL Introduction
- Setting Up a MySQL Database
- Connecting to a Database
- Getting Data From a Database
- Rendering Data to the Browser
- The Explode Function
- Control Flow Alt Syntax
- Saving Data to the Database
- Getting a Single Record
- Deleting a Record
- Finishing Touches
04. Beyond the Basics
- Ternary Operators
- Superglobals
- Sessions
- Null Coalescing
- Cookies
- File System (part 1)
- File System (part 2)
- Classes & Objects (part 1)
- Classes & Objects (part 2)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Install PHP and set up the environment
Create and execute PHP files
Work with PHP variables and constants
Manipulate strings in PHP
Perform calculations with numbers
Define and use arrays
Utilize multi-dimensional arrays
Implement loops (for, foreach, while, do-while)
Make use of booleans and comparison operators
Apply conditional statements
Control loop execution with continue and break
Create and call functions
Understand variable scope
Include and require files
Manage project structure with header and footer
Process forms and handle user input
COURSE OUTLINE
01. PHP Basics
- Course Introduction
- Installing PHP
- Your First PHP File
- Variables & Constants
- Strings
- Numbers
- Arrays
- Multi-Dimensional Arrays
- Loops
- Booleans & Comparisons
- Conditional Statements
- Continue & Break
- Functions
- Variable Scope
- Include & Require
- Project Header & Footer
02. Forms & User Input
- Forms in PHP
- XSS Attacks
- Basic Form Validation
- Filters & More Validation
- Showing Form Errors
- Redirecting Users
03. MySQL Databases
- MySQL Introduction
- Setting Up a MySQL Database
- Connecting to a Database
- Getting Data From a Database
- Rendering Data to the Browser
- The Explode Function
- Control Flow Alt Syntax
- Saving Data to the Database
- Getting a Single Record
- Deleting a Record
- Finishing Touches
04. Beyond the Basics
- Ternary Operators
- Superglobals
- Sessions
- Null Coalescing
- Cookies
- File System (part 1)
- File System (part 2)
- Classes & Objects (part 1)
- Classes & Objects (part 2)