How swymmm/product-review-and-rating-system works
This PHP/MySQL product-rating app lets visitors browse products, inspect detail pages, submit one 1–5-star vote per product/IP, and see aggregate ratings. Administrators create an initial account, log in, review ratings, and manage products. The graph separates visitor-facing pages, rating submission, admin workflows, and database access. The README documents the key capabilities; sampled PHP shows the main queries, forms, and calls. JavaScript, schema, and several admin handlers were not inspected, so their internal relationships are not expanded.
Main entry points: db.php PDO connection · dashboard.php Admin dashboard · index.php Product catalog · app.js Star rating UI
Components 21
Visitor experience
- Product catalog
public/index.php - Product details
public/product.php - Star rating UI
public/assets/js/app.js - Responsive styling
public/assets/css/styles.css
Rating workflow
- Rating submission
public/rate.php
Admin operations
- Admin setup
admin/setup.php - Admin login
admin/login.php - Session guard
admin/guard.php - Admin dashboard
admin/dashboard.php - Create product
admin/product_create.php - Edit product
admin/edit_product.php - Delete products
admin/product_delete.php - Delete all products
admin/product_delete_all.php - Remove rating
admin/delete_rating.php - Admin logout
admin/logout.php - Image uploads
public/assets/images/uploads
Data access
- Database settings
config/config.php - PDO connection
config/db.php - MySQL data
sql/schema.sql
Other components
- Visitor
- Administrator
Connections 34
- Visitor → Product catalog: browses
README.md - Product catalog → Product details: opens details
public/index.php - Visitor → Star rating UI: selects stars
- Product details → Star rating UI: renders stars
public/product.php - Star rating UI → Rating submission: posts rating
- Visitor → Rating submission: submits vote
- Product catalog → PDO connection: queries products
public/index.php - Product details → PDO connection: queries product
public/product.php - Rating submission → PDO connection: checks and saves
public/rate.php - Product catalog → Responsive styling: loads styles
public/index.php - Product catalog → Star rating UI: loads script
public/index.php - Administrator → Admin setup: creates account
README.md - Administrator → Admin login: signs in
README.md - Admin setup → PDO connection: creates admin
admin/setup.php - Admin login → PDO connection: checks credentials
admin/login.php - Administrator → Admin dashboard: manages catalog
admin/dashboard.php - Admin dashboard → Session guard: requires session
admin/dashboard.php - Admin dashboard → PDO connection: reads products and ratings
admin/dashboard.php - Admin dashboard → Create product: posts new product
admin/dashboard.php - Admin dashboard → Edit product: opens editor
admin/dashboard.php - Admin dashboard → Delete products: posts deletion
admin/dashboard.php - Admin dashboard → Delete all products: posts bulk deletion
admin/dashboard.php - Admin dashboard → Remove rating: posts rating removal
admin/dashboard.php - Create product → PDO connection: inserts product
admin/product_create.php - Create product → Image uploads: saves image
admin/product_create.php - Edit product → PDO connection: updates product
admin/edit_product.php - Edit product → Image uploads: replaces image
admin/edit_product.php - Delete products → PDO connection: deletes product
admin/product_delete.php - Delete products → Image uploads: removes image
admin/product_delete.php - Delete all products → PDO connection: deletes products
admin/product_delete_all.php - Remove rating → PDO connection: deletes rating
admin/delete_rating.php - Administrator → Admin logout: ends session
- PDO connection → Database settings: loads settings
config/db.php - PDO connection → MySQL data: connects PDO
config/db.php