BlackArsenal - PHP MVC E-commerce Site

University Project PHP MVC E-commerce

Project Overview

#

1. Academic Context

   2024

   University Project

   Development of a complete e-commerce site as part of a university course on web development with PHP. The objective was to master MVC architecture and object-oriented programming concepts.
2. MVC Architecture

   PHP 7.4+

   Modular Structure

   Implementation of a clean and maintainable Model-View-Controller architecture: - **Model**: Data management and MySQL database interaction - **View**: Responsive user interface with Bootstrap - **Controller**: Business logic and request routing
3. Database

   MySQL

   Relational Structure

   Design of a normalized database with well-structured relational tables, included creation script and test data for immediate demonstration.

Technical Stack

#

Main Features

#

1. User Management

#

• Complete authentication system with registration and login
• User session management
• User profiles with personalized information
• Role system (administrator/standard user)

2. Product Catalog

#

• Product display with pagination
• Detailed pages for each product
• Category system to organize products
• Images and detailed descriptions
• Real-time pricing and availability

3. Administration Interface

#

• Complete CRUD (Create, Read, Update, Delete) for products
• Add interface for new products
• Inline editing of product characteristics
• Stock and price management
• Image upload for products

4. User Experience

#

• Responsive design adapted for mobile and tablets
• Intuitive navigation with dropdown menu
• Product search and filtering
• Modern user interface with Bootstrap

Database

#

The database features:

• Complete normalized schema
• Well-structured relational tables
• Test data for products and users
• Optimized relationships between entities

-- BlackArsenal Database Structure

CREATE TABLE utilisateur(
    id VARCHAR(50),
    nom VARCHAR(50),
    email VARCHAR(50),
    mdp VARCHAR(50),
    PRIMARY KEY(id)
);

CREATE TABLE arme(
    id INT,
    nom VARCHAR(50),
    prix DOUBLE,
    description VARCHAR(200),
    stock INT,
    image VARCHAR(50),
    PRIMARY KEY(id)
);

CREATE TABLE armeCorpsACorps(
    id INT,
    tranchante LOGICAL,
    contondante LOGICAL,
    deLancee LOGICAL,
    poids VARCHAR(50),
    longueur DOUBLE,
    diametre DOUBLE,
    distanceDeLance DOUBLE,
    nbLots INT,
    PRIMARY KEY(id),
    FOREIGN KEY(id) REFERENCES arme(id)
);

CREATE TABLE arme_a_feu(
    id INT,
    modeDeTir VARCHAR(50),
    portee DECIMAL(15,2),
    type VARCHAR(50),
    nbBalles INT,
    typeMunition VARCHAR(50),
    PRIMARY KEY(id),
    FOREIGN KEY(id) REFERENCES arme(id)
);

CREATE TABLE Stand(
    id INT,
    types VARCHAR(50),
    Destructive_Power SMALLINT,
    Speed SMALLINT,
    Range_Of_Manifestation SMALLINT,
    Stamina SMALLINT,
    Precision_Accuracy SMALLINT,
    Development_Potential SMALLINT,
    PRIMARY KEY(id),
    FOREIGN KEY(id) REFERENCES arme(id)
);

CREATE TABLE Commande(
    id INT,
    dateCommande DATE,
    montant DECIMAL(15,2),
    statut VARCHAR(50),
    id_user VARCHAR(50) NOT NULL,
    PRIMARY KEY(id),
    FOREIGN KEY(id_user) REFERENCES utilisateur(id)
);

Table Architecture

#

• Utilisateur: User account management and authentication
• Arme: Main catalog with common characteristics
• ArmeCorpsACorps: Specialization for melee weapons
• Arme_a_feu: Specialization for ranged weapons
• Stand: Special category of fictional weapons
• Commande: Order management system

Demonstrated Skills

#

Previous Nextsads

Backend Development

#

• Object-oriented PHP with classes and inheritance
• MVC Architecture clean and modular
• Database with PDO and secure queries
• Security SQL injection protection

Frontend Development

#

• Semantic HTML5 well-structured
• Responsive CSS3 adaptive design
• Bootstrap professional interface
• JavaScript dynamic interactions

Project Management

#

• Organized Code maintainable structure
• Documentation complete technical docs
• Versioning file management

Educational Aspects

#

This project illustrates a methodical approach to web development:

• Separation of concerns with MVC pattern
• Best practices in professional web development
• Securing a complete web application
• Frontend/backend integration harmonious
• Relational database design

Installation and Configuration

#

The project includes:

• Database design and implementation
• Simple configuration for local environment
• Complete technical documentation
• Test data for demonstration