'; ?> changeEPSG_dynamic 0){ $sql_layer_wms .= ",";} $sql_layer_wms .= "$".($i+1); array_push($v,$fkey_wms_id_1[$i]); array_push($t,'i'); } $sql_layer_wms.= ") ORDER BY layer_id"; $res_layer_wms = db_prep_query($sql_layer_wms,$v,$t); while($row = db_fetch_array($res_layer_wms)){ $layer_id[$cnt_layer_wms] = $row["layer_id"]; $fkey_wms_id[$cnt_layer_wms] = $row["fkey_wms_id"]; $cnt_layer_wms++; } /*get allocated wms from allocated gui ***********************************************************/ /*get allocated epsg-code from allocated wms *****************************************************/ $v = array(); $t = array(); $sql_epsg_wms = "SELECT DISTINCT wms_srs FROM wms_srs WHERE fkey_wms_id IN ("; for($i=0; $i0){ $sql_epsg_wms .= ",";} $sql_epsg_wms .= "$".($i+1); array_push($v,$fkey_wms_id_1[$i]); array_push($t,'i'); } $sql_epsg_wms.= ") ORDER BY wms_srs"; $res_epsg_wms = db_prep_query($sql_epsg_wms,$v,$t); while($row = db_fetch_array($res_epsg_wms)){ $fkey_wms_id_2[$cnt_epsg_wms] = $row["fkey_wms_id"]; $epsg_code[$cnt_epsg_wms] = $row["wms_srs"]; $cnt_epsg_wms++; //possible error because increment before echo statement echo"$epsg_code[$cnt_epsg_wms]"; } echo ""; # transform coordinates if(isset($_REQUEST["srs"])){ require_once(dirname(__FILE__)."/../../conf/mapbender.conf"); $con = pg_connect ($con_string) or die ("Error while connecting database DBname"); $arraymapObj = mb_split("###", $_REQUEST["srs"]); echo ""; } else{ echo ""; } ?> "; echo ""; /*insert EPSG in selectbox************************************************************************************/ echo""; echo""; echo""; ?>