* 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 '90 minute') > now() ORDER BY received DESC"; ?>
Shows all submissions of the last 90 min
NUM ROWS: query($query)->fetchAll()); ?>
fid | flag | service | received | submitted | status | srvresponse |
---|---|---|---|---|---|---|