//connection
$conn_string = "host=/var/run/postgresql dbname=prao user=www-prao";
$db = pg_connect($conn_string);
if($db) {
$query = "SELECT * FROM administrationE ORDER BY number";
$result = pg_exec($db, $query);
$numb = pg_numrows($result);
$rowFromTable = pg_fetch_array($result);
} else {
print "Can't create connection
";
exit;
}
?>
 |
|
 |
 |
while (is_array($rowFromTable)) {
$name = $rowFromTable["name"];
$post = $rowFromTable["post"];
$phone = $rowFromTable["phone"];
echo "";
echo " ". $name ." | ";
echo " ". $post ." | ";
echo " ". $phone ." | ";
echo " ";
$rowFromTable=pg_fetch_array($result);
}
?>
|
$query = "SELECT * FROM divisionE WHERE name_div != 'no department'";
$result = pg_exec($db, $query);
$rowFromTable = pg_fetch_array($result);
while (is_array($rowFromTable)) {
$idD = $rowFromTable["id"];
$nameD = $rowFromTable["name_div"];
echo "";
echo " ";
echo " ". $nameD ."";
echo " | ";
echo " ";
$rowFromTable=pg_fetch_array($result);
}
?>
$query = "SELECT name_lab, id
FROM laboratoryE
WHERE name_lab != 'no laboratory' AND div_id =
(SELECT id FROM divisionE WHERE name_div = 'no department')";
$result = pg_exec($db, $query);
$rowFromTable = pg_fetch_array($result);
while (is_array($rowFromTable)) {
$idL = $rowFromTable["id"];
$nameL = $rowFromTable["name_lab"];
echo "";
echo " ";
echo " ". $nameL ."";
echo " | ";
echo " ";
$rowFromTable=pg_fetch_array($result);
}
pg_close($db);
?>
|
|
|
 |
|
|