Build Real Estate Management System With Php (8.2) & Mysql

Learning PHP and MySQL (A to Z) and developing a complete dynamic real estate listing website. PHP 8.2 is used here.

What you'll learn

Learn PHP from scratch

Learn MySQL from scratch

Learn the using of PDO in PHP

Visual Studio Code Editor and plugins in that

Variables, Data types, Strings in php

Operators in php

Array, Multi-dimensional Array and Array functions

Conditions in php (if, elseif, else)

Loops (for, while and dowhile), Nested Loop

Functions in php (built-in and user-defined)

Switch case using in php

$_POST, $_GET, $_REQUEST

Session and Cookies

Using Regular Expression in PHP

File Upload and Validation, File I/O

Database Basic, Query Language

Connecting Database in PHP

Form Validation Technique

Basic CRUD Operation

Login, Registration and Forget Password System

Email verification in registration

Payment Method Integration - PayPal

Payment Method Integration - Stripe

Contact form email sending

Website logo, favicon and other items setup

Admin profile management

Photo uploading system

Toastr message notification system

Customer and Agent Profile Management

Customer and Agent Login and Registration

Pricing Package Management

Advanced Real Estate Searching Option

Uploading Project to Live Server

Requirements

Basic knowledge in HTML

Basic knowledge in CSS

Basic knowledge in Javascript

Basic knowledge in Bootstrap

Basic knowledge in Code Editor like VS Code or any

Description

In this course, I have taught the students the most popular programming language PHP and MySQL database from scratch. After showing all the basics of PHP, authentication system, security, template mastering etc., I have developed a complete real estate listing web application with the latest version of PHP and that is PHP 8.2The persons who are very beginner in php or have no knowledge at all in PHP, they will be benefitted the most from this course. But the advanced persons will also get help from this course, because I have tried to show all the real life features of a real estate applications with advanced features.Application Features:Search features in the home pageAdvanced search features in the properties pageURL rewrite option using a htaccess file. So in the front end, there will be no .php extensions. Ajax form submission with page refresh.Optimized query added in some sections in order to load data faster instead of nested queries.Uploading task in web server using cpanel was shown in this project. Admin Panel Features:Admin can change logo, favicon etc. Admin can change footer information.Admin can update the home page information. Admin can update the FAQ page information. Admin can control the FAQ SectionAdmin can update the contact page map. Admin can create, edit and delete blog posts.Admin can create, edit and delete listing types.Admin can create, edit and delete listing locations.Admin can create, edit and delete listing amenities.Admin can create, edit and delete why choose us sectionAdmin can create, edit and delete testimonials.Admin can send email to subscribersAdmin can see all the agent profiles and can delete themAdmin can make agent active or inactiveAdmin can see all the properties sections added by agentsAdmin can see all the orders and delete thoseAdmin can see all the customer profiles and can delete themAdmin can make customer active or inactiveAdmin can change his own photo, information and passwordAdmin can create, edit and delete his own listingsAdmin can update the privacy policy page information. Admin can update the terms and conditions page information. Agent Features:Agent can create account for freeAgent can login and reset his password if necessaryAgent can change profile informationAgent can buy package using PayPal and StripeAgent can renew package anytimeAgent can see order historyAgent can create, edit and delete propertiesAgent can create and delete photos per propertiesAgent can create and delete videos per propertiesAgent can reply to customer messagesApplied security so that non-subscribed agents can not add property.Applied security so that if order is expired, then agent can not have access to his properties add list until he renew his packages. Customer Features:Customer can create account for freeCustomer can login and reset his password if necessaryCustomer can change profile informationCustomer can add properties in wishlistCustomer can create or delete messagesCustomer can reply to agent messages

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Local Server Setup (Windows OS)

Lecture 2 Installing XAMPP

Lecture 3 Shift between php 7 and php 8 in XAMPP

Lecture 4 Installing Laragon

Lecture 5 Shift between php 7 and php 8 in Laragon

Lecture 6 Install PHP 8.2 in Laragon

