Create JSON & Parsing PHP

{"posts":[
            {
                "headline":"The Headline for post 1",
                "body":"Lorem ipsum dolor sit amet consectetur adipiscing elit.",
                "posted_on":"Feb 11, 2013",
                "posted_by":"username"
            },
            {
                "headline":"The Headline for post 2",
                "body":"Lorem ipsum dolor sit amet consectetur adipiscing elit.",
                "posted_on":"Feb 12, 2013",
                "posted_by":"anotheruser"
            }
]}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

{"posts":[

{

"headline":"The Headline for post 1",

"body":"Lorem ipsum dolor sit amet consectetur adipiscing elit.",

"posted_on":"Feb 11, 2013",

"posted_by":"username"

},

{

"headline":"The Headline for post 2",

"body":"Lorem ipsum dolor sit amet consectetur adipiscing elit.",

"posted_on":"Feb 12, 2013",

"posted_by":"anotheruser"

}

]}

CREATE TABLE `artikel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `headline` varchar(100) DEFAULT NULL,
  `body` text,
  `postdate` int(11),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

1

2

3

4

5

6

7

CREATE TABLE `artikel` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`headline` varchar(100) DEFAULT NULL,

`body` text,

`postdate` int(11),

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

INSERT INTO artikel(id,headline,body,postdate)
VALUES('1','The Headline for post 1','Lorem ipsum dolor sit posting 1','1351570931');

INSERT INTO artikel(id,headline,body,postdate)
VALUES('2','The Headline for post 2','Lorem ipsum dolor sit posting 2','1351570931');

INSERT INTO artikel(id,headline,body,postdate)
VALUES('3','The Headline for post 3','Lorem ipsum dolor sit posting 3','1351570931');

1

2

3

4

5

6

7

8

INSERT INTO artikel(id,headline,body,postdate)

VALUES('1','The Headline for post 1','Lorem ipsum dolor sit posting 1','1351570931');

INSERT INTO artikel(id,headline,body,postdate)

VALUES('2','The Headline for post 2','Lorem ipsum dolor sit posting 2','1351570931');

INSERT INTO artikel(id,headline,body,postdate)

VALUES('3','The Headline for post 3','Lorem ipsum dolor sit posting 3','1351570931');

<?php
	mysql_connect('localhost', 'root', '');
	mysql_select_db('contohjson');
	
	$query = mysql_query("SELECT * FROM `artikel`");
	
	if ($query) {
		$posts = array();
		if(mysql_num_rows($query)) {
			while ($post = mysql_fetch_assoc($query)) {
				$posts[] = $post;
			}
		}
		
		echo json_encode(array('artikel'=>$posts));
	}
?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

<?php

mysql_connect('localhost', 'root', '');

mysql_select_db('contohjson');

$query = mysql_query("SELECT * FROM `artikel`");

if ($query) {

$posts = array();

if(mysql_num_rows($query)) {

while ($post = mysql_fetch_assoc($query)) {

$posts[] = $post;

}

echo json_encode(array('artikel'=>$posts));

}

?>

<?php
	$json_url = 'http://localhost/blog/contoh_json/creat_json.php';
	$ch = curl_init ($json_url);
	$options = array(
		CURLOPT_RETURNTRANSFER => true,
		CURLOPT_HTTPHEADER => array('Content-type: application/json'),
	);
	curl_setopt_array ($ch, $options); // setting curl options
	$result = curl_exec($ch); // getting json result string
	
	$decode = json_decode($result, true);
	foreach ($decode['artikel'] as $row) {
		echo "<div id='content'>";
		echo "<p id='judul'>".$row['headline'] ."</p>";
		echo "<p id='isi'>".$row['body'] ."</p>";
		echo "<p id='tanggal'>".$row['postdate'] ."</p>";
		echo "</div>";
	}
	
?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

<?php

$json_url = 'http://localhost/blog/contoh_json/creat_json.php';

$ch = curl_init ($json_url);

$options = array(

CURLOPT_RETURNTRANSFER => true,

CURLOPT_HTTPHEADER => array('Content-type: application/json'),

);

curl_setopt_array ($ch, $options); // setting curl options

$result = curl_exec($ch); // getting json result string

$decode = json_decode($result, true);

foreach ($decode['artikel'] as $row) {

echo "<div id='content'>";

echo "".$row['headline'] ."";

echo "".$row['body'] ."";

echo "".$row['postdate'] ."";

echo "</div>";

}

?>

<?php
mysql_connect("localhost", "root", "");
mysql_select_db("buku");
 
// MEMBUAT DATA DENGAN FORMAT JSON
 
// buat inisialisasi variabel dengan tipe data array yang masih kosong
// ambil data dari tabel daftar_buku di database
// kemudian masukkan data-data tersebut ke variabel $data2;
$data2 = array();
$get = mysql_query("SELECT * FROM daftar_buku ORDER BY buku_kode");
while($data = mysql_fetch_array($get)){
    $data2[] = $data;
}
 
//konversi data array tadi menjadi "semua string" dengan format json.
$json_format = json_encode($data2);
 
echo $json_format;
echo "<br/>";
 
// MENGOLAH DATA BERFORMAT JSON
// true untuk menjadikannya array
$json_data = json_decode($json_format,true);
 
for($i=0; $i<count($json_data); $i++){
    echo $json_data[$i]['buku_kode']."<br/>";
    echo $json_data[$i]['buku_judul']."<br/>";
    echo $json_data[$i]['buku_penerbit']."<br/>";
    echo $json_data[$i]['buku_tahun']."<br/>";
    echo "<br/>";
}
 
echo "<br/>";
foreach ($json_data as $thedata->buku_kode) {
    foreach ($thedata as $value) {
        echo $value['buku_kode']."<br/>";
        echo $value['buku_judul']."<br/>";
        echo $value['buku_penerbit']."<br/>";
        echo $value['buku_tahun']."<br/>";
        echo "<br/>";
    }
}

?>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

<?php

mysql_connect("localhost", "root", "");

mysql_select_db("buku");

// MEMBUAT DATA DENGAN FORMAT JSON

// buat inisialisasi variabel dengan tipe data array yang masih kosong

// ambil data dari tabel daftar_buku di database

// kemudian masukkan data-data tersebut ke variabel $data2;

$data2 = array();

$get = mysql_query("SELECT * FROM daftar_buku ORDER BY buku_kode");

while($data = mysql_fetch_array($get)){

$data2[] = $data;

}

//konversi data array tadi menjadi "semua string" dengan format json.

$json_format = json_encode($data2);

echo $json_format;

echo " ";

// MENGOLAH DATA BERFORMAT JSON

// true untuk menjadikannya array

$json_data = json_decode($json_format,true);

for($i=0; $i<count($json_data); $i++){

echo $json_data[$i]['buku_kode']." ";

echo $json_data[$i]['buku_judul']." ";

echo $json_data[$i]['buku_penerbit']." ";

echo $json_data[$i]['buku_tahun']." ";

echo " ";

}

echo " ";

foreach ($json_data as $thedata->buku_kode) {

foreach ($thedata as $value) {

echo $value['buku_kode']." ";

echo $value['buku_judul']." ";

echo $value['buku_penerbit']." ";

echo $value['buku_tahun']." ";

echo " ";

}

?>