Skip to content
BranchesTags

Latest commit

 

History

7 Commits

Folders and files

NameName
Last commit message
Last commit date
controllers
controllers
 
 
models/database
models/database
 
 
views
views
 
 
.DS_Store
.DS_Store
 
 
README.md
README.md
 
 

Repository files navigation

🥋 DojoSearch

Web platform for managing and discovering martial arts events.

PHP MySQL Bootstrap XAMPP

📋 Table of Contents

  1. Description
  2. Features
  3. Project Structure
  4. Requirements
  5. Installation
  6. Database
  7. User Roles
  8. Class Diagram
  9. Sequence Diagrams
  10. Tech Stack

Description

DojoSearch is a web application built with native PHP following an MVC architecture. It allows users to browse, register for and manage martial arts events. Administrators can create, edit and delete events from a dedicated control panel.

Features

  • 🔐 Authentication — Registration and login with passwords hashed via password_hash (bcrypt).
  • 👤 User Profiles — Edit personal data, profile photo (BLOB), social networks, bio, phone and notification preferences.
  • 🗓️ Event Management — Full CRUD for events (create, read, edit, delete).
  • 🔍 Event Detail — Individual view with all event information.
  • 🛡️ Access Control — Session-protected routes; admin panel exclusive to administrators.
  • 📱 Responsive Design — Interface adapted for mobile, tablet and desktop.

Project Structure

MP0487_RA5RA6_DojoSearch/
├── controllers/
│   ├── db_connection.php      # PDO connection to MySQL
│   ├── EventController.php    # Event CRUD
│   └── UserController.php     # Auth, registration and profile management
├── models/
│   └── database/
│       ├── seed.sql           # Database creation script and seed data
│       └── xml/
│           └── users.xml
├── views/
│   ├── assets/
│   │   ├── css/               # Stylesheets (style.css, events.css, profile.css…)
│   │   ├── images/            # Images, icons, logos
│   │   └── videos/            # Hero background video
│   └── php/
│       ├── index.php          # Landing page
│       ├── login.php          # Login page
│       ├── register.php       # New user registration
│       ├── events.php         # Event listing
│       ├── detail.php         # Single event detail
│       ├── manageEvents.php   # Create / edit events (admin)
│       ├── userAdmin.php      # Administrator profile
│       └── userUser.php       # Standard user profile
└── README.md

Requirements

Tool Minimum version
PHP 8.0
MySQL 8.0
XAMPP / Apache Any
Modern browser Chrome, Firefox, Edge

Installation

  1. Clone or copy the project into C:\xampp\htdocs\:

    C:\xampp\htdocs\MP0487\MP0487_RA5RA6_DojoSearch\

  2. Start Apache and MySQL from the XAMPP control panel.

  3. Create the database by running the SQL script in phpMyAdmin or from the terminal:

    mysql -u root -p < models/database/seed.sql

  4. Configure the connection in controllers/db_connection.php if your settings differ:

    $server   = "127.0.0.1";
$user     = "root";
$password = "";
$database = "mp0487_dojosearch";
$port     = 3306;

  5. Open the application in your browser:

    http://localhost/MP0487/MP0487_RA5RA6_DojoSearch/views/php/index.php

Database

Name: mp0487_dojosearch

Table users

Column Type Description
id INT UNSIGNED PK Unique identifier
name VARCHAR(100) Full name
username VARCHAR(50) UNIQUE Username
email VARCHAR(150) UNIQUE Email address
fecha_born DATE Date of birth
password VARCHAR(255) bcrypt hash
is_admin TINYINT(1) 1 = administrator
photo LONGBLOB Profile photo
bio TEXT Biography
phone VARCHAR(20) Phone number
twitter VARCHAR(100) Twitter profile
instagram VARCHAR(100) Instagram profile
facebook VARCHAR(100) Facebook profile
youtube VARCHAR(100) YouTube channel
email_messages TINYINT(1) Message notifications
email_reminders TINYINT(1) Reminder notifications
email_promotions TINYINT(1) Promotional notifications
created_at DATETIME Registration date

