How to create multiple page in dompdf

4.8k Views Asked by rolex At 24 April 2025 at 06:39

I created a dompdf which fetch data from database mysql. But my problem is how i am going to iterate a page if the data of each user will exceed 19 transactions?

<?php
define( 'WP_USE_THEMES', false );
define( 'COOKIE_DOMAIN', false );
define( 'DISABLE_WP_CRON', true );
require('wp-load.php'); 

global $current_user;
get_currentuserinfo();

$d = $current_user->user_login;

// include autoloader
require_once 'dompdf/autoload.inc.php';

// reference the Dompdf namespace
use Dompdf\Dompdf;

// instantiate and use the dompdf class
$dompdf = new Dompdf();

$html = '<html><body>'.
        '<p>Date | Details </p>';

$ff = $wpdb->get_results( "SELECT * FROM table WHERE dd = '$d' ORDER by tdate");
    foreach ( $ff as $jj ) {
     $html = '<p>'.$jj->tdate.' | '.$jj->details.'</p>';
    }

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

$dompdf->loadHtml($html);

// (Optional) Setup the paper size and orientation
$dompdf->setPaper('A4', 'landscape');

// Render the HTML as PDF
$dompdf->render();

// Output the generated PDF to Browser
//$dompdf->stream();

// Output the generated PDF (1 = download and 0 = preview)
$dompdf->stream("codex",array("Attachment"=>0));

For now it works fine for 1 page only but my problem is when the data of each user exceeds 19 to higher transactions it will break the page. I want to set 19 transaction per page.

BTW sample output look like this:

Can anyone here help me?

Thanks.

Original Q&A

There are 1 best solutions below

YUNOOS PARVEZ ANSARI On 03 April 2017 at 06:16

try this

$start = '<html><body>';
$body  = '<p>Date | Details </p>';
$ff = $wpdb->get_results( "SELECT * FROM table WHERE dd = '$d' ORDER by tdate");
    foreach ( $ff as $jj ) {
     $body .= '<p>'.$jj->tdate.' | '.$jj->details.'</p>';
    }
$end= '</body></html>';
$dompdf->loadHtml($start.$body.$body.$end);

implement this code in your code.

How to create multiple page in dompdf

There are 1 best solutions below

Related Questions in PHP

Related Questions in MYSQL

Related Questions in DOMPDF

Trending Questions

Popular # Hahtags

Popular Questions