Build Real Estate Management System with PHP (8.2) & MySQL

Focused View

Morshedul Arefin

47:58:40

23 View

1. Introduction

1. Introduction.mp4

21:52

2. Local Server Setup (Windows OS)

1. Installing XAMPP.mp4

04:32

2. Shift between php 7 and php 8 in XAMPP.mp4

09:08

3. Installing Laragon.mp4

09:42

4. Shift between php 7 and php 8 in Laragon.mp4

03:57

5. Install PHP 8.2 in Laragon.mp4

03:44

3. Local Server Setup (Mac OS)

1. Installing XAMPP.mp4

04:30

2. Installing MAMP.mp4

07:27

3. Shift between php 7 and php 8 in MAMP.mp4

07:09

4. Code Editors

1. Code Editors.mp4

01:47

5. Visual Studio Code Editor

1. VS Code Installation.mp4

02:45

2. Opening Folders (Single and Multiple).mp4

04:35

3. Autosave.mp4

02:33

4. Installing Extensions.mp4

04:53

5. Export Settings.mp4

02:25

6. Reset VS Code.mp4

02:16

7. Creating and Working with Snippets.mp4

13:10

8. Extension - Bootstrap 5 Quick Snippets.mp4

04:56

9. Extension - Auto Rename Tag.mp4

01:57

10. Extension - Material Icon Theme.mp4

01:51

11. Extension - Vscode Great Icons.mp4

01:41

12. Extension - Live Server.mp4

01:09

13. Extension - Live Server Preview.mp4

01:53

14. Extension - HTML CSS Support.mp4

01:40

15. Color Scheme.mp4

05:15

16. Working with Terminal.mp4

02:23

17. Settings Sync.mp4

03:56

6. PHP Fundamentals - A to Z

1.1 What is PHP.zip

1. What is PHP.mp4

10:48

2.1 PHP Syntax.zip

2. PHP Syntax.mp4

05:59

3.1 Comment.zip

3. Comments.mp4

04:09

4.1 Variable.zip

4. Variables.mp4

05:20

5.1 Variable Scope.zip

5. Variable Scope.mp4

11:22

6.1 Echo Print.zip

6. Echo and Print.mp4

05:34

7.1 Data Type.zip

7. Data Types.mp4

16:21

8.1 Type Casting.zip

8. Type Casting.mp4

06:36

9.1 String.zip

9. String - Part 1.mp4

05:24

10.1 String.zip

10. String - Part 2.mp4

25:33

11.1 String.zip

11. String - Part 3.mp4

12:10

12.1 Number.zip

12. Number.mp4

06:06

13.1 Math.zip

13. Math.mp4

10:18

14.1 Constant.zip

14. Constant.mp4

07:01

15.1 Operator.zip

15. Operator - Part 1.mp4

22:59

16.1 Operator.zip

16. Operator - Part 2.mp4

14:45

17.1 Operator.zip

17. Operator - Part 3.mp4

11:23

18.1 Conditional Statement.zip

18. Conditional Statement (if, elseif, else).mp4

10:59

19.1 Switch.zip

19. Switch.mp4

04:52

20.1 Loop.zip

20. Loop - Part 1.mp4

22:09

21.1 Loop.zip

21. Loop - Part 2.mp4

09:56

22.1 Nested Loop.zip

22. Nested Loop - Part 1.mp4

23:40

23.1 Nested Loop.zip

23. Nested Loop - Part 2.mp4

11:33

24.1 Array.zip

24. Array - Part 1.mp4

13:57

25.1 Array.zip

25. Array - Part 2.mp4

05:04

26.1 Array.zip

26. Array - Part 3.mp4

13:17

27.1 Array Function.zip

27. Array Function.mp4

19:07

28.1 Function.zip

28. Function.mp4

10:43

29.1 Superglobal.zip

29. Superglobals.mp4

02:56

30.1 Form, $ GET, $ POST, $ REQUEST.zip

30. Form, $ GET, $ POST, $ REQUEST.mp4

24:45

31.1 Cookie.zip

31. Cookie - Part 1.mp4

10:01

32.1 Cookie.zip

32. Cookie - Part 2.mp4

25:52

33.1 Session.zip

33. Session.mp4

16:52

