PHP & MySQL - Learn The Easy Way. Master PHP & MySQL Quickly

Master PHP arithmetic by learning to add, subtract, multiply, and divide using operators plus, minus, asterisk, and slash; explore parentheses, combination operators, and increment and decrement with ++ and --.

Learn how to assign constant values in PHP using the defined command, explore predefined constants and magic constants, and see constants defined in integer, float, string, and boolean types.

Learn to use printf in PHP to format strings precisely using a format string, placeholders like %s, %d, %f, and width specifiers that preserve alignment and decimal precision.

Demonstrate mixing HTML and PHP by inserting quantity and price variables, echoing values, calculating extended price and totals, replicating blocks for multiple items, and linking cart to index.

Understand numeric keys in PHP arrays: positive integers create 0-based arrays starting at zero, access elements with brackets, and initialize with the array function for strings, integers, floats, and booleans.

Learn how to work with associative arrays in PHP by using string keys, accessing elements with square brackets, and printing a full name with placeholders like first and last.

Learn how to measure differences between arrays using array_diff, returning elements in the first array not in the second, and copy subsections with array_slice using offset and length.

Merge two or more arrays in PHP using the array_merge function, including associative arrays; learn how conflicting keys are overwritten by the second array, producing a merged result.

Learn how to compare values using operators such as double equal and triple equal, evaluate comparison expressions inside if statements, and distinguish numeric and string comparisons.

Learn how to use if, else, and else if in PHP to control program flow, handle branching, and implement nested conditions and default cases on a website.

Set up a for loop with initialization, condition, and increment, and use it to execute a fixed number of times. Loop through days or states to build a dropdown.

Explore how continue, break, and goto control loops in PHP, with examples in foreach and modulus checks, and examine the controversy and alternatives like a flag with a while loop.

Master how to define PHP functions with a variable number of parameters and access them with func_get_args, then use foreach to build table cells and fill remaining columns.

Explore visibility levels in PHP by contrasting public, private, and protected members, show access restrictions inside and outside a class, and cover basic security practices with strip_tags and htmlspecialchars.

Build an MVC website using OOP by organizing code into model, view, and controller, and convert the display products function into a public method in the new view class.

Builds an MVC website using OOP by creating model and view folders, defining a new class, and moving a function into the class, then accessing it via include.

Discover php libraries and pear, learn what pear packages are and how to install them, plus encryption packages such as crypt_blowfish, crypt_cbc, and crypt_chap.

Practice downloading and installing an external library (PH mailer) for the lab, follow the GitHub installation procedure, and run a test email to verify delivery.

Discover how to download and install the external PHP library mailer from GitHub, extract it into the pear directory, and run a local test to verify email delivery.

Learn how to create a database and assign user privileges using phpMyAdmin, including choosing collations like UTF-8, and two approaches: create together or separately.

Manage tables with my admin by adding or altering columns, reviewing and deleting data, and renaming tables; browse, insert, import, export, and edit rows as shown.

Learn to insert data into a table using insert into syntax, listing columns and values for single or multiple rows. Explore auto increment keys, defaults, nulls, and foreign key constraints.

Update data with update statements to modify rows and columns using a where clause, and learn how primary keys, foreign key constraints, and cascade on update affect related tables.

Practice creating select, insert, update, and delete statements to manage a members table. Look up, add, remove, and update members by email; sort products by title with a limit.

Explore creating and querying a MySQL database via phpMyAdmin, building select, insert, update, and delete statements, with joins, limits, and like searches.