PHP 5 and 7 & SQL Queries with MySQL database hands on

Set up a PHP development environment with Visual Studio Code and a local server. Install PHP 7.2.x, create a public folder under the server root, and run localhost.

explains how to configure php.ini in a local development environment, including setting the default time zone, adjusting max execution time, and controlling upload size and file limits.

Explore PHP 5 and 7 basics with hands-on practice using the echo statement and print function to output content to the browser, including simple hello world examples.

Learn PHP comments and escape characters to write clearer code. Understand single-line and multiline comments and how backslashes escape quotes in strings, with echo examples.

Enable the display of PHP errors and configure error_reporting levels to capture detailed messages during development. Route errors to log files for easy debugging by other developers.

This lecture introduces PHP variables and data types, distinguishing scalar (string, integer, float, boolean) from compound types, showing variable declaration, assignment, and basic type conversion between strings and numbers.

Learn how to define and use constants in PHP, including naming rules, immutability, and scope. Explore magic constants that reveal file paths and line numbers.

Explore PHP integer functions, including is_integer (alias is_int) that checks if a value is an integer. Learn how intval extracts the integer value and how is_numeric tests numeric inputs.

Explore PHP floats and floats functions, test values with is_float and is_double, and observe how integers and booleans influence the results.

Explore PHP boolean functions and how booleans return true as 1 and false as 0 or empty when given non-boolean types, with examples using booleans, integers, and floats.

Explore PHP string functions such as ucfirst, ucwords, strtoupper, strtolower, str_repeat, strpos, substr, trim, and str_replace, and learn how to manipulate and search text in web development.

Explore fundamental PHP maths functions, including pi(), abs(), sqrt(), round(), floor(), ceil(), and rand(), with examples of absolute value handling and bounded random ranges.

Explore PHP arrays, including index and associative arrays, learn how to access values by index positions or keys, and understand that keys are case sensitive.

Explore creating and accessing multidimensional arrays in PHP, using index and associative layers, and retrieve names, emails, and professions through nested keys and positions.

Explore how PHP sorts arrays by index or by key, sorting by value or key in ascending, descending, and alphabetic orders for numeric and associative arrays.

Master essential PHP array concepts and functions, from printing structures with print_r and var_dump to iterating with current, next, prev, and end, and transforming arrays with implode and explode.

Explore PHP array handling in depth, using array_walk and foreach, and manipulate single and multidimensional arrays with array_values, array_keys, shift, unique, slice, splice, push, merge, and count.

Explore PHP operators, including arithmetic, assignment, and comparison, with examples of plus, minus, times, divide, modulus, and equals. Understand operator precedence with brackets and logical operators in conditional statements.

Explore PHP conditional statements, using if, else if, and else, with equality and strict comparison, nesting, case sensitivity, and handling multiple conditions to control code flow in web input scenarios.

Explore the PHP switch statement as a type of if, using a name variable with multiple cases, break, and a default to handle unmatched values in code and browser testing.

Explore the PHP ternary and null coalescing operators, learn how the ternary mimics if statements to return values, and use null coalescing to provide defaults when values are null.

Understand how return and exit statements govern PHP script flow, when to use die for error handling, and how returning values inside functions differs from outputting with statements.

Learn PHP functions, including echo vs return, return types, and passing arguments, with variables inside functions and returns to build robust web applications.

This lecture explains global scope and local scope in PHP, showing how outside variables are global and inside variables are local, and how to access globals via the $GLOBALS superglobal.

Explore PHP superglobals, predefined global variables available in all scopes, without declaring global, and learn how to access them within functions.

Explore how the PHP foreach loop iterates over arrays, extracting keys and values (including associative and indexed arrays) and echoes results to show country and team pairs.

Discover how PHP for loops iterate by index or array, using count() to set limits, with a cars example showing each item.

Learn how the while loop repeats actions by initializing a counter, testing a condition like x < n, and incrementing the counter through practical PHP examples.

Explore the PHP do-while loop, a variant of the while loop that runs at least once before checking the condition, with practical examples showing repeated iterations.

Explore how PHP branch statements control data retrieval by using break and continue inside loops. Learn to filter items from an array by skipping or stopping the loop.

Explore PHP class types, properties, and methods, including public, private, protected, and static access, and learn how classes act as blueprints for objects.

Explore php classes by building a standard class that extends one parent or abstract class, inherits properties and methods, and uses interfaces and traits, with php 7.4 type declarations.

Learn how a standard class extends another, inheriting the parent’s properties and methods, and access public and static members via an object—note abstract classes cannot be instantiated.

Explore PHP abstract classes, show that you cannot instantiate them, demonstrate extending with standard classes, and abstract methods without bodies, while previewing interfaces.

Explore PHP interfaces and abstract classes as contracts that define methods without bodies, show how to implement them across multiple classes, and compare traits for reusing methods.

Learn how PHP include and require insert files into a script, how include_once prevents multiple inclusions, and how errors occur when a file is not found.

Explore the PHP require function, contrast it with include, and learn how repeated requires trigger fatal errors or warnings, while using require_once to load files only once.

Explore how PHP include and require statements work, including include_once, using them as functions or statements, and handling file paths with examples.

