Parsing GeoJSON in PHP?

manpreet Best Answer 2 years ago

i am trying to parse GeoJson from database with php but somehow i got an error and i cannot found any error in my script. here my script

$id = 1;
$db = new mysqli("com/tag/localhost">localhost","com/tag/root">root","","skriboo");
$sql = $db->query('SELECT * FROM profil_sekolah WHERE id_sekolah='.$id);
$sql2 = $db->query('SELECT * FROM pegawai WHERE id_pegawai='.$id);
$sql3 = $db->query('SELECT * FROM kelas_x A, kelas_xi B, kelas_xii C WHERE A.id_x=B.id_xi AND B.id_xi=C.id_xii AND C.id_xii='.$id);
$sql4 = $db->query('SELECT * FROM fasilitas WHERE id_sekolah='.$id);
$sql5 = $db->query('SELECT * FROM galeri where id_sekolah='.$id);
$sql6 = $db->query('SELECT bujur, lintang FROM lokasi WHERE id_lokasi='.$id);
$geojson = array(
'type' => 'FeatureCollection',
'features' => array(
    'type' => 'feature',
    'properties' => array(),
    'geometry' => array()
));

while ($row = $sql->fetch_array(MYSQLI_ASSOC)) {
    $properties = $row;
    array_push($geojson['properties'], $properties);
}

while ($row2 = $sql2->fetch_array(MYSQLI_ASSOC)) {
    $properties2 = $row2;
    array_push($geojson['properties'], $properties2);
}

while ($row3 = $sql3->fetch_array(MYSQLI_ASSOC)) {
    $properties3 = $row3;
    array_push($geojson['properties'], $properties3);
}

while ($row4 = $sql4->fetch_array(MYSQLI_ASSOC)) {
    $properties4 = $row4;
    array_push($geojson['properties'], $properties4);
}

while ($row5 = $
                                                

                                                                                                        REPLY
                                                    
                                                
                                                


                                                    

                                                        
                                                            0
                                                            views 

                                                            0
                                                                likes 
                                                            
                                                            

                                                            0
                                                            shares

                                                            


    

         Facebook
        
         Twitter
        
        
         Linked In 
        
          WhatsApp