| Title | projectworlds Student Project Allocation System v1.0 SQL Injection |
|---|
| Description | ## The following are screenshots of some specific information obtained from testing and running with the sqlmap tool:
```bash
《sqlmap.py -r C:\Users\韩旭\Desktop\sqli.txt -p id --batch》
```
<img width="803" alt="Image" src="https://github.com/hhhanxx/attack/blob/main/Snipaste_2025-04-28_22-41-09.png?raw=true" />
# Suggested repair
1. **Use prepared statements and parameter binding:**
Preparing statements can prevent SQL injection as they separate SQL code from user input data. When using prepare statements, the value entered by the user is treated as pure data and will not be interpreted as SQL code.
2. **Input validation and filtering:**
Strictly validate and filter user input data to ensure it conforms to the expected format.
3. **Minimize database user permissions:**
Ensure that the account used to connect to the database has the minimum necessary permissions. Avoid using accounts with advanced permissions (such as' root 'or' admin ') for daily operations.
4. **Regular security audits:**
Regularly conduct code and system security audits to promptly identify and fix potential security vulnerabilities.
|
|---|
| Source | ⚠️ https://github.com/hhhanxx/attack/issues/3 |
|---|
| User | attackxu (UID 84219) |
|---|
| Submission | 04/28/2025 16:56 (12 months ago) |
|---|
| Moderation | 05/09/2025 13:46 (11 days later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 308197 [Project Worlds Student Project Allocation System 1.0 forgot_password_sql.php Pat_BloodGroup1 sql injection] |
|---|
| Points | 20 |
|---|