使用JQUERY使用PHP AJAX JSON显示所有数据

Question

filePHP.php

$query = $kon->prepare("SELECT * FROM t_kategori");
$query->execute();
while($row = $query->fetch(PDO::FETCH_ASSOC))
{
    $json = array('id' => $row['id_kategori'], 'nama' => $row['nama_kategori']);
    echo json_encode($json);
}

and index.php

$.post('filePHP.php', function(data){
   console.log(data);
},'json');

but this not working, please solution ???? thankz

Answer 1

Try this in PHP

$query = $kon->prepare("SELECT id_kategori,nama_kategori FROM t_kategori");
$query->execute();
$json=array();
while($row = $query->fetch(PDO::FETCH_ASSOC))
{
    $arr=array('id'=>$row['id_kategori'],'nama'=>$row['nama_kategori']);
    array_push($json,$arr);
}
echo json_encode($json);

Read array-push