{"id":11971,"date":"2022-10-04T05:55:01","date_gmt":"2022-10-04T05:55:01","guid":{"rendered":"https:\/\/www.webhozz.com\/blog\/?p=11971"},"modified":"2023-05-11T06:20:41","modified_gmt":"2023-05-11T06:20:41","slug":"export-data-ke-excel-dengan-php-2","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/","title":{"rendered":"Export Data ke Excel dengan PHP"},"content":{"rendered":"\n

Untuk membuat laporan yang akan dikirim ke atasan di kantor, biasanya dalam bentuk Excel agar mudah dipahami. Nah bagaimana jika lamporan diambil dari sebuah aplikasi Web dan datanya berasal dari database ? Maka kita perlu membuat Fitur Export ke Excel pada aplikasi Web kita. Ikuti panduan berikut.<\/p>\n\n\n\n

Buatlah 1 buah file index.php, yang berisi Table Data dan Button Export<\/p>\n\n\n\n

index.php<\/strong><\/p>\n\n\n

\n<!DOCTYPE html>\n<html>\n<head>\n    <title>Export Data Ke Excel <\/title>\n<\/head>\n<body>\n     \n     \n    <a target="_blank" href="export_excel.php">EXPORT KE EXCEL<\/a>\n \n    <table>\n        <tr>\n            <th>No<\/th>\n            <th>Nama<\/th>\n            <th>Alamat<\/th>\n            <th>Telp<\/th>\n        <\/tr>\n        <?php \n        \/\/ koneksi database\n        $koneksi = mysqli_connect("localhost","root","","dbpegawai");\n \n        \/\/ menampilkan data pegawai\n        $data = mysqli_query($koneksi,"select * from pegawai");\n        $no = 1;\n        while($x = mysqli_fetch_array($data)){\n        ?>\n        <tr>\n            <td><?php echo $no++; ?><\/td>\n            <td><?php echo $x['nama']; ?><\/td>\n            <td><?php echo $x['alamat']; ?><\/td>\n            <td><?php echo $x['telepon']; ?><\/td>\n        <\/tr>\n        <?php \n        }\n        ?>\n    <\/table>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Lalu buat file export_excel.php<\/strong><\/p>\n\n\n
\n<?php\nheader("Content-type: application\/vnd-ms-excel");\nheader("Content-Disposition: attachment; filename=Data Pegawai.xls");\n?>\n \n<!DOCTYPE html>\n<html>\n<head>\n    <title>Export Data Ke Excel <\/title>\n<\/head>\n<body>\n     \n     \n    <table>\n        <tr>\n            <th>No<\/th>\n            <th>Nama<\/th>\n            <th>Alamat<\/th>\n            <th>No.Telp<\/th>\n        <\/tr>\n        <?php \n        \/\/ koneksi database\n        $koneksi = mysqli_connect("localhost","root","","pegawai");\n \n        \/\/ menampilkan data pegawai\n        $data = mysqli_query($koneksi,"select * from data_pegawai");\n        $no = 1;\n        while($d = mysqli_fetch_array($data)){\n        ?>\n        <tr>\n            <td><?php echo $no++; ?><\/td>\n            <td><?php echo $d['nama']; ?><\/td>\n            <td><?php echo $d['alamat']; ?><\/td>\n            <td><?php echo $d['telepon']; ?><\/td>\n        <\/tr>\n        <?php \n        }\n        ?>\n    <\/table>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Happy Koding dan Salam WebHozz 🙂<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Untuk membuat laporan yang akan dikirim ke atasan di kantor, biasanya dalam bentuk Excel agar mudah dipahami. Nah bagaimana jika lamporan diambil dari sebuah aplikasi<\/p>\n","protected":false},"author":1,"featured_media":11872,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[3339,3341,3343,3342,3340,3338],"class_list":["post-11971","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-belajar-web-programming","tag-belajar-php-export-data-ke-excel","tag-belajar-php-export-data-ke-excel-pemula","tag-kursus-php-export-data-ke-excel-bandung","tag-kursus-php-export-data-ke-excel-jakarta","tag-tutorial-php-export-data-ke-excel","tag-tutorial-php-export-data-ke-excel-pemula"],"yoast_head":"\nExport Data ke Excel dengan PHP - 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\/export-data-ke-excel-dengan-php-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export Data ke Excel dengan PHP - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Untuk membuat laporan yang akan dikirim ke atasan di kantor, biasanya dalam bentuk Excel agar mudah dipahami. Nah bagaimana jika lamporan diambil dari sebuah aplikasi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-04T05:55:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-11T06:20:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2022\/09\/PHP_1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\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\\\/export-data-ke-excel-dengan-php-2\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\"},\"headline\":\"Export Data ke Excel dengan PHP\",\"datePublished\":\"2022-10-04T05:55:01+00:00\",\"dateModified\":\"2023-05-11T06:20:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/\"},\"wordCount\":80,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/PHP_1.jpg\",\"keywords\":[\"Belajar PHP Export Data ke Excel\",\"Belajar PHP Export Data ke Excel Pemula\",\"Kursus PHP Export Data ke Excel Bandung\",\"Kursus PHP Export Data ke Excel Jakarta\",\"Tutorial PHP Export Data ke Excel\",\"Tutorial PHP Export Data ke Excel Pemula\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/\",\"name\":\"Export Data ke Excel dengan PHP - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/PHP_1.jpg\",\"datePublished\":\"2022-10-04T05:55:01+00:00\",\"dateModified\":\"2023-05-11T06:20:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/PHP_1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/PHP_1.jpg\",\"width\":\"750\",\"height\":\"400\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/export-data-ke-excel-dengan-php-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export Data ke Excel dengan PHP\"}]},{\"@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":"Export Data ke Excel dengan PHP - 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\/export-data-ke-excel-dengan-php-2\/","og_locale":"en_US","og_type":"article","og_title":"Export Data ke Excel dengan PHP - WebHozz Blog","og_description":"Untuk membuat laporan yang akan dikirim ke atasan di kantor, biasanya dalam bentuk Excel agar mudah dipahami. Nah bagaimana jika lamporan diambil dari sebuah aplikasi","og_url":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/","og_site_name":"WebHozz Blog","article_published_time":"2022-10-04T05:55:01+00:00","article_modified_time":"2023-05-11T06:20:41+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2022\/09\/PHP_1.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\/export-data-ke-excel-dengan-php-2\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef"},"headline":"Export Data ke Excel dengan PHP","datePublished":"2022-10-04T05:55:01+00:00","dateModified":"2023-05-11T06:20:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/"},"wordCount":80,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2022\/09\/PHP_1.jpg","keywords":["Belajar PHP Export Data ke Excel","Belajar PHP Export Data ke Excel Pemula","Kursus PHP Export Data ke Excel Bandung","Kursus PHP Export Data ke Excel Jakarta","Tutorial PHP Export Data ke Excel","Tutorial PHP Export Data ke Excel Pemula"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/","url":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/","name":"Export Data ke Excel dengan PHP - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2022\/09\/PHP_1.jpg","datePublished":"2022-10-04T05:55:01+00:00","dateModified":"2023-05-11T06:20:41+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/#primaryimage","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2022\/09\/PHP_1.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2022\/09\/PHP_1.jpg","width":"750","height":"400"},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/export-data-ke-excel-dengan-php-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Export Data ke Excel dengan PHP"}]},{"@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\/11971","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=11971"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/11971\/revisions"}],"predecessor-version":[{"id":12700,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/11971\/revisions\/12700"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media\/11872"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=11971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=11971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=11971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}