Table events

Column Type Description
id INT UNSIGNED PK Unique identifier
name VARCHAR(150) Event name
description TEXT Description
date DATETIME Date and time
location VARCHAR(200) Event venue

User Roles

Role Access
Visitor index.php, login.php, register.php
User All of the above + events.php, detail.php, userUser.php
Administrator All of the above + userAdmin.php, manageEvents.php (create/edit/delete events)

Class Diagram

classDiagram
    class UserController {
        -PDO conn
        +__construct(PDO db)
        +handleRequest() void
        +login() void
        +register() void
        +updateUser() void
        +updateGeneral() void
        +updatePassword() void
        +updateInfo() void
        +updateSocial() void
        +updateNotifications() void
        +uploadPhoto() void
        +deleteAccount() void
        +logout() void
        +checkSession()$ void
    }

    class EventController {
        -PDO conn
        +__construct(PDO conn)
        +getAllEvents() array
        +handleForm() void
        -createEvent() void
        -deleteEvent() void
        -updateEvent() void
    }

    class User {
        +int id
        +string name
        +string username
        +string email
        +date fecha_born
        +string password
        +bool is_admin
        +blob photo
        +string bio
        +string phone
        +string twitter
        +string instagram
        +string facebook
        +string youtube
        +bool email_messages
        +bool email_reminders
        +bool email_promotions
        +datetime created_at
    }

    class Event {
        +int id
        +string name
        +string description
        +datetime date
        +string location
    }

    class Database {
        -string server
        -string user
        -string password
        -string database
        -int port
        +connect() PDO
    }

    UserController --> Database : uses
    EventController --> Database : uses
    UserController ..> User : manages
    EventController ..> Event : manages
Loading

Sequence Diagrams

1. Login

sequenceDiagram
    actor U as User
    participant V as login.php
    participant C as UserController
    participant DB as MySQL (users)

    U->>V: Fills in email + password and submits
    V->>C: POST action=login
    C->>DB: SELECT * FROM users WHERE email = ?
    DB-->>C: User row (or empty)
    alt User found
        C->>C: password_verify(input, hash)
        alt Correct password
            C->>C: $_SESSION['user'] = userData
            alt is_admin = 1
                C-->>U: Redirect → userAdmin.php
            else is_admin = 0
                C-->>U: Redirect → userUser.php
            end
        else Wrong password
            C-->>V: $_SESSION['error'] = message
            V-->>U: Shows error
        end
    else User not found
        C-->>V: $_SESSION['error'] = message
        V-->>U: Shows error
    end
Loading

2. User Registration

sequenceDiagram
    actor U as User
    participant V as register.php
    participant C as UserController
    participant DB as MySQL (users)

    U->>V: Fills in form and submits
    V->>C: POST register=1
    C->>C: Validate fields, terms, password rules
    alt Validation failed
        C-->>V: $_SESSION['error']
        V-->>U: Shows error
    else Validation passed
        C->>DB: SELECT id WHERE email OR username
        alt Email / username already exists
            C-->>V: $_SESSION['error'] = 'already registered'
            V-->>U: Shows error
        else Available
            C->>C: password_hash(password)
            C->>DB: INSERT INTO users (...)
            DB-->>C: OK
            C-->>V: $_SESSION['success']
            V-->>U: Redirect → login.php
        end
    end
Loading

3. Create an Event (Admin)

sequenceDiagram
    actor A as Administrator
    participant V as manageEvents.php
    participant C as EventController
    participant DB as MySQL (events)

    A->>V: Opens event creation form
    V->>V: checkSession() + is_admin check
    A->>V: Fills in name, description, date, location
    V->>C: POST createEvent=1
    C->>DB: INSERT INTO events (name, description, date, location)
    DB-->>C: OK
    C-->>A: Redirect → manageEvents.php
Loading

4. View Event Detail

