Gift267/malawi-tourism-directory

Directory of banks, lodges, safaris, banks, etc for the tourism industry # Malawi Tourism Directory A searchable web directory for tourism in Malawi — the Warm Heart of Africa. It lists hotels, lodges, safari and tour operators, restaurants, airlines, attractions, national parks, campsites, activities, museums, guesthouses, transport and more across all 28 districts. Built with **Flask + PyMySQL**, modelled on the Malawi NGO Directory project. ## Features - **Directory & search** — browse listings with full-text search and filters by type, district, minimum rating and sort order (name / highest rated / newest). - **User submissions** — visitors suggest new listings via a form; they are saved as **pending** until an admin acts on them. - **Admin dashboard** — approve or reject submissions, and mark approved listings as **verified** (verified badge shown publicly). - **Ratings & reviews** — anyone can rate a listing 1–5 stars and leave a review; the average rating and review count are displayed and used for filtering. - **14 tourist types** — hotel, lodge, guesthouse, safari operator, tour operator, restaurant, airline, attraction, national park, campsite, activity, museum, bar, transport. - **Responsive design** — mobile-first layout with a **dark/light theme toggle** (persisted in `localStorage`, honours `prefers-color-scheme`). - **Malawi-themed visuals** — day and night SVG scenes of Lake Malawi (sunset sailboat, baobab, hills, city skyline / starlit lake, moon, baobab) used as the site background in each theme. ## Tech stack - Python 3 / Flask - PyMySQL (MySQL / MariaDB) - Jinja2 templates, vanilla CSS + JS ## Project structure ``` app.py Flask app: routes, admin auth, review logic config.py Database & secret configuration (env-overridable) db.py PyMySQL connection helpers (Flask appcontext) constants.py Listing types, districts, sort options schema.sql Database schema seed.py Seed script: 66 listings + reviews + admin account templates/ Jinja2 templates (public + adm …