snipt

Ctrl+h for KB shortcuts

PHP

Simple CSV Generation PHP

#put db connection code here

$sql	= "YOUR SQL HERE";
$res    = mysql_query($sql);

$header = false;
$out    = fopen('php://output', 'w');

while($row = mysql_fetch_assoc($res)) {
                if(!$header) {
                                $header = array_keys($row);
                                fputcsv($out,$header);
                }
                fputcsv($out,$row);
}
                
fclose($out);

$filename = 'something.csv';

header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=".$filename";");
https://snippets.siftie.com/embed/3a464b8e509ccd87c5fbf68cac624880/
/raw/3a464b8e509ccd87c5fbf68cac624880/
3a464b8e509ccd87c5fbf68cac624880
php
PHP
22
2019-04-23T15:52:59
True
False
False
Jun 17, 2013 at 05:24 PM
/api/public/snipt/61339/
simple-csv-generation-php
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a> <a href="#L-20">20</a> <a href="#L-21">21</a> <a href="#L-22">22</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="x">#put db connection code here</span> </span><span id="L-2"><a name="L-2"></a> </span><span id="L-3"><a name="L-3"></a><span class="x">$sql = &quot;YOUR SQL HERE&quot;;</span> </span><span id="L-4"><a name="L-4"></a><span class="x">$res = mysql_query($sql);</span> </span><span id="L-5"><a name="L-5"></a> </span><span id="L-6"><a name="L-6"></a><span class="x">$header = false;</span> </span><span id="L-7"><a name="L-7"></a><span class="x">$out = fopen(&#39;php://output&#39;, &#39;w&#39;);</span> </span><span id="L-8"><a name="L-8"></a> </span><span id="L-9"><a name="L-9"></a><span class="x">while($row = mysql_fetch_assoc($res)) {</span> </span><span id="L-10"><a name="L-10"></a><span class="x"> if(!$header) {</span> </span><span id="L-11"><a name="L-11"></a><span class="x"> $header = array_keys($row);</span> </span><span id="L-12"><a name="L-12"></a><span class="x"> fputcsv($out,$header);</span> </span><span id="L-13"><a name="L-13"></a><span class="x"> }</span> </span><span id="L-14"><a name="L-14"></a><span class="x"> fputcsv($out,$row);</span> </span><span id="L-15"><a name="L-15"></a><span class="x">}</span> </span><span id="L-16"><a name="L-16"></a><span class="x"> </span> </span><span id="L-17"><a name="L-17"></a><span class="x">fclose($out);</span> </span><span id="L-18"><a name="L-18"></a> </span><span id="L-19"><a name="L-19"></a><span class="x">$filename = &#39;something.csv&#39;;</span> </span><span id="L-20"><a name="L-20"></a> </span><span id="L-21"><a name="L-21"></a><span class="x">header(&quot;Content-type: application/octet-stream&quot;);</span> </span><span id="L-22"><a name="L-22"></a><span class="x">header(&quot;Content-Disposition: attachment; filename=&quot;.$filename&quot;;&quot;);</span> </span></pre></div> </td></tr></table>