sequenceDiagram
    actor U as User
    participant EV as events.php
    participant D as detail.php
    participant DB as MySQL (events)

    U->>EV: Loads event listing
    EV->>DB: SELECT * FROM events ORDER BY date ASC
    DB-->>EV: Event list
    EV-->>U: Renders event cards
    U->>D: Clicks "More details" → GET id=X
    D->>D: checkSession() — validate session
    D->>DB: SELECT * FROM events WHERE id = X
    DB-->>D: Event data
    D-->>U: Renders full event detail view
Loading

5. Update User Profile

sequenceDiagram
    actor U as User
    participant V as userUser.php / userAdmin.php
    participant C as UserController
    participant DB as MySQL (users)

    U->>V: Edits a section (general / info / social / notifications / password)
    V->>C: POST action=updateGeneral | updateInfo | updateSocial | updateNotifications | updatePassword
    C->>C: Validate session + permissions (id == session id)
    C->>DB: UPDATE users SET ... WHERE id = ?
    DB-->>C: OK
    C->>DB: SELECT * FROM users WHERE id = ?
    DB-->>C: Updated data
    C->>C: $_SESSION['user'] = fresh data
    C-->>V: $_SESSION['success']
    V-->>U: Shows confirmation
Loading

Tech Stack

Layer Technology
Backend PHP 8 (native, MVC pattern)
Database MySQL 8 + PDO
Frontend HTML5, CSS3, Bootstrap 4.5
Icons Font Awesome 6
Typography Google Fonts (Bebas Neue, Montserrat)
Maps Leaflet.js
Local server XAMPP (Apache + MySQL)

Academic project — Module MP0487 · RA5/RA6 · DojoSearch

PHP MySQL Bootstrap XAMPP

📋 Tabla de contenidos

  1. Descripción
  2. Características
  3. Estructura del proyecto
  4. Requisitos
  5. Instalación
  6. Base de datos
  7. Roles de usuario
  8. Diagrama de clases
  9. Diagrama de secuencia
  10. Tecnologías utilizadas

Descripción

DojoSearch es una aplicación web desarrollada en PHP nativo con arquitectura MVC que permite a los usuarios explorar, registrarse y gestionar eventos de artes marciales. Los administradores pueden crear, editar y eliminar eventos desde un panel de control dedicado.

Características

  • 🔐 Autenticación — Registro e inicio de sesión con contraseñas cifradas con password_hash (bcrypt).
  • 👤 Perfiles de usuario — Edición de datos personales, foto de perfil (BLOB), redes sociales, bio, teléfono y preferencias de notificaciones.
  • 🗓️ Gestión de eventos — CRUD completo de eventos (crear, leer, editar, eliminar).
  • 🔍 Detalle de evento — Vista individual con toda la información del evento.
  • 🛡️ Control de acceso — Rutas protegidas por sesión; panel de administración exclusivo para admins.
  • 📱 Diseño responsive — Interfaz adaptada a móvil, tablet y escritorio.

Estructura del proyecto

MP0487_RA5RA6_DojoSearch/
├── controllers/
│   ├── db_connection.php      # Conexión PDO a MySQL
│   ├── EventController.php    # CRUD de eventos
│   └── UserController.php     # Auth, registro y gestión de perfil
├── models/
│   └── database/
│       ├── seed.sql           # Script de creación de BD y datos iniciales
│       └── xml/
│           └── users.xml
├── views/
│   ├── assets/
│   │   ├── css/               # Hojas de estilo (style.css, events.css, profile.css…)
│   │   ├── images/            # Imágenes, iconos, logos
│   │   └── videos/            # Video de fondo del hero
│   └── php/
│       ├── index.php          # Página principal / landing
│       ├── login.php          # Inicio de sesión
│       ├── register.php       # Registro de nuevo usuario
│       ├── events.php         # Listado de eventos
│       ├── detail.php         # Detalle de un evento
│       ├── manageEvents.php   # Crear / editar eventos (admin)
│       ├── userAdmin.php      # Perfil del administrador
│       └── userUser.php       # Perfil del usuario estándar
└── README.md

Requisitos

