Car Rental Php Script Here

<footer class="bg-dark text-white text-center py-3 mt-5"> <p>© 2024 <?php echo SITE_NAME; ?>. All rights reserved.</p> </footer>

$check_result = mysqli_query($conn, $check_sql); car rental php script

-- 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 ); $password = $_POST['password']

// Check if user exists $check = mysqli_query($conn, "SELECT id FROM users WHERE email = '$email' OR username = '$username'"); if (mysqli_num_rows($check) > 0) $error = "Username or email already exists!"; else $sql = "INSERT INTO users (username, email, password, full_name, phone, license_number) VALUES ('$username', '$email', '$password', '$full_name', '$phone', '$license_number')"; if (mysqli_query($conn, $sql)) $success = "Registration successful! You can now login."; else $error = "Registration failed: " . mysqli_error($conn); meta name="viewport" content="width=device-width

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

$car_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

<!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>