The Complete PHP MYSQL Professional Course with 5 Projects

Master the local PHP and MySQL setup by installing a bundled Zahm server with Apache, PHP 5.6, and MySQL, then use a text editor and browser to run projects locally.

Download and install Zahm server locally, start Apache and MySQL via the Zahm control panel, choose the version for Windows, Linux, or Mac, and test PHP on localhost.

Explore choosing any code editor, from free notepad plus plus to komodo ide, sublime, and code lobster, with notes on installation and cross-platform options.

Set up a local PHP development environment with Apache and MySQL, access files via localhost, and embed PHP in HTML using basic tags and echo.

Learn how variables work in PHP: names start with $, rules for dashes, underscores, and case sensitivity, and how to store and echo values in simple examples.

Define constants in PHP using the define keyword, assigning unchangeable values like pi and gravity. See how constants differ from variables and why redefining them causes errors.

Explore PHP strings by using double and single quotes, variable interpolation, and the dot operator for concatenation. Master string functions such as strtoupper, strtolower, str_repeat, strlen, strpos, substr, and str_replace.

Learn to manipulate real numbers in PHP, using integers and floats, perform arithmetic, apply ceiling and floor, check numeric types, and explore random numbers and basic mathematical functions.

Learn how arrays power data handling in PHP, including numeric and associative arrays, indexing, key access, and basic operations like adding items and printing structure.

Explore php arrays by pushing and popping items, counting elements, finding max and min, testing with in_array, then sort, and using implode to join and explode to split strings.

Discover how PHP arrays behave internally, traverse numeric arrays with a next pointer, reset pointers, and explore end-of-array behavior through practical echo and print examples.

Learn how conditional statements work in PHP using if, else, and else-if, with practical examples such as gym access by ID, homework completion, and payment dispatch.

Explore PHP operators, including assignment, equality, strict and not equal, comparisons, logical operators, and the ternary operator, with notes on precedence and typical usage.

Learn to use PHP for loops to display data by printing numbers 1 through 10 with echo, define initial values, conditions, and increments, and generate a multiplication table of 2.

Compare while loops with for loops by placing initial value, condition, and increment in distinct places. Demonstrate a PHP example that echoes a message 15 times using a while loop.

Use foreach loops to traverse simple and associative arrays in PHP, iterating keys and values. Format output with echo, apply ucwords and str_replace, and validate prices with is_numeric.

Explore how switch statements streamline conditional logic by defining cases, using break, and a default clause. See practical PHP examples, including weather conditions and access permissions, with grouped cases.

Learn how branching statements, including continue and break, control loops in PHP, with examples using arrays, data access, and efficient looping to optimize time complexity.

Define and reuse your own PHP user-defined functions using the function keyword, parameters, and return values to encapsulate logic and avoid repetition.

Master re-usability by defining functions once and calling them across files with function parameters. Learn to include or require function files, linking code across files to reduce repetition.

Explore static variables in php and compare them with normal variables by using a function to show how static values persist across calls while normal values reset.

Explore local variables and their function scope, showing how a, b, and c declared inside a function remain inaccessible outside. The lesson demonstrates undefined variable errors and previews global variables.

Learn how global variables differ from local variables and how to access them inside functions by declaring them global.

Explore the concept and usage of super global variables in PHP, including global, server, request, post, environment, and cookies, and learn how to access them across functions and files.

Learn to build PHP forms that post data using the super global variables, connecting username and password fields and setting the action attribute, plus checking with if statements.

Explore multi-file PHP form handling by posting data between files, reading $_POST, validating username and password, and providing feedback through simple echoes and defaults.

Learn how to use regular expressions to validate forms by matching patterns with literals, quantifiers, anchors, and escapes to ensure data is valid.

Create and test regular expressions using editors and the project one on one dot com tool; define patterns for names, emails, and websites with proper ranges and anchors.

Create a single regular expression to validate website names and addresses by handling http(s) two forward slashes and other protocols, escaping slashes, and allowing letters, digits, and symbols.