Herramienta Versión mínima
PHP 8.0
MySQL 8.0
XAMPP / Apache Cualquiera
Navegador moderno Chrome, Firefox, Edge

Instalación

  1. Clonar o copiar el proyecto en C:\xampp\htdocs\:

    C:\xampp\htdocs\MP0487\MP0487_RA5RA6_DojoSearch\

  2. Iniciar Apache y MySQL desde el panel de XAMPP.

  3. Crear la base de datos ejecutando el script SQL en phpMyAdmin o desde la terminal:

    mysql -u root -p < models/database/seed.sql

  4. Configurar la conexión en controllers/db_connection.php si los datos difieren:

    $server   = "127.0.0.1";
$user     = "root";
$password = "";
$database = "mp0487_dojosearch";
$port     = 3306;

  5. Acceder a la aplicación en el navegador:

    http://localhost/MP0487/MP0487_RA5RA6_DojoSearch/views/php/index.php

Base de datos

Nombre: mp0487_dojosearch

Tabla users

Columna Tipo Descripción
id INT UNSIGNED PK Identificador único
name VARCHAR(100) Nombre completo
username VARCHAR(50) UNIQUE Nombre de usuario
email VARCHAR(150) UNIQUE Correo electrónico
fecha_born DATE Fecha de nacimiento
password VARCHAR(255) Hash bcrypt
is_admin TINYINT(1) 1 = administrador
photo LONGBLOB Foto de perfil
bio TEXT Biografía
phone VARCHAR(20) Teléfono
twitter VARCHAR(100) Perfil Twitter
instagram VARCHAR(100) Perfil Instagram
facebook VARCHAR(100) Perfil Facebook
youtube VARCHAR(100) Canal YouTube
email_messages TINYINT(1) Notif. mensajes
email_reminders TINYINT(1) Notif. recordatorios
email_promotions TINYINT(1) Notif. promociones
created_at DATETIME Fecha de registro

Tabla events

Columna Tipo Descripción
id INT UNSIGNED PK Identificador único
name VARCHAR(150) Nombre del evento
description TEXT Descripción
date DATETIME Fecha y hora
location VARCHAR(200) Lugar del evento

Roles de usuario

Rol Acceso
Visitante index.php, login.php, register.php
Usuario Todo lo anterior + events.php, detail.php, userUser.php
Administrador Todo lo anterior + userAdmin.php, manageEvents.php (crear/editar/eliminar eventos)

Diagrama de clases

classDiagram
    class UserController {
        -PDO conn
        +__construct(PDO db)
        +handleRequest() void
        +login() void
        +register() void
        +updateUser() void
        +updateGeneral() void
        +updatePassword() void
        +updateInfo() void
        +updateSocial() void
        +updateNotifications() void
        +uploadPhoto() void
        +deleteAccount() void
        +logout() void
        +checkSession()$ void
    }

    class EventController {
        -PDO conn
        +__construct(PDO conn)
        +getAllEvents() array
        +handleForm() void
        -createEvent() void
        -deleteEvent() void
        -updateEvent() void
    }

    class User {
        +int id
        +string name
        +string username
        +string email
        +date fecha_born
        +string password
        +bool is_admin
        +blob photo
        +string bio
        +string phone
        +string twitter
        +string instagram
        +string facebook
        +string youtube
        +bool email_messages
        +bool email_reminders
        +bool email_promotions
        +datetime created_at
    }

    class Event {
        +int id
        +string name
        +string description
        +datetime date
        +string location
    }

    class Database {
        -string server
        -string user
        -string password
        -string database
        -int port
        +connect() PDO
    }

    UserController --> Database : uses
    EventController --> Database : uses
    UserController ..> User : manages
    EventController ..> Event : manages
Loading

Diagrama de secuencia

1. Inicio de sesión (Login)

