{"id":7924,"date":"2024-09-05T21:37:26","date_gmt":"2024-09-05T18:37:26","guid":{"rendered":"https:\/\/www.karadere.com\/blog\/?p=7924"},"modified":"2024-09-13T17:28:40","modified_gmt":"2024-09-13T14:28:40","slug":"php-ile-excel-export-dizi-ornegi","status":"publish","type":"post","link":"https:\/\/www.karadere.com\/blog\/php-ile-excel-export-dizi-ornegi.html","title":{"rendered":"PHP ile Excel Export Dizi \u00d6rne\u011fi"},"content":{"rendered":"\n<p>Merhabalar PHP ile Excel export i\u015flemine bir \u00f6rnek dizi&#8230;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/w7.pngwing.com\/pngs\/751\/3\/png-transparent-logo-php-html-others-text-trademark-logo-thumbnail.png\" alt=\"\" style=\"width:292px;height:auto\"\/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php \n\n\n  $data = array(\n         '0' => array('Name'=> 'Parvez', 'Status' =>'complete', 'Priority'=>'Low', 'Salary'=>'001'),\n         '1' => array('Name'=> 'Alam', 'Status' =>'inprogress', 'Priority'=>'Low', 'Salary'=>'111'),\n         '2' => array('Name'=> 'Sunnay', 'Status' =>'hold', 'Priority'=>'Low', 'Salary'=>'333'),\n         '3' => array('Name'=> 'Amir', 'Status' =>'pending', 'Priority'=>'Low', 'Salary'=>'444'),\n         '4' => array('Name'=> 'Amir1', 'Status' =>'pending', 'Priority'=>'Low', 'Salary'=>'777'),\n         '5' => array('Name'=> 'Amir2', 'Status' =>'pending', 'Priority'=>'Low', 'Salary'=>'777')\n        );\n        $filename =  time().\".xls\";      \n        header(\"Content-Type: application\/vnd.ms-excel\");\n        header(\"Content-Disposition: attachment; filename=\\\"$filename\\\"\");\n\n        ExportFile($data);\n        function ExportFile($records) {\n            $heading = false;\n                if(!empty($records))\n                  foreach($records as $row) {\n                    if(!$heading) {\n                      \/\/ display field\/column names as a first row\n                      echo implode(\"\\t\", array_keys($row)) . \"\\n\";\n                      $heading = true;\n                    }\n                    echo implode(\"\\t\", array_values($row)) . \"\\n\";\n                }\n            exit;\n        }\n\n        \n?><\/code><\/pre>\n\n\n\n<p>Bu PHP kodu, bir dizi veriyi Excel format\u0131nda indirilebilir hale getiriyor. \u0130\u015flevi, verilen verileri al\u0131p bir .xls dosyas\u0131 olarak d\u0131\u015fa aktarmakt\u0131r. \u015eimdi ad\u0131m ad\u0131m a\u00e7\u0131klayal\u0131m:<\/p>\n\n\n\n<p>Bu k\u0131s\u0131m, her biri &#8220;Name&#8221;, &#8220;Status&#8221;, &#8220;Priority&#8221;, ve &#8220;Salary&#8221; (Maa\u015f) gibi \u00f6zelliklere sahip olan birka\u00e7 ki\u015finin verisini tutan bir dizi olu\u015fturur. Bu dizi daha sonra Excel dosyas\u0131na yaz\u0131lacak.<\/p>\n\n\n\n<p>Bu k\u0131s\u0131m, olu\u015fturulan dosyan\u0131n ad\u0131n\u0131 ve indirilmesini sa\u011flayan HTTP ba\u015fl\u0131klar\u0131n\u0131 tan\u0131mlar:<\/p>\n\n\n\n<p>time() fonksiyonu, o anki Unix zaman damgas\u0131na g\u00f6re bir dosya ad\u0131 \u00fcretir (\u00f6rne\u011fin 1630980000.xls gibi).<br>Content-Type ba\u015fl\u0131\u011f\u0131, bu dosyan\u0131n bir Excel dosyas\u0131 oldu\u011funu belirtir.<br>Content-Disposition ba\u015fl\u0131\u011f\u0131 ise taray\u0131c\u0131ya dosyay\u0131 bir ek dosya olarak indirilmesi gerekti\u011fini s\u00f6yler ve dosya ad\u0131n\u0131 ayarlar.<br>Burada ExportFile() fonksiyonu, verilerin Excel dosyas\u0131na d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesinden sorumludur.<\/p>\n\n\n\n<p>Bu fonksiyonun i\u015fleyi\u015fi \u015fu \u015fekildedir:<\/p>\n\n\n\n<p>E\u011fer veri varsa, her sat\u0131r\u0131 d\u00f6ng\u00fc ile i\u015fler.<br>implode(&#8220;\\t&#8221;, array_keys($row)) ifadesi, ilk sat\u0131rda s\u00fctun adlar\u0131n\u0131 (\u00f6rne\u011fin &#8220;Name&#8221;, &#8220;Status&#8221;, &#8220;Priority&#8221;, &#8220;Salary&#8221;) sekme (\\t) ile ay\u0131rarak yazar.<br>Sonraki sat\u0131rlarda her ki\u015finin verileri sekme ile ayr\u0131larak yazd\u0131r\u0131l\u0131r (\u00f6rne\u011fin Parvez complete Low 001).<br>Her sat\u0131r bitti\u011finde yeni bir sat\u0131r (\\n) eklenir.<br>T\u00fcm veriler i\u015flendi\u011finde, exit; ile fonksiyon sonlan\u0131r ve d\u0131\u015fa aktarma i\u015flemi tamamlan\u0131r.<br>Sonu\u00e7:<br>Bu kod, belirli bir veriyi tablo halinde Excel format\u0131nda d\u0131\u015fa aktarmak i\u00e7in kullan\u0131l\u0131r. Veri, sekme ile ayr\u0131lm\u0131\u015f \u015fekilde yaz\u0131l\u0131r ve taray\u0131c\u0131 bu veriyi .xls format\u0131nda indirilmek \u00fczere haz\u0131rlar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar PHP ile Excel export i\u015flemine bir \u00f6rnek dizi&#8230; Bu PHP kodu, bir dizi veriyi Excel format\u0131nda indirilebilir hale getiriyor. \u0130\u015flevi, verilen verileri al\u0131p bir .xls dosyas\u0131 olarak d\u0131\u015fa aktarmakt\u0131r. \u015eimdi ad\u0131m ad\u0131m a\u00e7\u0131klayal\u0131m: Bu k\u0131s\u0131m, her biri &#8220;Name&#8221;, &#8220;Status&#8221;, &#8220;Priority&#8221;, ve &#8220;Salary&#8221; (Maa\u015f) gibi \u00f6zelliklere sahip olan birka\u00e7 ki\u015finin verisini tutan bir dizi olu\u015fturur. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[1],"tags":[517,968,3323,3120],"class_list":["post-7924","post","type-post","status-publish","format-standard","hentry","category-genel","tag-array","tag-fonksiyon","tag-nassil","tag-php-2","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"aioseo_notices":[],"views":193,"_links":{"self":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/7924","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/comments?post=7924"}],"version-history":[{"count":5,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/7924\/revisions"}],"predecessor-version":[{"id":7932,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/posts\/7924\/revisions\/7932"}],"wp:attachment":[{"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/media?parent=7924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/categories?post=7924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.karadere.com\/blog\/wp-json\/wp\/v2\/tags?post=7924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}