Eye Medicine Inventory & Billing Web App

Database Setup

In phpMyAdmin or MySQL CLI, run:

CREATE TABLE products (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  price DECIMAL(10,2) NOT NULL,
  quantity INT NOT NULL,
  expiry DATE NOT NULL
);