PATH:
root
/
quiz
<!doctype html> <html lang="pl"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Wszystkie zgłoszenia</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"> <h2>Wszystkie potwierdzone zgłoszenia - sortowene po czasie odpowiedzi i data_zgloszenia</h2> <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 zgloszenia WHERE potwierdzenie_email='1' AND data_zgloszenia BETWEEN '$currentday 00:00:00' AND '$currentday 23:59:59' ORDER BY czas ASC"; echo $sql; $result = mysqli_query($conn, $sql); ?> <ul> <li> <span class="id">ID</span> <span class="data">Data zgłoszenia</span> <span class="id2">Czas [s]</span> <span class="email">Email</span> <span class="data">Imię</span> <span class="data">regulamin</span> <span class="data">newsletter</span> <span class="data">Data potwierdzenia email</span> <span class="data">token</span> </li> <?php foreach ($result as $row): ?> <li> <span class="id"><?php echo $row['id'] ?></span> <span class="data"><?php echo $row['data_zgloszenia'] ?></span> <span class="id2"><?php echo $row['czas'] ?></span> <span class="email"><?php echo $row['email'] ?></span> <span class="data"><?php echo $row['name'] ?></span> <span class="data"><?php echo $row['regulamin'] ?></span> <span class="data"><?php echo $row['newsletter'] ?></span> <span class="data"><?php echo $row['data_potwierdzenia_email'] ?></span> <span class="data"><?php echo $row['token'] ?></span> </li> <?php endforeach; ?> </ul> <br><br><br><br> <h2>Wszystkie potwierdzone zgłoszenia - sortowene po czasie odpowiedzi </h2> <?php $sql = "SELECT * FROM zgloszenia WHERE potwierdzenie_email='1' ORDER BY czas ASC"; echo $sql; $result = mysqli_query($conn, $sql); ?> <ul> <li> <span class="id">ID</span> <span class="data">Data zgłoszenia</span> <span class="id2">Czas [s]</span> <span class="email">Email</span> <span class="data">Imię</span> <span class="data">regulamin</span> <span class="data">newsletter</span> <span class="data">Data potwierdzenia email</span> <span class="data">token</span> </li> <?php foreach ($result as $row): ?> <li> <span class="id"><?php echo $row['id'] ?></span> <span class="data"><?php echo $row['data_zgloszenia'] ?></span> <span class="id2"><?php echo $row['czas'] ?></span> <span class="email"><?php echo $row['email'] ?></span> <span class="data"><?php echo $row['name'] ?></span> <span class="data"><?php echo $row['regulamin'] ?></span> <span class="data"><?php echo $row['newsletter'] ?></span> <span class="data"><?php echo $row['data_potwierdzenia_email'] ?></span> <span class="data"><?php echo $row['token'] ?></span> </li> <?php endforeach; ?> </ul> <?php mysqli_close($conn); ?> </main> </body>
[-] form.js
[edit]
[+]
..
[-] COMMITMENT
[edit]
[+]
language
[+]
src
[-] form.php
[edit]
[+]
vendor
[-] show.php
[edit]
[-] verifyemail.php
[edit]
[-] composer
[edit]
[-] HackTimer.js
[edit]
[+]
css
[-] get_oauth_token.php
[edit]
[-] composer.bat
[edit]
[-] composer.json
[edit]
[-] composer.phar
[edit]
[-] index.php
[edit]
[+]
edit