47 |
if (! isset($sql_upit)) { $sql_upit="novi_na_vrh"; } |
if (! isset($sql_upit)) { $sql_upit="novi_na_vrh"; } |
48 |
|
|
49 |
echo ' <form method="post" action="'.$PHP_SELF.'?'.$QUERY_STRING.'" name="forma2"> |
echo ' <form method="post" action="'.$PHP_SELF.'?'.$QUERY_STRING.'" name="forma2"> |
50 |
<input type=submit value="Prikaži"> |
Upišite ime ili prezime po kojem želite pretraživati: |
51 |
|
<input type=text name=imepr size=40 value="'.$imepr.'"> |
52 |
|
<br><input type=submit value="Prikaži"> |
53 |
slogove |
slogove |
54 |
<select name="sql_upit"> |
<select name="sql_upit"> |
55 |
'; |
'; |
93 |
"; |
"; |
94 |
$sql_order="order by id"; |
$sql_order="order by id"; |
95 |
|
|
|
|
|
96 |
if (isset($sql_upit)) { |
if (isset($sql_upit)) { |
97 |
switch($sql_upit) { |
switch($sql_upit) { |
98 |
case "samo_moji": |
case "samo_moji": |
122 |
$sql_polja.=",umrezavanje"; |
$sql_polja.=",umrezavanje"; |
123 |
} |
} |
124 |
|
|
125 |
|
if (isset($imepr) && $imepr != "") { |
126 |
|
$sql_where.=" and ( upper(toczs(osobe.ime)) like upper(toczs('$imepr')) or upper(toczs(osobe.prezime)) like upper(toczs('$imepr')) )"; |
127 |
|
} |
128 |
|
|
129 |
$sql="select $sql_polja from $sql_tablice where $sql_where $sql_order limit $on_page,$from"; |
$sql="select $sql_polja from $sql_tablice where $sql_where $sql_order limit $on_page,$from"; |
130 |
|
|
131 |
# echo "<pre>$sql</pre>"; |
# echo "<pre>$sql</pre>"; |
132 |
|
# echo "<pre>$sql_where</pre>"; |
133 |
$result = pg_Exec ($conn, "$sql"); |
$result = pg_Exec ($conn, "$sql"); |
134 |
|
|
135 |
echo "<table border=1> |
echo "<table border=1> |
142 |
</tr> |
</tr> |
143 |
"; |
"; |
144 |
|
|
145 |
function print_bool($val) { |
include("inc/print_bool.inc"); |
|
if ($val == 't') { |
|
|
print "da"; |
|
|
} elseif ($val == 'f') { |
|
|
print "ne"; |
|
|
} else { |
|
|
print "nepoznato"; |
|
|
} |
|
|
} |
|
146 |
|
|
147 |
for ($k = 0; $k < pg_numrows($result); $k++) { |
for ($k = 0; $k < pg_numrows($result); $k++) { |
148 |
$row=pg_fetch_array($result,$k); |
$row=pg_fetch_array($result,$k); |
169 |
|
|
170 |
|
|
171 |
if (isset($shell)) { |
if (isset($shell)) { |
172 |
print "<br>shell: "; |
print "<br>shell: ".print_bool($row[shell]); |
|
print_bool($row[shell]); |
|
173 |
} |
} |
174 |
if (isset($podesavanje)) { |
if (isset($podesavanje)) { |
175 |
print "<br>podešavanje: "; |
print "<br>podešavanje: ".print_bool($row[podesavanje]); |
|
print_bool($row[podesavanje]); |
|
176 |
} |
} |
177 |
if (isset($umrezavanje)) { |
if (isset($umrezavanje)) { |
178 |
print "<br>umrežavanje: "; |
print "<br>umrežavanje: ".print_bool($row[umrezavanje]); |
|
print_bool($row[umrezavanje]); |
|
179 |
} |
} |
180 |
print "</small></td></tr>"; |
print "</small>"; |
181 |
|
print "</td><td> |
182 |
|
<a href=\"obavijest.php?id=$row[id]\"> |
183 |
|
<img src=pix/text.gif border=0 |
184 |
|
alt=\"Prikaži sve podatke o ovom zahtjevu\"></a> |
185 |
|
"; |
186 |
|
print "</td></tr>"; |
187 |
} |
} |
188 |
|
|
189 |
|
|