include_once(dirname(__FILE__) . "/../include/dyn_css.php"); ?> "; echo "var conffile = '".$_REQUEST["conf_file"]."';"; echo "var lingo = '".$_REQUEST["lingo"]."';"; echo "var backlink = '".$_REQUEST["backlink"]."';"; $lingo = $_REQUEST["lingo"]; $title = "layername_".$lingo; require_once(dirname(__FILE__) . "/../../conf/".$_REQUEST["conf_file"]); echo ""; ?>
"; echo "Suchen: "; echo ""; echo ""; echo ""; } else{ if(preg_match("/\*/",$_REQUEST["search"])){ $search = trim(preg_replace("/\*/i","", $_REQUEST["search"])); } $con = pg_connect ($con_string) or die ("Error while connecting database $dbname"); #$sql = "SELECT DISTINCT identificationinfo,minscale, md_fileidentifier ,search_columns, search_result FROM tab_metadata WHERE public = '1' and not identificationinfo = 'Rasterebene' and not identificationinfo = 'rasterlayer'"; $sql = "SELECT DISTINCT identificationinfo,minscale, md_fileidentifier ,".$title.",search_columns, search_result,search_keywords, wms_title FROM tab_metadata WHERE public = '1' and not identificationinfo = 'Rasterebene' and not identificationinfo = 'rasterlayer'"; $res = pg_query($con,$sql); $cnt = 0; while(pg_fetch_row($res)){ $table[$cnt] = pg_result($res,$cnt,"identificationinfo"); # Tabellen, Abfragenname $minscale[$cnt] = pg_result($res,$cnt,"minscale"); $md_fileidentifier[$cnt] = pg_result($res,$cnt,"md_fileidentifier"); # Layername $layername[$cnt] = pg_result($res,$cnt,"md_fileidentifier"); # Layername in der Mapdatei $result_title[$cnt] = pg_result($res,$cnt,"\"".$title."\""); # layer_deutsch Ergebnisname $search_columns[$cnt] = pg_result($res,$cnt,"search_columns"); # Suchspalten, Trennung �ber , $search_result[$cnt] = pg_result($res,$cnt,"search_result"); # Ergebnisspalte $search_keywords[$cnt] = pg_result($res,$cnt,"search_keywords"); # Ergebnisspalte $wms_title[$cnt] = pg_result($res,$cnt,"wms_title"); # WMS tile # if one of the searchkeywords is found the data of the whole table is displayed as the result if($search_keywords[$cnt] != '') { $array_search_keywords = explode(",", $search_keywords[$cnt]); $all[$cnt] = false; for ($p=0 ; $p