Car Rental Php Script — Original

// Calculate days and price $pickup = new DateTime($pickup_date); $return = new DateTime($return_date); $interval = $pickup->diff($return); $total_days = $interval->days + 1; $total_price = $total_days * $car['price_per_day'];

// 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))"; car rental php script

-- Users table CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(50) UNIQUE NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, password VARCHAR(255) NOT NULL, full_name VARCHAR(100), phone VARCHAR(20), address TEXT, license_number VARCHAR(50), role ENUM('admin', 'customer') DEFAULT 'customer', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); // Calculate days and price $pickup = new

if ($_SERVER['REQUEST_METHOD'] == 'POST') $username = mysqli_real_escape_string($conn, $_POST['username']); $password = $_POST['password']; $return = new DateTime($return_date)

// Function to check if user is logged in function isLoggedIn() return isset($_SESSION['user_id']);