Build Real Estate Management System with PHP & MySQL

Install and configure Laragon on Windows to run a local web stack with Apache and MySQL, access phpMyAdmin, and enable root access by adjusting allow no password, then test localhost/test.psp.

Learn to install XAMPP on Mac, start Apache and MySQL, verify phpMyAdmin, and run a simple project from the apps folder using a sample index dot PSP file in localhost.

Download and install VS Code on Windows from the official site, accept the default drive settings, and launch the editor to work with your project folders.

Open and manage a project in Visual Studio Code by adding single or multiple folders, using open folder, and launching code from the command line to set up workspaces.

Create and use code snippets in VS Code to automate repeated HTML and PHP blocks, define prefix, body, and description, and insert multi-line code across files.

Install the bootstrap five quick snippets extension in VSCode and insert bootstrap five code snippets to quickly scaffold boilerplate, containers, accordions, headings, and tables, then preview the results.

Install the auto rename tag extension and learn how renaming an opening HTML tag automatically updates the closing tag, speeding up coding and project development.

Install the VSCode great icons extension to enable a blue icon set in the explorer, providing distinct CSS and JavaScript icons and improving file and folder visuals.

Create a .php file in a local server folder and run it to print output in the browser using echo. Embed HTML in PHP and echo results.

Learn how variables work in PHP, including storage location, associated names, and changeable values such as strings, integers, and arrays. Master variable naming rules, assignment, and output in PHP scripts.

Explore echo and print in PHP, comparing output behavior, return values, parameter usage, and syntax with or without parentheses. Learn how to print text and HTML to the browser efficiently.

Explore PHP data types, including string, integer, float, boolean, array, object, null, and resource, with examples of strings, echo, and type checks like is_int.

Learn how strings work in PHP, including declaring string variables and escaping quotes with backslashes to display text like Peter's car or Bangladesh is a beautiful country.

Understand the switch statement in PSP, testing a value against multiple cases with switch, case, and break. A default handles unmatched values, demonstrated with a country example.

Explore PHP loops including while, do-while, for, and foreach, with practical examples and key concepts like initialization, condition, increment, break, and handling infinite loops.

Explore nested loops in programming, using outer and inner loops and for loops to print pyramid patterns and number sequences across multiple rows.

Understand how PHP sessions store per-user data across pages, start sessions with session_start, use $_SESSION, and modify and destroy them, then build a simple login with redirects and access control.

Learn how to send email in PSP using the PSP mailer library or APIs, with SMTP configuration, testing via mail trap, and optional attachments.

Explore regular expressions to validate Bangladeshi phone numbers and emails, implement anchors and character classes, and use preg_replace for string substitution while understanding case sensitivity and pattern options.

Learn how to connect PHP with MySQL using the MySQL extension, mysqli, and PDO, compare object-oriented and procedural approaches, and use prepared statements to prevent SQL injection.

Explore the join clause, including inner, left, right, and full joins, with practical examples of combining rows from related tables using primary and foreign keys.

Master the union clause and union all to combine two select statements into result set, requiring same column count and data types; union yields unique rows, union all yields duplicates.

Protect folder contents by preventing directory listings with empty index files and options indexes. Avoid exposing sensitive data by placing JSON inside a PHP file rather than in data.json.

Set up a PHP authentication template system with modular header and footer, implement registration, email verification, login, and password reset, and configure a MySQL database.