PHP: how to do page grouping/ page break in TCPDF from the records coming from SQL group by query

Question

I am trying to do a page grouping/ page break in TCPDF from the recordsets i get from database by grouping by sql statement. Each 'group by' recordsets from database should start from a new page in PDF. I tried looking for the examples given at TCPDF website but they are more static pages and not the dynamic. Is there any way around we can do it?

Thanks in advance

Have you tried anything? Other than looking at examples, what research have you done/ — random_user_name, Jul 31 '18 at 22:49
i tried `$pdf->AddPage();` , `$pdf->AddPage(row($forKey));` `
` and few other conditions. nothing worked — Kunal Parekh, Jul 31 '18 at 22:54

score 0 · Answer 1 · answered Aug 01 '18 at 01:35

It is very easy Sarah.

When you doing the While loop to fetch the recordsets delcare it like:

<?php 

            $pb = 0; //pagebreak counter
            do { 

                if ($pb != $row['yourforiegnkey']){?> 
// make sure you close your tag for php above here
                    <br pagebreak="true"/>
                    <?php // and open your php tag again here, or else it will not go to the next page
                    $pb = $row['yourforiegnkey'];

                }

                else {
                echo $row['yourforiegnkey'] . "<br>";   
                }

?>

Hope this works!!!

PHP: how to do page grouping/ page break in TCPDF from the records coming from SQL group by query

1 Answers1