<?php
$servername = "";
$username = "";
$password = "";
$dbname = "";

// Crea conexion
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

lista_entidad( $conn, "tabla", "geojson");

$conn->close();
/*
 Crea un archivo geojson por cada entidad que se le envie
*/
function crea_json( $file, $tabla, $contenido){
 $myfile = fopen($file, "w") or die("Unable to open file!");
 fwrite($myfile, '{ "type": "MultiPolygon", "coordinates": [[['.$contenido.']]]}');
 fclose($myfile);
}


/*
 Recorre la tabla por cada entidad
*/
function lista_entidad( $conn, $tabla, $campo){
 $sql = "SELECT * FROM $tabla";
 $result = $conn->query($sql);

 if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
		crea_json( $row["id"].".json", "", $row[$campo] );
    }
 } else {
    echo "0 results";
 }
}
?>