34. Include, Require.mp4

07:46

35.1 File Upload and Validation.zip

35. File Upload and Validation - Part 1.mp4

32:16

36.1 File Upload and Validation.zip

36. File Upload and Validation - Part 2.mp4

15:10

37.1 File I O.zip

37. File IO.mp4

15:36

38.1 Form Validation.zip

38. Form Validation.mp4

29:06

39.1 Sending Email.zip

39. Sending Email.mp4

13:44

40.1 Regular Expression.zip

40. Regular Expression - Part 1.mp4

19:46

41.1 Regular Expression.zip

41. Regular Expression - Part 2.mp4

14:02

7. MySQL Database

1.1 What Is MySQL.zip

1. What is MySQL.mp4

16:31

2.1 Connect MySQL with PHP.zip

2. Connect MySQL with PHP.mp4

09:10

3.1 Create Database and Table.zip

3. Create Database and Table.mp4

10:31

4.1 Inserting Data.zip

4. Inserting Data.mp4

06:57

5.1 Prepared Statement.zip

5. Prepared Statement.mp4

08:11

6.1 Select Data.zip

6. Select Data.mp4

24:57

7.1 Where Clause.zip

7. Where Clause.mp4

18:30

8.1 Update Data.zip

8. Update Data.mp4

02:32

9.1 Delete Data.zip

9. Delete Data.mp4

04:03

10.1 Order By Clause.zip

10. Order By Clause.mp4

03:23

11.1 LIMIT Clause.zip

11. LIMIT Clause.mp4

05:25

12.1 JOIN Clause.zip

12. JOIN Clause.mp4

31:16

13.1 UNION Clause.zip

13. UNION Clause.mp4

07:26

14.1 ALTER Table.zip

14. ALTER Table.mp4

05:29

15.1 Group By and Having.zip

15. GROUP BY and HAVING.mp4

09:38

8. PHP Security

1.1 Security Folder Content Protection.zip

1. Folder Content Protection.mp4

11:30

2.1 Security Least Privilege.zip

2. Least Privilege.mp4

13:44

3.1 Security SQL Injection.zip

3. SQL Injection.mp4

28:06

4.1 Security XSS Attack.zip

4. XSS Attack.mp4

13:29

9. Pagination

1.1 Pagination.zip

1. Pagination.mp4

37:23

10. Authentication System

1. Template Setup.mp4

12:17

2. Registration.mp4

26:42

3. Registration - Email Verification.mp4

08:22

4. Login and Logout.mp4

18:53

5. Forget Password.mp4

12:45

6. Reset Password.mp4

11:20

7.1 Final Codes.zip

7.2 Main Template.zip

7. Source Codes.html

11. Payment Method Integration

1. PayPal - Part 1.mp4

10:18

2. PayPal - Part 2.mp4

17:57

3. Stripe - Part 1.mp4

05:03

4. Stripe - Part 2.mp4

10:20

5.1 payment integration php.zip

5. Source Codes.html

12. Admin Panel Template Mastering

1. Describing HTML Template.mp4

04:33

2. Separate Dashboard and Login.mp4

08:46

3. Config File and Mailtrap Setup.mp4

08:30

4. Moving all data into admin folder.mp4

18:29

5. Creating Users Table and Developing Login & Logout System.mp4

30:11

6. Forget Password.mp4

16:37

7. Reset Password.mp4

08:45

8. Edit Profile - Part 1.mp4

17:03

9. Edit Profile - Part 2.mp4

16:19

10. Other Pages.mp4

09:12

11.1 admin panel html.zip

11.2 admin panel php.zip

11.3 database.zip

11. Source Codes.html

13. Front End Template

1. Describing the Front End Template.mp4

11:53

2.1 front end html.zip

2. Source Codes.html

14. Front End Template Mastering

1. Rename Admin Panel Folder to Real Estate Project.mp4

07:56

2. Home Page Setup.mp4

11:26

3. Creating an intermediate page between user and agent.mp4

14:19

4. Using .htaccess file to rewrite url (Removing .php extention).mp4

09:09

15. Customer Section

1. Registration - Part 1.mp4

10:14

2. Registration - Part 2.mp4

20:02

3. Verify Registration.mp4

07:32

