<?php
// database access parameters 
// alter this as per your configuration 
$host = "192***"; 
$user = "user"; 
$pass = "123"; 
$db = "asu"; 
$table= "_dis";

//echo "<p align='right'><input type='text' name='date_123' id='123' size='6' maxlenght='40' value=$dy  readonly='readonly'></p>";
//echo "<meta http-equiv='Refresh' content='5'>";
// open a connection to the database server 
$connection = pg_pconnect ("host=$host dbname=$db user=$user password=$pass"); 
if (!$connection) 
{ 
die("Could not open connection to database server"); 
} 

// generate and execute a query 
$query = "SELECT id,name,cut_name FROM $table";
$result = pg_query($connection, $query) or die("Error in query: $query.
" . pg_last_error($connection));
$result = pg_query($query) or die('Query failed: ' . pg_last_error());
echo "<form id='mainform' name='mainform' method='post' action='' >";
echo "<SELECT name='close' id='close'>";
while ($row = pg_fetch_row($result))
{
$subject = "<option value={$row['0']}>{$row['1']}";
echo $subject;
}
echo "</SELECT>";
echo "<input name='go' id='go' type='submit' value='Ok' >";
echo "</form>";

// get the number of rows in the resultset 
$rows = pg_num_rows($result); 
echo "<br>";
// close database connection 
pg_close($connection); 
?>
<?php
$host = "192.***"; 
$user = "userl"; 
$pass = "123"; 
$db = "asu"; 
$table= "_obj";
$c_pp="1";
if( isset($_POST['go'] ) )
{
  $c_pp=$_POST['close'];     
}
// open a connection to the database server 
$connection = pg_pconnect ("host=$host dbname=$db user=$user password=$pass"); 
if (!$connection) 
{ 
die("Could not open connection to database server"); 
} 
$query = "SELECT object_name,object_district,object_address,id_district FROM $table WHERE id_district = '$c_pp'";

$result = pg_query($connection, $query) or die("Error in query: $query.
" . pg_last_error($connection));

$result = pg_query($query) or die('Query failed: ' . pg_last_error());
echo "<h4>Район - {$row[1]}</h4>";
while ($row = pg_fetch_row($result)){
echo "<a href='dop_main.php?id={$row[3]}' target='DopMainFrame'>{$row[0]}</a>, ({$row[2]})";
echo "<br>";
echo "$row[3]";
}
// get the number of rows in the resultset 
$rows = pg_num_rows($result); 
echo "<br>";
echo "Всего $rows элементов";
// close database connection 
pg_close($connection); 
?>