Master regular expressions to secure enterprise applications and perform robust validations across languages. Learn to build patterns for names, emails, URLs, IPs, dates, postal codes, credit cards, and passwords.

This lecture covers building a BHB form validation app with PHP and MySQL, validating name, email, gender, and website formats, handling errors, and submitting data to a database.

Practice form validation in a single PHP file by validating name, email, gender, and website fields on submit, using a reusable input function and dynamic error messages; optional comment field.

Add regex-based constraints to the name, email, and website fields using preg_match to ensure only letters and spaces and proper formats, with clear error messages.

Improve form validation by echoing submitted data and enforcing name, email, and website checks with nested ifs, regular expressions, and optional comments.

Apply css styling to a form validation project, including styling inputs and error messages, and learn how to send validated data to email or a database.

Learn to send email locally using localhost and install version 3.2.1. Understand how sender and receiver servers and spam filters impact delivery, with hosting guidance for live setup.

Configure your local host to send emails with PHP by editing sendmail settings and using the mail() function with Gmail SMTP, including subject, body, headers, and test emails.

Implement and validate a form in PHP to send emails using the mail function, build the email body with user data, and apply regular expressions for robust validation.

Master building URLs with the GET super global in PHP, handling spaces with plus signs, and choosing urlencode or rawurlencode for query strings.

Create and pass data between PHP pages with GET variables in hyperlinks, then read and display name and position using $_GET and URL encoding.

Build a dynamic php web app that restricts access to select pages, shows friendly errors for unauthorized requests, and demonstrates page privileges across home, about, contact, and share.

Build a reusable dynamic web layout with a common header, sidebar, and content area, then convert static pages into dynamic PHP pages via a single index file.

Build dynamic web pages with PHP by scanning a pages directory, routing based on a query parameter, and including page files like about, contact, home, and share with friend.

Learn to build dynamic web pages by using include statements, manage page names and search parameters, and ensure forms submit correctly without affecting other pages.

Cookies are a client-side mechanism stored in your browser that remember login details and persist across visits. Learn how servers send cookies in responses and how to create cookies.

Learn how to set cookies in PHP using the setcookie function, configuring name, content, and expiry in seconds, and verify them in the browser on localhost.

Learn how to unset cookies in PHP by expiring them in the past, setting empty values, or using null, and apply header timing when managing cookies.

Explore PHP sessions, a server-side approach that uses session_start() to store data in $_SESSION and persists across pages until the browser closes, offering advantages over cookies.

Explore the PHP server super global to access server name, address, port, document root, and user details like remote address, HTTP referer, and user agent for developer debugging and tracking.

Build a simple employee data app to create, read, update, delete, and search records in a database, teaching basic crud techniques for starter projects.

Create a PHP database app with a form that posts to insert into the database, enabling insert, update, delete, and search of employee records.

Create a database named record collector and a table emp_it using phpMyAdmin, define six columns with id as auto increment primary key, and set appropriate column types for data insertion.

Learn to create a PHP connection file, configure a DSN for localhost and the database, and securely insert data using prepared statements with named parameters to prevent sql injection.

Learn what SQL injection is, how attackers exploit form inputs to damage or steal data, and how to prevent it using prepared statements with named parameters in PDO.

Learn to insert data into a database using prepared statements with named parameters, bind value, and execute, while sanitizing input to prevent sql injection and adding validation.

Fetch and display records from a MySQL database using PHP, rendering them in a bordered table with id, name, ssn, salary, address, and department, plus update and delete links.

Show how to display and edit a record on an update page by retrieving the id via get, querying the database, and pre-filling a form with current data.

Update data in a PHP MySQL app by submitting a post form that targets a record by ID, runs an update query, and redirects with a success message.

Demonstrates deleting records in a PHP MySQL app by turning an update page into a delete workflow, adjusting the form action, and returning to the view page with success message.

Learn to build a PHP and MySQL search feature that queries by name or SSN using a form, prepared statements, and fetch results displayed in a table.