how to generate pdf file in php with demo – The FPDF is very awesome PHP class to generate PDF using PHP from MySQL database.
how to generate pdf file in php with demo?
Contents
Let’s generate a simple pdf file, Download the latest zip file from the fpdf official site( click here ).
Generate PDF using PHP from Mysql database
- Step-1: First of all the data from MySQL database into the web page
- Step-2: free Download the open source FPDF library from fpdf.org
- Step-3: Copy the fpdf.php file into your web application directory
- Step-4: Use the fpdf PHP library like therefor
members.sql
-- -- Table structure for table `members` -- CREATE TABLE IF NOT EXISTS `members` ( `name` varchar(255) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- -- Dumping data for table `members` -- INSERT INTO `members` (`name`,`designation`) VALUES ('Ravi Shastri', 'Batsmen'), ('Rohit Sharma', 'Batsmen'), ('Virat Kohali', 'Batsmen'), ('K.L Rahul', ' Batsmen'), ('Mahendrashinh Dhoni', ' Wickekeepr'), ('Sachin Tendulkar', ' Batsment'), ('Virendra Shevag', 'Batsment Opern');
index.php
<?php include('link.php'); $link = new Database(); $result = $link->runQuery("SELECT name,designation FROM members"); $header = $link->runQuery("SELECT UCASE(`COLUMN_NAME`) FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA`='pakainfo_v1' AND `TABLE_NAME`='members' and `COLUMN_NAME` in ('name','designation')"); require('fpdf/fpdf.php'); $pdf = new FPDF(); $pdf->AddPage(); $pdf->SetFont('Arial','B',16); foreach($header as $heading) { foreach($heading as $column_heading) $pdf->Cell(95,12,$column_heading,1); } foreach($result as $row) { $pdf->Ln(); foreach($row as $column) $pdf->Cell(95,12,$column,1); } $pdf->Output(); ?>
link.php
<?php class Database { private $host = "localhost"; private $user = "root"; private $password = "NewPakainfo_v1454"; private $database = "pakainfo_v1"; function runQuery($sql) { $conn = new mysqli($this->host,$this->user,$this->password,$this->database); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $resultset[] = $row; } } $conn->close(); if(!empty($resultset)) return $resultset; } } ?>
Don’t Miss : how to generate pdf file from dynamic data coming from mysql database in php?
I hope you get an idea about how to generate pdf file in php with demo.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, donβt forget to share.
I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I’m a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.