viewKegiatan

<?php

    include_once('connection.php');

    //query silahkan disesuaikan//
    $query = "SELECT kegiatan.id_kegiatan, kegiatan.nama_kegiatan, program.nama_program, kegiatan.galeri FROM tb_kegiatan AS kegiatan LEFT JOIN tb_program AS program ON kegiatan.id_program = program.id_program ORDER BY kegiatan.id_kegiatan DESC";

    $result = mysqli_query($conn,$query);
    $arraydata = array();

    while($baris = mysqli_fetch_assoc($result))
    {
        # code...
        $arraydata[]=$baris;
    }
    echo json_encode($arraydata);

?>