2 if (!isset($_POST['oid'])) {
3 header('Location: index.php');
7 #include <infocon.style>
9 <page func=InfoCon title="Stempeluhr">
12 function hour2min($hour)
14 $parts = explode(':', $hour);
16 return $parts[0]*60 + $parts[1];
19 $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
20 or die("Unable to connect to SQL server");
23 if (isset($_POST['delete'])) {
24 $query = sprintf("DELETE FROM stempel WHERE oid = %d",
27 $sth = pg_exec ($dbh, $query);
28 echo('<p><strong>Deleted.</strong></p>');
30 $query = sprintf("UPDATE stempel SET time=%d, start='%s', stop='%s', task='%s', status=%d WHERE oid = %d",
31 hour2min($_POST['time']),
32 pg_escape_string($dbh, $_POST['start']),
33 pg_escape_string($dbh, $_POST['stop']),
34 pg_escape_string($dbh, $_POST['task']),
38 $sth = pg_exec ($dbh, $query);
39 echo('<p><strong>Updated.</strong></p>');
44 <p>Return to <a href="index.php">Index</a>, <a href="edit.php?id=<?=$_POST['oid']?>">edit page</a></p>