Section 3: Local Server Setup (Mac OS)

Lecture 7 Installing XAMPP

Lecture 8 Installing MAMP

Lecture 9 Shift between php 7 and php 8 in MAMP

Section 4: Code Editors

Lecture 10 Code Editors

Section 5: Visual Studio Code Editor

Lecture 11 VS Code Installation

Lecture 12 Opening Folders (Single and Multiple)

Lecture 13 Autosave

Lecture 14 Installing Extensions

Lecture 15 Export Settings

Lecture 16 Reset VS Code

Lecture 17 Creating and Working with Snippets

Lecture 18 Extension - Bootstrap 5 Quick Snippets

Lecture 19 Extension - Auto Rename Tag

Lecture 20 Extension - Material Icon Theme

Lecture 21 Extension - Vscode Great Icons

Lecture 22 Extension - Live Server

Lecture 23 Extension - Live Server Preview

Lecture 24 Extension - HTML CSS Support

Lecture 25 Color Scheme

Lecture 26 Working with Terminal

Lecture 27 Settings Sync

Section 6: PHP Fundamentals - A to Z

Lecture 28 What is PHP

Lecture 29 PHP Syntax

Lecture 30 Comments

Lecture 31 Variables

Lecture 32 Variable Scope

Lecture 33 Echo and Print

Lecture 34 Data Types

Lecture 35 Type Casting

Lecture 36 String - Part 1

Lecture 37 String - Part 2

Lecture 38 String - Part 3

Lecture 39 Number

Lecture 40 Math

Lecture 41 Constant

Lecture 42 Operator - Part 1

Lecture 43 Operator - Part 2

Lecture 44 Operator - Part 3

Lecture 45 Conditional Statement (if, elseif, else)

Lecture 46 Switch

Lecture 47 Loop - Part 1

Lecture 48 Loop - Part 2

Lecture 49 Nested Loop - Part 1

Lecture 50 Nested Loop - Part 2

Lecture 51 Array - Part 1

Lecture 52 Array - Part 2

Lecture 53 Array - Part 3

Lecture 54 Array Function

Lecture 55 Function

Lecture 56 Superglobals

Lecture 57 Form, $_GET, $_POST, $_REQUEST

Lecture 58 Cookie - Part 1

Lecture 59 Cookie - Part 2

Lecture 60 Session

Lecture 61 Include, Require

Lecture 62 File Upload and Validation - Part 1

Lecture 63 File Upload and Validation - Part 2

Lecture 64 File IO

Lecture 65 Form Validation

Lecture 66 Sending Email

Lecture 67 Regular Expression - Part 1

Lecture 68 Regular Expression - Part 2

Section 7: MySQL Database

Lecture 69 What is MySQL

Lecture 70 Connect MySQL with PHP

Lecture 71 Create Database and Table

Lecture 72 Inserting Data

Lecture 73 Prepared Statement

Lecture 74 Select Data

Lecture 75 Where Clause

Lecture 76 Update Data

Lecture 77 Delete Data

Lecture 78 Order By Clause

Lecture 79 LIMIT Clause

Lecture 80 JOIN Clause

Lecture 81 UNION Clause

Lecture 82 ALTER Table

Lecture 83 GROUP BY and HAVING

Section 8: PHP Security

Lecture 84 Folder Content Protection

Lecture 85 Least Privilege

Lecture 86 SQL Injection

Lecture 87 XSS Attack

Section 9: Pagination

Lecture 88 Pagination

Section 10: Authentication System

Lecture 89 Template Setup

Lecture 90 Registration

Lecture 91 Registration - Email Verification

Lecture 92 Login and Logout

Lecture 93 Forget Password

Lecture 94 Reset Password

Lecture 95 Source Codes

Section 11: Payment Method Integration

Lecture 96 PayPal - Part 1

Lecture 97 PayPal - Part 2

Lecture 98 Stripe - Part 1

Lecture 99 Stripe - Part 2

Lecture 100 Source Codes

Section 12: Admin Panel Template Mastering

Lecture 101 Describing HTML Template

