itsourcecode Apartment Management System SQL Injection Vulnerability in r_all_info.php

A SQL injection vulnerability has been identified in the itsourcecode Apartment Management System version 1.0. The issue resides in the file '/t_dashboard/r_all_info.php', where the 'mid' parameter is not properly validated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, without any authentication, potentially leading to unauthorized database access, data manipulation, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows for SQL injection, which could lead to unauthorized database access, data modification or deletion, and exposure of sensitive information.

Reproduction

The vulnerability can be reproduced by sending a request to '/t_dashboard/r_all_info.php' with a crafted 'mid' parameter that includes malicious SQL payloads. This can be done using tools like sqlmap, which can automate the injection process and exploit the vulnerability.

Remediation

It is recommended to implement input validation and sanitization for the 'mid' parameter to prevent SQL injection. Additionally, using prepared statements and parameterized queries can help mitigate this type of vulnerability. Regular security audits should also be conducted to identify and address potential security issues.