Description
A security flaw has been discovered in SourceCodester Pharmacy Sales and Inventory System 1.0. This impacts the function save_expired of the file /ajax.php?action=save_expired. The manipulation of the argument ID results in sql injection. It is possible to launch the attack remotely. The exploit has been released to the public and may be used for attacks.
Published: 2026-04-28
Score: 5.1 Medium
EPSS: n/a
KEV: No
Impact: SQL Injection
Action: Apply Patch
AI Analysis

Impact

The SourceCodester Pharmacy Sales and Inventory System version 1.0 suffers from an input handling flaw in its save_expired function located in ajax.php. An attacker can manipulate the ID parameter to inject arbitrary SQL statements, a vulnerability grouped under CWE-74 and CWE-89. This flaw allows a remote attacker to read, modify, or delete database contents, potentially exposing sensitive pharmacy data.

Affected Systems

The vulnerable product is SourceCodester Pharmacy Sales and Inventory System 1.0, downloadable from sourcecodester.com. The flaw resides in the AJAX endpoint /ajax.php?action=save_expired, where the ID parameter is not properly sanitized.

Risk and Exploitability

The CVSS score of 5.1 indicates moderate risk, and no EPSS value is available; the vulnerability is not listed in the CISA KEV catalog. Publicly released exploit code demonstrates that a remote attacker can target any accessible instance to execute the SQL injection against the ID parameter.

Generated by OpenCVE AI on April 28, 2026 at 19:13 UTC.

Remediation

No vendor fix or workaround currently provided.

OpenCVE Recommended Actions

  • Apply the latest security patch or upgrade to a newer version of SourceCodester Pharmacy Sales and Inventory System that resolves the unsanitized ID handling in ajax.php.
  • If an update is unavailable, limit access to /ajax.php or the save_expired action to trusted IP addresses and enforce strict validation and escaping of the ID parameter before it is concatenated into SQL queries.
  • Deploy a web application firewall or intrusion detection system configured to detect and block SQL injection attempts targeting the ID parameter in the save_expired function.
  • Continuously monitor database activity and audit logs for unusual queries or authorized access attempts that may indicate exploitation of this flaw.

Generated by OpenCVE AI on April 28, 2026 at 19:13 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories yet.

History

Tue, 28 Apr 2026 16:45:00 +0000

Type Values Removed Values Added
First Time appeared Sourcecodester
Sourcecodester pharmacy Sales And Inventory System
Vendors & Products Sourcecodester
Sourcecodester pharmacy Sales And Inventory System

Tue, 28 Apr 2026 16:15:00 +0000

Type Values Removed Values Added
Metrics ssvc

{'options': {'Automatable': 'no', 'Exploitation': 'poc', 'Technical Impact': 'partial'}, 'version': '2.0.3'}


Tue, 28 Apr 2026 15:15:00 +0000

Type Values Removed Values Added
Description A security flaw has been discovered in SourceCodester Pharmacy Sales and Inventory System 1.0. This impacts the function save_expired of the file /ajax.php?action=save_expired. The manipulation of the argument ID results in sql injection. It is possible to launch the attack remotely. The exploit has been released to the public and may be used for attacks.
Title SourceCodester Pharmacy Sales and Inventory System ajax.php save_expired sql injection
Weaknesses CWE-74
CWE-89
References
Metrics cvssV2_0

{'score': 5.8, 'vector': 'AV:N/AC:L/Au:M/C:P/I:P/A:P/E:POC/RL:ND/RC:UR'}

cvssV3_0

{'score': 4.7, 'vector': 'CVSS:3.0/AV:N/AC:L/PR:H/UI:N/S:U/C:L/I:L/A:L/E:P/RL:X/RC:R'}

cvssV3_1

{'score': 4.7, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:H/UI:N/S:U/C:L/I:L/A:L/E:P/RL:X/RC:R'}

cvssV4_0

{'score': 5.1, 'vector': 'CVSS:4.0/AV:N/AC:L/AT:N/PR:H/UI:N/VC:L/VI:L/VA:L/SC:N/SI:N/SA:N/E:P'}


Subscriptions

Sourcecodester Pharmacy Sales And Inventory System
cve-icon MITRE

Status: PUBLISHED

Assigner: VulDB

Published:

Updated: 2026-04-28T15:35:16.499Z

Reserved: 2026-04-28T08:02:08.566Z

Link: CVE-2026-7283

cve-icon Vulnrichment

Updated: 2026-04-28T15:35:04.313Z

cve-icon NVD

Status : Deferred

Published: 2026-04-28T15:16:36.870

Modified: 2026-04-28T20:24:20.377

Link: CVE-2026-7283

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-04-28T19:15:25Z

Weaknesses