Lecture 102 Separate Dashboard and Login

Lecture 103 Config File and Mailtrap Setup

Lecture 104 Moving all data into admin folder

Lecture 105 Creating Users Table and Developing Login & Logout System

Lecture 106 Forget Password

Lecture 107 Reset Password

Lecture 108 Edit Profile - Part 1

Lecture 109 Edit Profile - Part 2

Lecture 110 Other Pages

Lecture 111 Source Codes

Section 13: Front End Template

Lecture 112 Describing the Front End Template

Lecture 113 Source Codes

Section 14: Front End Template Mastering

Lecture 114 Rename Admin Panel Folder to Real Estate Project

Lecture 115 Home Page Setup

Lecture 116 Creating an intermediate page between user and agent

Lecture 117 Using .htaccess file to rewrite url (Removing .php extention)

Section 15: Customer Section

Lecture 118 Registration - Part 1

Lecture 119 Registration - Part 2

Lecture 120 Verify Registration

Lecture 121 Login, Dashboard and Logout

Lecture 122 Forget Password

Lecture 123 Reset Password

Lecture 124 Edit Profile

Section 16: Agent Section

Lecture 125 Registration

Lecture 126 Verify Registration

Lecture 127 Login, Dashboard and Logout

Lecture 128 Forget Password

Lecture 129 Reset Password

Lecture 130 Edit Profile

Lecture 131 Pending Agent and Customer Login Protection

Section 17: Admin - Notification

Lecture 132 iziToast Notification

Section 18: Package

Lecture 133 Package - Part 1

Lecture 134 Package - Part 2

Lecture 135 Package - Part 3

Lecture 136 Package - Part 4

Lecture 137 Package - Part 5

Section 19: Property Location

Lecture 138 Property Location - Part 1

Lecture 139 Property Location - Part 2

Lecture 140 Property Location - Part 3

Lecture 141 Property Location - Part 4

Lecture 142 Property Location - Part 5

Section 20: Property Type

Lecture 143 Property Type - Part 1

Lecture 144 Property Type - Part 2

Lecture 145 Property Type - Part 3

Lecture 146 Property Type - Part 4

Lecture 147 Property Type - Part 5

Section 21: Amenity

Lecture 148 Amenity - Part 1

Lecture 149 Amenity - Part 2

Section 22: Agent - Package Purchase

Lecture 150 Package Purchase - Part 1

Lecture 151 Package Purchase - Part 2

Lecture 152 Package Purchase - Part 3

Section 23: Agent - Orders

Lecture 153 Show Orders

Section 24: Agent - Property Manage

Lecture 154 Creating Tables

Lecture 155 Add Property - Part 1

Lecture 156 Add Property - Part 2

Lecture 157 Add Property - Part 3

Lecture 158 Show Properties - Part 1

Lecture 159 Show Properties - Part 2

Lecture 160 Show Properties - Part 3

Lecture 161 Edit Property

Lecture 162 Photo Gallery - Part 1

Lecture 163 Photo Gallery - Part 2

Lecture 164 Video Gallery

Lecture 165 Delete Property

Section 25: Adding Sample Data

Lecture 166 Creating Agents

Lecture 167 Creating Properties

Section 26: Featured Property Setup

Lecture 168 Featured Property Setup

Section 27: Security Checking in Some Modules

Lecture 169 Agent - Duplicate Email Checking in Signup & Edit Profile

Lecture 170 Customer - Duplicate Email Checking in Signup & Edit Profile

Lecture 171 Preventing Location, Type & Amenity Name Duplication - Part 1

Lecture 172 Preventing Location, Type & Amenity Name Duplication - Part 2

Lecture 173 Giving Security in Location, Type & Amenity Deletion - Part 1

Lecture 174 Giving Security in Location, Type & Amenity Deletion - Part 2

Lecture 175 Agent can not edit or delete other agent's peoperty

Lecture 176 Apply exit after each redirection

Lecture 177 Non-subscribed Agents can not add property

