/

CVE-2026-86213

Severity:

HIGH RISK

(7.3)

SQL Injection (CWE-89) in College-Management-System

CVE-2026-86213

Deferred

Vulnerability type

Category:

SQL Injection

CWE:

CWE-74, CWE-89

Impact:

Database access, data disclosure, and possible data modification

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 College-Management-System search handler allows attacker-controlled book name or author values to influence database queries. Because the affected search function may be reachable remotely, an unauthenticated attacker could potentially read, alter, or interfere with database content.

Affected context

The issue occurs in the Search Handler implemented in Front-end/university.php, where the book_name and book_author request arguments are passed to mysqli_query. Deployments are at risk when these values can reach SQL construction without reliable parameterization and when the search endpoint is exposed to remote users.

Exploit preconditions

  • Attack surface: Remotely reachable search functionality
  • Required access: Access to submit requests to the search handler; authentication requirements may vary by deployment
  • Trigger point: Processing of the book_name or book_author argument
  • Why exploitation is possible: User-controlled values may influence a database query without sufficient separation between data and SQL syntax

Why this happens

The underlying bug is improper neutralization of special elements in externally controlled input used in an SQL statement. This maps primarily to CWE-89, SQL Injection. The related CWE-74 classification reflects the broader failure to neutralize or constrain special elements in an interpreted command or query language. The insecure pattern is dynamically constructing SQL from request values instead of binding those values as data.

Potential impact

  • An attacker may retrieve sensitive database records
  • An attacker could modify or delete application data if the database account permits it
  • The vulnerability may enable unauthorized changes to application behavior or records
  • Database availability could be affected through resource-intensive or malformed queries
  • Exposed records could support further attacks against users or administrators

General mitigation guidance

Mitigation generally centers on ensuring that all search parameters remain

data rather than executable SQL.

Common defensive patterns include:

  • Use parameterized queries or prepared statements for every user-controlled value
  • Apply allowlisted input validation appropriate to search fields without relying on validation as the sole defense
  • Avoid dynamic SQL construction and restrict database operations to known query shapes
  • Run the application with a database identity having only the permissions it requires
  • Keep sensitive database services isolated from unnecessary network access
  • Use generic error handling so database details are not disclosed to clients

How teams detect issues like this

Detection approaches may include:

  • Static analysis rules identifying string concatenation or interpolation in SQL execution calls
  • Code review checks for direct request-parameter flow into mysqli_query or similar database APIs
  • Dynamic application testing using benign SQL-injection test cases in authorized environments
  • Database monitoring for abnormal query shapes, unexpected errors, and unusual access patterns
  • Policy enforcement requiring prepared statements for database access
  • Neutral automated code-review or software-composition tools that flag unsafe query construction

Sources

SourceLink
github.comgithub.com/Mstfakts/College-Management-System/
github.comgithub.com/Mstfakts/College-Management-System/issues/5
vuldb.comvuldb.com/cve/CVE-2026-86213
vuldb.comvuldb.com/submit/897249
vuldb.comvuldb.com/vuln/399349
vuldb.comvuldb.com/vuln/399349/cti

Frequently asked

questions

Potentially. The affected search handler is described as remotely reachable, so

exploitation may be possible through crafted requests if the endpoint is

exposed and the input reaches the query without adequate protection.

Not necessarily. The required access depends on the application's deployment

and access controls, but any user who can invoke the vulnerable search

function may be able to submit the relevant parameters.

Use parameterized queries or prepared statements so request values are bound

as data, combined with appropriate input validation and least-privilege

database permissions.

Enforce secure database-access patterns in code review and CI, scan for

untrusted data flowing into query APIs, test exposed endpoints, and monitor

database activity for anomalous query behavior.

Find out what's already
exploitable in your codebase.