📁 File Manager
Editing:
/home/wedigitalindia/public_html/home-wedigitalindia/punja-sahib/local-city.php
<?php include("admin/connection.php"); include('include/header.php'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Collect & sanitize $trip_type = trim($_POST['trip_type'] ?? ''); $bus_type = trim($_POST['bus_type'] ?? ''); $journey_date_raw = trim($_POST['journey_date'] ?? ''); $name = trim($_POST['name'] ?? ''); $email = trim($_POST['email'] ?? ''); $phone = trim($_POST['phone'] ?? ''); $pickup_address = trim($_POST['pickup_address'] ?? ''); $destination_address = trim($_POST['destination_address'] ?? ''); // Convert date safely $journey_date = $journey_date_raw ? date("Y-m-d", strtotime($journey_date_raw)) : ''; // ✅ Prevent blank submission if ($trip_type == '' || $bus_type == '' || $journey_date == '' || $name == '' || $email == '' || $phone == '' || $pickup_address == '' || $destination_address == '') { echo "<script>alert('Please fill all required fields.');</script>"; } else { // Escape inputs $trip_type = mysqli_real_escape_string($con, $trip_type); $bus_type = mysqli_real_escape_string($con, $bus_type); $journey_date = mysqli_real_escape_string($con, $journey_date); $name = mysqli_real_escape_string($con, $name); $email = mysqli_real_escape_string($con, $email); $phone = mysqli_real_escape_string($con, $phone); $pickup_address = mysqli_real_escape_string($con, $pickup_address); $destination_address = mysqli_real_escape_string($con, $destination_address); // Insert booking $sql = "INSERT INTO `local_city` (`trip_type`, `bus_type`, `journey_date`, `name`, `email`, `phone`, `pickup_address`, `destination_address`, `created_at`) VALUES ('$trip_type', '$bus_type', '$journey_date', '$name', '$email', '$phone', '$pickup_address', '$destination_address', NOW())"; if (mysqli_query($con, $sql)) { // WhatsApp message $message = "*Local City New Booking* \n" . "Trip Type: $trip_type\n" . "Bus Type: $bus_type\n" . "Journey Date: $journey_date\n" . "Name: $name\n" . "Email: $email\n" . "Phone: $phone\n" . "Pickup: $pickup_address\n" . "Destination: $destination_address"; $waMessage = urlencode($message); $whatsappNumber = "919812390615"; // without + echo "<script> // alert('Booking Confirmed!'); window.location.href = 'https://wa.me/$whatsappNumber?text=$waMessage'; </script>"; } else { echo "<script>alert('Booking failed! Try again.');</script>"; } } } ?> <main class="main"> <!-- breadcrumb --> <div class="site-breadcrumb" style="background: url(assets/img/breadcrumb/01.jpg)"> <div class="container"> <h2 class="breadcrumb-title">Local City Booking</h2> <ul class="breadcrumb-menu"> <li><a href="index.php">Home</a></li> <li class="active">Local City Booking</li> </ul> </div> </div> <!-- breadcrumb end --> <!-- flight booking --> <div class="flight-booking py-120"> <div class="container"> <div class="row"> <div class="col-lg-9"> <div class="booking-widget"> <h4 class="booking-widget-title">Book Your Taxi/Cab For Local City Travel</h4> <div class="booking-form"> <form action="#" method="post"> <div class="row"> <div class="col-lg-4"> <div class="form-check"> <input class="form-check-input" name="trip_type" type="radio" value="8 Hours (80 Km.)" id="trip1" required> <label class="form-check-label" for="room-type5"> 8 Hours (80 Km.) </label> </div> <div class="form-check"> <input class="form-check-input" name="trip_type" type="radio" value="12 Hours (120 Km.)" id="trip2"> <label class="form-check-label" for="room-type5"> 12 Hours (120 Km.) </label> </div> </div> <div class="col-lg-4"> <div class="form-group"> <label>I Need a Bus</label> <div class="form-group-icon"> <input type="text" class="form-control" name="bus_type" id="bus_type" placeholder="I Need a bus" required> <i class="fa-solid fa-car"></i> </div> </div> </div> <div class="col-lg-4"> <div class="form-group"> <label>Journey Date</label> <div class="form-group-icon search-form-date"> <input type="text" name="journey_date" id="journey_date" class="form-control date-picker journey-date" placeholder="Journey Date" required> <i class="fal fa-calendar-days"></i> </div> </div> </div> <div class="col-lg-4"> <div class="form-group"> <label>Name</label> <div class="form-group-icon"> <input type="text" name="name" id="name" class="form-control" placeholder="Name" oninput="this.value = this.value.replace(/[^a-zA-Z\s]/g, '')" required> <i class="far fa-user"></i> </div> </div> </div> <div class="col-lg-4"> <div class="form-group"> <label>Email</label> <div class="form-group-icon"> <input type="text" name="email" id="email" class="form-control" placeholder="Your Email" required> <i class="far fa-envelopes"></i> </div> </div> </div> <div class="col-lg-4"> <div class="form-group"> <label>Phone</label> <div class="form-group-icon"> <input type="text" name="phone" id="phone" class="form-control" placeholder="Phone Number" maxlength="10" oninput="this.value = this.value.replace(/[^0-9]/g, '')" required> <i class="far fa-phone"></i> </div> </div> </div> <div class="col-lg-12"> <div class="form-group"> <label>Pick Up Point Address</label> <div class="form-group-icon"> <input type="text" class="form-control" name="pickup_address" id="pickup_address" placeholder="Pick Up Point Address" required> <i class="far fa-map-location-dot"></i> </div> </div> </div> <div class="col-lg-12"> <div class="form-group"> <label>Destination Point Address</label> <div class="form-group-icon"> <input type="text" class="form-control" name="destination_address" id="destination_address" placeholder="Destination Point Address" required> <i class="far fa-map-location-dot"></i> </div> </div> </div> <div class="form-group mt-2"> <button type="submit" name="submit" class="theme-btn">Confirm Booking<i class="fas fa-arrow-circle-right"></i></button> </div> </div> </form> </div> </div> </div> <div class="col-lg-3"> <div class="booking-summary"> <h4 class="mb-30">Booking Summary</h4> <div class="booking-property-img"> <img src="assets/img/flight/07.jpg" alt=""> </div> </div> </div> </div> </div> </div> <!-- tour booking end --> </main> <?php include("include/footer.php"); ?>
Save
Cancel