Forum Moderators: coopster

Message Too Old, No Replies

Exporting PHP output as CSV

PHP,CSV,TXT,Export

         

IndiaMaster

8:01 am on May 18, 2007 (gmt 0)

10+ Year Member



I have tried the following code for generating CSV file from a search result. Its simple please replace the separator to create CSV or Tab Delimitated file (.TXT)

<?php
include("dbconnect.php");
$sDate=$_GET['sdate'];
$eDate=$_GET['edate'];
$phone=$_GET['phone'];
if($phone!="")
$pSql=" and orig_phone='$phone'";
else
$pSql="";
$select = "select * from att_daily where date between '$sDate' and '$eDate'".$pSql." order by date";
$export = mysql_query($select);
echo(mysql_error());
$count = mysql_num_fields($export);
$header="";
$data="";
for ($i = 0; $i < $count; $i++)
{
$header .= mysql_field_name($export, $i).","; //for Tab Delimitated use \t
}
while($row = mysql_fetch_row($export))
{
$line = '';
foreach($row as $value)
{
if ((!isset($value)) OR ($value == ""))
{
$value = ","; //for Tab Delimitated use \t
}
else
{
$value = str_replace('"', '""', $value);
$value = '"' . $value . '"' . ","; //for Tab Delimitated use \t
}
$line .= $value;
}
$data .= trim($line)."\n";
}
$data = str_replace("\r", "", $data);
if ($data == "")
{
$data = "\n(0) Records Found!\n";
}
$fp=fopen("cdr.csv","w");
$content=$header."\n".$data;
fwrite($fp,$content);
fclose($fp);
?>

phparion

9:42 am on May 18, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



why would you take this hassle if you have a pretty handy php built in function

[php.net...]

:)

joelgreen

4:35 pm on May 18, 2007 (gmt 0)

10+ Year Member



Because it only works starting php5 :)

phparion

8:44 am on May 19, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



one other reason to use latest stable php version :)