Location-Based Service Hub System Using MERN Stack with SQL-Based Distance Calculation

 Authors:

Kharol Tushar Narayanbhai

Email: kharoltushar@gmail.com

Department of Computer Science & Engineering

Parul Institute of Technology, Faculty of Engineering & Technology Parul University, Vadodara, Gujarat, India

Abstract — The rapid proliferation of internet-enabled mobile devices and location-aware technologies has created a significant opportunity for digital platforms that connect service consumers with nearby service providers. This paper presents the design and implementation of a Location-Based Service Hub System — a full-stack web application developed using the MERN stack (React.js, Node.js, Express.js) integrated with MySQL as the relational database management system. The system incorporates geolocation-driven service discovery using the Haversine formula for real-time proximity computation, a multi-role authentication framework encompassing customers, service providers, and administrators, a complete booking workflow with date and time management, and a secure online payment module implemented through the Razorpay payment gateway. An administrative analytics dashboard powered by Chart.js provides real-time operational insights. The architecture follows RESTful API principles for clean separation between frontend and backend layers. The proposed system demonstrates the viability of combining modern JavaScript frameworks with spatial computing and fintech integration to address the growing demand for on-demand local service platforms, particularly within the context of India's rapidly expanding digital economy.

Keywords — MERN Stack, Location-Based Services, Haversine Formula, Geolocation, Full-Stack Web Development, Razorpay, On-Demand Services, MySQL, RESTful API, Booking System