Phone House WebApp
A sophisticated, enterprise-grade online marketplace built with PHP and MySQL. Designed for high-end electronics retail, the platform includes dynamic product catalogs, secure payment gateways and a robust admin dashboard.
Project Overview
Phone House is a feature-rich E-Commerce ecosystem built to handle the complexities of a modern electronics marketplace. Moving away from traditional synchronous page reloads, this platform leverages Asynchronous JavaScript and XML (AJAX) to provide a fluid, single-page feel within a multi-page PHP environment. From real-time input validation to dynamic cart updates, every interaction is engineered for speed and user retention.
AJAX Powered Core
Utilized XMLHttpRequest and FormData for all critical processes (Sign Up, Sign In, Cart Management), ensuring zero page flickering during data transactions.
Automated Communications
Integrated PHPMailer with SMTP for secure verification codes and transactional notifications, enhancing user account security.
Enterprise-Grade Features
Advanced Authentication
Features a robust "Remember Me" system using Cookies and a secure password reset flow utilizing unique IDs and SMTP-driven verification codes.
Admin Control Center
A comprehensive dashboard for managing users, products and sales. Includes real-time uptime counters, sales analytics and stock level monitoring.
Dynamic Inventory Management
Complex logic for adding, updating and filtering products with multi-image upload support and automated category mapping.
Smart Invoice Generation
Implemented html2pdf and custom print logic to generate professional, downloadable invoices directly from the browser.
Relational Database
Designed a complex MySQL schema with over 15 tables, ensuring data integrity through foreign key constraints and optimized indexing for fast searches.
SQL View Architecture
Strategically implemented 3 custom SQL Views to handle complex joins for the dashboard, product listings, and sales reports, improving query performance and security.
Database Schema & ER Diagram
The backbone of Phone House is a meticulously designed relational database. To maintain a high level of abstraction and simplify backend logic, I utilized SQL Views. This approach allowed me to pre-calculate stock levels and aggregate sales data within the database engine itself, rather than processing it in PHP.
Entity Relationship Diagram (ERD) showcasing the 25+ interconnected tables and relational constraints.
1. Simplified Reporting
Views encapsulate complex JOIN operations between Orders, Users, and Products, providing a "virtual table" for the admin dashboard.
2. Logic Centralization
By moving business logic (like price calculations) into views, the PHP code remains clean and focused solely on request handling.
3. Enhanced Security
Views act as a security layer, exposing only necessary data columns to the application while hiding sensitive internal table structures.
Project Metadata
- Type Academic Project
- Architecture PHP + AJAX + MySQL
- Status Live to Visit
- Mailing System PHPMailer (SMTP)
- Frontend Bootstrap 5 + JS