connect_error) { die("Connection failed: " . $conn->connect_error); } $lang='de'; header('Content-type: text/html; charset=UTF-8'); echo ''; $rubrik=filter_input(INPUT_GET, 'rubrik', FILTER_SANITIZE_STRING); // Koordinaten für Google Map $maplng=$lng; $maplat=$lat; // lng lat runden $lng = round($lng, 2); $lat = round($lat, 2); $entf=15; // Entfernung in Kilometern $alpha = 180*$entf/(6378137/1000*3.14159); $ursprungsbreite = $lng; $ursprungslaenge = $lat; $geo1 = $ursprungsbreite-$alpha; $geo2 = $ursprungsbreite+$alpha; $geo3 = $ursprungslaenge-$alpha; $geo4 = $ursprungslaenge+$alpha; $neu=mysqli_query($conn, "SELECT * FROM `artikel` where rubrik='$rubrik' AND lang='$lang' AND (`lat` >= '$geo1') AND (`lat` <= '$geo2') AND (`lng` >= '$geo3') AND (`lng` <= '$geo4') order by timestamp DESC LIMIT 20"); include("inc_umlaute.php"); $latest=""; while($row = mysqli_fetch_assoc($neu)) { $utitel = $row['titel']; foreach( $aUmlaute as $sSonderZeichen=>$sReplace ) { $utitel = str_replace( $sSonderZeichen, $sReplace, $utitel); } $q=$row['quelle']; $quelle = mysqli_query($conn, "select * from feeds where ind='$q' LIMIT 1"); $rquelle = mysqli_fetch_assoc($quelle); $wer = $rquelle['quelle']; $art = $rquelle['ind']; $bild = mysqli_query($conn, "select * from bilder where text='$art' LIMIT 1"); $latest=$latest.''.$wer.'

'.$row['titel'].'

'; if (mysqli_num_rows($bild) > 0) { $rbild= mysqli_fetch_assoc($bild); $latest=$latest.' '.$rbild['legende'].'

'; } $latest=$latest.'

'.$row["timestamp"].'

'; } mysqli_close($conn); ?> <? echo $rubrik ?> - News und Informationen <? echo $key_place ?>