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.
try this
implement this code in your code.