<?php 

$q = "SELECT * FROM ilanlar WHERE durum=?";
$sql = $conn->prepare($q);
$sql->execute(array(1));

if ($sql->rowCount() != 0 ){

	$bilgiler	= array();
	$data		= array();

	foreach ($sql as $key) {

	$data["id"]			=	"marker-" . $key["id"];
	$data["center"]		=	 [ $key['enlem'] . ',' .  $key['boylam'] ];
	$data["icon"]		=	"<i class='zmdi zmdi-home'></i>";
	$data["title"]		=	$key["baslik"];
	$data["desc"]		=	$key["oda"].' - '.$key["metre"].'m²';
	$data["price"]		=	$key["fiyat"].' '.$key["birim"];
	$data["image"]		=	$baseURL . "uploads/vitrin/" . $key['resim'];
	$data["link"]			=	$baseURL . "detay/" . $key['id'] . "/" . $key['seo'] . "/";

	array_push($bilgiler, $data);

	}

	$encoded_json = json_encode($bilgiler, JSON_NUMERIC_CHECK);

	file_put_contents("markers.json", $encoded_json);

}

?>