<?php
include "config.php";
echo"
<html>
<head>
<script type=\"text/javascript\">
<!—
var aHouseValues = new Array(";
$query1 = "select * from view_ekind where etypeid=$rr";
$result = pg_query($connection, $query1) or die("Error in query: $query." . pg_last_error($connection));
$rows = pg_num_rows($result);
$ty='"';
echo "$ty";
while($row=@pg_fetch_array($result)) { $re=$row[2]; echo "$re,"; };
echo "$ty";
echo"
);
function getHouseValuesByStreet(index){
var sHouseValues = aHouseValues[index];
return sHouseValues.split(\",\"); // преобразуем строку в массив домов
}
function MkHouseValues(index){
var aCurrHouseValues = getHouseValuesByStreet(index);
var nCurrHouseValuesCnt = aCurrHouseValues.length;
var oHouseList = document.forms[\"address\"].elements[\"house\"];
var oHouseListOptionsCnt = oHouseList.options.length;
oHouseList.length = 0; // удаляем все элементы из списка домов
for (i = 0; i < nCurrHouseValuesCnt; i++){
if (document.createElement){
var newHouseListOption = document.createElement(\"OPTION\");
newHouseListOption.text = aCurrHouseValues[i];
newHouseListOption.value = aCurrHouseValues[i];
(oHouseList.options.add) ? oHouseList.options.add(newHouseListOption) : oHouseList.add(newHouseListOption, null);
}else{
oHouseList.options[i] = new Option(aCurrHouseValues[i], aCurrHouseValues[i], false, false); } } }
MkHouseValues(document.forms[\"address\"].elements[\"street\"].selectedIndex);
//-->
</script>
</head>
<body>
<form name=\"address\" action=\"#\">
Улица:
<select name=\"street\" onChange=\"MkHouseValues(this.selectedIndex)\">";
$query1 = "SELECT id,name FROM esttype";
$result = pg_query($connection, $query1) or die("Error in query: $query." . pg_last_error($connection));
$rows = pg_num_rows($result);
while($row=@pg_fetch_array($result)) { $rr=$row[0]; $re=$row[1]; echo "<option value=\"$re\">$re"; };
echo"
</select>
Дом:
<select name=\"house\">
<option value=\"N/A\">N/A</option>
</select>
</form>
</body> </html>";
?>