Zoo Arcadia ✨
Overview
Zoo Arcadia is a complex interactive platform that represents a true full-stack challenge. The site offers a dual experience: a public interface for visitors and an administrative section for zoo management. It's an ambitious project that allowed me to explore NoSQL and SQL databases in parallel.
Visitor Features
- 🦁 Habitat exploration : Visualize different zoo habitats with descriptions
- 🐘 Animal gallery : Discover animals, their characteristics and habitat
- 🎪 Zoo services : Hours, rates, offered services
- ⭐ Review system : Visitors can leave reviews and ratings
- 📱 Responsive design : Perfect on all devices
Admin Features
- 🔐 Secure login : Authentication for zoo employees
- 🦁 Animal management : Add, modify, delete animal records
- 🏠 Enclosure management : Manage habitats and their capacities
- 🎟️ Service management : Rates, hours, special services
- 📋 Veterinary reports : Access to veterinary observations of animals
Backend Architecture
Backend Explanations
💾 MySQL - Structured data
Stores relational data: users, animals, enclosures, services. Main tables:
animals: id, nom, espece, enclos_idenclosures: id, nom, habitat_type, capaciteservices: id, nom, prix, horairesusers: id, email, password_hash, role
🍃 MongoDB - Flexible data
Stores semi-structured data: visitor reviews, veterinary reports. Main collections:
reviews: avis avec ratings, commentaires, datesvet_reports: rapports détaillés avec observations flexibles
🔌 MVC Architecture
Clear separation between:
- Models: Classes for Animal, Enclosure, Service, Review
- Controllers: AnimalController, AdminController, ReviewController
- Views: PHP templates for public and admin
🔒 🔐 Security:
- Password hashing with bcrypt
- Secure sessions with role verification
- Prepared statements to prevent SQL injection
- Strict server-side data validation
Frontend-Backend Integration
- AJAX : Dynamic content loading without reload
- 🔌 Internal API: Endpoints to create, modify, delete admin data
- 🔍 Smart filtering: Search animals by habitat or species
- ⭐ Rating system: Dynamic review display with average calculation
Technical Challenges Addressed
1. Multi-database management : Coordinating MySQL and MongoDB required careful planning. I learned to choose the right database for the right type of data.
2. Authentication and authorization : Verifying that admins can only access their specific sections strengthened my understanding of web security.
3. Performance : With potentially many animals and reviews, I had to implement pagination and database indexes.