//connection
$conn_string = "host=/var/run/postgresql dbname=prao user=www-prao";
$db = pg_connect($conn_string);
$idN = $_GET['idL'];
if($db) {
$query = "SELECT name_lab, name_head FROM laboratoryE WHERE id='$idN'";
$result = pg_exec($db, $query);
$rowFromTable = pg_fetch_array($result);
$nameHead = $rowFromTable["name_head"];
$nameLab = $rowFromTable["name_lab"];
$query = "SELECT * FROM staffE WHERE lab_id='$idN' ORDER BY name";
$result = pg_exec($db, $query);
$rowFromTable = pg_fetch_array($result);
} else {
print "Can't create connection
";
exit;
}
?>
|
|
|
|
if(!empty($nameHead)) { ?>
} ?>
while (is_array($rowFromTable)) {
$name = $rowFromTable["name"];
$post = $rowFromTable["post"];
echo "";
echo " ". $name ." | ";
if($post) {
$addr = "mailto:".$post;
echo " ". $post ." | ";
} else {
echo "   | ";
}
echo " ";
$rowFromTable=pg_fetch_array($result);
}
pg_close($db);
?>
|
|
|
|
|
|
|