{"id":8736,"date":"2019-07-02T14:47:35","date_gmt":"2019-07-02T14:47:35","guid":{"rendered":"https:\/\/www.webhozz.com\/blog\/?p=8736"},"modified":"2019-07-16T13:24:45","modified_gmt":"2019-07-16T13:24:45","slug":"menampilkan-data-dari-beberapa-table-dengan-php-mysql","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/","title":{"rendered":"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL"},"content":{"rendered":"\n

Pada artikel ini, saya akan sharing bagaimana cara menampilkan data dari beberapa table sekaligus. Hal ini biasanya dibutuhkan ketika ada data yang berelasi pada table yang berbeda untuk lebih melengkapi data yang akan ditampilkan.<\/p>\n\n\n\n

Menampilkan Data Dari Tabel Berelasi Satu-ke-satu<\/h3>\n\n\n
\n\t\n<?php\n$conn = mysql_connect("localhost","root","blah");\nmysql_select_db("test",$conn);\n$sql = "select * from product p inner join buku b on p.id_produk=b.id_produk";\n$result = mysql_query($sql);\n?>\n<table cellpadding="5" cellspacing="0" border="1">\n    <tr>\n        <th>Nama<\/th>\n        <th>Harga<\/th>\n        <th>Penulis<\/th>\n        <th>Penerbit<\/th>\n        <th>ISBN<\/th>\n        <th>Tanggal Terbit<\/th>\n    <\/tr>\n    <?php while($buku = mysql_fetch_array($result)){?>\n    <tr>\n        <td><?php echo $buku['nama'];?><\/td>\n        <td><?php echo $buku['harga'];?><\/td>\n        <td><?php echo $buku['penulis'];?><\/td>\n        <td><?php echo $buku['penerbit'];?><\/td>\n        <td><?php echo $buku['isbn'];?><\/td>\n        <td><?php echo $buku['tgl_terbit'];?><\/td>\n    <\/tr>\n    <?php }?>\n<\/table>\n<\/pre><\/div>\n\n\n
Menampilkan Data dari Tabel Berelasi Satu-ke-banyak<\/h3>\n\n\n
\n<?php\n$conn = mysql_connect("localhost","root","blah");\nmysql_select_db("test",$conn);\n$sql = "select * from album";\n$result = mysql_query($sql);\n?>\n<table cellpadding="5" cellspacing="0" border="1">\n    <tr>\n        <th>Judul<\/th>\n        <th>Artis<\/th>\n    <\/tr>\n    <?php while($album = mysql_fetch_array($result)){?>\n    <tr>\n        <td><?php echo $album['judul'];?><\/td>\n        <td><?php echo $album['artis'];?><\/td>\n    <\/tr>\n    <tr>\n        <td colspan="2">\n        <strong>Lagu: <\/strong>\n        <table cellspacing="0" cellpadding="3">\n            <tr>\n                <td style="border-bottom:1px solid #000;">No Track<\/td>\n                <td style="border-bottom:1px solid #000">Judul<\/td>\n                <td style="border-bottom:1px solid #000">Durasi<\/td>\n            <\/tr>\n            <?php\n            $rowset = mysql_query("select * from lagu where id_album='".$album['id']."'");\n            while($lagu = mysql_fetch_array($rowset)){\n            ?>\n            <tr>\n                <td style="border-bottom:1px solid #000; border-right:1px solid #000"><?php echo $lagu['no_track'];?><\/td>\n                <td style="border-bottom:1px solid #000; border-right:1px solid #000"><?php echo $lagu['judul'];?><\/td>\n                <td style="border-bottom:1px solid #000"><?php echo $lagu['durasi'];?><\/td>\n            <\/tr>\n            <?php }?>\n        <\/table>\n        <\/td>\n    <\/tr>\n    <?php }?>\n<\/table>\n<\/pre><\/div>\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Pada artikel ini, saya akan sharing bagaimana cara menampilkan data dari beberapa table sekaligus. Hal ini biasanya dibutuhkan ketika ada data yang berelasi pada table<\/p>\n","protected":false},"author":1,"featured_media":6286,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[2707,16,35,2700,2701],"class_list":["post-8736","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-belajar-web-programming","tag-belajar-mysql","tag-belajar-php","tag-belajar-web-programming-2","tag-join-table-mysql","tag-menampilkan-data-multitable"],"yoast_head":"\nMenampilkan Data Dari Beberapa Table Dengan PHP MySQL - WebHozz Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Pada artikel ini, saya akan sharing bagaimana cara menampilkan data dari beberapa table sekaligus. Hal ini biasanya dibutuhkan ketika ada data yang berelasi pada table\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-02T14:47:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-16T13:24:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/02\/mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\"},\"headline\":\"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL\",\"datePublished\":\"2019-07-02T14:47:35+00:00\",\"dateModified\":\"2019-07-16T13:24:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/\"},\"wordCount\":54,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/mysql.jpg\",\"keywords\":[\"Belajar MySQL\",\"Belajar PHP\",\"belajar web programming\",\"join table mysql\",\"menampilkan data multitable\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/\",\"name\":\"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/mysql.jpg\",\"datePublished\":\"2019-07-02T14:47:35+00:00\",\"dateModified\":\"2019-07-16T13:24:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/mysql.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/02\\\/mysql.jpg\",\"width\":900,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"name\":\"WebHozz Blog\",\"description\":\"Kursus Web & Android di Jakarta Bandung\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\",\"name\":\"WebHozz\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"width\":442,\"height\":442,\"caption\":\"WebHozz\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL - WebHozz Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL - WebHozz Blog","og_description":"Pada artikel ini, saya akan sharing bagaimana cara menampilkan data dari beberapa table sekaligus. Hal ini biasanya dibutuhkan ketika ada data yang berelasi pada table","og_url":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/","og_site_name":"WebHozz Blog","article_published_time":"2019-07-02T14:47:35+00:00","article_modified_time":"2019-07-16T13:24:45+00:00","og_image":[{"width":900,"height":400,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/02\/mysql.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef"},"headline":"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL","datePublished":"2019-07-02T14:47:35+00:00","dateModified":"2019-07-16T13:24:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/"},"wordCount":54,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/02\/mysql.jpg","keywords":["Belajar MySQL","Belajar PHP","belajar web programming","join table mysql","menampilkan data multitable"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/","url":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/","name":"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/02\/mysql.jpg","datePublished":"2019-07-02T14:47:35+00:00","dateModified":"2019-07-16T13:24:45+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/#primaryimage","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/02\/mysql.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/02\/mysql.jpg","width":900,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/menampilkan-data-dari-beberapa-table-dengan-php-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Menampilkan Data Dari Beberapa Table Dengan PHP MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/blog\/#website","url":"https:\/\/www.webhozz.com\/blog\/","name":"WebHozz Blog","description":"Kursus Web & Android di Jakarta Bandung","publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhozz.com\/blog\/#organization","name":"WebHozz","url":"https:\/\/www.webhozz.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","width":442,"height":442,"caption":"WebHozz"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/8736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=8736"}],"version-history":[{"count":3,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/8736\/revisions"}],"predecessor-version":[{"id":8948,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/8736\/revisions\/8948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media\/6286"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=8736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=8736"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=8736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}