sequenceDiagram
    actor U as Usuario
    participant V as login.php
    participant C as UserController
    participant DB as MySQL (users)

    U->>V: Rellena email + contraseña y envía
    V->>C: POST action=login
    C->>DB: SELECT * FROM users WHERE email = ?
    DB-->>C: Fila del usuario (o vacío)
    alt Usuario encontrado
        C->>C: password_verify(input, hash)
        alt Contraseña correcta
            C->>C: $_SESSION['user'] = userData
            alt is_admin = 1
                C-->>U: Redirect → userAdmin.php
            else is_admin = 0
                C-->>U: Redirect → userUser.php
            end
        else Contraseña incorrecta
            C-->>V: $_SESSION['error'] = mensaje
            V-->>U: Muestra error
        end
    else Usuario no encontrado
        C-->>V: $_SESSION['error'] = mensaje
        V-->>U: Muestra error
    end
Loading

2. Registro de nuevo usuario

sequenceDiagram
    actor U as Usuario
    participant V as register.php
    participant C as UserController
    participant DB as MySQL (users)

    U->>V: Rellena formulario y envía
    V->>C: POST register=1
    C->>C: Validar campos, términos, contraseña
    alt Validación fallida
        C-->>V: $_SESSION['error']
        V-->>U: Muestra error
    else Validación correcta
        C->>DB: SELECT id WHERE email OR username
        alt Email / username ya existe
            C-->>V: $_SESSION['error'] = 'ya registrado'
            V-->>U: Muestra error
        else Disponible
            C->>C: password_hash(password)
            C->>DB: INSERT INTO users (...)
            DB-->>C: OK
            C-->>V: $_SESSION['success']
            V-->>U: Redirect → login.php
        end
    end
Loading

3. Crear un evento (Admin)

sequenceDiagram
    actor A as Administrador
    participant V as manageEvents.php
    participant C as EventController
    participant DB as MySQL (events)

    A->>V: Accede al formulario de creación
    V->>V: checkSession() + is_admin check
    A->>V: Rellena nombre, descripción, fecha, lugar
    V->>C: POST createEvent=1
    C->>DB: INSERT INTO events (name, description, date, location)
    DB-->>C: OK
    C-->>A: Redirect → manageEvents.php
Loading

4. Ver detalle de un evento

sequenceDiagram
    actor U as Usuario
    participant EV as events.php
    participant D as detail.php
    participant DB as MySQL (events)

    U->>EV: Carga listado de eventos
    EV->>DB: SELECT * FROM events ORDER BY date ASC
    DB-->>EV: Lista de eventos
    EV-->>U: Muestra tarjetas de eventos
    U->>D: Clic en "Más detalles" → GET id=X
    D->>D: checkSession() — validar sesión
    D->>DB: SELECT * FROM events WHERE id = X
    DB-->>D: Datos del evento
    D-->>U: Renderiza vista de detalle completa
Loading

5. Actualizar perfil de usuario

sequenceDiagram
    actor U as Usuario
    participant V as userUser.php / userAdmin.php
    participant C as UserController
    participant DB as MySQL (users)

    U->>V: Modifica sección (general / info / redes / notificaciones / contraseña)
    V->>C: POST action=updateGeneral | updateInfo | updateSocial | updateNotifications | updatePassword
    C->>C: Validar sesión + permisos (id == session id)
    C->>DB: UPDATE users SET ... WHERE id = ?
    DB-->>C: OK
    C->>DB: SELECT * FROM users WHERE id = ?
    DB-->>C: Datos actualizados
    C->>C: $_SESSION['user'] = datos frescos
    C-->>V: $_SESSION['success']
    V-->>U: Muestra confirmación
Loading

Tecnologías utilizadas

Capa Tecnología
Backend PHP 8 (nativo, patrón MVC)
Base de datos MySQL 8 + PDO
Frontend HTML5, CSS3, Bootstrap 4.5
Iconos Font Awesome 6
Tipografía Google Fonts (Bebas Neue, Montserrat)
Mapas Leaflet.js
Servidor local XAMPP (Apache + MySQL)

Proyecto académico — Módulo MP0487 · RA5/RA6 · DojoSearch

About

No description, website, or topics provided.

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

Packages

Contributors

Languages