11. LIMIT Clause | 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

11. LIMIT Clause

Complete and Continue