Display All Data with PHP AJAX JSON using JQUERY

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, what would solve this problem?

Please provide information on what is not working. Error message, returned data, expected data. There can never be too much information — elzaer
– elzaer, Commented Oct 22, 2013 at 4:56
in you ajax you are using "proses.php" while code is in "filePHP.php". — developerCK
– developerCK, Commented Oct 22, 2013 at 5:23
@developerCK : sorry for the file name,, but this code copy/paste from my project, mr. .. — PACE
– PACE, Commented Oct 22, 2013 at 10:21

Rohan Kumar · Accepted Answer · 2013-10-23 04:35:45Z

2

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

edited Oct 23, 2013 at 4:35

answered Oct 22, 2013 at 4:56

Rohan Kumar

40.7k11 gold badges81 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Priya Over a year ago

best coding practice says you should use column name instead of asterisk(*). Use array_push() in loop

Rohan Kumar Over a year ago

@Ryo check the file name you passed in $.post as Both are looking different in your question and in $.post

PACE Over a year ago

@rohan : ohh sorry,,, but this source copy/paste from my project .. hehehe

rajesh kakawat · Accepted Answer · 2013-10-22 06:19:15Z

1

try something like this , your code will echo json in wrong format whereas below code will give you json array.

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

echo json_encode($json_arr);

edited Oct 22, 2013 at 6:19

answered Oct 22, 2013 at 5:36

rajesh kakawat

10.9k1 gold badge24 silver badges40 bronze badges

Collectives™ on Stack Overflow

Display All Data with PHP AJAX JSON using JQUERY

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related