|
8
845
|
<?php
session_start();
$_SESSION = array();
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Herp de derp</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<script type="text/javascript" src="/js/jquery.js"></script>
<script type="text/javascript">
setInterval('update()', 500);
function update() {
$.ajax({
dataType: 'json',
url: './ajax.php',
success: function (data) {
var $v = $("#viewer");
for (i = 0; i < data.length; i++) {
x = data[i].replace(/\/derp/, "");
$('<img alt="img" src=".' + x +'" />').prependTo($v);
}
while ($v.children().length > 30) {
$v.children().last().remove();
}
}
});
}
</script>
<style type="text/css">
img {
display: block;
float: left;
clear: both;
}
</style>
</head>
<body>
<h1>Derp de herp</h1>
<div id="viewer"></div>
</body>
</html>
<?php
session_start();
$lastid = $_SESSION['lastid'] ?: 0;
$pg = pg_connect("s33crit inf0z");
$res = pg_query($pg, "SELECT imagePath, imageId FROM images ORDER BY imageId DESC LIMIT 30");
$a = array();
$row = pg_fetch_array($res);
if ($row['imageid'] == $lastid) {
die(json_encode(array()));
}
$a[] = $row['imagepath'];
$newid = $row['imageid'];
while ($row = pg_fetch_array($res)) {
if ($row['imageid'] <= $lastid) {
break;
}
$a[] = $row['imagepath'];
}
$_SESSION['lastid'] = $newid;
echo json_encode($a);
?>
<script>
$(document).ready(function() {
$("#news").load("news.php");
var refreshId = setInterval(function() {
$("#news").load('news.php');
}, 20000);
});
</script>
|
|
