Generate two XLS Files

0

I need to generate two files with different names and data in a PHP page, but the code only generates the second one, it follows a brief excerpt from the code:

// Primeiro Arquivo

       for($i=0;$i<1;$i++){   
        $html[$i] .= "<table>";
        $html[$i] .= "<tr>";
        $html[$i] .= "<td><b>Nome</b></td>";
        $html[$i] .= "<td><b>Email</b></td>";
        $html[$i] .= "<td><b>Status do cliente</b></td>";
        $html[$i] .= "</tr>";
        $html[$i] .= "</table>";
    }

    $i = 1;
    $sql = "SELECT * FROM cadastros";
    $result = $conn->query($sql);
    while($ret = $result->fetch_assoc()) {


        $nome_cad = $ret['nome_cad'];
        $email_cad = $ret['email_cad'];
        $html[$i] .= "<table>";
        $html[$i] .= "<tr>";
        $html[$i] .= "<td>$nome_cad</td>";
        $html[$i] .= "<td>$email_cad</td>";
        $html[$i] .= "<td>Pagseguro</td>";
        $html[$i] .= "</tr>";
        $html[$i] .= "</table>";
        $i++;
    }
    $arquivo = 'dados.xls';
    header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
    header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
    header ("Cache-Control: no-cache, must-revalidate");
    header ("Pragma: no-cache");
    header ("Content-type: application/x-msexcel");
    header ("Content-Disposition: attachment; filename={$arquivo}" );
    header ("Content-Description: PHP Generated Data" );

    for($i=0;$i<=$result->num_rows;$i++){  
        echo $html[$i];
    }


    // Segundo arquivo -------------------------------


    for($ia=0;$ia<1;$ia++){   
        $html[$ia] .= "<table>";
        $html[$ia] .= "<tr>";
        $html[$ia] .= "<td><b>Pessoa</b></td>";
        $html[$ia] .= "<td><b>Data de contato</b></td>";
        $html[$ia] .= "<td><b>Hora contato</b></td>";
        $html[$ia] .= "<td><b>Status do contato</b></td>";
        $html[$ia] .= "<td><b>Detalhe do Contato</b></td>";
        $html[$ia] .= "</tr>";
        $html[$ia] .= "</table>";
    }

    $ia = 1;
    $sql = "SELECT * FROM cadastros WHERE situacao_pagseguro = 'aprovado'";
            $result = $conn->query($sql);
    while($ret = $result->fetch_assoc()) {


        $data_pagseguro = $ret['data_pagseguro'];
        $id_cad = $ret['id_cad'];

        $html[$ia] .= "<table>";
        $html[$ia] .= "<tr>";   
        $html[$ia] .= "<td>$data_pagseguro</td>";
        $html[$ia] .= "<td>$id_cad</td>";   
        $html[$ia] .= "</tr>";
        $html[$ia] .= "</table>";
        $ia++;
    }
    $arquivo = "retorno_pago.xls';
    header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
    header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
    header ("Cache-Control: no-cache, must-revalidate");
    header ("Pragma: no-cache");
    header ("Content-type: application/x-msexcel");
    header ("Content-Disposition: attachment; filename={$arquivo}" );
    header ("Content-Description: PHP Generated Data" );

    for($ia=0;$ia<=$result->num_rows;$ia++){  
        echo $html[$ia];
    }
    
asked by anonymous 08.09.2016 / 23:55

0 answers