27 |
</form>'; |
</form>'; |
28 |
} else { |
} else { |
29 |
$sth = $dbh->prepare("select ime,prezime,passwd,prava from kontakt_osobe where aktivna=true and id=$kontakt_osoba_id"); |
$sth = $dbh->prepare("select ime,prezime,passwd,prava from kontakt_osobe where aktivna=true and id=$kontakt_osoba_id"); |
30 |
|
$sth->execute(); |
31 |
$row=$sth->fetchrow_hash(); |
$row=$sth->fetchrow_hash(); |
32 |
print "<small>Trenutno ste prijavljeni kao $row[ime] $row[prezime], ako je to krivo odaberite <a href=\"$PHP_SELF?what=relogin\">ovaj link</a>.</small>"; |
print "<small>Trenutno ste prijavljeni kao $row[ime] $row[prezime], ako je to krivo odaberite <a href=\"$PHP_SELF?what=relogin\">ovaj link</a>.</small>"; |
33 |
$prava=$row[prava]; |
$prava=$row[prava]; |
132 |
# echo "<pre>$sql</pre>"; |
# echo "<pre>$sql</pre>"; |
133 |
# echo "<pre>$sql_where</pre>"; |
# echo "<pre>$sql_where</pre>"; |
134 |
$sth = $dbh->prepare("$sql"); |
$sth = $dbh->prepare("$sql"); |
135 |
|
$sth->execute(); |
136 |
|
|
137 |
echo "<table border=1> |
echo "<table border=1> |
138 |
<tr> |
<tr> |
165 |
<td>$row[orgjed]</td><td>"; |
<td>$row[orgjed]</td><td>"; |
166 |
|
|
167 |
$sth1 = $dbh->prepare("select datum,opis from status,status_tip where status.status_tip_id=status_tip.id and osoba_id=$row[id] order by datum"); |
$sth1 = $dbh->prepare("select datum,opis from status,status_tip where status.status_tip_id=status_tip.id and osoba_id=$row[id] order by datum"); |
168 |
|
$sth->execute(); |
169 |
while ($row1=$sth1->fetchrow_hash()) { |
while ($row1=$sth1->fetchrow_hash()) { |
170 |
print "<small>$row1[datum]</small> $row1[opis]<br>"; |
print "<small>$row1[datum]</small> $row1[opis]<br>"; |
171 |
} |
} |