Skip to content
Mateo Sonzogni

Project · tienda-mistica

Tienda Mística

Role
Da Vinci coursework · pure PHP
Client
Escuela Da Vinci · Buenos Aires, AR
Year
2026
Status
Live
Technologies
  • JavaScriptLanguages. Since 2022 · 4 years. The foundation of modern web development, ECMAScript standards and native DOM manipulation. Only in this work for now.
  • MariaDBData. Since 2025 · 1 year. A MySQL-compatible relational database accessed through PDO: catalog, cart and orders on a normalized model, with no ORM in between. Only in this work for now.
  • PHPLanguages. Since 2025 · 1 year. A traditional backend language used in client integrations and transactional modules. Also in Circuito Kitsune.
  • Tailwind CSSTooling. Since 2026. A composable, utility-first design system with aggressive purging for ultra-light bundles. Also in La Rúcula Gastrobar, ARG Piscinas, Ynara Web, and Circuito Kitsune.
Tienda Mística cover: the “TIENDA MÍSTICA — Collect Legendary Elves” masthead in arcade type on a dark background with a grid

A fictional e-commerce store of magical elves in pure PHP, with no framework: a front controller, PDO and MariaDB. Catalog, cart, blog and admin panel, with an arcade look.

Brief

A PHP coursework project built by hand, with no framework hiding how it works: a custom front controller, PDO classes and a relational model on MariaDB. The challenge was to make the fundamentals visible and still give the shop a brand identity.

Process

  1. Brief

    A coursework assignment asked for a shop with a catalog, a cart and administration in PHP without a framework. The decision was not to ship a bare CRUD but a brand: an arcade of legendary elves inspired by the enchanted forests of Ireland.

  2. Model

    A custom front controller (index.php) that routes by section, PDO classes on MariaDB and an 18-table relational model: elves, rarities, materials, accessories, blog, cart and orders. An admin panel behind session authentication; no framework doing the work underneath.

  3. Piece

    Arcade-cyberpunk art direction: an Orbitron masthead, a monospaced HUD and an intro that assembles the “mystic portal”. A catalog filterable by rarity and a detail page for each elf, with a closed visual system on its own color tokens.

Outcome

In production at mistica.mateogs.tech. A catalog of 21 elves across four rarities on an 18-table model, with a session cart, a blog of chronicles, a contact page and an admin panel with authentication. All in pure PHP served by Apache + mod_php, with no framework dependencies.

Metrics

  • 21SpritesSprites. Creatures in the catalog, each with its rarity and accessories.
  • 4RaritiesRarities. Catalog rarity tiers, from common to legendary.
  • 40AccessoriesAccessories. Accessories that equip the sprites, on their own tables.
  • 18TablesTables. Tables in the MariaDB relational model, accessed with PDO.

Links