{"id":5319,"date":"2022-07-01T01:49:36","date_gmt":"2022-06-30T18:49:36","guid":{"rendered":"https:\/\/doc.gm-computindo.com\/?p=5319"},"modified":"2024-09-27T03:08:51","modified_gmt":"2024-09-27T03:08:51","slug":"ekspor-tabel-mysql-ke-excel-di-php","status":"publish","type":"post","link":"https:\/\/gmcomputindo.com\/doc\/ekspor-tabel-mysql-ke-excel-di-php\/","title":{"rendered":"Ekspor Tabel MySQL ke Excel di PHP"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5319\" class=\"elementor elementor-5319\">\n\t\t\t\t<div class=\"elementor-element elementor-element-23b6c35 e-flex e-con-boxed e-con e-parent\" data-id=\"23b6c35\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d953aa9 elementor-widget elementor-widget-text-editor\" data-id=\"d953aa9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span>Kita dapat menggunakan header excel di PHP untuk mengimpor tabel di MySQL ke dalam file excel.\u00a0Kita harus menentukan\u00a0<\/span><code>Content-type<\/code><span>header\u00a0<\/span><code>application\/xls<\/code><span>untuk menyertakan header excel.\u00a0Untuk mengunduh file excel, kita harus menggunakan\u00a0<\/span><code>Content-Disposition<\/code><span>header sebagai\u00a0<\/span><code>attachment<\/code><span>dan memberikan nama file dengan\u00a0<\/span><code>filename<\/code><span>opsi.\u00a0Kami dapat meminta tabel yang diperlukan dalam PHP dan menyimpan hasilnya dalam sebuah variabel.\u00a0Variabel harus berupa tabel HTML yang berisi hasil kueri.\u00a0Kemudian, kita dapat mengirim informasi header ke browser menggunakan\u00a0<\/span><code>header()<\/code><span>fungsi dan mengeluarkan variabel yang berisi tabel menggunakan\u00a0<\/span><code>echo<\/code><span>fungsi tersebut.\u00a0Kami akan memecah langkah-langkah untuk mengekspor tabel MySQL menjadi file excel.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-95b2dfc e-flex e-con-boxed e-con e-parent\" data-id=\"95b2dfc\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-89269db elementor-widget elementor-widget-text-editor\" data-id=\"89269db\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Misalnya, kami memiliki tabel bernama\u00a0<code>users<\/code>dalam database kami.<\/p><pre class=\" language-sql\"><code class=\" language-sql\"><span class=\"token operator\">+<\/span><span class=\"token comment\" spellcheck=\"true\">----+-----------+----------+------------+<\/span>\n<span class=\"token operator\">|<\/span> id <span class=\"token operator\">|<\/span> firstname <span class=\"token operator\">|<\/span> lastname <span class=\"token operator\">|<\/span> dob        <span class=\"token operator\">|<\/span>\n<span class=\"token operator\">+<\/span><span class=\"token comment\" spellcheck=\"true\">----+-----------+----------+------------+<\/span>\n<span class=\"token operator\">|<\/span>  <span class=\"token number\">1<\/span> <span class=\"token operator\">|<\/span> Hasan     <span class=\"token operator\">|<\/span> Ashari   <span class=\"token operator\">|<\/span> <span class=\"token number\">1998<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">08<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">13<\/span> <span class=\"token operator\">|<\/span>\n<span class=\"token operator\">|<\/span>  <span class=\"token number\">2<\/span> <span class=\"token operator\">|<\/span> Siapa     <span class=\"token operator\">|<\/span> Kamu     <span class=\"token operator\">|<\/span> <span class=\"token number\">1970<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">02<\/span><span class=\"token operator\">-<\/span><span class=\"token number\">15<\/span> <span class=\"token operator\">|<\/span>\n<span class=\"token operator\">+<\/span><span class=\"token comment\" spellcheck=\"true\">----+-----------+----------+------------+<\/span>\n<\/code><\/pre><p>Sekarang, kita akan mengekspor tabel ke dalam file excel.\u00a0Pertama, mari kita buat tombol untuk mengekspor tabel ke excel.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-03b8351 e-flex e-con-boxed e-con e-parent\" data-id=\"03b8351\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-588d780 elementor-widget elementor-widget-text-editor\" data-id=\"588d780\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span>Ketika kita mengklik tombol Ekspor, kita akan dapat mengunduh file excel, yang berisi konten database.\u00a0<\/span><span>Dengan cara ini, kita dapat mengekspor tabel MySQL ke dalam file excel di PHP.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Kita dapat menggunakan header excel di PHP untuk mengimpor tabel di MySQL ke dalam file excel.\u00a0Kita harus menentukan\u00a0Content-typeheader\u00a0application\/xlsuntuk menyertakan header excel.\u00a0Untuk mengunduh file excel, kita harus menggunakan\u00a0Content-Dispositionheader sebagai\u00a0attachmentdan memberikan nama&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[16],"tags":[],"class_list":["post-5319","post","type-post","status-publish","format-standard","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/posts\/5319","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/comments?post=5319"}],"version-history":[{"count":1,"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/posts\/5319\/revisions"}],"predecessor-version":[{"id":6657,"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/posts\/5319\/revisions\/6657"}],"wp:attachment":[{"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/media?parent=5319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/categories?post=5319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gmcomputindo.com\/doc\/wp-json\/wp\/v2\/tags?post=5319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}