Lecture 178 Agent Package Limitation Check for Property, Photos & Videos

Lecture 179 When Package Expires, Agent can not add property

Lecture 180 Package Downgrade - What will happen with Previous Data

Section 28: Home Page - Featured Properties

Lecture 181 Featured Properties - Part 1

Lecture 182 Featured Properties - Part 2

Section 29: Properties Search Section

Lecture 183 Search Section - Part 1

Lecture 184 Search Section - Part 2

Lecture 185 Search Section - Part 3

Lecture 186 Search Section - Part 4

Lecture 187 Search Section - Part 5

Lecture 188 Search Section - Part 6

Lecture 189 Search Section - Part 7

Section 30: Property Detail Page

Lecture 190 Property Detail - Part 1

Lecture 191 Property Detail - Part 2

Lecture 192 Property Detail - Part 3

Lecture 193 Property Detail - Part 4

Lecture 194 Property Detail - Part 5

Lecture 195 Property Detail - Part 6

Section 31: Location-Wise Properties

Lecture 196 Part 1

Lecture 197 Part 2

Section 32: Agent-Wise Properties

Lecture 198 Part 1

Lecture 199 Part 2

Lecture 200 Part 3

Lecture 201 Part 4

Lecture 202 Part 5

Section 33: Customer - Wishlist

Lecture 203 Part 1

Lecture 204 Part 2

Section 34: Message between Customer and Agent

Lecture 205 Creating database, tables, view message table, create message form

Lecture 206 Sending message by customer, save data & email receive by agent

Lecture 207 Reply page create and setup the forms and contents

Lecture 208 Sending reply by customer, save data & email receive by agent

Lecture 209 Show all replies by customer & agent, message deletion by customer

Lecture 210 Sending reply by agents, save data, email receive by customers

Section 35: Admin - Agent Property Section

Lecture 211 Show all properties

Lecture 212 Delete property

Section 36: Admin - Agent Orders

Lecture 213 Show all orders

Lecture 214 Delete Order

Section 37: Admin - Agent and Customer Message

Lecture 215 Show all messages

Lecture 216 Show replies

Lecture 217 Delete message

Section 38: Admin - Agents and Customers Information

Lecture 218 Show customers

Lecture 219 Make customers active or inactive

Lecture 220 Delete customer

Lecture 221 Show agents

Lecture 222 Make agents active or inactive

Lecture 223 Delete agent

Section 39: Why Choose Us

Lecture 224 Part 1

Lecture 225 Part 2

Section 40: Testimonial

Lecture 226 Part 1

Lecture 227 Part 2

Section 41: Blog

Lecture 228 Part 1

Lecture 229 Part 2

Lecture 230 Part 3

Section 42: FAQ

Lecture 231 Part 1

Lecture 232 Part 2

Section 43: Contact

Lecture 233 Sending email using contact form

Section 44: Newsletter

Lecture 234 Part 1

Lecture 235 Part 2

Section 45: Automatically Logout System

Lecture 236 Making admin, agent, customer logged out automatically after certain period

Section 46: Terms & Privacy Page

Lecture 237 Part 1

Lecture 238 Part 2

Section 47: Dashboard Setup

Lecture 239 Customer & Agent Dashboard

Lecture 240 Admin Dashboard

Section 48: Website Settings

Lecture 241 Logo and Favicon

Lecture 242 Banner Photo

Lecture 243 Footer Section

Lecture 244 Contact Page Map

Lecture 245 Home Page Sections - Part 1

Lecture 246 Home Page Sections - Part 2

Lecture 247 Home Page Sections - Part 3

Lecture 248 Home Page Sections - Part 4

Section 49: Upload Project to Live Server

Lecture 249 Part 1

Lecture 250 Part 2

Section 50: Final Source Code

Lecture 251 Final Code

Persons who want to learn php 8.2 from scratch,Persons who want to learn mysql from scratch,Persons who are looking for a good job in web development sector,Persons who want to have a remote job in php,Persons who want to start his freelancing career using php,Persons who want to learn making a real estate listing application