// Get car details $sql = "SELECT * FROM cars WHERE id = $car_id AND status = 'available'"; $result = mysqli_query($conn, $sql);
// Function to check if user is logged in function isLoggedIn() return isset($_SESSION['user_id']);
-- 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');
?>
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title><?php echo SITE_NAME; ?></title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css"> </head> <body> <nav class="navbar navbar-expand-lg navbar-dark bg-dark"> <div class="container"> <a class="navbar-brand" href="index.php"><?php echo SITE_NAME; ?></a> <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav"> <span class="navbar-toggler-icon"></span> </button> <div class="collapse navbar-collapse" id="navbarNav"> <ul class="navbar-nav ms-auto"> <?php if(isLoggedIn()): ?> <li class="nav-item"> <a class="nav-link" href="my-bookings.php">My Bookings</a> </li> <li class="nav-item"> <a class="nav-link" href="logout.php">Logout (<?php echo $_SESSION['user_name']; ?>)</a> </li> <?php else: ?> <li class="nav-item"> <a class="nav-link" href="login.php">Login</a> </li> <li class="nav-item"> <a class="nav-link" href="register.php">Register</a> </li> <?php endif; ?> </ul> </div> </div> </nav>
$check_result = mysqli_query($conn, $check_sql);
// Get car details $sql = "SELECT * FROM cars WHERE id = $car_id AND status = 'available'"; $result = mysqli_query($conn, $sql);
// Function to check if user is logged in function isLoggedIn() return isset($_SESSION['user_id']);
-- 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');
?>
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title><?php echo SITE_NAME; ?></title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css"> </head> <body> <nav class="navbar navbar-expand-lg navbar-dark bg-dark"> <div class="container"> <a class="navbar-brand" href="index.php"><?php echo SITE_NAME; ?></a> <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav"> <span class="navbar-toggler-icon"></span> </button> <div class="collapse navbar-collapse" id="navbarNav"> <ul class="navbar-nav ms-auto"> <?php if(isLoggedIn()): ?> <li class="nav-item"> <a class="nav-link" href="my-bookings.php">My Bookings</a> </li> <li class="nav-item"> <a class="nav-link" href="logout.php">Logout (<?php echo $_SESSION['user_name']; ?>)</a> </li> <?php else: ?> <li class="nav-item"> <a class="nav-link" href="login.php">Login</a> </li> <li class="nav-item"> <a class="nav-link" href="register.php">Register</a> </li> <?php endif; ?> </ul> </div> </div> </nav>
$check_result = mysqli_query($conn, $check_sql);
ECUADOR
