Skip to content

Latest commit

Β 

History

History
83 lines (55 loc) Β· 1.92 KB

File metadata and controls

83 lines (55 loc) Β· 1.92 KB

One Stop Guide

One Stop Guide is a responsive and dynamic web platform that helps users explore major Indian cities. It combines static city pages with PHP & MySQL backend to deliver city-specific information dynamically, and includes Google Maps integration for real-world exploration.


πŸš€ Features

  • πŸ™οΈ Explore various Indian cities like Ajmer, Delhi, Sikar, and more
  • πŸ“ β€œExplore” button redirects to the city on Google Maps
  • 🧠 City info dynamically loaded using PHP and MySQL
  • πŸ’‘ User-friendly and mobile responsive design
  • 🧾 Database file (CityGuideDb.sql) included for easy setup

πŸ§‘β€πŸ’» Technologies Used

Frontend:

  • HTML5
  • CSS3
  • JavaScript

Backend:

  • PHP

Database:

  • MySQL

πŸ“ Project Structure

One-Stop-Guide/
β”œβ”€β”€ indx.html # Main homepage
β”œβ”€β”€ ajmer.html, delhi.html # Static city pages
β”œβ”€β”€ city.php, sikar.php # Dynamic pages using PHP
β”œβ”€β”€ dbconnect.php # DB connection file
β”œβ”€β”€ CityGuideDb.sql # SQL file to create and populate DB
└── assets/ # (If present) For images, CSS, JS


βš™οΈ How to Run Locally (XAMPP/WAMP)

  1. Clone or download this repo and move the folder into htdocs (for XAMPP).
  2. Start Apache and MySQL from XAMPP Control Panel.
  3. Import the database:
    • Go to phpMyAdmin
    • Create a DB named CityGuide
    • Import CityGuideDb.sql
  4. Open the browser and visit:
  5. Click on any city card or page. Pages like sikar.php fetch data from DB.

πŸ’‘ Future Scope

  • Add login/register functionality
  • User feedback or review system
  • Admin panel to update city content
  • API integration (weather, transport, tourism)

πŸ™‹β€β™€οΈ Developed By

Komal Khatod
B.Tech CSE (3rd Year), Mody University of Science and Technology
πŸ“§ Email: [komalkhatod1234@gmail.com]
πŸ”— GitHub: komalkhatod1105