Learn PHP and MySQL for Beginners the Easy Way - 13 Hours

Get the most from this high-definition, video-based course with downloadable exercise files, clear guidance on which files to open for each exercise, and tips to adjust playback quality and speed.

Set up a PHP development environment, write readable code with proper whitespace and inline and block comments, and render hello world pages on local servers like Apache or IIS.

Explore the differences between echo and print, including argument handling, the concatenation operator, and performance notes, and compare single versus double quotes in PHP, highlighting variable interpolation and special characters.

Master PHP operators that manipulate variables and literals, including arithmetic, modulus, assignment, string concatenation, equality and identical checks, not equal, and shortcuts like += and ++ with precedence and parentheses.

Explains how to control the flow of execution using if, else if, else, and switch constructs in PHP, with a practical exercise testing username and password on a web page.

Explore php looping constructs while, for, and foreach, with break and continue to control termination. Learn to print sequences and reverse 0–10 and square the counter.

Learn practical debugging in PHP by scaffolding code with echo statements, using a debug flag to reveal variables and execution flow, and safely toggling debugging for development versus production.

Learn how to create and call PHP functions, pass parameters and arguments, and return values to interact with data, while understanding scope and execution.

Master PHP functions by handling required and default arguments, exploring local and static scopes, and using built-in helpers, then build a validate_user function with a static credential map for login checks.

Use include, include_once, require, and require_once to bring reusable PHP functions into pages, avoiding duplication and enabling centralized updates. Know that require halts on missing files, while include only warns.

Learn how PHP handles runtime errors with try and catch, protecting code blocks, controlling execution flow, and recovering via multiple catch blocks ordered from most specific to general.

Explore PHP server side file handling by opening files with fopen, reading data with fread and fgets, parsing CSV with fgetcsv, and writing with fwrite, then closing with fclose.

Learn how to read application configuration files in PHP using parse_ini_file and simplexml_load_file, extracting database login details and debug settings from ini or XML formats.

learn to store user interaction data in a relational database, connect via php to mysql or mariadb, and use select, update, insert, and delete operations.

Connect to sequel server and my sequel databases from a PHP app using local environment settings, then perform select and insert operations and verify results as associative arrays.

Explore object oriented development in PHP, encapsulating data and behavior into objects with a clear interface. Create classes and instances using constructors, destructors, and access modifiers.

Explore a PHP object-oriented user model with private attributes, a constructor, destructor, and getters. Learn status validation and generate unique user IDs with a static helper, plus object creation examples.

Master object oriented development in php by extending a base class to create a child class, reuse existing functionality, and override parent methods with parent::method.

Demonstrates inheritance by modeling a person class and an employee subclass, highlighting private attributes, a public constructor, access modifiers, and a static, private employee ID generator.

Define a movie class with title, year, director, and rating, provide a public interface avoiding direct attribute access, and use is-a inheritance with web form to enter and print movies.

Explore PHP threats like cross-site scripting, cross-site forgery, session hijacking, and SQL injection, and learn server-side validation and sanitization using htmlspecialchars and filter_input and filter_var to prevent attacks.

Develop a reusable validator class to securely validate and sanitize user name, email, personal website URL field, and phone number. The lesson emphasizes server-side validation for security and injection prevention.

Demonstrates a movie catalog class that implements the countable, array access, and iterator aggregate interfaces to manage a list of movies with insert and director search functionality.

Explore standard PHP library usage by building a movie catalog with require_once, inserting movie objects, displaying them, and iterating with foreach using iterator aggregate and array access.

Explore the PHP SPL data structures, including fixed arrays, doubly linked lists, stacks, queues, and heaps, and learn how to implement custom exceptions for robust error handling.

Explore SPL data structures in PHP, including heap, stack, doubly linked list, and fixed array, with concrete examples of iterators, countable interfaces, abstract classes, and compare logic.

Explore the SPL exception hierarchy and runtime error handling, create custom exceptions, and organize catch blocks; build a movies class implementing Countable, ArrayAccess, IteratorAggregate for foreach and for loops.

Demonstrates how to use various forms of the select statement against the employee table, measuring performance with a Timer, and applying where, order by, and like to refine results.

Learn to join related data across tables using inner, left, right, and full outer joins, plus union, by matching common keys in a relational database.

Explore how to use the select statement with joins to link employee and person tables via the business entity ID, retrieve names and addresses, and analyze join performance across tables.

Explore left and right joins by combining the employee and person tables on business_entity_id, illustrating how unmatched rows appear and how results differ.

Master insert, update, and delete in MySQL, including long vs short forms and where clauses; apply archiving inactive records and use aggregate functions (count, avg, max, min, sum) in selects.

Learn to replace ad hoc PHP queries with stored procedures, sanitize and validate user input to prevent SQL injection, and build a dynamic, database-driven site with a content management workflow.

Explore design pattern categories (creational, structural, and behavioral) through the singleton and observer patterns, highlighting language-independent solutions that boost reusability and rapid software development.

Explore how the singleton design pattern ensures a single database connection manager instance, using a private constructor and a get instance method to manage and close the connection.

Explore the observer pattern in PHP using publish-subscribe with SPL interfaces, implementing a sales manager subject and three observers (fulfillment, inventory, finance) that react to a new sale.