CVE-2025-5711

7.3 HIGH

📋 TL;DR

This critical SQL injection vulnerability in Real Estate Property Management System 1.0 allows remote attackers to execute arbitrary SQL commands via the cmbState parameter in /Admin/InsertCity.php. Attackers can potentially read, modify, or delete database content, including sensitive property and user data. All installations of version 1.0 are affected.

💻 Affected Systems

Products:
  • code-projects Real Estate Property Management System
Versions: 1.0
Operating Systems: All platforms running PHP
Default Config Vulnerable: ⚠️ Yes
Notes: Requires PHP environment with database connectivity; vulnerable in default installation

📦 What is this software?

⚠️ Risk & Real-World Impact

🔴

Worst Case

Complete database compromise leading to data theft, data destruction, or full system takeover via SQL injection to RCE chaining

🟠

Likely Case

Unauthorized data access, modification of property records, potential privilege escalation to admin accounts

🟢

If Mitigated

Limited impact if proper input validation and WAF rules block malicious SQL patterns

🌐 Internet-Facing: HIGH - Remote exploitation possible without authentication
🏢 Internal Only: MEDIUM - Still exploitable by internal users or compromised accounts

🎯 Exploit Status

Public PoC: ⚠️ Yes
Weaponized: LIKELY
Unauthenticated Exploit: ⚠️ Yes
Complexity: LOW

Exploit details publicly disclosed; simple SQL injection requiring basic web testing tools

🛠️ Fix & Mitigation

✅ Official Fix

Patch Version: Unknown

Vendor Advisory: https://code-projects.org/

Restart Required: No

Instructions:

No official patch available. Consider migrating to alternative software or implementing custom fixes.

🔧 Temporary Workarounds

Input Validation and Sanitization

all

Add parameter validation and prepared statements to /Admin/InsertCity.php

Edit InsertCity.php to use prepared statements: $stmt = $conn->prepare('INSERT INTO cities (state_id, city_name) VALUES (?, ?)'); $stmt->bind_param('is', $cmbState, $cityName);

Web Application Firewall Rules

all

Block SQL injection patterns targeting cmbState parameter

Add WAF rule: SecRule ARGS:cmbState "@detectSQLi" "id:1001,phase:2,deny,status:403"

🧯 If You Can't Patch

  • Block external access to /Admin/ directory via firewall rules or .htaccess
  • Implement network segmentation to isolate the vulnerable system from sensitive databases

🔍 How to Verify

Check if Vulnerable:

Test /Admin/InsertCity.php with SQL injection payloads in cmbState parameter (e.g., ' OR '1'='1)

Check Version:

Check system documentation or configuration files for version information

Verify Fix Applied:

Verify prepared statements are implemented and test with SQL injection payloads that should be rejected

📡 Detection & Monitoring

Log Indicators:

  • Unusual SQL errors in web server logs
  • Multiple requests to /Admin/InsertCity.php with special characters in parameters
  • Database queries with UNION, SELECT, or other injection patterns

Network Indicators:

  • HTTP POST requests to /Admin/InsertCity.php containing SQL keywords in cmbState parameter
  • Unusual database connection patterns from web server

SIEM Query:

source="web_logs" AND uri="/Admin/InsertCity.php" AND (param="*UNION*" OR param="*SELECT*" OR param="*OR '1'='1*")

🔗 References

📤 Share & Export