PATH:
root
/
quizedit
<!doctype html> <html lang="pl"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Edycja</title> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@400;600&&display=swap" rel="stylesheet"> <link rel="stylesheet" href="css/style.css"> </head> <?php $currentday = date("Y-m-d"); if(isset($_POST['SubmitButton'])){ //check if form was submitted $currentday = $_POST['data']; //get input text } ?> <body> <main id="content" role="main" class="content show-all"> <form action="" method="post"> <input type="date" id="data" name="data" value="<?php echo $currentday?>" /> <input type="submit" name="SubmitButton" value="zmień date"> </form> <br><br> <?php $conn = mysqli_connect("localhost", "quiz", "quiz", "quiz"); // Check connection if($conn === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } $sql = "SELECT * FROM ranking"; echo $sql; $result = mysqli_query($conn, $sql); ?> <ul> <li> <span class="id">Imię</span> <span class="data">Czas</span> </li> <?php foreach ($result as $row): ?> <li> <span class="id"><?php echo $row['Imie'] ?></span> <span class="data"><?php echo $row['Czas'] ?></span> </li> <?php endforeach; ?> </ul> <?php mysqli_close($conn); ?> </main> </body>
[+]
..
[-] edit.php
[edit]