StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcreate table in pdf with wrap data using fpdf in php
text
Body
copied!<p>I have a problem in creating table structure in pdf using fpdf library. when any data of perticular cell have a long string then the cell data will overlap with other cell data. So whole table data has been disordered. then data in pdf will not seem correctly.</p> <p>any one please help me to create table in pdf auto adjust all cells according to data in cell. </p> <pre><code> <?php if($_POST['cmbReportType'] == '1') { $fromdate = date_format(date_create($_POST['txtFromDate']), 'd-M-y'); $import = ociparse($c, "SELECT t2.membercardno, (t1.firstname||' '||t1.middlename||' '||t1.lastname) as fullname, t3.description, to_char(t2.startdate,'DD-MON-YY') startdate, to_char(t2.expirydate,'DD-MON-YY') expirydate, t2.ramount, t1.address1, t1.address2 FROM useradmin t1, userplan t2, plan t3 WHERE t1.memberid = t2.memberid AND t2.planid = t3.planid AND t1.branchid = 3 AND t2.startdate >= '$fromdate' ORDER BY t2.membercardno"); OCIExecute($import); $k=0; while(OCIFetch($import)) { $a[$k]['membercardno'] = ociresult($import,"MEMBERCARDNO"); $a[$k]['fullname'] = ociresult($import,"FULLNAME"); $a[$k]['description'] = ociresult($import,"DESCRIPTION"); $a[$k]['startdate'] = ociresult($import, "STARTDATE"); $a[$k]['expirydate'] = ociresult($import, "EXPIRYDATE"); $a[$k]['ramount'] = ociresult($import, "RAMOUNT"); $a[$k]['address1'] = ociresult($import, "ADDRESS1"); $a[$k]['address2'] = ociresult($import, "ADDRESS2"); $k++; } $resultcount = count($a); elseif($_POST['rdbReportFormat'] == 'pdf') { /***This report view in tabular format.****/ $pdf=new FPDF(); $pdf->AddPage(); $reportdate = date('d-m-Y'); $filename = $reportdate.'_report.pdf'; $pdf->SetFillColor(255,0,0); $pdf->SetTextColor(255); $pdf->SetDrawColor(128,0,0); $pdf->SetLineWidth(.3); $pdf->SetFont('Arial', 'B', 6); // Header $header=array('Member Card No','Full Name','Description', 'Start Date', 'Expiry Date', 'ramount', 'Address1', 'Address2'); $w = array(25, 35, 35, 15, 18, 15, 30, 30); for($i=0;$i<count($header); $i++) $pdf->Cell($w[$i],7, $header[$i], 1, 0, 'L', true); $pdf->Ln(); // Reset colour set for data $pdf->SetFillColor(224,235,255); $pdf->SetTextColor(0); $pdf->SetFont('courier','',7); $fill=false; for($i=0;$i<$resultcount;$i++) { $height =6; $pdf->Cell($w[0], '$height', $a[$i]['membercardno'], '1', '0', 'L', $fill); $pdf->Cell($w[1], '$height', $a[$i]['fullname'], '1', '0', 'L', $fill); $pdf->Cell($w[2], '$height', $a[$i]['description'], '1', '0', 'L', $fill); $pdf->Cell($w[3], '$height', $a[$i]['startdate'], '1', '0', 'L', $fill); $pdf->Cell($w[4], '$height', $a[$i]['expirydate'], '1', '0', 'L', $fill); $pdf->Cell($w[5], '$height', $a[$i]['ramount'], '1', '0', 'L', $fill); $pdf->Cell($w[5], '$height', $a[$i]['address1'], '1', '0', 'L', $fill); $pdf->Cell($w[5], '$height', $a[$i]['address2'], '1', '0', 'L', $fill); $pdf->Ln(); $fill = !$fill; } $pdf->Cell(array_sum($w),0,'','T'); $pdf->Output($filename, 'I'); } } ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload