Export the result into a CSV 1

[aas1611]

Suppose I already have the following result appeared on my page:

No Account Note
1 11 A
2 22 B
3 33 C
4 44 D

Then, I want to export this to a txt file with CSV format, so it would appear like the following in the file:
1,11,A
2,22,B
3,33,C
4,44,D

How to do this?

 

[Chacalinc]

what's about the fwrite function?

Chacal, Inc.

 

[aas1611]

Can you explain a little more about this functon?

I've read the explanation and the sample codes, but it still doesn't do what I want it to do or I still don't get it quite right.

The query result already appears on my webpage. Then I want to send (export) this result to a txt file with CSV format.

Help? or any other solution?

 

[kenrbnsn]

Can we see your code? It's hard to tell you what you are doing incorrectly without it.

Ken

 

[Chacalinc]

take a look to this thread:

thread434-1099479

http://www.tek-tips.com/viewthread.cfm?qid=1099479&page=5

Chacal, Inc.

 

[aas1611]

## Here is my code that gives result to my webpage. I haven't done anything to export it to a txt file.

<?

include 'header.htm';
include 'db_connection.php';

$query = "SELECT sperrgrund, blz, kontonr, beschreibung FROM sperr001";
$result = mysql_query($query);
$num = mysql_numrows($result);


?>

<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Sperrgrund</font></th>
<th><font face="Arial, Helvetica, sans-serif">Bankleitzahl</font></th>
<th><font face="Arial, Helvetica, sans-serif">Kontonummer</font></th>
<th><font face="Arial, Helvetica, sans-serif">Beschreibung</font></th>
</tr>

<?

$i = 0;

while($i < $num) {
$sperrgrund = mysql_result($result,$i,"sperrgrund");
$blz = mysql_result($result,$i,"blz");
$kontonr = mysql_result($result,$i,"kontonr");
$beschreibung = mysql_result($result,$i,"beschreibung");

?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><? echo $sperrgrund; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $blz; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $kontonr; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo $beschreibung; ?></font></td>
</tr>
<?
$i++;
}

echo "</table>";

mysql_close($conn);

?>

 

[Chacalinc]

pls, see my previous post. (too look at
thread434-1099479

http://www.tek-tips.com/viewthread.cfm?qid=1099479&amp;page=5

)

Chacal, Inc.

 

[kenrbnsn]

Thanks for posting your code, now we can make some progress. I'm also going to modify your code to make it shorter.

<?

include 'header.htm';
include 'db_connection.php';

// open output file
$fp = fopen('test.csv','w');

$query = "SELECT sperrgrund, blz, kontonr, beschreibung FROM sperr001";
$result = mysql_query($query);
// the following line is not needed anymore
// $num = mysql_numrows($result);


?>

<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Sperrgrund</font></th>
<th><font face="Arial, Helvetica, sans-serif">Bankleitzahl</font></th>
<th><font face="Arial, Helvetica, sans-serif">Kontonummer</font></th>
<th><font face="Arial, Helvetica, sans-serif">Beschreibung</font></th>
</tr>

<?
// the following line is not needed anymore
// $i = 0;

while($rw = mysql_fetch_assoc($result)) {
// don't need the following four lines if you use the above method of getting each row
//    $sperrgrund = mysql_result($result,$i,"sperrgrund");
//    $blz = mysql_result($result,$i,"blz");
//    $kontonr = mysql_result($result,$i,"kontonr");
//    $beschreibung = mysql_result($result,$i,"beschreibung");
//
// write each row to file with values seperated with commas
//
   fwrite($fp, implode(',',$rw)."\n");
?>
    <tr>
    <td><font face="Arial, Helvetica, sans-serif"><? echo $rw['sperrgrund']; ?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><? echo $rw['blz']; ?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><? echo $rw['kontonr']; ?></font></td>
    <td><font face="Arial, Helvetica, sans-serif"><? echo $rw['beschreibung; ?></font></td>
    </tr>']
<?
//    $i++;    
}

echo "</table>";

mysql_close($conn);
//
//  close file
//
    fclose($fp);
?>

Using mysql_fetch_assoc() will put each row into an associative array. I use implode() to write each row with the values seperated with commas.

Ken

 

[aas1611]

It works, wonderful!! THANKS!!

Now let's say a user want to export this to her local computer. How can she choose her own directory? Should there be an input form and/or function ? How would it be?

 

[Chacalinc]

again, follow the thread I posted you... in that post you gonna see how to make the file get downloaded.

Cheers.

Chacal, Inc.

 

[aas1611]

Alrighty, I will give it a look.

Thank you both for your help!!