Development

PHP and MySQL for Beginners

Beginner
6h

By: Shaun Pelling

PHP and MySQL for Beginners

Overview

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.

Skills Learned

  • 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

Modules

1. PHP Basics

1.1 Course Introduction7 min
1.2 Installing PHP9 min
1.3 Your First PHP File8 min
1.4 Variables & Constants7 min
1.5 Strings12 min
1.6 Numbers10 min
1.7 Arrays17 min
1.8 Multi-Dimensional Arrays10 min
1.9 Loops20 min
1.10 Booleans & Comparisons12 min
1.11 Conditional Statements12 min
1.12 Continue & Break4 min
1.13 Functions12 min
1.14 Variable Scope9 min
1.15 Include & Require5 min
1.16 Project Header & Footer11 min

2. Forms & User Input

2.1 Forms in PHP16 min
2.2 XSS Attacks4 min
2.3 Basic Form Validation6 min
2.4 Filters & More Validation13 min
2.5 Showing Form Errors11 min
2.6 Redirecting Users5 min

3. MySQL Databases

3.1 MySQL Introduction5 min
3.2 Setting Up a MySQL Database8 min
3.3 Connecting to a Database6 min
3.4 Getting Data From a Database7 min
3.5 Rendering Data to the Browser8 min
3.6 The Explode Function6 min
3.7 Control Flow Alt Syntax4 min
3.8 Saving Data to the Database11 min
3.9 Getting a Single Record13 min
3.10 Deleting a Record9 min
3.11 Finishing Touches4 min

4. Beyond the Basics

4.1 Ternary Operators5 min
4.2 Superglobals5 min
4.3 Sessions9 min
4.4 Null Coalescing3 min
4.5 Cookies6 min
4.6 File System (part 1)7 min
4.7 File System (part 2)8 min
4.8 Classes & Objects (part 1)11 min
4.9 Classes & Objects (part 2)9 min

Ready to Elevate Your Team's Learning?

Talk with our sales team to see how StormWind can transform the way your organization trains and grows.

CONTACT SALES