1 #include <infocon.style>
3 <page title="Kontoführung">
5 <headline "Buchhaltung">
8 $dbh = pg_pconnect ("kuolema", "5432", "<db>")
9 or die("Unable to connect to SQL server");
11 $query = "SELECT nr FROM sales WHERE paid=0";
12 $sth = pg_exec ($dbh, $query);
14 # Collect all to be paid entries
16 for ($nr=0; $nr <pg_NumRows ($sth); $nr++) {
17 $row = pg_fetch_array ($sth, $nr);
19 $v = sprintf ("pay_%d", $row['nr']);
27 echo ("Folgende Buchungen werden bezahlt:<p>");
28 for ($i=0; $i < count ($pay); $i++) {
29 $query = sprintf ("UPDATE sales SET paid=1 WHERE nr = %d", $pay[$i]);
31 printf ("%s<br>", $query);
32 $sth = pg_exec ($dbh, $query);