Generate HTML Table Data To PDF From MySQL Database

Hi Ankita Solanki,

You can generate HTML Table Data To PDF From MySQL Database like below,

function fetch_data()
{
$output = '';
$conn = mysqli_connect("localhost", "root", "", "tut");
$sql = "SELECT * FROM pdf_export ORDER BY id ASC";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_array($result))
{
$output .= '
'.$row["id"].'
'.$row["name"].'
'.$row["age"].'
'.$row["email"].'
';
}
return $output;
}
if(isset($_POST["generate_pdf"]))
{
require_once('tcpdf/tcpdf.php');
$obj_pdf = new TCPDF('P', PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$obj_pdf->SetCreator(PDF_CREATOR);
$obj_pdf->SetTitle("Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP");
$obj_pdf->SetHeaderData('', '', PDF_HEADER_TITLE, PDF_HEADER_STRING);
$obj_pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$obj_pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
$obj_pdf->SetDefaultMonospacedFont('helvetica');
$obj_pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$obj_pdf->SetMargins(PDF_MARGIN_LEFT, '10', PDF_MARGIN_RIGHT);
$obj_pdf->setPrintHeader(false);
$obj_pdf->setPrintFooter(false);
$obj_pdf->SetAutoPageBreak(TRUE, 10);
$obj_pdf->SetFont('helvetica', '', 11);
$obj_pdf->AddPage();
$content = '';
$content .= '
"center">Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP
"1" cellspacing="0" cellpadding="3">
"5%">Id
"30%">Name
"15%">Age
"50%">Email
';
$content .= fetch_data();
$content .= '';
$obj_pdf->writeHTML($content);
$obj_pdf->Output('file.pdf', 'I');
}
?>
SoftAOX | Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP
"stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
class="container">
"center"> Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP
class="table-responsive">
class="col-md-12" align="right">
"post">
"submit" name="generate_pdf" class="btn btn-success" value="Generate PDF" />

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ravishankar N8y ago
Hi Ankita Solanki,

You can generate HTML Table Data To PDF From MySQL Database like below,
function fetch_data()
{
      $output = '';
      $conn = mysqli_connect("localhost", "root", "", "tut");
      $sql = "SELECT * FROM pdf_export ORDER BY id ASC";
      $result = mysqli_query($conn, $sql);
      while($row = mysqli_fetch_array($result))
      {
      $output .= '
                          '.$row["id"].'
                          '.$row["name"].'
                          '.$row["age"].'
                          '.$row["email"].'

                          ';
      }
      return $output;
}
if(isset($_POST["generate_pdf"]))
{
      require_once('tcpdf/tcpdf.php');
      $obj_pdf = new TCPDF('P', PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
      $obj_pdf->SetCreator(PDF_CREATOR);
      $obj_pdf->SetTitle("Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP");
      $obj_pdf->SetHeaderData('', '', PDF_HEADER_TITLE, PDF_HEADER_STRING);
      $obj_pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
      $obj_pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
      $obj_pdf->SetDefaultMonospacedFont('helvetica');
      $obj_pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
      $obj_pdf->SetMargins(PDF_MARGIN_LEFT, '10', PDF_MARGIN_RIGHT);
      $obj_pdf->setPrintHeader(false);
      $obj_pdf->setPrintFooter(false);
      $obj_pdf->SetAutoPageBreak(TRUE, 10);
      $obj_pdf->SetFont('helvetica', '', 11);
      $obj_pdf->AddPage();
      $content = '';
      $content .= '
      "center">Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP
      "1" cellspacing="0" cellpadding="3">

                "5%">Id
                "30%">Name
                "15%">Age
                "50%">Email

      ';
      $content .= fetch_data();
      $content .= '';
      $obj_pdf->writeHTML($content);
      $obj_pdf->Output('file.pdf', 'I');
}
?>



           SoftAOX | Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP
           "stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />



           class="container">
                "center"> Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP
                class="table-responsive">
                    class="col-md-12" align="right">
                     "post">
                          "submit" name="generate_pdf" class="btn btn-success" value="Generate PDF" />
class="table table-bordered">
"5%">Id
"30%">Name
"15%">Age
"50%">Email
echo fetch_data();
?>