-- 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');
// Create connection $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
<footer class="bg-dark text-white text-center py-3 mt-5"> <p>© 2024 <?php echo SITE_NAME; ?>. All rights reserved.</p> </footer> car rental php script
-- 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 );
$check_result = mysqli_query($conn, $check_sql); -- Reviews table CREATE TABLE reviews ( id
// Site configuration define('SITE_NAME', 'Car Rental System'); define('SITE_URL', 'http://localhost/car-rental/');
// Get car details $sql = "SELECT * FROM cars WHERE id = $car_id AND status = 'available'"; $result = mysqli_query($conn, $sql); rating INT CHECK (rating >
// Set timezone date_default_timezone_set('Asia/Kolkata');