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.
Beginner
PHP and MySQL for Beginners
Curriculum
- 4 Sections
- 42 Lessons
- 6h Duration
PHP Basics
16 Lessons
- 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
Forms & User Input
6 Lessons
- Forms in PHP
- XSS Attacks
- Basic Form Validation
- Filters & More Validation
- Showing Form Errors
- Redirecting Users
MySQL Databases
11 Lessons
- 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
Beyond the Basics
9 Lessons
- Ternary Operators
- Sessions
- Superglobals
- Null Coalescing
- Cookies
- File System (part 1)
- File System (part 2)
- Classes & Objects (part 1)
- Classes & Objects (part 2)
