PDF Table by taking data from MySQL or SQLite database

How to create tables in PDF document by using Cell function

In the above tutorial, it is explained how to draw tables. We will use the same concepts to display data with column headers to show the records.

Steps Involved

• Connect to the database
• Run SQL to collect records
• Display the data inside a table and generate a PDF document

You can download the ZIP file containing all the above steps. Inside the ZIP folder, these files are used.

How to connect and collect the records from table

<?Php
require "config.php";//connection to database
$sql="select * from student LIMIT 0,10";

require('fpdf.php');
$pdf = new FPDF(); 
$pdf->AddPage();

$width_cell=array(20,50,40,40,40);
$pdf->SetFont('Arial','B',16);

// Background color of header //
$pdf->SetFillColor(193,229,252);

// Header starts // 
$pdf->Cell($width_cell[0],10,'ID',1,0,'C',true);
$pdf->Cell($width_cell[1],10,'NAME',1,0,'C',true);
$pdf->Cell($width_cell[2],10,'CLASS',1,0,'C',true);
$pdf->Cell($width_cell[3],10,'MARK',1,0,'C',true);
$pdf->Cell($width_cell[4],10,'GENDER',1,1,'C',true);

$pdf->SetFont('Arial','',14);
// Background color of rows //
$pdf->SetFillColor(235,236,236);

$fill=false;

// Each record is one row //
foreach ($dbo->query($sql) 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['gender'],1,1,'C',$fill);
    $fill = !$fill;
}

$pdf->Output();
?>

Download and Install script

• Use the SQL_dump.txt file to create student table in your MySQL database
• Open config.php file to enter your MySQL login details.
• Open index.php file to see the records in your browser ( Not PDF ).
• Open index-pdf.php file to generate PDF document.
• Open index1-pdf.php file to generate PDF document with link to breakup of marks.

Connecting database and executing Query

Enhanced PDF Generation Script: Now Supports SQLite Database

To include SQLite database support, additional files have been added. These allow the script to work with an SQLite database instead of MySQL.

SQLite Integration

• create_table_sqlite.php : This script creates a sample SQLite database file my_student.db in the same location.
• config.php : By updating this file, the script can be switched to use SQLite instead of MySQL.

With these modifications, you can easily run the script using an SQLite database without requiring a MySQL server.

Questions