| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/ODLDDD_2/FPDF/ |
Upload File : |
<?Php
if(!file_exists('fpdf.php')){
echo " Place fpdf.php file in this directory before using this page. ";
exit;
}
if(!file_exists('font')){
echo " Place font directory in this directory before using this page. ";
exit;
}
require "config.php"; // connection to database
$count="select * from student LIMIT 0,10"; // SQL to get 10 records
require('fpdf.php');
$pdf = new FPDF();
$pdf->AddPage();
$width_cell=array(20,50,40,40,40);
$pdf->SetFont('Arial','B',16);
$pdf->SetFillColor(193,229,252); // Background color of header
// Header starts ///
$pdf->Cell($width_cell[0],10,'ID',1,0,C,true); // First header column
$pdf->Cell($width_cell[1],10,'NAME',1,0,C,true); // Second header column
$pdf->Cell($width_cell[2],10,'CLASS',1,0,C,true); // Third header column
$pdf->Cell($width_cell[3],10,'MARK',1,0,C,true); // Fourth header column
$pdf->Cell($width_cell[4],10,'SEX',1,1,C,true); // Third header column
//// header ends ///////
$pdf->SetFont('Arial','',14);
$pdf->SetFillColor(235,236,236); // Background color of header
$fill=false; // to give alternate background fill color to rows
/// each record is one row ///
foreach ($dbo->query($count) as $row) {
$pdf->Cell($width_cell[0],10,$row['id'],1,0,C,$fill);
$pdf->Cell($width_cell[1],10,$row['name'],1,0,L,$fill);
$pdf->Cell($width_cell[2],10,$row['class'],1,0,C,$fill);
$pdf->Cell($width_cell[3],10,$row['mark'],1,0,C,$fill);
$pdf->Cell($width_cell[4],10,$row['sex'],1,1,C,$fill);
$fill = !$fill; // to give alternate background fill color to rows
}
/// end of records ///
$pdf->Output();
?>