Car Rental Php Script [Works 100%]
// Check if car is available for selected dates $check_sql = "SELECT * FROM bookings WHERE car_id = $car_id AND status NOT IN ('cancelled', 'completed') AND ((pickup_date BETWEEN '$pickup_date' AND '$return_date') OR (return_date BETWEEN '$pickup_date' AND '$return_date') OR ('$pickup_date' BETWEEN pickup_date AND return_date))";
$check_result = mysqli_query($conn, $check_sql);
if ($_SERVER['REQUEST_METHOD'] == 'POST') $username = mysqli_real_escape_string($conn, $_POST['username']); $email = mysqli_real_escape_string($conn, $_POST['email']); $password = password_hash($_POST['password'], PASSWORD_DEFAULT); $full_name = mysqli_real_escape_string($conn, $_POST['full_name']); $phone = mysqli_real_escape_string($conn, $_POST['phone']); $license_number = mysqli_real_escape_string($conn, $_POST['license_number']); car rental php script
if ($_SERVER['REQUEST_METHOD'] == 'POST') $pickup_date = $_POST['pickup_date']; $return_date = $_POST['return_date'];
if ($_SERVER['REQUEST_METHOD'] == 'POST') $username = mysqli_real_escape_string($conn, $_POST['username']); $password = $_POST['password']; // Check if car is available for selected
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Register - <?php echo SITE_NAME; ?></title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"> </head> <body class="bg-light"> <div class="container mt-5"> <div class="row justify-content-center"> <div class="col-md-6"> <div class="card shadow"> <div class="card-header bg-primary text-white"> <h4 class="mb-0">Register</h4> </div> <div class="card-body"> <?php if($error) echo showMessage($error, 'danger'); ?> <?php if($success) echo showMessage($success, 'success'); ?>
-- Bookings table CREATE TABLE bookings ( id INT PRIMARY KEY AUTO_INCREMENT, user_id INT, car_id INT, pickup_date DATE NOT NULL, return_date DATE NOT NULL, total_days INT, total_price DECIMAL(10,2), status ENUM('pending', 'confirmed', 'active', 'completed', 'cancelled') DEFAULT 'pending', payment_status ENUM('pending', 'paid', 'refunded') DEFAULT 'pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE, FOREIGN KEY (car_id) REFERENCES cars(id) ON DELETE CASCADE ); $check_result = mysqli_query($conn
// Function to check if user is logged in function isLoggedIn() return isset($_SESSION['user_id']);