--- html/obavijest.php	2000/07/27 08:35:35	1.15
+++ html/obavijest.php	2000/08/02 13:10:00	1.15.2.2
@@ -6,8 +6,9 @@
 include("inc/bgcolor.inc");
 
 if (isset($kontakt_osoba_id) && $what!="relogin") {
-	$result = pg_Exec ($conn, "select ime,prezime,passwd,prava from kontakt_osobe where aktivna=true and id=$kontakt_osoba_id");
-	$korow=pg_fetch_array($result,0);
+	$sth = $dbh->prepare("select ime,prezime,passwd,prava from kontakt_osobe where aktivna=true and id=$kontakt_osoba_id");
+	$sth->execute();
+	$korow=$sth->fetchrow_hash();
 #	print "--$korow[passwd] | $md5_passwd | $passwd ";
 	$prava=$korow[prava];
 	print "<small>Trenutno ste prijavljeni kao $korow[ime] $korow[prezime], ako je to krivo odaberite <a href=\"$PHP_SELF?what=relogin\">ovaj link</a>.</small>";
@@ -35,21 +36,21 @@
 	include("inc/obavjest-forma.inc");
 } elseif (isset($id) && $what!="auth") {
 
-
-$result = pg_Exec ($conn, "
+$sth = $dbh->prepare("
 	select osobe.id as id,ime,prezime,tel,lokacije.naziv as lok,sifra,
 		org_jed.naziv as orgjed,org_pod_jed.pod_naziv as orgpodjed,
 		lok_racunala as lokrac,objekt,kat,soba,z_rac,podesavanje,
 		umrezavanje,shell
-	from osobe
+	from osobe,lokacije,org_jed,org_pod_jed
 	where osobe.id=$id
 		and lokacija_id=lokacije.id and org_jed_id=org_jed.id
 		and org_pod_jed_id=org_pod_jed.pod_id
 	order by lokacije.naziv,org_jed.naziv
 	");
 
-if (pg_numrows($result) > 0) {
-	$row=pg_fetch_array($result,0);
+$sth->execute();
+
+if ($row=$sth->fetchrow_hash()) {
 
 	print "
 <h1>Podaci o osobi</h1>
@@ -85,35 +86,37 @@
 
 $instaliran=0;
 
-$result = pg_Exec ($conn, "select status.id as status_id,datum,opis,ime,prezime,status_tip_id as st
+$sth = $dbh->prepare("select status.id as status_id,datum,opis,ime,prezime,status_tip_id as st
 	from status,kontakt_osobe,status_tip
 	where kontakt_osoba_id=kontakt_osobe.id and status_tip_id=status_tip.id
 	and osoba_id=$id order by datum");
+$sth->execute();
 
 $statusi="";
 
-$nr = pg_numrows($result);
-if ($nr > 0) {
-	for ($i=0; $i<$nr; $i++) {
-		$row=pg_fetch_array($result,$i);
-		if ($row[st] != 2) {
-			$statusi.="<tr ".bgcolor()."><td><small>$row[datum]</small></td><td>$row[opis]</td><td>$row[ime] $row[prezime]</td></tr>";
-		} else {
-			$statusi.="<tr ".bgcolor()."><td><small>$row[datum]</small></td><td><a href=\"promjene.php?osoba_id=$id&status_id=$row[status_id]\">$row[opis]</a></td><td>$row[ime] $row[prezime]</td></tr>";
-		}
-		if ($row[st] == 6) { $instaliran = 1; };
+$nr=0;
+while($row=$sth->fetchrow_hash()) {
+	if ($row[st] != 2) {
+		$statusi.="<tr ".bgcolor()."><td><small>$row[datum]</small></td><td>$row[opis]</td><td>$row[ime] $row[prezime]</td></tr>";
+	} else {
+		$statusi.="<tr ".bgcolor()."><td><small>$row[datum]</small></td><td><a href=\"promjene.php?osoba_id=$id&status_id=$row[status_id]\">$row[opis]</a></td><td>$row[ime] $row[prezime]</td></tr>";
 	}
-} else {
+	if ($row[st] == 6) { $instaliran = 1; };
+	$nr++;
+}
+
+if ($nr == 0) {
 	$statusi.="<p><big>Nema podataka o korisničkom računu</big>";
 }
 
 
-$result = pg_Exec ($conn, "select racuni.login as login,
+$sth = $dbh->prepare("select racuni.login as login,
 	racuni.passwd as passwd,e_mail.alias as email
+	from racuni,e_mail
 	where racuni.osoba_id=$id and e_mail.osoba_id=$id");
+$sth->execute();
 
-if (pg_numrows($result) > 0) {
-	$row=pg_fetch_array($result,0);
+if ($row=$sth->fetchrow_hash()) {
 
 	print "
 <h1>Podaci o korisničkom računu</h1>
@@ -165,15 +168,15 @@
 
 $statusi.="<td><select name=status_tip_id>";
 
-	$result = pg_Exec ($conn, "select id,opis
+	$sth = $dbh->prepare("select id,opis
 		from status_tip
 		where id >= 5
 		");
+	$sth->execute();
 
 	$num_prava=0;
 
-	for ($i=0; $i<pg_numrows($result); $i++) {
-		$row=pg_fetch_array($result,$i);
+	while ($row=$sth->fetchrow_hash()) {
 		if ($prava & pow(2,$row[id])) {
 			$statusi.="<option value=$row[id]>$row[opis]</option>\n";
 			$num_prava++;
@@ -196,9 +199,9 @@
 <hr>
 ";
 
-} else { // pg_numrows($result) > 0
+} else { // nema rezultata
 	print "<p><big>Nema podataka o osobi sa id-jem $id</big>";
-}	// pg_numrows($result) > 0
+}
 
 include("inc/obavjest-forma.inc");