🚜 Farmer Marketplace App – Capstone Project 2026

---

📌 Project Title

Farmer Marketplace App & Website – A platform connecting Grenadian farmers directly with consumers to buy and sell fresh produce efficiently.

🌱 Local Context

In Grenada, small farmers play a vital role in supplying fresh produce, but supply-demand gaps often lead to food waste or inconsistent access for consumers. This marketplace helps bridge that gap by enabling direct trade, supporting local agriculture, and reducing waste.

---

📝 Project Description

The Farmer Marketplace App & Website is a full-stack application where users can:

• Browse farm products
• Create product listings
• Place and track orders

Farmers can optionally verify their accounts by submitting a Farmer ID, giving them a “verified” status. The frontend is built with JavaScript / PHP, and the backend is a PHP + MySQL API managed via phpMyAdmin.

---

🎯 Objectives

1. Build a working frontend + backend for a local farmer marketplace
2. Enable farmer verification via Farmer ID
3. Implement CRUD functionality for product listings
4. Support order creation, tracking, and reviews
5. Persist all data securely in a MySQL database

---

⚡ Features

• 👤 User profiles (customers & farmers)
• ✅ Farmer verification with Farmer ID
• 📦 Product listings: create, read, update, delete
• 🛒 Browse products and place orders
• 🔄 Order tracking and status updates
• 💬 Messaging between users
• ⭐ Product reviews
• 🔔 Notifications for users
• 🧾 Data stored in MySQL backend via PHP API

---

🛠️ Technology Stack

• Frontend / Website: PHP, HTML, CSS, JavaScript
• Backend / API: PHP
• Database: MySQL (via phpMyAdmin)
• Development Server: Local (XAMPP)

---

🗄️ Database Overview

The application uses a relational database to manage its core entities:

• Users: Stores user profiles, optional farmer verification, and contact information.
• Listings: Contains product information including name, category, price, quantity, and status.
• Orders & Order Items: Tracks orders placed by customers and the specific products included.
• Messages: Supports messaging between users.
• Reviews: Stores ratings and reviews for completed orders.
• Notifications: Tracks alerts and updates for users.
• Cart: Optional structure for storing user cart items.

The database is fully normalized and uses indexes for efficient querying and relational integrity.

---

📊 Project Evaluation

✅ Achievements

• Fully functional frontend integrated with a PHP + MySQL backend
• Farmer verification (partly) implemented via optional Farmer ID
• Secure, persistent CRUD operations for users, listings, orders, and messages
• Clear, responsive UI across multiple pages