水壺電商管理系統

Abstract

中文摘要 本系統旨在運用網頁設計與資料庫整合技術，開發一套以水壺商品為主題的電子商務平台「AquaBottle」。由於現今網路購物已成為常見的消費方式，但部分電商平台仍存在商品分類不清楚、規格選擇容易混淆、商品資訊分散及結帳流程不夠直覺等問題，因此本專題希望設計一個介面清晰、操作便利且流程完整的購物平台，讓使用者能順利完成商品瀏覽、規格選擇、加入購物車、結帳與訂單查詢等流程。 在開發過程中，先透過功能架構圖規劃平台整體功能，再繪製 ER Model 分析各資料表之間的關聯，最後建立關聯式資料表作為系統資料架構。系統開發使用 HTML、CSS、JavaScript、PHP 與 MySQL 等技術，完成前台購物頁面與後台管理介面，並設計會員、商品、購物車、訂單、庫存、優惠券、公告、客服與退貨等功能模組，以確保平台具備互動性、穩定性與資料管理能力。 本專題最後成功實作一套兼具前台購物體驗與後台管理功能的電子商務平台。使用者可進行會員登入、商品瀏覽、規格選擇、購物車管理與訂單查詢；管理者則可透過後台管理商品、會員、訂單、庫存與行銷內容。整體系統具備操作直覺、功能完整與後續擴充彈性，未來可進一步加入線上支付、物流追蹤及推薦機制，以提升平台實用性與商業價值。

Abstract The purpose of this project is to develop an e-commerce platform named AquaBottle, which focuses on water bottle products by applying web design and database integration techniques. Since online shopping has become a common purchasing method, some existing e-commerce platforms still have problems such as unclear product categories, confusing product specifications, scattered product information, and unintuitive checkout processes. Therefore, this project aims to build a shopping platform with a clear interface, convenient operation, and complete shopping flow, allowing users to smoothly browse products, select specifications, add items to the cart, complete checkout, and view order records. During the development process, the system functions were first planned through a functional architecture diagram. Then, an ER Model was created to analyze the relationships among different data tables, followed by the design of relational database tables to establish a complete data structure. The system was developed using HTML, CSS, JavaScript, PHP, and MySQL. Both the frontend shopping interface and backend management system were implemented. The platform includes modules such as member management, product management, shopping cart, orders, inventory, coupons, announcements, customer service, and returns, nsuring system interactivity, stability, and data management capability. As a result, this project successfully implemented an e-commerce platform that combines frontend shopping functions with backend management features. Users can register, log in, browse products, choose product specifications, manage their shopping cart, and check order information. Administrators can manage products, members, orders, inventory, and marketing content through the backend system. Overall, the system is intuitive, functional, and expandable. In the future, features such as online payment, logistics tracking, and product recommendation mechanisms can be added to improve its practical value and commercial potential.