Car Rental Php Script | Validated

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

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

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

// Get car details $sql = "SELECT * FROM cars WHERE id = $car_id AND status = 'available'"; $result = mysqli_query($conn, $sql);

if ($_SERVER['REQUEST_METHOD'] == 'POST') $username = mysqli_real_escape_string($conn, $_POST['username']); $email = mysqli_real_escape_string($conn, $_POST['email']); $password = password_hash($_POST['password'], PASSWORD_DEFAULT); $full_name = mysqli_real_escape_string($conn, $_POST['full_name']); $phone = mysqli_real_escape_string($conn, $_POST['phone']); $license_number = mysqli_real_escape_string($conn, $_POST['license_number']); $sql = "SELECT * FROM users WHERE username

?>

// 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); $result = mysqli_query($conn

// Site configuration define('SITE_NAME', 'Car Rental System'); define('SITE_URL', 'http://localhost/car-rental/');

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