<html>
<body>
<?php
$db = pg_connect("host=localhost port=5432 dbname=S-H-V user=user1 password=mypass");
if ($qid) {
if ($submits) {
$result = pg_query($db, "UPDATE supply.factorylist SET fname='$fname',fnamefull='$fnamefull'
WHERE fnum=$qid");
echo "Thank you! Information updated.\n";
} else {
// query the DB
$result = pg_query($db, "SELECT * FROM supply.factorylist WHERE fnum=$qid");
$myrow = pg_fetch_row($result);
?>
<form method="post" action="<?php echo $PHP_SELF ?>">
<input type=hidden name="qid" value="<?php echo $myrow["fnum"] ?>">
сокращенное название завода:<input type="Text" name="fname" value="<?php echo $myrow["fname"] ?>"><br>
полное название:<input type="Text" name="fnamefull" value="<?php echo $myrow["fnamefull"] ?>"><br>
<input type="Submit" name="submits" value="Enter information">
</form>
<?php
}
} else {
// display list of employees
$result = pg_query($db, "SELECT * FROM supply.factorylist");
while ($myrow = pg_fetch_array($result)) {
printf("<a href=\"%s?qid=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["fnum"], $myrow["fname"], $myrow["fnamefull"]);
}
}
?>
</body>
</html>
|