Contoh JSON (1) Kesatu
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" } ]} |
Membuat Database
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; |
Isi value / recordnya.
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'); |
Membuat file create_json.php untuk menampilkan data kedalam bentuk json.
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)); } ?> |
Read dan Parsing JSON
Membuat file parsing_json.php untuk menampikan data
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 "<p id='judul'>".$row['headline'] ."</p>"; echo "<p id='isi'>".$row['body'] ."</p>"; echo "<p id='tanggal'>".$row['postdate'] ."</p>"; echo "</div>"; } ?> |
Contoh JSON (2) Kedua
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 "<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/>"; } } ?> |