具有fputcsv和循环功能的CSV生成器

Question

How should I use tabulate?

$naglowek = "ID,\t Imię,\t Nazwisko,\t Data urodzenia,\t Miasto,\t EMAIL";
$naglowek = explode(";",$naglowek); // header
fputcsv($fp, $naglowek); 
while($r = $result->fetch_assoc()){
    $ciag = '';
    $ciag =  $r['id'].','.$r['name'].','.$r['surName'].','.$r['dateOfBirth'].','.$r['city'].','.$r['email'];
    $ciag = explode(";",$ciag);
    fputcsv($fp, $ciag,"\t");
}

I added "\t" but it isn't working.

Below is question, what somebody answered.
I made a CSV generator for my client. It should get data from DB (mysqli). The code is :

while($r = $result->fetch_assoc()){
  $someVariable = $r['id'].','.$r['name'].','.$r['surName'].','.$r['dateOfBirth'].','.
  $r['city'].','.$r['email'];
}

It is working. But I go to next step to use a function fputcsv. It is from PHP5. This is how my DB looks: In PHPManual fputcsv is using like:

$list = array (
    array('aaa', 'bbb', 'ccc', 'dddd'),
    array('123', '456', '789'),
    array('"aaa"', '"bbb"')
);

How can I use my data to this array ? My data will be from DataBase and will be generated dynamically by the loop above.

Answer 1

You can do that in this way:

$fp = fopen('out.csv', 'w');

while($r = $result->fetch_assoc()){
    fputcsv($fp, $r);
}

fclose($fp);

For each line that fetch from the database, it will include in out.csv file.