Php Script: Car Rental

// Check connection if (!$conn) die("Connection failed: " . mysqli_connect_error());

// 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']; car rental php script

$sql = "SELECT * FROM users WHERE username = '$username' OR email = '$username'"; $result = mysqli_query($conn, $sql); // Check connection if (

-- Reviews table CREATE TABLE reviews ( id INT PRIMARY KEY AUTO_INCREMENT, user_id INT, car_id INT, rating INT CHECK (rating >= 1 AND rating <= 5), comment TEXT, 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 ); <?php session_start(); // Database configuration define('DB_HOST', 'localhost'); define('DB_USER', 'root'); define('DB_PASS', ''); define('DB_NAME', 'car_rental'); $return = new DateTime($return_date)

// Function to check if user is admin function isAdmin() return isset($_SESSION['user_role']) && $_SESSION['user_role'] == 'admin';

-- Payments table CREATE TABLE payments ( id INT PRIMARY KEY AUTO_INCREMENT, booking_id INT, amount DECIMAL(10,2), payment_method VARCHAR(50), transaction_id VARCHAR(100), status ENUM('pending', 'completed', 'failed') DEFAULT 'pending', payment_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (booking_id) REFERENCES bookings(id) ON DELETE CASCADE );