Code-Projects Simple Cafe Ordering System SQL Injection Vulnerability in addmem.php

A SQL injection vulnerability has been identified in Code-Projects Simple Cafe Ordering System version 1.0, specifically within the addmem.php file. The issue arises from inadequate validation of user input for the studentnum parameter, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, without the need for authentication, potentially leading to unauthorized access to the database, data manipulation, and disruption of services.

Impact

Exploitation of this vulnerability allows for SQL injection, where attackers can interfere with the application's database queries. This could lead to unauthorized data access, data manipulation, and in some cases, executing administrative operations on the database.

Reproduction

The vulnerability can be reproduced by sending a crafted request to the addmem.php file with a manipulated studentnum parameter. This can be done using a variety of SQL injection techniques, such as boolean-based blind, error-based, time-based blind, or UNION-based payloads. The injection takes place through a POST request, where the studentnum parameter is included along with other form data.

Remediation

To address this vulnerability, it is recommended to implement prepared statements and parameter binding to separate SQL code from user input, conduct thorough input validation and filtering, and minimize database user permissions.