4. Login, Dashboard and Logout.mp4

17:49

5. Forget Password.mp4

05:12

6. Reset Password.mp4

05:35

7. Edit Profile.mp4

13:00

16. Agent Section

1. Registration.mp4

09:00

2. Verify Registration.mp4

01:51

3. Login, Dashboard and Logout.mp4

06:46

4. Forget Password.mp4

02:56

5. Reset Password.mp4

02:51

6. Edit Profile.mp4

13:21

7. Pending Agent and Customer Login Protection.mp4

04:46

17. Admin - Notification

1. iziToast Notification.mp4

03:08

18. Package

1. Package - Part 1.mp4

23:40

2. Package - Part 2.mp4

13:20

3. Package - Part 3.mp4

07:47

4. Package - Part 4.mp4

02:47

5. Package - Part 5.mp4

13:37

19. Property Location

1. Property Location - Part 1.mp4

08:14

2. Property Location - Part 2.mp4

12:16

3. Property Location - Part 3.mp4

11:43

4. Property Location - Part 4.mp4

04:13

5. Property Location - Part 5.mp4

08:39

20. Property Type

1. Property Type - Part 1.mp4

06:12

2. Property Type - Part 2.mp4

02:41

3. Property Type - Part 3.mp4

01:24

4. Property Type - Part 4.mp4

01:18

5. Property Type - Part 5.mp4

01:34

21. Amenity

1. Amenity - Part 1.mp4

05:44

2. Amenity - Part 2.mp4

02:38

22. Agent - Package Purchase

1. Package Purchase - Part 1.mp4

16:59

2. Package Purchase - Part 2.mp4

23:21

3. Package Purchase - Part 3.mp4

13:37

23. Agent - Orders

1. Show Orders.mp4

09:27

24. Agent - Property Manage

1. Creating Tables.mp4

12:05

2. Add Property - Part 1.mp4

15:47

3. Add Property - Part 2.mp4

24:27

4. Add Property - Part 3.mp4

14:00

5. Show Properties - Part 1.mp4

11:19

6. Show Properties - Part 2.mp4

12:16

7. Show Properties - Part 3.mp4

08:55

8. Edit Property.mp4

23:33

9. Photo Gallery - Part 1.mp4

13:40

10. Photo Gallery - Part 2.mp4

08:25

11. Video Gallery.mp4

11:46

12. Delete Property.mp4

09:16

25. Adding Sample Data

1. Creating Agents.mp4

20:19

2. Creating Properties.mp4

53:09

26. Featured Property Setup

1. Featured Property Setup.mp4

09:58

27. Security Checking in Some Modules

1. Agent - Duplicate Email Checking in Signup & Edit Profile.mp4

07:06

2. Customer - Duplicate Email Checking in Signup & Edit Profile.mp4

02:40

3. Preventing Location, Type & Amenity Name Duplication - Part 1.mp4

06:34

4. Preventing Location, Type & Amenity Name Duplication - Part 2.mp4

07:54

5. Giving Security in Location, Type & Amenity Deletion - Part 1.mp4

15:20

6. Giving Security in Location, Type & Amenity Deletion - Part 2.mp4

06:18

7. Agent can not edit or delete other agents peoperty.mp4

09:33

8. Apply exit after each redirection.mp4

10:46

9. Non-subscribed Agents can not add property.mp4

06:12

10. Agent Package Limitation Check for Property, Photos & Videos.mp4

19:57

11. When Package Expires, Agent can not add property.mp4

09:55

12. Package Downgrade - What will happen with Previous Data.mp4

21:55

28. Home Page - Featured Properties

1. Featured Properties - Part 1.mp4

21:03

2. Featured Properties - Part 2.mp4

16:40

29. Properties Search Section

1. Search Section - Part 1.mp4

11:29

2. Search Section - Part 2.mp4

29:20

3. Search Section - Part 3.mp4

06:51

4. Search Section - Part 4.mp4

11:33

5. Search Section - Part 5.mp4

19:19

6. Search Section - Part 6.mp4

10:33

7. Search Section - Part 7.mp4

12:55

30. Property Detail Page

1. Property Detail - Part 1.mp4

09:16

2. Property Detail - Part 2.mp4

20:43

3. Property Detail - Part 3.mp4

