Alter" : ""; ?> " : "" ?> query($strSQL); while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $id = $row['lid']; $numDatum= strtotime($row['created_at']); $strDatum= date("d.m.Y",$numDatum); echo ""; echo ""; echo ""; echo ($boolUserinfo) ? "" : ""; echo ""; echo ""; echo ($boolRating) ? "" : ""; echo ""; $strDefect = (isset($row['defect']) && $row['defect']>0) ? $arrDefect[$row['defect']] : ""; echo "\n"; echo ""; echo ""; //echo ""; echo "\n"; echo "\n"; $strScript.="var mymap_".$id." = L.map(map_".$id.").setView([".$row['lat'].", ".$row['lng']."], 16);\n"; $strScript.="L.tileLayer(url, {maxZoom: 18,minZoom:12,attribution: attribution,id: 'mapbox/streets-v11',tileSize: 512,zoomOffset: -1}).addTo(mymap_".$id.")\n"; $strScript.="L.marker([".$row['lat'].", ".$row['lng']."], { icon: infoMarker } ).addTo(mymap_".$id.")\n\n"; } ?>
id Username TransportTopic Beschreibung Kommentare Mangel Bild Adresse Karte
".$id."". stripslashes($row['username']) ."

". $strDatum . "
".$row['age']."".$row['transport']."".$arrIcon[$row['topic']]." ".$arrTopic[$row['topic']]."" . stripslashes(nl2br($row['description'])) . "".$row['thumb_ups']."".$row['thumb_downs'].""; $strSQL = "SELECT id,username,comment,created_at FROM comment WHERE loc_id=".$id; $comments = $db->query($strSQL); while ($comment = $comments->fetch(PDO::FETCH_ASSOC)) { echo "
"; echo "".$comment['username']." schrieb am "; $numDatum = strtotime($comment['created_at']); $strDatum = date("d.m.Y",$numDatum); echo $strDatum."
"; echo nl2br($comment['comment']); echo "
"; } echo "
".$strDefect.""; $strSQL = "SELECT id,filename FROM files WHERE loc_id=".$id; $files=$db->query($strSQL); if ($file=$files->fetch(PDO::FETCH_ASSOC)) { echo ""; } echo "".$row['road']." ".$row['house_number']."
".$row['neighbourhood']."
" .$row['hamlet']."
".$row['suburb']."
".$row['postcode']." ".$row['city']."
".round($row['lat'],5)." ".round($row['lng'],5)."
zurück