In this post I will explain you how to generate a simple PDF file from your MySQL database using PHP. For this purpose we will use the popular PHP library FPDF which will enable us to generate the PDF file with the content and ourput format we desire.

Live Demo Download

Step-1: Get the data from MySQL database into the page
Step-1: Download the FPDF library from fpdf.org
Step-2: Copy the fpdf.php file into your application folder
Step-3: Use the fpdf library like so

books.sql

index.php

database.php