School Project
Mister Snoep Webshop
A school webshop project built with PHP and MySQL. Users can browse products, open product pages, add items to a cart and submit reviews.
Overview
About the project
Mister Snoep was created during a school project. The goal was to build a multi-page webshop and connect it to a MySQL database.
Product data, reviews and cart information are loaded and saved with PHP.
Feature
Product catalogue
Products are loaded from the database and shown as cards. Each card contains an image, name, price and rating.
Feature
Product pages
Each product has its own page with an image, name, price and Add to Cart button.
Feature
Product reviews
Visitors can enter their name, select a rating and write a comment. Reviews are saved in MySQL and stay visible after the page is refreshed.
Feature
Shopping cart
The cart shows selected products, prices and quantities. Users can remove products and see the total price.
My work
What I worked on
- Building the webshop pages and navigation.
- Creating the visual design.
- Connecting PHP to MySQL.
- Loading products from the database.
- Adding products to the shopping cart.
- Calculating the cart total.
- Saving and displaying product reviews.
Technology
Technologies used
Reflection
What I learned
- Connecting PHP to a MySQL database.
- Reading and saving database records.
- Working with HTML forms.
- Using prepared statements.
- Organising a PHP project into different files.
- Testing the project with XAMPP.