Getting Started with PHP and MySQL Development

Explore PHP functions, covering syntax, untyped parameters, and function bodies. Learn to echo output, return values, and concatenate strings with the dot operator using examples like right bold and wrappers.

Explore PHP scope concepts, show how variables have local function scope and how the global keyword allows modifying the top-level namespace variables from within a function.

Learn static properties belonging to the class and access with self and the scope resolution operator, then track instances with a counted class using constructor, destructor, and unset.

Explore PHP arrays as associative arrays (dictionaries) with key–value pairs, including non-integer keys, and see examples like colors and flavors. Access, assign, and print them using echo, print, and print_r.

Explore PHP server variables via $_SERVER, inspect server context, script locations, and client data; learn how get and post pass form data between pages.

Learn to submit and retrieve form data in PHP via the get method and the $_GET array, extracting name and age from the query string, with security notes.

Learn how $_POST in PHP differs from $_GET, using the http post method to submit data via a form, accessed as an associative array, and why post is more secure.

Explore how PHP's $_REQUEST combines GET and POST data, demonstrating retrieval from query strings and form submissions, and explain when to use $_REQUEST versus $_GET or $_POST.

Explore using phpMyAdmin to manage a MySQL database, run queries, view table structures, and export or import data, including working with a language table and primary key auto increment.

Learn to connect to a MySQL database with PHP using the MySQLi object-oriented interface, query the language table, and output results in a table, preparing for inserts.

Learn to insert data into a MySQL database using PHP, handling POST data from a form, and display the updated language table with basic error checking.

Install mysql using the XAMPP package from Apache Friends, start all included servers (mysql, PHP, Apache), access mysql via the command line as root without a password, and learn basic mysql commands.

Learn to list and create databases in MySQL, including information_schema and performance_schema, create a database named Course, use it, and observe an empty set when showing tables.

Create a simple table in MySQL with name columns, learn insert into names (first, last) values ('John', 'Doe'), and query data using select statements, including where filters.

Explore mysql data types, from numeric tinyint to bigint, floats and doubles with precision, decimals, char and varchar, binary and varbinary, blob, date, datetime, timestamp, set, enum, not null constraints.

Create a names table in MySQL with a mediumint id as an auto incrementing not null primary key, starting at 1, and use inserts and selects to verify its behavior.

Create a small MySQL database using a SQL file to automate table setup. Describe the names and addresses tables to understand primary keys, data types, and references.

Drop the database if it exists, recreate the contacts database, create names and addresses tables, populate with insert‑into … select … from names to link IDs, then load sql file.

Learn how to perform MySQL update queries with update, set, and where clauses to modify one or more columns, and avoid updating all rows.

Explore how structured query language supports arithmetic in queries and updates, create and modify tables like numbers in a contacts database, and use aliases with as to name calculations.

Explore distinct last names, count rows, and group by last name with SQL. Learn how group by enables per-name counts and how order by sorts results.

Explore the basics of relational databases, including one-to-one, one-to-many, and many-to-many relationships. Learn to use primary keys, foreign keys, and join tables to link data across tables.

Explore the four types of joins in MySQL: inner join, left join, right join, and full join (cartesian product), with practical names and colors examples and join syntax.

Explore inner, left, right, and full joins by joining the names and colors tables, observing how matches and nonmatches shape query results.

Create and use a view to save a complex left join query, then query it with select from the view and manage it with show tables and drop view.

Explore setting up a many-to-many relationship with a join table between names and items, including creating a demo database, inserting data, and mapping associations.