/

CVE-2026-19710

Severity:

HIGH RISK

(7.3)

SQL Injection (CWE-89) in Simple Student Info System

CVE-2026-19710

Deferred

Vulnerability type

Category:

SQL Injection

CWE:

CWE-74, CWE-89

Impact:

Unauthorized database access and data manipulation

Severity:

HIGH RISK

(7.3)

CVSS version:

3.1

Catch this CVE while code is being written

Detect vulnerable code directly in pull requests, so CVEs are fixed before merge.

Summary

A SQL injection vulnerability in the Simple Student Information System allows remotely supplied input in the department view function to influence database queries. If the vulnerable identifier parameter is reachable and insufficiently constrained, an attacker may read, alter, or otherwise interfere with stored application data.

Affected context

The issue occurs in the administrative department-view functionality at app/admin/departments/view_department.php. It becomes risky when the ID request parameter is incorporated into a database query without adequate parameterization or validation, and the endpoint is reachable through the application's remote web interface.

Exploit preconditions

  • Attack surface: Remote web request to the department viewing endpoint
  • Required access: Access sufficient to reach the affected functionality; authentication requirements depend on deployment controls
  • Trigger point: Processing of the ID argument in view_department.php
  • Why exploitation is possible: User-controlled input may influence SQL query construction without reliable separation between data and query syntax

Why this happens

The underlying bug is improper neutralization of externally controlled input used in a database query. When the ID parameter is concatenated into SQL or otherwise processed without parameterized query boundaries, database syntax can be interpreted as part of the command rather than as ordinary data. This maps primarily to CWE-89: Improper Neutralization of Special Elements used in an SQL Command (SQL Injection) and is also related to CWE-74: Improper Neutralization of Special Elements in Output Used by a Downstream Component.

Potential impact

  • An attacker may retrieve unauthorized application or database records
  • An attacker could modify or delete stored information
  • The vulnerability may enable bypass of intended database-level restrictions
  • Application availability could be affected through disruptive database operations
  • Exposed data may support further attacks against users or connected systems

General mitigation guidance

Mitigation generally centers on removing interpreter ambiguity at the database boundary and reducing trust in request parameters.

Common defensive patterns include:

  • Use parameterized queries or prepared statements for all database operations
  • Apply allowlisted type and range validation to identifier parameters
  • Avoid dynamically concatenating request values into SQL statements
  • Enforce least-privilege permissions for the application database account
  • Limit administrative endpoints through authentication, authorization, and network policy
  • Return generic database errors to clients while preserving detailed diagnostics in protected logs

How teams detect issues like this

Detection approaches commonly include:

  • Static analysis rules identifying string concatenation or interpolation in SQL construction
  • Code review checks for request parameters passed directly to database APIs
  • Dynamic application testing that uses benign boundary and metacharacter inputs to identify query-handling anomalies
  • Web-application firewall or gateway policies for suspicious SQL syntax patterns, used as a compensating control rather than a primary fix
  • Database audit logging for unexpected query shapes, error spikes, or unusual access to administrative tables

Sources

SourceLink
github.comgithub.com/gxcyyjy/CVE/issues/5
vuldb.comvuldb.com/cve/CVE-2026-19710
vuldb.comvuldb.com/submit/867530
vuldb.comvuldb.com/vuln/389368
vuldb.comvuldb.com/vuln/389368/cti
sourcecodester.comsourcecodester.com/

Frequently asked

questions

Yes. The affected functionality is exposed through a web endpoint, so exploitation may be possible remotely when the endpoint is reachable and the request parameter reaches the vulnerable query path.

Not necessarily. The required access depends on how the application protects the administrative department functionality, including authentication, authorization, and network restrictions.

Use parameterized queries or prepared statements, validate the identifier as an expected data type, and ensure the database account has only the permissions the application needs.

Combine secure database APIs, centralized input validation, least-privilege database roles, focused code review, automated static analysis, and monitoring of database query anomalies.

Find out what's already
exploitable in your codebase.