Share via

Edit items in database in PHP

Jack Herer 110 Reputation points
2023-04-25T06:17:08.2266667+00:00 

<?php

require_once 'db.php';

$sql = 'SELECT * FROM manufacturer';

$stmt = $conn->prepare($sql);
$stmt->execute();
$manufacturers = $stmt->fetchAll();


$sql = 'SELECT * FROM employee';

$stmt = $conn->prepare($sql);
$stmt->execute();
$employees = $stmt->fetchAll();

$sql = 'SELECT * FROM cars';

$stmt = $conn->prepare($sql);
$stmt->execute();
$cars = $stmt->fetchAll();

$car = null;

 if (isset($_POST['edit_car'], $_POST['car_id'])) {

    $sql = 'UPDATE cars SET model = :model, license_plate = :license_plate, id_employee = :employee WHERE id = :id';

    $stmt = $conn->prepare($sql);
    $stmt->execute([
        ':model' => $_POST['model'],
        ':license_plate' => $_POST['license_plate'],
        ':employee' => $_POST['employee'],
        ':id' => $_POST['car_id'],
    ]);

    header('Location: index.php');
}


if (isset($_GET['id'])) {
    $sql = 'SELECT * FROM cars WHERE id = :id';
    $stmt = $conn->prepare($sql);
    $stmt->execute([':id' => $_GET['id']]);
    $car = $stmt->fetch();
}

?>

<!doctype html>

        <html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="stylesheet" href="styles.css">
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js"></script>

    <title>Driver</title>
</head>
<body style="">
<form action="" method="post" style="margin: 20px 100px 0 100px">
    <div style="display: flex; justify-content: space-between">
        <h2>Upravit Vozidlo</h2>
        <button style="height: 30px; align-self: center;">Uložit</button>
    </div>
    <input type="hidden" name="edit_car" value="1">
    <input type="hidden" name="car_id" value="<?= $car['id'] ?>">
    <div style="display: grid; grid-template-columns: 1fr 1fr; justify-content: center; align-items: center; width: 500px">
        <div>
            <label for="manufacturer">Značka</label>
            <select name="manufacturer" id="manufacturer">
                <?php foreach($manufacturers as $manufacturer):?>
                    <option value="<?= $manufacturer['id'] ?>" <?= $car['id_manufacturer'] == $manufacturer['id'] ? 'selected' : '' ?>><?= $manufacturer['name'] ?></option>
                <?php endforeach?>
            </select>
        </div>
        <div style="display: flex; flex-direction: column; width: 150px">
            <label for="">Model Vozidla</label>
            <input type="text" name="model" value="<?= $car['model'] ?>">
        </div>
        <div style="display: flex; flex-direction: column; width: 150px">
            <label for="">SPZ</label>
            <input type="text" name="license_plate" value="<?= $car['license_plate'] ?>">
        </div>
        <div>
            <label for="employee">Zodpovědný řidič</label>
            <select name="employee" id="employee">
                <?php foreach($employees as $employee):?>
                    <option value="<?= $employee['id'] ?>" <?= $car['id_employee'] == $employee['id'] ? 'selected' : '' ?>><?= $employee['name'] ?></option>
                <?php endforeach?>
            </select>
        </div>
    </div>

</form>
</body>
</html>
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
883 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.