CVE-2025-11403

6.3 MEDIUM

📋 TL;DR

This SQL injection vulnerability in SourceCodester Hotel and Lodge Management System 1.0 allows remote attackers to manipulate database queries via the /del_booking.php file. Attackers could potentially read, modify, or delete sensitive hotel management data. All users running the vulnerable version are affected.

💻 Affected Systems

Products:
  • SourceCodester Hotel and Lodge Management System
Versions: 1.0
Operating Systems: Any OS running PHP web server
Default Config Vulnerable: ⚠️ Yes
Notes: Affects the /del_booking.php file specifically. Requires PHP environment with database connectivity.

📦 What is this software?

⚠️ Risk & Real-World Impact

🔴

Worst Case

Complete database compromise allowing data theft, data manipulation, or system takeover via SQL injection leading to remote code execution.

🟠

Likely Case

Unauthorized access to sensitive hotel guest data, booking information, and potential data manipulation affecting business operations.

🟢

If Mitigated

Limited impact with proper input validation and database permissions restricting damage to non-critical data.

🌐 Internet-Facing: HIGH - The vulnerability is remotely exploitable and affects a web application component.
🏢 Internal Only: MEDIUM - Internal attackers could exploit this to escalate privileges or access sensitive data.

🎯 Exploit Status

Public PoC: ⚠️ Yes
Weaponized: UNKNOWN
Unauthenticated Exploit: ✅ No
Complexity: LOW

Exploit details are publicly available on GitHub. Attack requires access to the vulnerable endpoint.

🛠️ Fix & Mitigation

✅ Official Fix

Patch Version: Not available

Vendor Advisory: https://www.sourcecodester.com/

Restart Required: No

Instructions:

No official patch available. Implement input validation and parameterized queries in /del_booking.php.

🔧 Temporary Workarounds

Input Validation and Sanitization

PHP

Add server-side validation to sanitize the ID parameter in /del_booking.php

Modify PHP code to use prepared statements: $stmt = $conn->prepare('DELETE FROM bookings WHERE id = ?'); $stmt->bind_param('i', $_GET['ID']);

Web Application Firewall Rules

all

Block SQL injection patterns targeting /del_booking.php

Add WAF rule: SecRule REQUEST_URI "@contains /del_booking.php" "id:1001,phase:2,deny,status:403,msg:'SQLi attempt detected'"
SecRule ARGS:ID "@detectSQLi" "id:1002,phase:2,deny"

🧯 If You Can't Patch

  • Restrict network access to the application using firewall rules
  • Implement database user with minimal required permissions

🔍 How to Verify

Check if Vulnerable:

Test /del_booking.php with SQL injection payloads like: /del_booking.php?ID=1' OR '1'='1

Check Version:

Check application version in admin panel or readme files

Verify Fix Applied:

Verify that SQL injection payloads no longer work and return proper error handling

📡 Detection & Monitoring

Log Indicators:

  • Unusual SQL error messages in web server logs
  • Multiple failed DELETE requests to /del_booking.php
  • Requests with SQL keywords in ID parameter

Network Indicators:

  • HTTP requests to /del_booking.php with SQL injection patterns
  • Unusual database query patterns from web server

SIEM Query:

source="web_server.log" AND uri="/del_booking.php" AND (message="*SQL*" OR message="*syntax*" OR param="*' OR *")

🔗 References

📤 Share & Export