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
Course content
50 sections • 251 lectures • 47h 58m total length
1. Introdction
Available in
days
days
after you enroll
2. Local Server Setup (Windows OS)
Available in
days
days
after you enroll
3. Local Server Setup (Mac OS)
Available in
days
days
after you enroll
4. Code Editors
Available in
days
days
after you enroll
5. Visual Studio Code Editor
Available in
days
days
after you enroll
- 1. VS Code Installation (2:45)
- 2. Opening Folders (Single and Multiple) (4:35)
- 3. Autosave (2:33)
- 4. Installing Extensions (4:53)
- 5. Export Settings (2:25)
- 6. Reset VS Code (2:16)
- 7. Creating and Working with Snippets (13:10)
- 8. Extension - Bootstrap 5 Quick Snippets (4:56)
- 9. Extension - Auto Rename Tag (1:57)
- 10. Extension - Material Icon Theme (1:51)
- 11. Extension - Vscode Great Icons (1:41)
- 12. Extension - Live Server (1:09)
- 13. Extension - Live Server Preview (1:53)
- 14. Extension - HTML CSS Support (1:40)
- 15. Extension - Bracket Pair Colorizer 2 (2:35)
- 16. Color Scheme (5:15)
- 17. Working with Terminal (2:23)
- 18. Settings Sync (3:56)
6. PHP Fundamentals - A to Z
Available in
days
days
after you enroll
- 1. What is PHP (10:48)
- 1.1. What is PHP
- 2. PHP Syntax (5:59)
- 2.1. PHP Syntax
- 3. Comments (4:09)
- 3.1. Comments
- 4. Variables (5:20)
- 4.1. Variables
- 5. Variable Scope (11:22)
- 5.1. Variable Scope
- 6. Echo and Print (5:34)
- 6.1. Echo and Print
- 7. Data Types (16:21)
- 7.1. Data Types
- 8. String - Part 1 (5:25)
- 9. String - Part 2 (25:33)
- 10. String - Part 3 (12:10)
- 10.1. String
- 11. Number (6:07)
- 11.1. Number
- 12. Math (10:18)
- 12.1. Math
- 13. Constant (7:01)
- 13.1. Constant
- 14. Operator - Part 1 (22:59)
- 15. Operator - Part 2 (14:45)
- 16. Operator - Part 3 (11:23)
- 16.1. Operator
- 17. Conditional Statement (if, elseif, else) (10:59)
- 17.1. Conditional Statement
- 18. Switch (4:52)
- 18.1. Switch
- 19. Loop - Part 1 (22:09)
- 20. Loop - Part 2 (9:56)
- 20.1. Loop
- 21. Nested Loop - Part 1 (23:40)
- 22. Nested Loop - Part 2 (11:33)
- 22.1. Nested Loop
- 23. Array - Part 1 (13:57)
- 24. Array - Part 2 (5:04)
- 25. Array - Part 3 (13:17)
- 25.1. Array
- 26. Array Function (19:08)
- 26.1. Array Function
- 27. Function (10:43)
- 27.1. Function
- 28. Superglobals (2:56)
- 28.1. Superglobals
- 29. Form, $_GET, $_POST, $_REQUEST (24:45)
- 29.1. Form, $_GET, $_POST, $_REQUEST
- 30. Cookie - Part 1 (10:02)
- 31. Cookie - Part_2 (25:52)
- 31.1. Cookie
- 32. Session (16:52)
- 32.1. Session
- 33. Include Require (7:46)
- 34. File Upload and Validation - Part 1 (32:17)
- 35. File Upload and Validation - Part 2 (15:10)
- 35.1. File Upload and Validation
- 36. File IO (15:36)
- 36.1. File IO
- 37. Form Validation (29:06)
- 37.1. Form Validation
- 38. Sending Email (13:44)
- 38.1. Sending Email
- 39. Regular Expression - Part 1 (19:46)
- 40.Regular Expression - Part 2 (14:02)
- 40.1. Regular Expression
7. MySQL Database
Available in
days
days
after you enroll
- 1. What is MySQL (16:31)
- 2. Connect MySQL with PHP (9:10)
- 3. Create Database and Table (10:31)
- 4. Inserting Data (6:57)
- 5. Prepared Statement (8:12)
- 6. Select Data (24:57)
- 7. Where Clause (18:30)
- 8. Update Data (2:32)
- 9. Delete Data (4:03)
- 10. Order By Clause (3:23)
- 11. LIMIT Clause (5:25)
- 12. JOIN Clause (31:16)
- 13. UNION Clause (7:26)
- 14. ALTER Table (5:29)
- 15. GROUP BY and HAVING (9:38)
8. PHP Security
Available in
days
days
after you enroll
9. Pagination
Available in
days
days
after you enroll
10. Authentication System
Available in
days
days
after you enroll
11. Payment Method Integration
Available in
days
days
after you enroll
12. Admin Panel Template Mastering
Available in
days
days
after you enroll
- 1. Describing HTML Template (4:33)
- 2. Separate Dashboard and Login (8:46)
- 3. Config File and Mailtrap Setup (8:30)
- 4. Moving all data into admin folder (18:29)
- 5. Creating Users Table and Developing Login & Logout System (30:11)
- 6. Forget Password (16:37)
- 7. Reset Password (8:45)
- 8. Edit Profile - Part 1 (17:03)
- 9. Edit Profile - Part 2 (16:19)
- 10. Other Pages (9:12)
- 11. Source Codes
13. Front End Template
Available in
days
days
after you enroll
14. Front End Template Mastering
Available in
days
days
after you enroll
15. Customer Section
Available in
days
days
after you enroll
16. Agent Section
Available in
days
days
after you enroll
17. Admin - Notification
Available in
days
days
after you enroll
18. Package
Available in
days
days
after you enroll
19. Property Location
Available in
days
days
after you enroll
20. Property Type
Available in
days
days
after you enroll
21. Amenity
Available in
days
days
after you enroll
22. Agent - Package Purchase
Available in
days
days
after you enroll
23. Agent - Orders
Available in
days
days
after you enroll
24. Agent - Property Manage
Available in
days
days
after you enroll
- 1. Creating Tables (12:06)
- 2. Add Property - Part 1 (15:47)
- 3. Add Property - Part 2 (24:27)
- 4. Add Property - Part 3 (14:00)
- 5. Show Properties - Part 1 (11:19)
- 6. Show Properties - Part 2 (12:16)
- 7. Show Properties - Part 3 (8:55)
- 8. Edit Property (23:33)
- 9. Photo Gallery - Part 1 (13:40)
- 10. Photo Gallery - Part 2 (8:25)
- 11. Video Gallery (11:46)
- 12. Delete Property (9:16)
25. Adding Sample Data
Available in
days
days
after you enroll
26. Featured Property Setup
Available in
days
days
after you enroll
27. Security Checking in Some Modules
Available in
days
days
after you enroll
- 1. Agent - Duplicate Email Checking in Signup & Edit Profile (7:06)
- 2. Customer - Duplicate Email Checking in Signup & Edit Profile (2:40)
- 3. Preventing Location, Type & Amenity Name Duplication - Part 1 (6:34)
- 4. Preventing Location, Type & Amenity Name Duplication - Part 2 (7:54)
- 5. Giving Security in Location, Type & Amenity Deletion - Part 1 (15:20)
- 6. Giving Security in Location, Type & Amenity Deletion - Part 2 (6:18)
- 7. Agent can not edit or delete other agent's peoperty (9:33)
- 8. Apply exit after each redirection (10:46)
- 9. Non-subscribed Agents can not add property (6:13)
- 10. Agent Package Limitation Check for Property, Photos & Videos (19:57)
- 11. When Package Expires, Agent can not add property (9:55)
- 12. Package Downgrade - What will happen with Previous Data (21:55)
28. Home Page - Featured Properties
Available in
days
days
after you enroll
29. Properties Search Section
Available in
days
days
after you enroll
30. Property Detail Page
Available in
days
days
after you enroll
31. Location-Wise Properties
Available in
days
days
after you enroll
32. Agent-Wise Properties
Available in
days
days
after you enroll
33. Customer - Wishlist
Available in
days
days
after you enroll
34. Message between Customer and Agent
Available in
days
days
after you enroll
- 1. Creating database, tables, view message table, create message form (18:45)
- 2. Sending message by customer, save data & email receive by agent (11:23)
- 3. Reply page create and setup the forms and contents (26:24)
- 4. Sending reply by customer, save data & email receive by agent (9:48)
- 5. Show all replies by customer & agent, message deletion by customer (26:20)
- 6. Sending reply by agents, save data, email receive by customers (31:50)
35. Admin - Agent Property Section
Available in
days
days
after you enroll
36. Admin - Agent Orders
Available in
days
days
after you enroll
37. Admin - Agent and Customer Message
Available in
days
days
after you enroll
38. Admin - Agents and Customers Information
Available in
days
days
after you enroll
39. Why Choose Us
Available in
days
days
after you enroll
40. Testimonial
Available in
days
days
after you enroll
41. Blog
Available in
days
days
after you enroll
42. FAQ
Available in
days
days
after you enroll
43. Contact
Available in
days
days
after you enroll
44. Newsletter
Available in
days
days
after you enroll
45. Automatically Logout System
Available in
days
days
after you enroll
46. Terms & Privacy Page
Available in
days
days
after you enroll
47. Dashboard Setup
Available in
days
days
after you enroll
48. Website Settings
Available in
days
days
after you enroll
49. Upload Project to Live Server
Available in
days
days
after you enroll
50. Final Source Code
Available in
days
days
after you enroll
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.2
The 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 page
- Advanced search features in the properties page
- URL 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 Section
- Admin 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 section
- Admin can create, edit and delete testimonials.
- Admin can send email to subscribers
- Admin can see all the agent profiles and can delete them
- Admin can make agent active or inactive
- Admin can see all the properties sections added by agents
- Admin can see all the orders and delete those
- Admin can see all the customer profiles and can delete them
- Admin can make customer active or inactive
- Admin can change his own photo, information and password
- Admin can create, edit and delete his own listings
- Admin can update the privacy policy page information.
- Admin can update the terms and conditions page information.
Agent Features:
- Agent can create account for free
- Agent can login and reset his password if necessary
- Agent can change profile information
- Agent can buy package using PayPal and Stripe
- Agent can renew package anytime
- Agent can see order history
- Agent can create, edit and delete properties
- Agent can create and delete photos per properties
- Agent can create and delete videos per properties
- Agent can reply to customer messages
- Applied 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 free
- Customer can login and reset his password if necessary
- Customer can change profile information
- Customer can add properties in wishlist
- Customer can create or delete messages
- Customer can reply to agent messages
Who this course is for:
- 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
Check your inbox to confirm your subscription