* do not publish! */ $GLOBALS['db'] = new PDO('pgsql:host=localhost;port=5432;dbname=postgres;user=postgres;password=dba'); $GLOBALS['db']->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $query = "SELECT * FROM flags WHERE (received + INTERVAL '30 minute') > now() and char_length(flag) = 32 ORDER BY received DESC"; ?>

Submission Board

Shows all submissions of the last 30 min
NUM ROWS: query($query)->fetchAll()); ?>

query($query); while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { ?>

fid	flag	service	received	submitted	status	srvresponse