Untitled

avatar
unknown
plain_text
a year ago
1.4 kB
5
Indexable
<?php
$conn = mysqli_connect("localhost", "root", "", "4ti_todo");

if (isset($_POST["todo_add"])) {
    $nazwa_zadania = $_POST["todo_name"];
    $priorytet = $_POST["todo_priority"];

    $q_ins = "INSERT INTO todos VALUES (null, '$nazwa_zadania', '$priorytet')";

    mysqli_query($conn, $q_ins);
}

$q_sel = "SELECT * FROM todos";
$result = mysqli_query($conn, $q_sel);
?>

<!DOCTYPE html>
<html lang="pl">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Lista zadań</title>
    <link rel="stylesheet" href="todo.css">
</head>
<body>
    <h1>Lista zadań:</h1>
    <ul>
        <?php
        while ($row = mysqli_fetch_assoc($result)) {
            $nazwa = $row["name"];
            $priorytet = "p" . $row["priority"];

            echo "<li class='$priorytet'>$nazwa</li>";
        }
        ?>
    </ul>
    <form method="POST">
        <input type="text" id="todo_name" name="todo_name" placeholder="Zadanie" required />
        <select id="todo_priority" name="todo_priority">
            <option value="1">Niski</option>
            <option value="2">Średni</option>
            <option value="3">Wysoki</option>
        </select>
        <button type="submit" id="todo_add" name="todo_add">
            Dodaj
        </button>
    </form>
</body>
</html>

<?php
mysqli_close($conn);
?>
Editor is loading...
Leave a Comment