Download Data in pdf format using tcpdf

$autoload['libraries'] = array('database', 'table'); $autoload['helper'] = array('url', 'file', 'text', 'form');

Now extract the downloaded library and put it into application/libraries/tcpdf folder. You may delete examples and tools directories from tcpdf directory. These directories are not required.

we will create a new library class that will extend the tcpdf functionality for using into our own application. So create a new file inside application/libraries/Pdf_download.php and create class Pdf that extends TCPDF.

<?php

if(!defined('BASEPATH')) exit('No direct script access allowed');

require_once dirname(__FILE__) . '/tcpdf/tcpdf.php';

class Pdf_download extends TCPDF {
function __construct() {
parent::__construct();
}

//Page header
public function Header() {
// Set font
$this->SetFont('helvetica', 'B', 20);
// Title
$this->Cell(0, 15, 'Sales Information for Products', 0, false, 'C', 0, '', 0, false, 'M', 'M');
}

// Page footer
public function Footer() {
// Position at 15 mm from bottom
$this->SetY(-15);
// Set font
$this->SetFont('helvetica', 'I', 8);
// Page number
$this->Cell(0, 10, 'Page '.$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, false, 'C', 0, '', 0, false, 'T', 'M');
}
}

public function generate_pdf() {
//load pdf library
$this->load->library('Pdf_download');
$pdf = new Pdf_download(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('https://ittutorial.com');
$pdf->SetTitle('Sales Information for Products');
$pdf->SetSubject('Report generated using Codeigniter and TCPDF');
$pdf->SetKeywords('TCPDF, PDF, MySQL, Codeigniter');

// set default header data
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING);

// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));

// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);

// set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);

// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);

// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

// set font
$pdf->SetFont('times', 'BI', 12);

// ---------------------------------------------------------


//Generate HTML table data from MySQL - start
$template = array(
'table_open' => '<table border="1" cellpadding="2" cellspacing="1">'
);

$this->table->set_template($template);

$this->table->set_heading('Id', 'First Name', 'Last Name', 'Email', 'Dob','contactNo');

$salesinfo = $this->Admin_model->get_table_records();

foreach ($salesinfo as $sf):
$this->table->add_row($sf->id, $sf->first_name, $sf->last_name, $sf->email, $sf->dob, $sf->contact_no);
endforeach;

$html = $this->table->generate();
//Generate HTML table data from MySQL - end






// add a page
$pdf->AddPage();

// output the HTML content
$pdf->writeHTML($html, true, false, true, false, '');

// reset pointer to the last page
$pdf->lastPage();

//Close and output PDF document
$pdf->Output(md5(time()).'.pdf', 'D');
}

<a class="pull-right btn btn-primary btn-xs" href="<?php echo base_url()?>admin/export/generate_pdf" ><i class="fa fa-file-excel-o"></i> Download PDF</a>

public function get_table_records()
{
/* $query = $this->db->get('import');
if ($query->num_rows() > 0) {
return $query->result();
}
return NULL;
*/

$this->db->select('*');
$this->db->from('import');
$query = $this->db->get();
$result = $query->result();
return $result;

}