Help me about using session username in json

jajul

This code below just show the data when i login with the level superadmin or admin.
But when i login with the level user, the data just show the process loading.
I don't know where is the wrong of this code below:

<?php
session_start();
require_once "../../../config/fungsi/koneksi.php";
require_once "../../../config/fungsi/fungsi_indotgl.php";
$aksi="modul/mod_blog/aksi_blog.php";
$requestData= $_REQUEST;
$username = $_SESSION['namauser'];

$columns = array( 
    0 => 'id_blog',
    1 => 'jdl_blog',
    2 => 'nama_lengkap',
    3 => 'nama_kategori',
    4 => 'tanggal',
    5 => 'aktif_blog'
);

// getting total number records without any search
if($_SESSION['leveluser']=='superadmin' OR $_SESSION['leveluser']=='admin'){
    $sql = "SELECT id_blog, jdl_blog, judul_seo, nama_lengkap, nama_kategori, aktif_blog, username, gbr_blog, tanggal ";
    $sql.=" FROM blog_view";
}else{
    $sql = "SELECT id_blog, jdl_blog, judul_seo, nama_lengkap, nama_kategori, aktif_blog, username, gbr_blog, tanggal ";
    $sql.=" FROM blog_view WHERE username = '".$_SESSION['username']."'";
}
$query          = mysqli_query($db, $sql) or die("load-data.php: get InventoryItems");
$totalData      = mysqli_num_rows($query);
$totalFiltered  = $totalData;  

if( !empty($requestData['search']['value']) ) {
    $sql = "SELECT id_blog, jdl_blog, judul_seo, nama_lengkap, nama_kategori, aktif_blog, username, gbr_blog, tanggal ";
    $sql.=" FROM blog_view";
    $sql.=" WHERE jdl_blog LIKE '".$requestData['search']['value']."%' ";
    $query=mysqli_query($db, $sql) or die("load-data.php: get PO");
    $totalFiltered = mysqli_num_rows($query); 
    $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]."   ".$requestData['order'][0]['dir']."   LIMIT ".$requestData['start']." ,".$requestData['length']."   "; 
    $query=mysqli_query($db, $sql) or die("load-data.php: get PO"); 
}else{
    $sql = "SELECT id_blog, jdl_blog, judul_seo, nama_lengkap, nama_kategori, aktif_blog, username, gbr_blog, tanggal ";
    $sql.=" FROM blog_view";
    $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]."   ".$requestData['order'][0]['dir']."   LIMIT ".$requestData['start']." ,".$requestData['length']."   ";
    $query=mysqli_query($db, $sql) or die("load-data.php: get PO"); 
}

$data = array();
$no = 1;
while( $row=mysqli_fetch_array($query) ) { 
    $nestedData=array(); 
    $nestedData[] = $no;
    if($row['aktif_blog']=='Ya'){
        $nestedData[] = '<a href="../berita/'.$row['id_blog'].'/'.$row['judul_seo'].'" target="_blank">'.$row['jdl_blog'].'</a>';
    }else{
        $nestedData[] = $row['jdl_blog'];
    }
    $nestedData[] = $row["nama_lengkap"];
    $nestedData[] = $row["nama_kategori"];
    $nestedData[] = tgl_indo($row["tanggal"]);
    if($row['aktif_blog']=='Ya'){
        $nestedData[] = '<a href="'.$aksi.'?module=blog&act=statusblokir&id='.abs((int)$row['id_blog']).'" class="btn btn-success btn-xs">Diterbitkan</a>';
    }else{
        $nestedData[] = '<a href="'.$aksi.'?module=blog&act=statusaktif&id='.abs((int)$row['id_blog']).'" class="btn btn-warning btn-xs">Draft</a>';
    }           
    $nestedData[] = '<div class="btn-group">
                        <a href="?module=blog&act=editData&id='.abs((int)$row['id_blog']).'" class="btn btn-warning btn-xs" role="button" data-toggle="tooltip" title="EDIT"><i class="fa fa-pencil"></i></a>
                        <a class="btn btn-danger btn-xs" href="#hapusData'.abs((int)$row['id_blog']).'" data-toggle="modal" data-toggle="tooltip" title="HAPUS"><i class="fa fa-trash"></i></a>
                            <div class="modal modal-default" id="hapusData'.abs((int)$row['id_blog']).'" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                                <div class="modal-dialog">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <button data-toggle="tooltip" title="Tutup" type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                                            <h4 class="modal-title"><i class="fa fa-trash-o"></i> Hapus Data</h4>
                                        </div>
                                        <div class="modal-body" style="text-align:center;">
                                            <font color="#FF0000"><i class="fa fa-warning fa-5x"></i></font><br><h3>Yakin data ini akan dihapus?</h3>
                                        </div>
                                        <div class="modal-footer">
                                            <a href="'.$aksi.'?module=blog&act=hapus&id='.abs((int)$row['id_blog']).'&namafile='.$row['gbr_blog'].'" class="btn btn-block btn-danger btn-flat">Hapus</a>
                                        </div>
                                    </div><!-- /.modal-content -->
                                </div><!-- /.modal-dialog -->
                            </div><!-- /.modal -->
                    </div>';
    $data[] = $nestedData;
$no++;
}

$json_data = array(
            "draw"            => intval( $requestData['draw'] ),
            "recordsTotal"    => intval( $totalData ),  
            "recordsFiltered" => intval( $totalFiltered ), 
            "data"            => $data   
            );

echo json_encode($json_data);  
?>

allan

I'm afraid I can't debug your PHP code for you, but I would suggest having a look at the server's error logs. It might indicate what the issue is.

Allan