Format csv via php

Question

I have the following code, where it generates a csv spreadsheet.

<?php
    require_once ('dbacess.php');
    // output headers so that the file is downloaded rather than displayed
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=data.csv');

    // create a file pointer connected to the output stream
    $output = fopen('php://output', 'w');

    // output the column headings

    // fetch the data

    $rows = sprintf('select * from ivr_contatos, ivr_campanha,ivr_business where ivr_contatos.campanha = ivr_campanha.id and ivr_business.idvisita = ivr_contatos.codigo and ivr_contatos.status = 0 and tentativas >= qtdtentativas');
    $linha = Populator::ConsultaDB($rows);
    // loop over the rows, outputting them
    fputcsv($output,array("CHAMADO","NOME","TELEFONE","TENTATIVA","DATA"));
    while ($resultado = pg_fetch_array($linha) ) {
        $chamado = $resultado['numerochamado'];
        $nome = $resultado['nome'];
        $telefone = $resultado['telefone'];
        $tentativa = $resultado['tentativas'];
        $lastAttempt = $resultado['atualizado'];
        $dataconvertida = date('d/m/Y H:i:s', strtotime($lastAttempt));
        $codigo = $resultado['codigo'];    
        fputcsv($output,array($chamado.";".$nome.";".$telefone.";".$tentativa.";".$dataconvertida));
    }
?>

It is functional, however wanted each data to be in a cell, instead of all being in cell A, there is alternative to this?

Answer 1

Your mistake is here, you’re concreting everything into one string:

fputcsv($output,array($chamado.";".$nome.";".$telefone.";".$tentativa.";".$dataconvertida));

Correct way:

//                     .--- Array de campos
fputcsv($output, array($chamado, $nome, $telefone, $tentativa, $dataconvertida), ';');
//       '--- handle do arquivo                                      separador ---'

The first field is the Handle, the second the array of fields, the third the separator. Do not forget to put the separator in the titles as well.

Handbook:

https://secure.php.net/manual/en/function.fputcsv.php