-
Notifications
You must be signed in to change notification settings - Fork 0
/
external_db.php
29 lines (26 loc) · 1.12 KB
/
external_db.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<?php
$query = pg_query("SELECT * FROM users");
echo "<h3>EXTERNAL DATABASE</h3>";
echo "<table width=\"90%\" align=center border=2>";
echo "<tr>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">USERNAME</td>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">FIRST</td>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">LAST</td>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">ALIAS</td>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">EMAIL</td>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">NICKNAME</td>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">USERTYPE</td>
<td width=\"20%\" align=center bgcolor =\"FFFF00\">LANGUAGE</td></tr>";
while($row=pg_fetch_array($query)){
$username=$row['username'];
$first=$row['first'];
$last=$row['last'];
$alias=$row['alias'];
$email=$row['email'];
$nickname=$row['nickname'];
$usertype=$row['usertype'];
$language=$row['language'];
echo "<tr><td>$username</td><td>$first</td><td>$last</td><td>$alias</td><td>$email</td><td>$nickname</td><td>$usertype</td><td>$language</td></tr>";
}
echo "</table>";
?>