$row = pg_fetch_array($result); echo "<option value='".$row[$husnummerbetegn]."'"; if ($row[$husnummerbetegn]==$husnummer) echo " name='select2' id='select2' SELECTED"; echo ">".$row[$husnummerbetegn]; echo "</option>"; } echo "</SELECT>"; $query = ("select * from $adresseTabel where $vejkodebetegn='".base64_decode($vejkode)."' and $husnummerbetegn='$husnummer'"); $result = pg_exec($query); $gid = pg_fetch_array($result); } } if (($matrnr && $query_mode=="matrikel") || ($husnummer && $query_mode=="adresse")) { $postgisObject->execQuery("set client_encoding='UTF8'"); $result=$postgisObject->featureQuery($query_mode, $gid[gid], "matrikel", "*",0); $row = pg_fetch_array($result); //echo "TEST".$row[gid]; $postgisObject -> search("matrikel", "GID", $row[gid], 0.5); for ($u = 0; $u < sizeof($slayer); $u ++) { // We set the query vars $bit = $slayer[$u]['f_table_schema'].".".$slayer[$u]['f_table_name']; $fieldconfArr = (array)json_decode($slayer[$u]['fieldconf']); //print_r($fieldconfArr); $postGisQueryName[strtoupper($bit)] = $slayer[$u]['f_table_title']; $queryable=true; if ($slayer[$u]['not_querable']=="t") { //echo $postgisObject->getGeometryColumns($bits[0],"not_querable");
$query = ("select * from $adresseTabel where $vejkodebetegn='".base64_decode($vejkode)."' and $husnummerbetegn='$husnummer'"); //echo $query; $result = pg_exec($query); $gid = pg_fetch_array($result); } } if (($matrnr && $query_mode=="matrikel") || ($husnummer && $query_mode=="adresse")) { if ($query_mode=="matrikel") { $table = $matrikelTabel; } if ($query_mode=="adresse") { $table = $adresseTabel; } $postgisObject->execQuery("set client_encoding='UTF8'"); $result=$postgisObject->featureQuery($table, $gid['gid'], $matrikelTabel, "*",0); $row = pg_fetch_array($result); //echo "TEST"; //print_r($row); //echo "TEST".$gid['gid']; $postgisObject -> search($matrikelTabel, "GID", $gid['gid'], 0.5); for ($u = 0; $u < sizeof($slayer); $u ++) { // We set the query vars $bit = $slayer[$u]['f_table_schema'].".".$slayer[$u]['f_table_name']; $fieldconfArr = (array)json_decode($slayer[$u]['fieldconf']); //print_r($fieldconfArr); $postGisQueryName[strtoupper($bit)] = $slayer[$u]['f_table_title']; $queryable=true;