Online Shoes Store Database

Final Project PHP + MySQL Application

System Reports

Each report uses SQL queries to display useful table outputs from the database.

Inventory by Warehouse

Shows item stock levels at each warehouse.

View Report

Customer Orders

Shows each order with customer names and totals.

View Report

Sales by Item

Shows quantity sold and revenue by item.

View Report

Monthly Sales

Shows sales totals grouped by month.

View Report

Payment Totals

Shows transaction totals by payment method.

View Report