Explore php 5 and 7 superglobals in a hands-on backend setup using Bootstrap for the frontend, local xampp development, and a modular project structure to connect to a MySQL database.

Learn how to use the PHP $_GET superglobal to read form data submitted via the get method, check keys with isset, and handle query string parameters in a web page.

Learn how to use the PHP $_POST superglobal to receive form data, set name attributes, detect post submissions, validate inputs, and prepare data for database storage.

Explore the PHP superglobal $_REQUEST and how it retrieves data from GET and POST forms. Implement request handling for different submissions, and preview the next lesson on the five superglobals.

Explore how PHP handles file uploads with the $_FILES superglobal, including form submission, multipart data, checking file type and size, and storing and displaying images in a MySQL database.

Learn to use php's super global $_COOKIE to set and read cookies with setcookie, specifying name, value, expiry, path, domain, and secure options, and delete cookies when needed.

Explore how PHP sessions use the $_SESSION superglobal to manage login state by starting a session, storing the user email, and destroying it on logout.

Master php server file handling by writing, appending, and reading data with fopen, fwrite, and fclose, and parse csv with fgetcsv while exploring api calls with guzzle and http.

Learn to send emails from your PHP website by configuring a free email service, creating credentials, and enabling sendmail in php.ini to implement user verification emails.

Explore the MySQL database structure by creating databases and tables, managing user accounts and privileges, applying constraints, and performing export and import operations.

Learn to connect to a MySQL database in PHP using PDO and MySQLi by crafting a class with a constructor that receives credentials, configuring settings, and testing the connection securely.

Explore SQL as the language for storing, querying, and manipulating data in relational databases, using tables, columns, and core commands like select, insert, update, and delete.

Master how to create and drop a MySQL database using SQL commands, work with the database admin panel or command line, and prepare to create tables in the next lecture.

Create, alter, and drop tables from within a PHP script connected to a MySQL database, using a sample members table with member_id, username, email, and password.

Master sql constraints to enforce accuracy by using not null, unique, primary key, foreign key, and check, with column and table options, and learn to add, drop, and index them.

Explore SQL constraints, including column and table level checks, defaults, primary keys, and unique constraints, and learn to create, alter, and drop them in table definitions.

Explore how indexes optimize queries, create and drop indexes on columns, and enforce constraints like primary keys and foreign keys, including cascade rules and auto increment, in MySQL.

Master SQL statements and clauses by building a dynamic website backend, focusing on insert statements, user registration, and category creation in MySQL databases.

learn to build and style a registration form with bootstrap, set up templates and navigation, and prepare form submissions with post requests and server-side handling in php.

Learn to create new users with PHP 5 and 7 and MySQL by validating inputs, securing data, inserting user records, hashing passwords, and sending activation emails for verification.

This lecture moves to the back end, showing how to create a category in the admin area, define a categories table, validate input, and insert via post.

Use the select statement to retrieve categories and populate a post form. Validate input, upload images, and insert posts into a MySQL database.

Learn to write direct select queries to fetch all categories and posts from a database, populate the categories and posts tables, and display data with description and content.

Learn to delete a post or record in a PHP and MySQL app by selecting with limit 1, verifying existence, deleting the database entry, and unlinking the image file.

Update records in a MySQL database using the update statement, set new values, and apply a where clause, while prepopulating a form for edits and handling image changes.

Explore updating posts with or without images, including strict image validation and conditional image handling, in PHP 5 and 7 with MySQL.

Learn to verify users in a PHP 5 and 7 MySQL app by starting a session, sending a verification email, updating the verified flag, and enforcing login.

Verify users and manage login flow with success and error messages. Implement sessions, bootstrap alerts, and password verification to safeguard access.

Implement a robust authentication layer using sessions to protect admin and public pages, enforce login and logout flows, and redirect unauthenticated users to the login page.

Explore how to implement sql like operators and wild cards in php 5/7, enabling and, or, not searches across posts and descriptions.

Master SQL ordering with the order by keyword and null tests; learn to sort by a chosen column in ascending or descending order and filter by null checks.

Explore how the SQL IN and BETWEEN operators filter data by matching a column to a set of values or a numeric range, with practical examples.

Explore the min, max, count, avg, and sum functions in MySQL. See how to implement these aggregates in queries against a table such as posts, with simple examples.

Discover SQL aliases that temporarily rename columns and tables for readability. Use select column as alias and apply aliases to post image, title, and description.

Explore SQL joins—inner, left, right, and full outer join—and learn to implement them to combine posts and categories, selecting columns from both tables.

Explore self joins within a single SQL table to pair customers by name and city, and use union and union all to merge data from multiple tables with matching columns.

Learn to use the group by clause in MySQL to group posts by category or country, count posts per group, and view results ordered by count.

Learn how the having clause filters aggregated results after group by, using count and order by, and how the exists operator tests for related records via subqueries.

Explore the any and all operators in SQL, learn how to use them with where and having clauses, and see practical examples across related tables.

Explore the SQL case clause and the when, then, else logic in MySQL, and see how to apply case expressions to categorize data while discussing SQL injection.