15. GROUP BY and HAVING | Coursetakers

Autoplay
Autocomplete

Previous Lesson Complete and Continue

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

1. Introdction

1. Introduction (21:52)

2. Local Server Setup (Windows OS)

1. Installing XAMPP (4:32)
2. Shift between php 7 and php 8 in XAMPP (9:08)
3. Installing Laragon (9:42)
4. Shift between php 7 and php 8 in Laragon (3:57)
5. Install PHP 8.2 in Laragon (3:44)

3. Local Server Setup (Mac OS)

2. Installing MAMP (7:27)
1. Installing XAMPP (4:30)
3. Shift between php 7 and php 8 in MAMP (7:09)
4. Install Composer (2:43)

4. Code Editors

1. Code Editors (1:47)

5. Visual Studio Code Editor

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

7. MySQL Database

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

1. Folder Content Protection (11:30)
2. Least Privilege (13:44)
3. SQL Injection (28:06)
4. XSS Attack (13:29)

9. Pagination

1. Pagination (37:23)

10. Authentication System

1. Template Setup (12:17)
2. Registration (26:42)
3. Registration - Email Verification (8:22)
4. Login and Logout (18:53)
5. Forget Password (12:45)
6. Reset Password (11:20)
7. Source Codes
8. Main Template

11. Payment Method Integration

1. PayPal - Part 1 (10:18)
2. PayPal - Part 2 (17:57)
3. PayPal - Part 3 (5:03)
4. PayPal - Part 4 (10:21)
5. PayPal - Part 5

12. Admin Panel Template Mastering

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

1. Describing the Front End Template (11:53)

14. Front End Template Mastering

1. Rename Admin Panel Folder to Real Estate Project (7:56)
2. Home Page Setup (11:26)
3. Creating an intermediate page between user and agent (14:20)
4. Using .htaccess file to rewrite url (Removing .php extention) (9:09)

15. Customer Section

1. Registration - Part 1 (10:14)
2. Registration - Part 2 (20:02)
3. Verify Registration (7:32)
4. Login Dashboard and Logout (17:49)
5. Forget Password (5:12)
6. Reset Password (5:35)
7. Edit Profile (13:00)

16. Agent Section

1. Registration (9:00)
2. Verify Registration (1:51)
3. Login Dashboard and Logout (6:46)
4. Forget Password (2:56)
5. Reset Password (2:51)
6. Edit Profile (13:21)
7. Pending Agent and Customer Login Protection (4:46)

17. Admin - Notification

1. iziToast Notification (3:08)

18. Package

1. Package - Part 1 (23:41)
2. Package - Part 2 (13:20)
3. Package - Part 3 (7:47)
4. Package - Part 4 (2:47)
5. Package - Part 5 (13:37)

19. Property Location

1. Property Location - Part 1 (8:14)
2. Property Location - Part 2 (12:16)
3. Property Location - Part 3 (11:43)
4. Property Location - Part 4 (4:13)
5. Property Location - Part 5 (8:39)

20. Property Type

1. Property Type - Part 1 (6:12)
2. Property Type - Part 2 (2:41)
3. Property Type - Part 3 (1:24)
4. Property Type - Part 4 (1:18)
5. Property Type - Part 5 (1:34)

21. Amenity

1. Amenity - Part 1 (5:44)
2. Amenity - Part 2 (2:38)

22. Agent - Package Purchase

1. Package Purchase - Part 1 (16:59)
2. Package Purchase - Part 2 (23:21)
3. Package Purchase - Part 3 (13:37)

23. Agent - Orders

1. Show Orders (9:27)

24. Agent - Property Manage

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

1. Creating Agents (20:19)
2. Creating Properties (53:09)

26. Featured Property Setup

1. Featured Property Setup (9:58)

27. Security Checking in Some Modules

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

1. Featured Properties - Part 1 (21:03)
2. Featured Properties - Part 2 (16:40)

29. Properties Search Section

1. Search Section - Part 1 (11:29)
2. Search Section - Part 2 (29:20)
3. Search Section - Part 3 (6:51)
4. Search Section - Part 4 (11:33)
5. Search Section - Part 5 (19:19)
6. Search Section - Part 6 (10:33)
7. Search Section - Part 7 (12:55)

30. Property Detail Page

1. Property Detail - Part 1 (9:16)
2. Property Detail - Part 2 (20:43)
3. Property Detail - Part 3 (2:30)
4. Property Detail - Part 4 (15:45)
5. Property Detail - Part 5 (10:32)
6. Property Detail - Part 6 (22:58)

31. Location-Wise Properties

1. Part 1 (27:09)
2. Part 2 (8:21)

32. Agent-Wise Properties

1. Part 1 (18:20)
2. Part 2 (13:06)
3. Part 3 (7:01)
4. Part 4 (11:39)
5. Part 5 (26:36)

33. Customer - Wishlist

1. Part 1 (15:25)
2. Part 2 (10:26)

34. Message between Customer and Agent

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

1. Show all properties (26:36)
2. Delete property (6:11)

36. Admin - Agent Orders

1. Show all orders (6:07)
2. Delete Order (8:07)

37. Admin - Agent and Customer Message

1. Show all messages (6:51)
2. Show replies (15:02)
3. Delete message (4:40)

38. Admin - Agents and Customers Information

1. Show customers (6:11)
2. Make customers active or inactive (3:33)
3. Delete customer (8:04)
4. Show agents (7:24)
5. Make agents active or inactive (2:10)
6. Delete agent (19:08)

39. Why Choose Us

2. Part 2 (9:17)
1. Part 1 (8:17)

40. Testimonial

1. Part 1 (9:44)
2. Part 2 (8:51)

41. Blog

2. Part 2 (17:54)
1. Part 1 (13:35)
3. Part 3 (17:06)

42. FAQ

1. Part 1 (8:04)
2. Part 2 (7:56)

43. Contact

1. Sending email using contact form (10:14)

44. Newsletter

1. Part 1 (16:56)
2. Part 2 (17:34)

45. Automatically Logout System

1. Making admin, agent, customer logged out automatically after certain period (7:41)

46. Terms & Privacy Page

1. Part 1 (7:53)
2. Part 2 (5:49)

47. Dashboard Setup

1. Customer & Agent Dashboard (7:25)
2. Admin Dashboard (7:37)

48. Website Settings

1. Logo and Favicon (15:15)
2. Banner Photo (9:25)
3. Footer Section (16:53)
4. Contact Page Map (4:52)
5. Home Page Sections - Part 1 (26:09)
6. Home Page Sections - Part 2 (8:31)
7. Home Page Sections - Part 3 (11:43)
8. Home Page Sections - Part 4 (8:29)

49. Upload Project to Live Server

1. Part 1 (9:54)
2. Part 2 (10:02)

50. Final Source Code

1. Final Code
2. Final Code

Teach online with

15. GROUP BY and HAVING

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock