1 |
dpavlin |
1.1 |
<? |
2 |
|
|
|
3 |
|
|
if (! isset($from)) { |
4 |
|
|
$from=0; |
5 |
|
|
} |
6 |
|
|
|
7 |
|
|
$on_page=10; |
8 |
|
|
|
9 |
|
|
$conn = pg_connect("dbname=informatika user=dpavlin"); |
10 |
|
|
|
11 |
|
|
$result = pg_Exec ($conn, "select * from otvoreni limit $on_page,$from"); |
12 |
|
|
|
13 |
|
|
echo "<table><tr><th>ime</th><th>prezime</th></tr>"; |
14 |
|
|
|
15 |
|
|
for ($k = 0; $k < pg_numrows($result); $k++) { |
16 |
|
|
$row=pg_fetch_array($result,$k); |
17 |
|
|
print "<tr><td>$row[ime]</td><td>$row[prezime]</td></tr>"; |
18 |
|
|
} |
19 |
|
|
|
20 |
|
|
|
21 |
|
|
echo "</table>"; |
22 |
|
|
|
23 |
|
|
echo "<pre>Druge stranice: "; |
24 |
|
|
|
25 |
|
|
if ($from >= $on_page) { |
26 |
|
|
echo "<a href=$PHP_SELF?from=".($from-$on_page).">----</a>"; |
27 |
|
|
} else { |
28 |
|
|
echo "...."; |
29 |
|
|
} |
30 |
|
|
|
31 |
|
|
if (pg_numrows($result) >= $on_page) { |
32 |
|
|
echo "<a href=$PHP_SELF?from=".($from+$on_page).">++++</a>"; |
33 |
|
|
} else { |
34 |
|
|
echo "...."; |
35 |
|
|
} |
36 |
|
|
|
37 |
|
|
echo "</pre>"; |
38 |
|
|
?> |