Car Rental Php: Script

// Create connection $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);

-- 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 );

-- Cars table CREATE TABLE cars ( id INT PRIMARY KEY AUTO_INCREMENT, brand VARCHAR(50) NOT NULL, model VARCHAR(50) NOT NULL, year INT, license_plate VARCHAR(20) UNIQUE NOT NULL, color VARCHAR(30), seats INT DEFAULT 5, transmission ENUM('Manual', 'Automatic') DEFAULT 'Manual', fuel_type ENUM('Petrol', 'Diesel', 'Electric', 'Hybrid') DEFAULT 'Petrol', price_per_day DECIMAL(10,2) NOT NULL, image VARCHAR(255), status ENUM('available', 'rented', 'maintenance') DEFAULT 'available', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); car rental php script

if ($_SERVER['REQUEST_METHOD'] == 'POST') $pickup_date = $_POST['pickup_date']; $return_date = $_POST['return_date'];

$user_id = $_SESSION['user_id']; $sql = "SELECT b.*, c.brand, c.model, c.license_plate FROM bookings b JOIN cars c ON b.car_id = c.id WHERE b.user_id = $user_id ORDER BY b.created_at DESC"; $result = mysqli_query($conn, $sql); ?> $car['year']

$error = '';

<h2 class="mb-4">Available Cars</h2> <div class="row"> <?php if(mysqli_num_rows($result) > 0): ?> <?php while($car = mysqli_fetch_assoc($result)): ?> <div class="col-md-4 mb-4"> <div class="card h-100 shadow-sm"> <?php if($car['image']): ?> <img src="uploads/<?php echo $car['image']; ?>" class="card-img-top" alt="<?php echo $car['brand'] . ' ' . $car['model']; ?>" style="height: 200px; object-fit: cover;"> <?php else: ?> <div class="bg-secondary text-white text-center py-5"> <i class="fas fa-car fa-3x"></i> </div> <?php endif; ?> <div class="card-body"> <h5 class="card-title"><?php echo $car['brand'] . ' ' . $car['model'] . ' (' . $car['year'] . ')'; ?></h5> <p class="card-text"> <i class="fas fa-chair"></i> <?php echo $car['seats']; ?> Seats | <i class="fas fa-cog"></i> <?php echo $car['transmission']; ?> | <i class="fas fa-gas-pump"></i> <?php echo $car['fuel_type']; ?> </p> <p class="card-text"> <strong>License Plate:</strong> <?php echo $car['license_plate']; ?><br> <strong>Color:</strong> <?php echo $car['color']; ?> </p> <h4 class="text-primary">$<?php echo number_format($car['price_per_day'], 2); ?>/day</h4> </div> <div class="card-footer bg-transparent"> <?php if(isLoggedIn()): ?> <a href="book-car.php?id=<?php echo $car['id']; ?>" class="btn btn-primary w-100">Book Now</a> <?php else: ?> <a href="login.php" class="btn btn-primary w-100">Login to Book</a> <?php endif; ?> </div> </div> </div> <?php endwhile; ?> <?php else: ?> <div class="col-12"> <div class="alert alert-info">No cars available at the moment.</div> </div> <?php endif; ?> </div> </div> $car['year'] . ')'

?>