Вот сам скрипт.
Помогите разобраться
INDEX!.PHP
<?php
$cn = pg_connect("host=localhost port=5432 dbname=db2 user=postgres password=888888");
if($cn)
{
echo "База данных - подключена";
}
$query = "SELECT * FROM patient1 ORDER BY idpatient DESC LIMIT 1";
$rs = pg_query($cn, $query) or die("XYU: $query\n");
$username = date('Y-m-d H:i:s:ms', time());
$user_panel = file_get_contents("index1.tpl");
$user_panel = str_replace("{username}", $username, $user_panel);
echo $user_panel;
?>
<?php
while ($row = pg_fetch_array($rs)) {
?>
<tr>
<td><?=$row[0]?></td>
<td><?=$row[1]?></td>
<td><?=$row[2]?></td>
<td><?=$row[3]?></td>
<td><?=$row[4]?></td>
<td><?=$row[5]?></td>
<td><?=$row[6]?></td>
<td><?=$row[7]?></td>
<td><?=$row[8]?></td>
</tr>
<?php
}
?>
PAGE1.HTML
<!DOCTYPE html>
<html lang="en">
<head>
<title>Центральная станция ALFA</title>
<meta charset="utf-8">
<script type="text/javascript" src="https://code.jquery.com/jquery-3.1.0.js"></script>
</head>
<body>
<div id="result"></div>
</body>
<script type="text/javascript">
$(function() {
(function worker() {
$.ajax({
url: 'index1.php',
method: 'POST',
data: {'test':'yes'},
success: function(data) {
$('#result').html(data);
},
complete: function() {
setTimeout(worker, 1000);
}
});
})();
});
</script>
</html>