//connection
$conn_string = "host=/var/run/postgresql dbname=prao user=www-prao";
$db = pg_connect($conn_string);
if($db) {
$idN = $_GET['idL'];
if(!is_numeric($idN)) die("Неверное значение id!");
$query = "SELECT name_lab, name_head FROM laboratory WHERE id='$idN'";
$result = pg_exec($db, $query);
$rowFromTable = pg_fetch_array($result);
$nameHead = $rowFromTable["name_head"];
$nameLab = $rowFromTable["name_lab"];
$query = "SELECT * FROM staff 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)) { ?>
Руководитель: echo $nameHead ?> |
} ?>
while (is_array($rowFromTable)) {
$name = $rowFromTable["name"];
$post = $rowFromTable["post"];
echo "";
echo " ". $name ." | ";
echo " ". $post ." | ";
echo " ";
$rowFromTable=pg_fetch_array($result);
}
pg_close($db);
?>
|
|
|
|
|
|
|
Copyright 2005 - 2008, ВТИТ home@prao.ru |