• PHP & MySQL

Hispanopedia is a cutting-edge web platform that delivers real-time statistical data on Spain’s communities, provinces, and localities. Developed with PHP and MySQL, and built on a responsive Bootstrap framework, the site features a minimalist design optimized for performance, mobile compatibility, and rapid data retrieval.

🌐 Data Acquisition & API Integration

• Data is stored in a local MySQL database for faster access and reduced API load.
• Statistics are retrieved daily using automated PHP scripts that interact with Spain’s official statistics API—INE (Instituto Nacional de Estadística).

🧩 Backend Architecture & Modular Organization

• Information modules are managed via custom backend panels for display priority and dynamic content sorting.
• Separate pages for communities, provinces, and localities ensure organized navigation.

📈 User Engagement & Click Tracking

• An interactive table index on each page tracks module clicks to analyze user interest and optimize the most-viewed content.

⚙️ Variable Management & Smart Text Integration

• A shortcode system allows embedded text to display contextual variable data in each module.
• Admins control which statistical variables appear per module, hiding irrelevant fields for clarity.

📚 Wikipedia Image API & Content Controls

• Visual content from Wikipedia is curated through an admin panel to toggle visibility based on client preferences.

🗺️ Map & Weather Modules via External APIs

• Weather estimates integrated using the AESMET (AEMET) API for locality-specific forecasts.
• Real-time mapping powered by Google Maps, OpenStreet, and the Leaflet library.

🏆 Statistical Rankings & Custom Visualization

• Admin tools support manual and automated updates for enhanced storytelling.
• Rankings highlight key demographics and geographic performance across regions.

📥 Explore Hispanopedia for insightful data, interactive visuals, and streamlined access to Spain’s most detailed geographic stats.