<?php require_once 'includes/mac_address.php'; require_once 'includes/progress.php'; if (!isset($_POST['submit'])) { die; } $db = new PDO('mysql:host=localhost;dbname=sitc', 'root', ''); $qr = $_POST['qr']; if (!mac_found($db)) { record_mac($db); } $qr_codes = load_qr_codes($db); if (count($qr_codes) === 10) { ?> {"already_won":1}<?php die; } if (array_search($qr, $qr_codes) !== FALSE) { ?> {"found":1}<?php die; } $statement = $db->prepare('SELECT COUNT(*) AS qr_count, funfact FROM stand WHERE qrcode=?'); $statement->bindValue(1, $qr, PDO::PARAM_STR); $statement->execute(); $qr_row = $statement->fetch(PDO::FETCH_ASSOC); if (!$qr_row['qr_count']) { ?> {"non_occuring":1}<?php die;
<button id="start" class="btn btn-primary" type="button">Start!</button> </div> </div> </div> </div> <p class="waiting"> waiting <strong class="waiting_dots"> <span class="first_waiting_dot">.</span> <span class="second_waiting_dot">.</span> <span class="third_waiting_dot">.</span> </strong> </p> <p> <strong id="qr_remaining"><?php echo 10 - count(load_qr_codes($db)); ?> </strong> stands remaining! </p> <p> <strong id="funfact"></strong> </p> <div id="non_occuring_qr" class="modal"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> <span aria-hidden="true">×</span> <span class="sr-only">Close</span> </button> </div>