02:30

4. Property Detail - Part 4.mp4

15:45

5. Property Detail - Part 5.mp4

10:32

6. Property Detail - Part 6.mp4

22:58

31. Location-Wise Properties

1. Part 1.mp4

27:09

2. Part 2.mp4

08:21

32. Agent-Wise Properties

1. Part 1.mp4

18:20

2. Part 2.mp4

13:06

3. Part 3.mp4

07:01

4. Part 4.mp4

11:39

5. Part 5.mp4

26:36

33. Customer - Wishlist

1. Part 1.mp4

15:25

2. Part 2.mp4

10:26

34. Message between Customer and Agent

1. Creating database, tables, view message table, create message form.mp4

18:45

2. Sending message by customer, save data & email receive by agent.mp4

11:23

3. Reply page create and setup the forms and contents.mp4

26:24

4. Sending reply by customer, save data & email receive by agent.mp4

09:48

5. Show all replies by customer & agent, message deletion by customer.mp4

26:20

6. Sending reply by agents, save data, email receive by customers.mp4

31:50

35. Admin - Agent Property Section

1. Show all properties.mp4

26:36

2. Delete property.mp4

06:11

36. Admin - Agent Orders

1. Show all orders.mp4

06:07

2. Delete Order.mp4

08:07

37. Admin - Agent and Customer Message

1. Show all messages.mp4

06:50

2. Show replies.mp4

15:02

3. Delete message.mp4

04:40

38. Admin - Agents and Customers Information

1. Show customers.mp4

06:10

2. Make customers active or inactive.mp4

03:33

3. Delete customer.mp4

08:04

4. Show agents.mp4

07:23

5. Make agents active or inactive.mp4

02:10

6. Delete agent.mp4

19:08

39. Why Choose Us

1. Part 1.mp4

08:17

2. Part 2.mp4

09:17

40. Testimonial

1. Part 1.mp4

09:44

2. Part 2.mp4

08:51

41. Blog

1. Part 1.mp4

13:35

2. Part 2.mp4

17:54

3. Part 3.mp4

17:06

42. FAQ

1. Part 1.mp4

08:04

2. Part 2.mp4

07:56

43. Contact

1. Sending email using contact form.mp4

10:14

44. Newsletter

1. Part 1.mp4

16:56

2. Part 2.mp4

17:34

45. Automatically Logout System

1. Making admin, agent, customer logged out automatically after certain period.mp4

07:41

46. Terms & Privacy Page

1. Part 1.mp4

07:53

2. Part 2.mp4

05:49

47. Dashboard Setup

1. Customer & Agent Dashboard.mp4

07:24

2. Admin Dashboard.mp4

07:36

48. Website Settings

1. Logo and Favicon.mp4

15:15

2. Banner Photo.mp4

09:25

3. Footer Section.mp4

16:52

4. Contact Page Map.mp4

04:51

5. Home Page Sections - Part 1.mp4

26:09

6. Home Page Sections - Part 2.mp4

08:31

7. Home Page Sections - Part 3.mp4

11:42

8. Home Page Sections - Part 4.mp4

08:29

49. Upload Project to Live Server

1. Part 1.mp4

09:54

2. Part 2.mp4

10:02

50. Final Source Code

1.1 database.zip

1.2 real estate project web.zip

1. Final Code.html

Description

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

Who is this 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

What You Need to Know?

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

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

I am a professional web designer and web developer who graduated from Khulna University in Bangladesh with a degree in Computer Science and Engineering (CSE). With over 15 years of experience in the software and web development sector, I have successfully completed numerous projects using PHP, WordPress, Codeigniter, and Laravel for both national and international clients.I earned recognition as one of the top-rated freelancers on Upwork (formerly known as oDesk and Elance). However, as I felt the need to embark on a different path for my personal growth, I decided to create my own web application products for Envato. Within the Envato marketplace, I hold the esteemed title of an Elite author and have contributed over 40 web applications.I handle every aspect of my projects, from design and development to planning and marketing, and I thoroughly enjoy this comprehensive approach. I believe in the importance of sharing knowledge, which is why I have ventured into teaching on Udemy. My goal is to create compelling courses that empower students to benefit from my experience and continually expand their skill sets.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.