3v4l.org

run code in 300+ PHP versions simultaneously
<html> <head> <style type="text/css"> body,tr,td {font-family:Arial; font-size:10pt}} b {font-family:Arial; font-size:10pt; font-weight:bold} .small {font-family:Arial; font-size:8pt} .kopf {font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px;border-spacing:0px;background-color:#999999} .inhalt {font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px #000000;border-spacing:0px} .inhalt_del {font:-family:Arial; color:#AAAAAA; font-size:8pt;padding:3px;margin:0px;border:solid 1px #000000;border-spacing:0px} .gesamt {font-family:Arial; font-weight:bold; font-size:8pt;padding:3px;margin:0px;border:solid 1px;border-spacing:0px} .inhaltgrau {color:#bbbbbb;font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px black;border-spacing:0px} .inhaltgraugrau {color:#bbbbbb;font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px black;border-spacing:0px} a:link { color:#0000AA; text-decoration:underline; } a:visited{ color:#0000AA; text-decoration:underline; } a:focus { color:#0000AA; text-decoration:underline; } a:hover { color:#0000EE; text-decoration:underline; } a:active { color:#0000AA; text-decoration:underline; } </style> <SCRIPT LANGUAGE="JavaScript" SRC="combined/CalendarPopup.js"></SCRIPT> <SCRIPT LANGUAGE="JavaScript">document.write(getCalendarStyles());</SCRIPT> <script type="text/javascript"> function flip(uebergabe1, uebergabe2) { for ( i = 0 ; i <= uebergabe2 ; i++ ) { if ( document.getElementsByName(uebergabe1)[i].style.display == "" ) { document.getElementsByName(uebergabe1)[i].style.display = "none"; aktion = "einblenden"; } else { document.getElementsByName(uebergabe1)[i].style.display = ""; aktion = "ausblenden"; } } if ( aktion == "ausblenden") { document.getElementById('img_' + uebergabe1).src = "/fesch/img/minus.gif"; } else { document.getElementById('img_' + uebergabe1).src = "/fesch/img/plus.gif"; } } function formLeeren(uebergabe3){ var obj = document.forms[uebergabe3]; for(i=0;i<obj.elements.length;i++){ if(obj.elements[i].type == 'text' || obj.elements[i].type == 'textarea'){ obj.elements[i].value = ''; } else { obj.elements[i].selectedIndex = 0; } } } var fenster; function neues() { fenster = window.open ( "", "NeuesFenster", // Name des neuen Fensters +"toolbar=0" // Toolbar +",location=0" // Adress-Leiste +",directories=0" // Zusatzleisten +",status=0" // Statusleiste +",menubar=0" // Menü +",scrollbars=0" // Scrollbars +",resizable=0" // Fenstergrösse veränderbar? +",width=920" // Fensterbreite in Pixeln +",height=840" // Fensterhöhe in Pixeln ); fenster.moveTo( 50, // X-Koordinate 50 // Y-Koordinate ); // der linken oberen Ecke fenster.location.href = "/fesch/map.php"; //Dateiname und Pfad der Datei, die angezeigt werden soll } function neues2() { fenster = window.open ( "", "NeuesFenster", // Name des neuen Fensters +"toolbar=0" // Toolbar +",location=0" // Adress-Leiste +",directories=0" // Zusatzleisten +",status=0" // Statusleiste +",menubar=0" // Menü +",scrollbars=0" // Scrollbars +",resizable=0" // Fenstergrösse veränderbar? +",width=920" // Fensterbreite in Pixeln +",height=840" // Fensterhöhe in Pixeln ); fenster.moveTo( 50, // X-Koordinate 50 // Y-Koordinate ); // der linken oberen Ecke fenster.location.href = "/fesch/map_ia.php"; //Dateiname und Pfad der Datei, die angezeigt werden soll } </script> <STYLE> .TESTcpYearNavigation, .TESTcpMonthNavigation { background-color:#6677DD; text-align:center; vertical-align:center; text-decoration:none; color:#FFFFFF; font-weight:bold; } .TESTcpDayColumnHeader, .TESTcpYearNavigation, .TESTcpMonthNavigation, .TESTcpCurrentMonthDate, .TESTcpCurrentMonthDateDisabled, .TESTcpOtherMonthDate, .TESTcpOtherMonthDateDisabled, .TESTcpCurrentDate, .TESTcpCurrentDateDisabled, .TESTcpTodayText, .TESTcpTodayTextDisabled, .TESTcpText { font-family:arial; font-size:8pt; } TD.TESTcpDayColumnHeader { text-align:right; border:solid thin #6677DD; border-width:0 0 1 0; } .TESTcpCurrentMonthDate, .TESTcpOtherMonthDate, .TESTcpCurrentDate { text-align:right; text-decoration:none; } .TESTcpCurrentMonthDateDisabled, .TESTcpOtherMonthDateDisabled, .TESTcpCurrentDateDisabled { color:#D0D0D0; text-align:right; text-decoration:line-through; } .TESTcpCurrentMonthDate { color:#6677DD; font-weight:bold; } .TESTcpCurrentDate { color: #FFFFFF; font-weight:bold; } .TESTcpOtherMonthDate { color:#808080; } TD.TESTcpCurrentDate { color:#FFFFFF; background-color: #6677DD; border-width:1; border:solid thin #000000; } TD.TESTcpCurrentDateDisabled { border-width:1; border:solid thin #FFAAAA; } TD.TESTcpTodayText, TD.TESTcpTodayTextDisabled { border:solid thin #6677DD; border-width:1 0 0 0; } A.TESTcpTodayText, SPAN.TESTcpTodayTextDisabled { height:20px; } A.TESTcpTodayText { color:#6677DD; font-weight:bold; } SPAN.TESTcpTodayTextDisabled { color:#D0D0D0; } .TESTcpBorder { border:solid thin #6677DD; } </STYLE> <title>FESCH - Metadatensuche zur Schätzungskarten</title> </head> <BODY bgcolor="#ffffff" text="#000000" link="#996600" vlink="#666666" alink="#336600"> <br /> <?php $user = $_SERVER['PHP_AUTH_USER']; /*echo "<pre>"; print_r($_SERVER); echo "</pre>";*/ include("../includes/config.inc.php"); $mysql_connection = mysql_connect($db_host,$db_user,$db_passwd); mysql_select_db($db_name); function to_space($word, $minus=FALSE) { if($minus) $word = str_replace("-", " ", $word); $word = str_replace("+", " ", $word); $word = str_replace("_", " ", $word); $word = str_replace("'", " ", $word); $word = str_replace("/", " ", $word); $word = str_replace("\\", " ", $word); //$word = str_replace("%", " ", $word); $word = str_replace("*", "%", $word); return $word; } $kartentyp = array("S"=>"Schätzungsreinkarte", "F"=>"Feldschätzungskarte", "D"=>"Deckpause"); $error = FALSE; if($_SERVER['QUERY_STRING'] == "gesamte_statistik" || $_SERVER['QUERY_STRING'] == "gesamte_statistik_ASC") { $_POST['submit'] = true; $_POST['statistik_Gemeinde'] = "%"; $_POST['search_in'] = "statistik"; } if($_POST['search_in'] == "dibos") { if($_POST['submit']) { if($_POST['search'] == "fulltext") { // Volltext if(trim($_POST['keywords'] == "")) $error_1 = TRUE; $error_txt_1 = "Raster-Metadaten-Suche: Sie haben keine Suchbegriffe angegeben."; } else { // Detail if(empty($_POST['landkreis']) && empty($_POST['Kartentyp']) && empty($_POST['Finanzamtsbezirk']) && trim($_POST['Gemeinde'])=="" && trim($_POST['Gmkg'])=="" && trim($_POST['Nr_Gmkg_txt'])=="" && trim($_POST['keywords_d'])=="") { $error_2 = TRUE; $error_txt_2 = "Raster-Metadaten-Suche: Bitte geben Sie mindestens ein Suchkriterium an."; } } } if($_POST['submit'] && !($error_1 OR $error_2 OR $error_3)) { for($j=0;$j<count($_POST);$j++) mysql_real_escape_string($_POST[$j]); if($_POST['search'] == "fulltext") { // Volltext //$query = "SELECT *,IF(`Finanzamtsbezirk`='-', 'unbekannt', REPLACE(REPLACE(`Finanzamtsbezirk`, 'Hr.', 'Herr'), 'Fr.', 'Frau')) as fab,(CONCAT_WS(' ', LOWER(IF(`Kartentyp`='S',' Schätzungsreinkarte',' ')), LOWER(IF(`Kartentyp`='F', ' Feldschätzungskarte', ' ')), LOWER(IF(`Kartentyp`='D', ' Deckpause', ' ')), LOWER(`Finanzamtsbezirk`), LOWER(`Landkreis`)"; $query = "SELECT *,IF(`Finanzamtsbezirk`='-', 'unbekannt', REPLACE(REPLACE(`Finanzamtsbezirk`, 'Hr.', 'Herr'), 'Fr.', 'Frau')) as fab,(CONCAT_WS(' ', LOWER(`Finanzamtsbezirk`), LOWER(`Landkreis`)"; $query .= ", LOWER(`Landkreis_Soll`), LOWER(`BEZ_Gemeinde`), LOWER(`Gmkg`), LOWER(`Nr_Gmkg`), LOWER(`lfd_Nr_Gemarkung`), LOWER(`Bezeichnung`), LOWER(`Bemerkung`), LOWER(`Kartentyp`), LOWER(`Scan`), ' ')) as such_kriterium FROM `fesch_sachdaten_LJ_raster` HAVING"; $keywords = explode(" ", to_space($_POST['keywords'])); //print_r($keywords); foreach($keywords as $keyword) { $query .= " (such_kriterium LIKE '% ".strtolower(trim(to_space($keyword)))." %') ".$_POST['link']; } $query = substr($query, 0, strlen($query)-3)." ORDER BY Nr_Gmkg,CAST(lfd_Nr_Gemarkung as SIGNED),prefix_nr_gmkg"; //echo $query; } else { // Detail $query = "SELECT * FROM `fesch_sachdaten_LJ_raster` WHERE"; if(!empty($_POST['landkreis'])) $query .= " `Landkreis_Soll`='".$_POST['landkreis']."' AND"; if(!empty($_POST['Kartentyp'])) $query .= " `Kartentyp`='".$_POST['Kartentyp']."' AND"; if(!empty($_POST['Finanzamtsbezirk'])) $query .= " `Finanzamtsbezirk`='".$_POST['Finanzamtsbezirk']."' AND"; if(trim($_POST['Gemeinde']) != "") { $keywords = explode(" ", to_space($_POST['Gemeinde'])); foreach($keywords as $keyword) { $query .= " (LCASE(`BEZ_Gemeinde`) LIKE '%".strtolower(trim(to_space($keyword)))."%') AND"; } } if(trim($_POST['Gmkg']) != "") { $keywords = explode(" ", to_space($_POST['Gmkg'])); foreach($keywords as $keyword) { $query .= " (LCASE(`Gmkg`) LIKE '%".strtolower(trim(to_space($keyword)))."%') AND"; } } if(trim($_POST['Nr_Gmkg_txt']) != "") { $keywords = explode(" ", to_space($_POST['Nr_Gmkg_txt'], TRUE)); foreach($keywords as $keyword) { $query .= " ((LCASE(`lfd_Nr_Gemarkung`) LIKE '%".strtolower(trim(to_space($keyword)))."%') OR (LCASE(`Nr_Gmkg`) LIKE '%".strtolower(trim(to_space($keyword)))."%')) AND"; } } if(trim($_POST['keywords_d']) != "") { $keywords = explode(" ", to_space($_POST['keywords_d'])); foreach($keywords as $keyword) { $query .= " ((LCASE(`Bemerkung`) LIKE '%".strtolower(trim(to_space($keyword)))."%') OR (LCASE(`Bezeichnung`) LIKE '%".strtolower(trim(to_space($keyword)))."%')) AND"; } } $query = substr($query, 0, strlen($query)-3)." ORDER BY Nr_Gmkg,CAST(lfd_Nr_Gemarkung as SIGNED),prefix_nr_gmkg"; } // Ausgabe der Suchergebnisse folgt $results = mysql_query($query); //echo mysql_error(); //echo $query; $count = mysql_num_rows($results); if($count < 1) { if($_POST['search'] == "fulltext") { $error_txt_1 = "Ihre Suche ergab keine Treffer."; $error_1 = TRUE; } else { $error_txt_2 = "Ihre Suche ergab keine Treffer."; $error_2 = TRUE; } /*} elseif($count > 50) { $error_txt = "Ihre Suche ergab mehr als 50 Treffer - bitte verfeinern Sie Ihre Suche."; $error = TRUE;*/ } else { if($_POST['view'] == "text") { ?> <table border="0"> <tr> <td style="width:300px"><h2>BSK-Info</h2></td><td align=right style="width:350px"><i>Zuletzt aktualisiert: <?php echo date("d.m.Y", filemtime($path_abs."/fesch/index.php")); ?>.</i></td> </tr> <tr> <td colspan=2><a href="index.php">Zu den Suchmasken</a> | <a href="fertig.php">Fertigstellung von Gemarkung melden</a> | <a href="map.php">interaktive Grabloch- und Gemarkungskarte</a></td> </tr> </table><br /> <?php while($o = mysql_fetch_array($results)) { //print_r($o); ?> <table border="0" width="600" style="border-spacing:0px" class="inhalt"> <tr> <td width="300"><b><?php echo $o['prefix_nr_gmkg']." ".$o['Nr_Gmkg']."-".$o['lfd_Nr_Gemarkung']." ".$o['Gmkg']."</b>"; ?></b></td><td width="300"><?php echo $o['Landkreis_Soll']." &raquo; ".$o['BEZ_Gemeinde']; ?></td> </tr> <tr> <td colspan=2 style="padding-left:40px"> <table border=0> <tr><td class="small">Bezeichnung:&nbsp;</td><td class="small"><?php echo $o['Bezeichnung']; ?></td></tr> <tr><td class="small">Kartentyp:&nbsp;</td><td class="small"><?php echo $kartentyp[$o['Kartentyp']]; ?></td></tr> <tr><td class="small">Finanzamtsbezirk:&nbsp;</td><td class="small"><?php echo $o['Finanzamtsbezirk']; ?></td></tr> <tr><td class="small">Scan-Büro:&nbsp;</td><td class="small"><?php echo $o['Scan']; ?></td></tr> <tr><td class="small" valign="top">Bemerkung:&nbsp;</td><td class="small"><?php echo $o['Bemerkung']; ?></td></tr> <?php // Dateinamen $filename = $o['Nr_Gmkg'].str_repeat("0", 4-strlen($o['Nr_Gmkg'])).$o['Nr_Gmkg']; if(is_numeric($o['lfd_Nr_Gemarkung'])) { $filename .= str_repeat("_", 3-strlen($o['lfd_Nr_Gemarkung'])).$o['lfd_Nr_Gemarkung']; } else { $char = $o['lfd_Nr_Gemarkung'][strlen($o['lfd_Nr_Gemarkung'])-1]; $num = substr($o['lfd_Nr_Gemarkung'], 0, strlen($o['lfd_Nr_Gemarkung'])-1); $filename .= str_repeat("_", 3-strlen($num)).$num.$char; } //echo $filename; if(file_exists($path_abs."/dibos/jpg/".$filename.".jpg")) { echo "<tr><td class=\"small\">Karte:&nbsp;</td><td class=\"small\"><a href=\"/dibos/jpg/".$filename.".jpg\" target=\"_blank\"><img src=\"/images/jpg.png\" border=0 width=16></a> <a href=\"/dibos/jpg/".$filename.".jpg\" target=\"_blank\">".$filename.".jpg</a></td></tr>"; } if(file_exists($path_abs."/dibos/jgw/".$filename.".jgw")) { echo "<tr><td class=\"small\">JGW-Datei:&nbsp;</td><td class=\"small\"><a href=\"/dibos/jgw/".$filename.".jgw\" target=\"_blank\"><img src=\"/images/jgw.png\" border=0 width=16></a> <a href=\"/dibos/jgw/".$filename.".jgw\" target=\"_blank\">".$filename.".jgw</a></td></tr>"; } //if($o['long'] != NULL) { // echo "<tr><td class=\"small\">Google Map:&nbsp;</td><td class=\"small\"><a href=\"http://maps.google.com/maps?f=q&hl=de&q=E".$o['long']."+N".$o['lat']."&t=h&om=1\" target=\"_blank\"><img src=\"/images/G.gif\" border=\"0\"></a> <a href=\"http://maps.google.com/maps?f=q&hl=de&q=E".$o['long']."+N".$o['lat']."&t=h&om=1\" target=\"_blank\">zur Karte</a></td></tr>"; //} ?> </table> </td> </tr> </table><br /> <?php } } else { // tabellarische Ansicht ?> <table border="0"> <tr> <td style="width:300px"><h2>BSK-Info</h2></td><td align=right style="width:350px"><i>Zuletzt aktualisiert: <?php echo date("d.m.Y", filemtime($path_abs."/fesch/index.php")); ?>.</i></td> </tr> <tr> <td colspan=2><a href="index.php">Zu den Suchmasken</a> | <a href="fertig.php">Fertigstellung von Gemarkung melden</a> | <a href="map.php">interaktive Grabloch- und Gemarkungskarte</a></td> </tr> </table><br /> <table cellspacing=0 style="border: solid 1px #000000;border-collapse:collapse;"> <?php $i = 0; while($o = mysql_fetch_array($results)){ // Dateinamen $filename = $o['prefix_nr_gmkg'].str_repeat("0", 4-strlen($o['Nr_Gmkg'])).$o['Nr_Gmkg']; if(is_numeric($o['lfd_Nr_Gemarkung'])) { $filename .= str_repeat("_", 3-strlen($o['lfd_Nr_Gemarkung'])).$o['lfd_Nr_Gemarkung']; } else { $char = $o['lfd_Nr_Gemarkung'][strlen($o['lfd_Nr_Gemarkung'])-1]; $num = substr($o['lfd_Nr_Gemarkung'], 0, strlen($o['lfd_Nr_Gemarkung'])-1); $filename .= str_repeat("_", 3-strlen($num)).$num.$char; } if($i == 0 OR $i%15==0) { ?> <tr class="kopf"> <th class="kopf" height=22 width=70>Nr. Gmkg.</th> <th class="kopf" width=75>Gemarkung</th> <th class="kopf" width=75>Landkreis</th> <th class="kopf" width=75>Gemeinde</th> <th class="kopf" width=170>Bezeichnung</th> <th class="kopf" width=170>Bemerkung</th> <th class="kopf" width=75>Kartentyp</th> <th class="kopf" width=100>Finanzamtsb.</th> <th class="kopf" width=80>Scan-Büro</th> <th class="kopf" width=60>Karte/JGW</th> </tr> <?php } if($o['Zusatz_Info'] == "Karte existiert nicht") { $suffix_del = "_del"; } else { $suffix_del = ""; } ?> <tr<?php if($i%2==1) echo " style=\"background-color:#DDDDDD\""; ?> class="inhalt<?php echo $suffix_del; ?>"> <td class="inhalt<?php echo $suffix_del; ?>" height=22 align=right valign=top width=70><?php echo $o['prefix_nr_gmkg']." ".$o['Nr_Gmkg']; ?> - <?php echo $o['lfd_Nr_Gemarkung']; ?>&nbsp;&nbsp;&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo $o['Gmkg']; ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo substr(strstr($o['Landkreis_Soll'], "("), 1, -1); ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo $o['BEZ_Gemeinde']; ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top width=170><?php echo $o['Bezeichnung']; ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top width=170><?php echo $o['Bemerkung']; ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=75><?php echo $o['Kartentyp']; ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=100><?php echo $o['Finanzamtsbezirk']; ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top align=center width=80><?php echo $o['Scan']; ?>&nbsp;</td> <td class="inhalt<?php echo $suffix_del; ?>" valign=top width=60><?php if(file_exists($path_abs."/dibos/jpg/".$filename.".jpg")) echo "<a href=\"/dibos/jpg/".$filename.".jpg\" target=\"_blank\" ALT=\"".$filename.".jpg\" text=\"".$filename.".jpg\"><img src=\"/images/jpg.png\" border=0 width=16></a>"; ?> <?php if(file_exists($path_abs."/dibos/jgw/".$filename.".jgw")) echo "<a href=\"/dibos/jgw/".$filename.".jgw\" target=\"_blank\" ALT=\"".$filename.".jgw\" text=\"".$filename.".jgw\"><img src=\"/images/jgw.png\" border=0 width=16 style=\"padding:0;margin:0\"></a>"; ?>&nbsp; <?php /*if($o['long'] != NULL) echo "<a href=\"http://maps.google.com/maps?f=q&hl=de&q=E".$o['long']."+N".$o['lat']."&t=h&om=1\" target=\"_blank\"><img src=\"/images/G.gif\" border=\"0\"></a>"; */?></td> </tr> <?php $i++; } echo "</table>"; } } } } if(!$_POST['submit'] OR $error_1 OR $error_2 OR $error_3) { ?> <table border="0"> <tr> <td style="width:300px"><h2>BSK-Info</h2></td><td align=right style="width:350px"><i>Zuletzt aktualisiert: <?php echo date("d.m.Y", filemtime($path_abs."/index.php")); ?>.</i></td> </tr> <tr> <td colspan=2><a href="index.php">Zu den Suchmasken</a> | <a href="fertig.php">Fertigstellung von Gemarkung melden</a> | <a href="map.php">interaktive Grabloch- und Gemarkungskarte</a></td> </tr> </table><br /> <a name="formular_1"></a> <?php if($error_1) echo "<b style=\"color:#FF0000\">".$error_txt_1."</b><br /><br />"; ?> <form name="form1" method="POST" action="index.php#formular_1"> <input type="hidden" name="search" value="fulltext"> <input type="hidden" name="search_in" value="dibos"> <b>Raster und Metadaten - Volltextsuche</b><br /> <table border="0" style="padding-left:150px"> <tr> <td rowspan=4 <?php if($error_1) echo "style=\"background-color:red\""; ?>> &nbsp; </td> </tr> <tr> <td style="width:200px">Suchbegriff/e:</td> <td colspan=2><input type="text" name="keywords" value="<?php echo $_POST['keywords']; ?>" style="width:200px"></td> </tr> <tr> <td style="width:200px">verknüpft über</td> <td width=130>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="link" value="AND" <?php if($_POST['link'] == "AND" OR empty($_POST['link'])) echo "checked"; ?>> UND</td><td width=70><input type="radio" name="link" value="OR" <?php if($_POST['link'] == "OR") echo "checked"; ?>> ODER</td> </tr> <?php /* <tr> <td style="width:200px">Ansicht</td> <td width=130>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="view" value="tab" <?php if($_POST['view'] == "tab" OR empty($_POST['view'])) echo "checked"; ?>> tabellarisch</td><td width=70><input type="radio" name="view" value="text" <?php if($_POST['view'] == "text") echo "checked"; ?>> Text</td> </tr> */ ?> <tr> <td> </td> <td colspan=3 align=right><input type="reset" name="reset" value="Eingaben löschen" onclick="formLeeren(0)";><input type="submit" name="submit" value="suchen"></td> </tr> </table> </form> <a name="formular_2"></a> <?php if($error_2) echo "<b style=\"color:#FF0000\">".$error_txt_2."</b><br /><br />"; ?> <form name="form2" method="POST" action="index.php#formular_2"> <input type="hidden" name="search" value="detail"> <input type="hidden" name="search_in" value="dibos"> <b>Raster und Metadaten - Detailsuche</b><br /> <table border="0" style="padding-left:150px"> <tr> <td rowspan=9 <?php if($error_2) echo "style=\"background-color:red\""; ?>> &nbsp; </td> </tr> <tr> <td>Landkreis:</td> <td colspan=2> <select name="landkreis" style="width:200px"> <option value="">keine Auswahl getroffen</option> <?php $lkq = mysql_query("SELECT DISTINCT(Landkreis_Soll) FROM `fesch_sachdaten_LJ_raster` ORDER BY Landkreis_Soll"); while($lk = mysql_fetch_array($lkq)) { if($_POST['landkreis'] == $lk['Landkreis_Soll']) echo "<option value=\"".$lk['Landkreis_Soll']."\" selected>".$lk['Landkreis_Soll']."</option>\n"; else echo "<option value=\"".$lk['Landkreis_Soll']."\">".$lk['Landkreis_Soll']."</option>\n"; } ?> </select> </td> </tr> <tr> <td style="width:200px">Gemeinde:</td> <td colspan=2><input type="text" name="Gemeinde" value="<?php echo $_POST['Gemeinde']; ?>" style="width:200px"></td> </tr> <tr> <td>Nr. Gemarkung:</td> <td colspan=2><input type="text" name="Nr_Gmkg_txt" value="<?php echo $_POST['Nr_Gmkg_txt']; ?>" style="width:200px"></td> </tr> <tr> <td>Gemarkung:</td> <td colspan=2><input type="text" name="Gmkg" value="<?php echo $_POST['Gmkg']; ?>" style="width:200px"></td> </tr> <tr> <td>Finanzamtsbezirk:</td> <td colspan=2> <select name="Finanzamtsbezirk" style="width:200px"> <option value="">keine Auswahl getroffen</option> <?php $fabq = mysql_query("SELECT DISTINCT(IF(`Finanzamtsbezirk`='-', 'unbekannt', REPLACE(REPLACE(`Finanzamtsbezirk`, 'Hr.', 'Herr'), 'Fr.', 'Frau'))) as fab,`Finanzamtsbezirk` FROM `fesch_sachdaten_LJ_raster` ORDER BY fab"); while($fab = mysql_fetch_array($fabq)) { if($_POST['Finanzamtsbezirk'] == $fab['Finanzamtsbezirk']) echo "<option value=\"".$fab['Finanzamtsbezirk']."\" selected>".$fab['Finanzamtsbezirk']."</option>\n"; else echo "<option value=\"".$fab['Finanzamtsbezirk']."\">".$fab['Finanzamtsbezirk']."</option>\n"; } ?> </select> </td> </tr> <tr> <td>Kartentyp:</td> <td colspan=2> <select name="Kartentyp" style="width:200px"> <option value="">keine Auswahl getroffen</option> <?php foreach($kartentyp as $typ=>$bez) { if($_POST['Kartentyp'] == $typ) echo "<option value=\"".$typ."\" selected>".$bez."</option>\n"; else echo "<option value=\"".$typ."\">".$bez."</option>\n"; } ?> </select> </td> </tr> <tr> <td>Bezeichnung/Bemerkung:</td> <td colspan=2><input type="text" name="keywords_d" value="<?php echo $_POST['keywords_D']; ?>" style="width:200px"></td> </tr> <?php /*<tr> <td style="width:200px">Ansicht</td> <td width=130>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="radio" name="view" value="tab" <?php if($_POST['view'] == "tab" OR empty($_POST['view'])) echo "checked"; ?>> tabellarisch</td><td width=70><input type="radio" name="view" value="text" <?php if($_POST['view'] == "text") echo "checked"; ?>> Text</td> </tr>*/ ?> <tr> <td> </td> <td colspan=3 align=right><input type="reset" name="reset" value="Eingaben löschen" onclick="formLeeren(1)";><input type="submit" name="submit" value="suchen"></td> </tr> </table><br /> </form> <!--<table border=0> <tr> <td style="width:550px"> Stern <b>*</b> kann als Wildcard/Platzhalter genutzt werden. Ansonsten ist nur der Bindestrich <b>-</b> als Sonderzeichen zugelassen. Bei der Volltextsuche sind Wörter optimal mit Leerzeichen zu trennen. </td> </tr> </table>--> <?php } mysql_close($mysql_connection); ?> <br /><br /> <table border="0"> <tr> <td colspan=2> <b>Metadaten zu den Urkarten der Reichsbodenschätzung / Statistik zu den geprüften Gemarkungen in FESCH </b><br /> Dieser Auszug ist gesetzlich geschützt und darf nur mit Zustimmung des Ministeriums der Finanzen des Landes Brandenburg vervielfältigt, umgearbeitet, veröffentlicht oder an Dritte weitergegeben werden.<br />Vervielfältigung und Umarbeitungen zur dienstlichen Verwendung innerhalb der Behörde oder zum eigenen nicht gewerblichen Gebrauch sind jedoch zulässig. </td> </tr> </table><br /> </body> </html>
Output for git.master, git.master_jit, rfc.property-hooks
<html> <head> <style type="text/css"> body,tr,td {font-family:Arial; font-size:10pt}} b {font-family:Arial; font-size:10pt; font-weight:bold} .small {font-family:Arial; font-size:8pt} .kopf {font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px;border-spacing:0px;background-color:#999999} .inhalt {font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px #000000;border-spacing:0px} .inhalt_del {font:-family:Arial; color:#AAAAAA; font-size:8pt;padding:3px;margin:0px;border:solid 1px #000000;border-spacing:0px} .gesamt {font-family:Arial; font-weight:bold; font-size:8pt;padding:3px;margin:0px;border:solid 1px;border-spacing:0px} .inhaltgrau {color:#bbbbbb;font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px black;border-spacing:0px} .inhaltgraugrau {color:#bbbbbb;font-family:Arial; font-size:8pt;padding:3px;margin:0px;border:solid 1px black;border-spacing:0px} a:link { color:#0000AA; text-decoration:underline; } a:visited{ color:#0000AA; text-decoration:underline; } a:focus { color:#0000AA; text-decoration:underline; } a:hover { color:#0000EE; text-decoration:underline; } a:active { color:#0000AA; text-decoration:underline; } </style> <SCRIPT LANGUAGE="JavaScript" SRC="combined/CalendarPopup.js"></SCRIPT> <SCRIPT LANGUAGE="JavaScript">document.write(getCalendarStyles());</SCRIPT> <script type="text/javascript"> function flip(uebergabe1, uebergabe2) { for ( i = 0 ; i <= uebergabe2 ; i++ ) { if ( document.getElementsByName(uebergabe1)[i].style.display == "" ) { document.getElementsByName(uebergabe1)[i].style.display = "none"; aktion = "einblenden"; } else { document.getElementsByName(uebergabe1)[i].style.display = ""; aktion = "ausblenden"; } } if ( aktion == "ausblenden") { document.getElementById('img_' + uebergabe1).src = "/fesch/img/minus.gif"; } else { document.getElementById('img_' + uebergabe1).src = "/fesch/img/plus.gif"; } } function formLeeren(uebergabe3){ var obj = document.forms[uebergabe3]; for(i=0;i<obj.elements.length;i++){ if(obj.elements[i].type == 'text' || obj.elements[i].type == 'textarea'){ obj.elements[i].value = ''; } else { obj.elements[i].selectedIndex = 0; } } } var fenster; function neues() { fenster = window.open ( "", "NeuesFenster", // Name des neuen Fensters +"toolbar=0" // Toolbar +",location=0" // Adress-Leiste +",directories=0" // Zusatzleisten +",status=0" // Statusleiste +",menubar=0" // Menü +",scrollbars=0" // Scrollbars +",resizable=0" // Fenstergrösse veränderbar? +",width=920" // Fensterbreite in Pixeln +",height=840" // Fensterhöhe in Pixeln ); fenster.moveTo( 50, // X-Koordinate 50 // Y-Koordinate ); // der linken oberen Ecke fenster.location.href = "/fesch/map.php"; //Dateiname und Pfad der Datei, die angezeigt werden soll } function neues2() { fenster = window.open ( "", "NeuesFenster", // Name des neuen Fensters +"toolbar=0" // Toolbar +",location=0" // Adress-Leiste +",directories=0" // Zusatzleisten +",status=0" // Statusleiste +",menubar=0" // Menü +",scrollbars=0" // Scrollbars +",resizable=0" // Fenstergrösse veränderbar? +",width=920" // Fensterbreite in Pixeln +",height=840" // Fensterhöhe in Pixeln ); fenster.moveTo( 50, // X-Koordinate 50 // Y-Koordinate ); // der linken oberen Ecke fenster.location.href = "/fesch/map_ia.php"; //Dateiname und Pfad der Datei, die angezeigt werden soll } </script> <STYLE> .TESTcpYearNavigation, .TESTcpMonthNavigation { background-color:#6677DD; text-align:center; vertical-align:center; text-decoration:none; color:#FFFFFF; font-weight:bold; } .TESTcpDayColumnHeader, .TESTcpYearNavigation, .TESTcpMonthNavigation, .TESTcpCurrentMonthDate, .TESTcpCurrentMonthDateDisabled, .TESTcpOtherMonthDate, .TESTcpOtherMonthDateDisabled, .TESTcpCurrentDate, .TESTcpCurrentDateDisabled, .TESTcpTodayText, .TESTcpTodayTextDisabled, .TESTcpText { font-family:arial; font-size:8pt; } TD.TESTcpDayColumnHeader { text-align:right; border:solid thin #6677DD; border-width:0 0 1 0; } .TESTcpCurrentMonthDate, .TESTcpOtherMonthDate, .TESTcpCurrentDate { text-align:right; text-decoration:none; } .TESTcpCurrentMonthDateDisabled, .TESTcpOtherMonthDateDisabled, .TESTcpCurrentDateDisabled { color:#D0D0D0; text-align:right; text-decoration:line-through; } .TESTcpCurrentMonthDate { color:#6677DD; font-weight:bold; } .TESTcpCurrentDate { color: #FFFFFF; font-weight:bold; } .TESTcpOtherMonthDate { color:#808080; } TD.TESTcpCurrentDate { color:#FFFFFF; background-color: #6677DD; border-width:1; border:solid thin #000000; } TD.TESTcpCurrentDateDisabled { border-width:1; border:solid thin #FFAAAA; } TD.TESTcpTodayText, TD.TESTcpTodayTextDisabled { border:solid thin #6677DD; border-width:1 0 0 0; } A.TESTcpTodayText, SPAN.TESTcpTodayTextDisabled { height:20px; } A.TESTcpTodayText { color:#6677DD; font-weight:bold; } SPAN.TESTcpTodayTextDisabled { color:#D0D0D0; } .TESTcpBorder { border:solid thin #6677DD; } </STYLE> <title>FESCH - Metadatensuche zur Schätzungskarten</title> </head> <BODY bgcolor="#ffffff" text="#000000" link="#996600" vlink="#666666" alink="#336600"> <br /> Warning: Undefined array key "PHP_AUTH_USER" in /in/4aPln on line 217 Warning: include(): open_basedir restriction in effect. File(../includes/config.inc.php) is not within the allowed path(s): (/tmp:/in:/etc) in /in/4aPln on line 223 Warning: include(../includes/config.inc.php): Failed to open stream: Operation not permitted in /in/4aPln on line 223 Warning: include(): Failed opening '../includes/config.inc.php' for inclusion (include_path='.:') in /in/4aPln on line 223 Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /in/4aPln:224 Stack trace: #0 {main} thrown in /in/4aPln on line 224
Process exited with code 255.

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page


preferences:
45.7 ms | 409 KiB | 8 Q