diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-04-16 17:45:23 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-04-16 17:45:23 +0000 |
| commit | a2f46eff39e547e40d042ce97851805b9f9efea4 (patch) | |
| tree | 674ce1bfe3af9dd6ca058b44d5d0fdf9e7b4ba29 /frontends/php/users.html | |
| parent | a23282b7b988f6bbe5e7f98170c88e0dfe24fc3b (diff) | |
Added PostgreSQL support for PHP frontend. Added database abstraction layer in frontend/php/include/db.inc.
git-svn-id: svn://svn.zabbix.com/trunk@42 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/users.html')
| -rw-r--r-- | frontends/php/users.html | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/frontends/php/users.html b/frontends/php/users.html index 167906d7..65015232 100644 --- a/frontends/php/users.html +++ b/frontends/php/users.html @@ -42,9 +42,9 @@ echo "<TD WIDTH=\"10%\" NOSAVE><B>Actions</B></TD>"; echo "</TR>"; - $result=mysql_query("select u.userid,u.alias,u.name,u.surname,g.name from users u,groups g where u.groupid=g.groupid order by g.name,u.alias",$mysql); + $result=DBselect("select u.userid,u.alias,u.name,u.surname,g.name from users u,groups g where u.groupid=g.groupid order by g.name,u.alias"); echo "<CENTER>"; - while($row=mysql_fetch_row($result)) + for($i=0;$i<DBnum_rows($result);$i++) { if($col==1) { @@ -56,11 +56,11 @@ $col=1; } - $alias=$row[1]; - $name=$row[2]; - $surname=$row[3]; - $group=$row[4]; - $userid_=$row[0]; + $alias=DBget_field($result,$i,1); + $name=DBget_field($result,$i,2); + $surname=DBget_field($result,$i,3); + $group=DBget_field($result,$i,4); + $userid_=DBget_field($result,$i,0); echo "<TD>$group</TD>"; echo "<TD>$alias</TD>"; echo "<TD>$name</TD>"; |