<h2>Login to access:</h2> <form method="post"> <p> <input type="radio" id="format1" name="format" value="preview" checked><label for="format1">Preview</label> <br /> <input type="radio" id="format2" name="format" value="download"><label for="format2">Download</label> </p> <p><label for="password">Password: </label> <input name="password" id="password" type="password" /></p> <p><input type="submit" name="submit" value="Submit" /></p> </form> <?php } else { $dbconn = db_openDB(); $sql = "SELECT * FROM reports WHERE finalized IS NOT NULL"; $result = mysqli_query($dbconn, $sql); $fields = mysqli_fetch_fields($result); $header = ""; $first = true; foreach ($fields as $val) { if ($first) { $first = false; } else { $header .= ","; } $header .= $val->name; } $data = ""; while ($row = mysqli_fetch_row($result)) {
function checkPurge() { if (isset($_REQUEST["purgeIncomplete"])) { $x = min($_REQUEST["purgeIncomplete"] * 60, 2 * 60 * 60); $dbconn = db_openDB(); // TODO: if image uploads being done, need to purge associated images? $sql = "DELETE FROM reports WHERE (now() - created) > {$x} AND finalized IS NULL"; //print($sql); $result = mysqli_query($dbconn, $sql); //printf("Select returned %d rows.\n", mysqli_num_rows($result)); } }