{"id":1156,"date":"2019-07-21T10:51:14","date_gmt":"2019-07-21T03:51:14","guid":{"rendered":"https:\/\/www.yellowweb.id\/blog\/?p=1156"},"modified":"2019-07-21T10:51:14","modified_gmt":"2019-07-21T03:51:14","slug":"ekspor-sql-to-csv-php","status":"publish","type":"post","link":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/","title":{"rendered":"Ekspor SQL to CSV – PHP"},"content":{"rendered":"

Ekspor data dari SQL ke CSV menggunakan PHP. Untuk melakukan ekspor file dari SQL ke CSV kali ini dilakukan tanpa menggunakan plugin, artinya hanya membutuhkan perintah Header<\/code> agar browser dapat mengenali file tersebut. Cara ini merupakan alternatif bagi teman-teman yang ingin melakukan ekspor file dengan metode yang cukup sederhana.<\/p>\n

<\/p>\n

Tahap uji coba teman-teman bisa membuat file index.php<\/code>, koneksi.php<\/code>, dan exp.php<\/code><\/p>\n

File index.php<\/code><\/p>\n

<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>SQL to CSV - PHP<\/title>\r\n<\/head>\r\n<body>\r\n\r\n\t<h3>SQL to CSV dengan PHP<\/h3>\r\n\r\n\t<table border=\"1\">\r\n\t\t<thead>\r\n\t\t\t<tr>\r\n\t\t\t\t<th>No<\/th>\r\n\t\t\t\t<th>ID<\/th>\r\n\t\t\t\t<th>Nama<\/th>\r\n\t\t\t\t<th>Email<\/th>\r\n\t\t\t\t<th>Jurusan<\/th>\r\n\t\t\t<\/tr>\r\n\t\t<\/thead>\r\n\t\t<tbody>\r\n\t\t\t<?php\r\n\t\t\t\tinclude \"koneksi.php\";\r\n\r\n\t\t\t\t$no = 1;\r\n\r\n\t\t\t\t$sql = \"SELECT * FROM tbl_pegawai ORDER BY id DESC\";\r\n\t\t\t\t$query = mysqli_query($konek,$sql) or die (mysqli_error($konek));\r\n\t\t\t\t\r\n\t\t\t\twhile($data = mysqli_fetch_array($query)){?>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td><?php echo $no; ?><\/td>\r\n\t\t\t\t\t\t<td><?php echo $data['id'];?><\/td>\r\n\t\t\t\t\t\t<td><?php echo $data['nama'];?><\/td>\r\n\t\t\t\t\t\t<td><?php echo $data['email'];?><\/td>\r\n\t\t\t\t\t\t<td><?php echo $data['jurusan'];?><\/td>\r\n\t\t\t\t\t<\/tr>\r\n\t\t\t\t\t\r\n\t\t\t\t\t<?php $no++; ?>\r\n\r\n\t\t\t\t<?php }\r\n\t\t\t?>\r\n\t\t\t\r\n\t\t<\/tbody>\r\n\t<\/table>\r\n\r\n\t<form action=\"exp.php\" method=\"post\">\r\n\t\t<input type=\"submit\" name=\"export\" value=\"Export\">\r\n\t<\/form>\r\n\r\n<\/body>\r\n<\/html><\/pre>\n
File exp.php<\/code><\/p>\n
<?php\r\n\tinclude \"koneksi.php\";\r\n\r\n\tif(isset($_POST[\"export\"])){\r\n\t\theader('Content-Type: text\/csv; charset=utf-8');\r\n\t\theader('Content-Disposition: attachment; filename=data.csv');\r\n\t\t$output = fopen(\"php:\/\/output\", \"w\");\r\n\t\tfputcsv($output, array('ID','Nama','Email','Jurusan'));\r\n\t\t$sql = \"SELECT * FROM tbl_pegawai\";\r\n\t\t$query = mysqli_query($konek,$sql) or die (mysqli_error($konek));\r\n\t\twhile($data = mysqli_fetch_assoc($query)){\r\n\t\t\tfputcsv($output, $data);\r\n\t\t}\r\n\t\tfclose($output);\r\n\t}\r\n?><\/pre>\n
File koneksi.php<\/code><\/p>\n
<?php\r\n\t$server = \"localhost\";\r\n\t$user = \"root\";\r\n\t$pass = \"\";\r\n\t$database = \"csvku\";\r\n\r\n\t$konek = mysqli_connect($server,$user,$pass,$database) or die (mysqli_error());\r\n\t\r\n?><\/pre>\n
Untuk file koneksi sesuaikan dengan database yang kalian gunakan.<\/p>\n
Demonya bisa teman-teman lihat disini:
\nDEMO<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Ekspor data dari SQL ke CSV menggunakan PHP. Untuk melakukan ekspor file dari SQL ke CSV kali ini dilakukan tanpa menggunakan plugin, artinya hanya membutuhkan perintah Header agar browser dapat mengenali file tersebut. Cara ini merupakan alternatif bagi teman-teman yang ingin melakukan ekspor file dengan metode yang cukup sederhana.<\/p>\n","protected":false},"author":1,"featured_media":1158,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110,17],"tags":[498,309,308,88,222],"class_list":["post-1156","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-tips-n-trik","tag-csv","tag-ekspor","tag-impor","tag-php","tag-sql"],"yoast_head":"\nEkspor SQL to CSV - PHP - YELLOWWEB.ID<\/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.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ekspor SQL to CSV - PHP - YELLOWWEB.ID\" \/>\n<meta property=\"og:description\" content=\"Ekspor data dari SQL ke CSV menggunakan PHP. Untuk melakukan ekspor file dari SQL ke CSV kali ini dilakukan tanpa menggunakan plugin, artinya hanya membutuhkan perintah Header agar browser dapat mengenali file tersebut. Cara ini merupakan alternatif bagi teman-teman yang ingin melakukan ekspor file dengan metode yang cukup sederhana.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/\" \/>\n<meta property=\"og:site_name\" content=\"YELLOWWEB.ID\" \/>\n<meta property=\"article:published_time\" content=\"2019-07-21T03:51:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/07\/sqlto.jpg?fit=600%2C290&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"290\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yellowweb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yellowweb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/\"},\"author\":{\"name\":\"yellowweb\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"headline\":\"Ekspor SQL to CSV – PHP\",\"datePublished\":\"2019-07-21T03:51:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/\"},\"wordCount\":80,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/sqlto.jpg\",\"keywords\":[\"csv\",\"ekspor\",\"impor\",\"php\",\"sql\"],\"articleSection\":[\"PHP\",\"Tips n Trik\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/\",\"name\":\"Ekspor SQL to CSV - PHP - YELLOWWEB.ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/sqlto.jpg\",\"datePublished\":\"2019-07-21T03:51:14+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/sqlto.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/sqlto.jpg\",\"width\":600,\"height\":290,\"caption\":\"sqlto.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/ekspor-sql-to-csv-php\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ekspor SQL to CSV – PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\",\"name\":\"YELLOWWEB.ID\",\"description\":\"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\",\"name\":\"yellowweb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"caption\":\"yellowweb\"},\"sameAs\":[\"https:\\\/\\\/www.yellowweb.id\"],\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/author\\\/yellowweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ekspor SQL to CSV - PHP - YELLOWWEB.ID","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.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/","og_locale":"en_GB","og_type":"article","og_title":"Ekspor SQL to CSV - PHP - YELLOWWEB.ID","og_description":"Ekspor data dari SQL ke CSV menggunakan PHP. Untuk melakukan ekspor file dari SQL ke CSV kali ini dilakukan tanpa menggunakan plugin, artinya hanya membutuhkan perintah Header agar browser dapat mengenali file tersebut. Cara ini merupakan alternatif bagi teman-teman yang ingin melakukan ekspor file dengan metode yang cukup sederhana.","og_url":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/","og_site_name":"YELLOWWEB.ID","article_published_time":"2019-07-21T03:51:14+00:00","og_image":[{"width":600,"height":290,"url":"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/07\/sqlto.jpg?fit=600%2C290&ssl=1","type":"image\/jpeg"}],"author":"yellowweb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yellowweb","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#article","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/"},"author":{"name":"yellowweb","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"headline":"Ekspor SQL to CSV – PHP","datePublished":"2019-07-21T03:51:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/"},"wordCount":80,"commentCount":0,"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/07\/sqlto.jpg","keywords":["csv","ekspor","impor","php","sql"],"articleSection":["PHP","Tips n Trik"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/","url":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/","name":"Ekspor SQL to CSV - PHP - YELLOWWEB.ID","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#primaryimage"},"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/07\/sqlto.jpg","datePublished":"2019-07-21T03:51:14+00:00","author":{"@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"breadcrumb":{"@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#primaryimage","url":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/07\/sqlto.jpg","contentUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/07\/sqlto.jpg","width":600,"height":290,"caption":"sqlto.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yellowweb.id\/blog\/ekspor-sql-to-csv-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yellowweb.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Ekspor SQL to CSV – PHP"}]},{"@type":"WebSite","@id":"https:\/\/www.yellowweb.id\/blog\/#website","url":"https:\/\/www.yellowweb.id\/blog\/","name":"YELLOWWEB.ID","description":"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yellowweb.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829","name":"yellowweb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","caption":"yellowweb"},"sameAs":["https:\/\/www.yellowweb.id"],"url":"https:\/\/www.yellowweb.id\/blog\/author\/yellowweb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/comments?post=1156"}],"version-history":[{"count":3,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1156\/revisions"}],"predecessor-version":[{"id":1160,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1156\/revisions\/1160"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media\/1158"}],"wp:attachment":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media?parent=1156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/categories?post=1156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/tags?post=1156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}