帮我用php语言mysql数据库编写一个用车申请网页

很高兴为您提供帮助，以下是一个简单的用车申请网页的php代码：

创建数据库

CREATE DATABASE car_application;
USE car_application;

CREATE TABLE users (
    id INT(11) NOT NULL AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    password VARCHAR(50) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE cars (
    id INT(11) NOT NULL AUTO_INCREMENT,
    car_name VARCHAR(50) NOT NULL,
    car_model VARCHAR(50) NOT NULL,
    car_number VARCHAR(20) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE applications (
    id INT(11) NOT NULL AUTO_INCREMENT,
    user_id INT(11) NOT NULL,
    car_id INT(11) NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL,
    purpose TEXT NOT NULL,
    status ENUM('pending', 'approved', 'rejected') NOT NULL DEFAULT 'pending',
    PRIMARY KEY (id),
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (car_id) REFERENCES cars(id)
);

创建用车申请页面

<?php
session_start();
if (!isset($_SESSION['user_id'])) {
    header('Location: login.php');
    exit();
}

require_once 'config.php';

$car_list = mysqli_query($conn, "SELECT * FROM cars");

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $user_id = $_SESSION['user_id'];
    $car_id = $_POST['car_id'];
    $start_date = $_POST['start_date'];
    $end_date = $_POST['end_date'];
    $purpose = $_POST['purpose'];

    $query = "INSERT INTO applications (user_id, car_id, start_date, end_date, purpose) 
              VALUES ('$user_id', '$car_id', '$start_date', '$end_date', '$purpose')";
    mysqli_query($conn, $query);

    header('Location: view_applications.php');
    exit();
}
?>

<!DOCTYPE html>
<html>
<head>
    <title>Car Application</title>
</head>
<body>
    <h1>Car Application</h1>

    <form method="post">
        <label for="car_id">Car:</label>
        <select name="car_id" required>
            <option value="">-- Select Car --</option>
            <?php while ($car = mysqli_fetch_assoc($car_list)) { ?>
                <option value="<?= $car['id'] ?>"><?= $car['car_name'] ?> (<?= $car['car_number'] ?>)</option>
            <?php } ?>
        </select><br><br>

        <label for="start_date">Start Date:</label>
        <input type="date" name="start_date" required><br><br>

        <label for="end_date">End Date:</label>
        <input type="date" name="end_date" required><br><br>

        <label for="purpose">Purpose:</label>
        <textarea name="purpose" required></textarea><br><br>

        <input type="submit" value="Submit">
    </form>
</body>
</html>

创建查看申请页面

<?php
session_start();
if (!isset($_SESSION['user_id'])) {
    header('Location: login.php');
    exit();
}

require_once 'config.php';

$user_id = $_SESSION['user_id'];
$application_list = mysqli_query($conn, "SELECT * FROM applications WHERE user_id = '$user_id'");

?>

<!DOCTYPE html>
<html>
<head>
    <title>View Applications</title>
</head>
<body>
    <h1>View Applications</h1>

    <table>
        <tr>
            <th>Car</th>
            <th>Start Date</th>
            <th>End Date</th>
            <th>Purpose</th>
            <th>Status</th>
        </tr>
        <?php while ($application = mysqli_fetch_assoc($application_list)) { ?>
            <?php
                $car = mysqli_query($conn, "SELECT * FROM cars WHERE id = '{$application['car_id']}'")->fetch_assoc();
            ?>
            <tr>
                <td><?= $car['car_name'] ?> (<?= $car['car_number'] ?>)</td>
                <td><?= $application['start_date'] ?></td>
                <td><?= $application['end_date'] ?></td>
                <td><?= $application['purpose'] ?></td>
                <td><?= $application['status'] ?></td>
            </tr>
        <?php } ?>
    </table>
</body>
</html>

以上是一个简单的用车申请网页的php代码，仅供参考。实际应用中，还需要进行安全性和数据验证等方面的处理。