Printing only the last result

Question

Printing only the last result

Asked 5 years, 5 months ago

Viewed 40 times

0

I’m putting together a PDF by MPDF, using a HTML. But he has printando only the last result and should printar all, for it is within one foreach. How to make it to print all the result one in each row.

<?php
foreach ($results as $k => $v) {
        $html = '
    <html>
    <head>
    </head>
    <body>
          <table class="flat-table">
          <tr>
            <th>Nosso Numero</th>
            <th>Ocorrencia</th>
            <th>Vlr Boleto</th>
            <th>Matricula</th>
            <th>Nome</th>
            <th>Competencia</th>
            <th>Valor Devido</th>
            </tr>
            <tr>
            <td>'.$v->nosso_numero.'</td>
            <td>'.$v->ocorrencia.'</td>
            <td>'.$v->vlr_boleto.'</td>
            <td>'.$v->matricula.'</td>
            <td>'.$v->nome.'</td>
            <td>'.$v->competencia.'</td>
            <td>'.$v->valor_devido.'</td>
            </tr>
          </table>
    </body>
    </html>
    ';
    }
    $this->mpdf->WriteHTML($html);
    $this->mpdf->Output();

For each foreach element you override the value of $html so it just feels like the last.

– rray

2019/01/21 at 18:12

3 answers

2

First of all your loop is wrong, because it is placing the whole page structure inside the repetition, so you would generate several "pages" in a single.

Then, as done by Marty, one should only repeat the records:

# Gera as tags principais, e o cabeçalho da table
$html = ' <html>
    <head>
    </head>
    <body>
          <table class="flat-table">
          <tr>
            <th>Nosso Numero</th>
            <th>Ocorrencia</th>
            <th>Vlr Boleto</th>
            <th>Matricula</th>
            <th>Nome</th>
            <th>Competencia</th>
            <th>Valor Devido</th>
          </tr>';

# Gera linhas da tabela
foreach ($results as $k => $v) {
        $html .= '
            <tr>
             <td>'.$v->nosso_numero.'</td>
             <td>'.$v->ocorrencia.'</td>
             <td>'.$v->vlr_boleto.'</td>
             <td>'.$v->matricula.'</td>
             <td>'.$v->nome.'</td>
             <td>'.$v->competencia.'</td>
             <td>'.$v->valor_devido.'</td>
            </tr>
    ';
    }

# Fecha a table e as outras tags principais
$html .= '</table>
    </body>
    </html>';

Complementing

You must use .=, to add the data to your variable $html, because if you don’t have the . which means concatenation, you will replace all values, staying only with the last, which in the case of the above example, would be only </table>.

Browser other questions tagged php mpdf

You are not signed in. Login or sign up in order to post.

by Márcio Amaral da Fonseca • **186** points · Answer 1 · 2019-01-21T18:15:05+00:00

Boas, you must concatenate the $html variable in each iteration:

$html = ' <html>
    <head>
    </head>
    <body>
          <table class="flat-table">
          <tr>
            <th>Nosso Numero</th>
            <th>Ocorrencia</th>
            <th>Vlr Boleto</th>
            <th>Matricula</th>
            <th>Nome</th>
            <th>Competencia</th>
            <th>Valor Devido</th>
          </tr>';

foreach ($results as $k => $v) {
        $html .= '
            <tr>
            <td>'.$v->nosso_numero.'</td>
            <td>'.$v->ocorrencia.'</td>
            <td>'.$v->vlr_boleto.'</td>
            <td>'.$v->matricula.'</td>
            <td>'.$v->nome.'</td>
            <td>'.$v->competencia.'</td>
            <td>'.$v->valor_devido.'</td>
            </tr>
    ';
    }

$html .= '</table>
    </body>
    </html>';

by Bulfaitelo • **1,684** points · Answer 2 · 2019-01-21T18:14:24+00:00

There was one detail missing from $html, now she concatenates $html and does not subscribe. with the use of the += will concatenate instead of subscribing.

<?php
$html = "";
foreach ($results as $k => $v) {
        $html+= '
    <html>
    <head>
    </head>
    <body>
          <table class="flat-table">
          <tr>
            <th>Nosso Numero</th>
            <th>Ocorrencia</th>
            <th>Vlr Boleto</th>
            <th>Matricula</th>
            <th>Nome</th>
            <th>Competencia</th>
            <th>Valor Devido</th>
            </tr>
            <tr>
            <td>'.$v->nosso_numero.'</td>
            <td>'.$v->ocorrencia.'</td>
            <td>'.$v->vlr_boleto.'</td>
            <td>'.$v->matricula.'</td>
            <td>'.$v->nome.'</td>
            <td>'.$v->competencia.'</td>
            <td>'.$v->valor_devido.'</td>
            </tr>
          </table>
    </body>
    </html>
    ';
    }
    $this->mpdf->WriteHTML($html);
    $this->mpdf->Output();