{"id":2093,"date":"2017-06-04T07:19:15","date_gmt":"2017-06-04T07:19:15","guid":{"rendered":"http:\/\/www.syedara.com\/?p=2093"},"modified":"2017-06-04T07:19:15","modified_gmt":"2017-06-04T07:19:15","slug":"tutorial-crud-php-kedua","status":"publish","type":"post","link":"https:\/\/www.syedara.com\/?p=2093","title":{"rendered":"Tutorial CRUD PHP Kedua"},"content":{"rendered":"<p>Ketemu lagi dengan saya, sekarang saya akan melanjutkan Tutorial CRUD PHP Kedua.<\/p>\n<p>Pada tahapan ini kita akan menampilkan data dari database atau jika dalam singkatan CRUD maka kali ini adalah R = Read.<\/p>\n<p>Untuk menampilkan data, kita akan membuat sebuah file dengan nama <strong>&#8220;tampildata.php&#8221;<\/strong> dan masukkan ke dalam folder <strong>&#8220;pweb2&#8221;<\/strong> yang berada dalam folder<strong> htdocs<\/strong> kemudian ketikkan script di bawah ini:<\/p>\n<p><span style=\"color: #0000ff;\">&lt;?php<\/span><br \/>\n<span style=\"color: #0000ff;\">include (&#8216;koneksi.php&#8217;);<\/span><br \/>\n<span style=\"color: #0000ff;\">?&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;html&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;body bgcolor=&#8221;yellow&#8221;&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;center&gt;&lt;a href=&#8221;index.php&#8221;&gt;Ke Halaman Index&lt;\/a&gt; | &lt;a href=&#8221;tambahdata.php&#8221;&gt;Ke Halaman Tambah Data&lt;\/a&gt;&lt;\/center&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;br \/&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;center&gt;&lt;table border=&#8221;1&#8243;&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;tr&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;th&gt;NO&lt;\/th&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;th&gt;NIM&lt;\/th&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;th&gt;NAMA&lt;\/th&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;th&gt;JURUSAN&lt;\/th&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;th&gt;NOMOR KENDARAAN&lt;\/th&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;th&gt;OPTION&lt;\/th&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;\/tr&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;?php <\/span><br \/>\n<span style=\"color: #0000ff;\">$result = mysql_query(&#8220;SELECT * FROM datakendaraan&#8221;);<\/span><br \/>\n<span style=\"color: #0000ff;\">while ($dataTampil = mysql_fetch_array($result)) {<\/span><br \/>\n<span style=\"color: #0000ff;\">?&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;tr&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;td&gt;&lt;?php echo $dataTampil[&#8216;siswa_id&#8217;]; ?&gt;&lt;\/td&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;td&gt;&lt;?php echo $dataTampil[&#8216;siswa_nim&#8217;]; ?&gt;&lt;\/td&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;td&gt;&lt;?php echo $dataTampil[&#8216;siswa_nama&#8217;]; ?&gt;&lt;\/td&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;td&gt;&lt;?php echo $dataTampil[&#8216;siswa_jurusan&#8217;]; ?&gt;&lt;\/td&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;td&gt;&lt;?php echo $dataTampil[&#8216;nomor_kendaraan&#8217;]; ?&gt;&lt;\/td&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0&lt;td&gt;&lt;a href=&#8221;editdata.php?id=&lt;?php echo $dataTampil[&#8216;siswa_id&#8217;]; ?&gt;&#8221;&gt;Edit&lt;\/a&gt; | <\/span><br \/>\n<span style=\"color: #0000ff;\">\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0&lt;a href=&#8221;hapus.php?id=&lt;?php echo $dataTampil[&#8216;siswa_id&#8217;]; ?&gt;&#8221;&gt;Hapus&lt;\/a&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;\/tr&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;?php<\/span><br \/>\n<span style=\"color: #0000ff;\">}<\/span><br \/>\n<span style=\"color: #0000ff;\">?&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;\/table&gt;&lt;\/center&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;\/body&gt;<\/span><br \/>\n<span style=\"color: #0000ff;\">&lt;\/html&gt;<\/span><\/p>\n<p>Kemudian simpan.<\/p>\n<p>Selanjutnya untuk melihat hasil sementara, silahkan buka browser dan ketikkan alamat: <strong>http:\/\/localhost\/pweb2\/tampildata.php<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Cukup Sekian tutorial kedua kali ini. Silahkan tunggu tutorial berikutnya. Sampai jumpa.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ketemu lagi dengan saya, sekarang saya akan melanjutkan Tutorial CRUD PHP Kedua. Pada tahapan ini kita akan menampilkan data dari database atau jika dalam singkatan CRUD maka kali ini adalah R = Read. Untuk menampilkan data, kita akan membuat sebuah file dengan nama &#8220;tampildata.php&#8221; dan masukkan ke dalam folder &#8220;pweb2&#8221; yang berada dalam folder htdocs&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2094,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[280],"tags":[641,642,340],"class_list":["post-2093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-crud","tag-mysql","tag-php"],"_links":{"self":[{"href":"https:\/\/www.syedara.com\/index.php?rest_route=\/wp\/v2\/posts\/2093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.syedara.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.syedara.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.syedara.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.syedara.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2093"}],"version-history":[{"count":0,"href":"https:\/\/www.syedara.com\/index.php?rest_route=\/wp\/v2\/posts\/2093\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.syedara.com\/index.php?rest_route=\/wp\/v2\/media\/2094"}],"wp:attachment":[{"href":"https:\/\/www.syedara.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.syedara.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.syedara.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}