JSON pagination blank after include few page

Question

Config.php

<?php
     define('HOST','localhost');
     define('USER','root');
     define('PASS','mypass');
     define('DB','db_news');

     $con = mysqli_connect(HOST,USER,PASS,DB) or die('Unable to Connect');
?>

Listnews.php

<?php 
include'con_db.php';

if (isset($_GET['page']) && is_numeric($_GET['page'])) { 
    $page= (int) $_GET['page'];
} else {
    $page= 1;  
}

$all_row = "SELECT COUNT(*) FROM berita";
$data_page = mysqli_query($con, $all_row);  
$r = mysqli_fetch_row($data_page);

$numrows = $r[0];
$rowsperpage = 10;

$totalpages = ceil($numrows / $rowsperpage);

//if current page is greater than total pages
if ($page > $totalpages) {
    //set current page to last page
    $page= $totalpages;
}

//if current page is less than first page
if ($page < 1) {
    //set current page to first page
    $page= 1;
}

// the offset of the list, based on current page
$offset = ($page - 1) * $rowsperpage;

$query = "SELECT * FROM berita order by id_berita DESC LIMIT $offset, $rowsperpage";
$result = mysqli_query($con, $query);
if(mysqli_num_rows($result)>0) {
        $response["list_data"] = array();
        while ($row = mysqli_fetch_assoc($result)) {
            $temp = array("id" => $row["id_berita"],
                        "judul" => $row["judul"], 
                        "isi" => $row["isi_berita"],
                        "tgl" => $row["tanggal"].' '.$row["jam"],
                        "dibaca" => $row["dibaca"].' Dibaca',
                        "url_berita" => $row["judul_seo"],
                        "gambar" => $row["gambar"]);
            array_push($response["list_data"], $temp);
        }

        if($result){
            $response["success"] = 1;
            $response["message"] = "Successfully Displayed";
            $response["page"] = $page;
            $response["total_pages"] = $totalpages;
            $data = json_encode($response);
            echo $data;
        }
        else{
            $response["success"] = 0;
            $response["message"] = "Try Again";
            $response["page"] = $page;
            $response["total_pages"] = $totalpages;
            $data = json_encode($response);
            echo $data;
        }
}else{
    $response["success"] = 2;
    $response["message"] = "No Details Found";
    $response["page"] = $page;
    $response["total_pages"] = $totalpages;
    $data = json_encode($response);
    echo $data;
}

/*
**$data = json_encode($response);
**echo $data;
*/
?>

after test with postman myhost/news/berita.php?page=1,2,3,4,5,6 it showing json data. showing json data with page 1-6

then i include page 7 myhost/news/berita.php?page=7 its blank after incluse page 7

please help me sir, i'm sorry for bad my language

Not sure but just try to change `if($result)` to `if(count($response))` — Omi, Apr 25 '17 at 23:05
just same sir, but i try with manual query it work SELECT * FROM berita order by id_berita DESC LIMIT 7, $rowsperpage — Minal Juadly, Apr 26 '17 at 05:59
finally done sir, just add formating utf8ize http://stackoverflow.com/questions/19361282/why-would-json-encode-returns-an-empty-string — Minal Juadly, Apr 26 '17 at 08:49

Minal Juadly · Answer 1 · 2017-06-01T10:44:20.573

finally done my problem, just add utf8ize function

function utf8ize($d) {
if (is_array($d)) {
    foreach ($d as $k => $v) {
        $d[$k] = utf8ize($v);
    }
} else if (is_string ($d)) {
    return utf8_encode($d);
}
return $d;

}

and use it for json_encode

$response["success"] = 1;
$response["message"] = "Successfully Displayed";
$response["page"] = $halaman;
$response["total_pages"] = $totalpages;
$data = json_encode(utf8ize($response));
echo $data;

JSON pagination blank after include few page

1 Answers1