Generate HTML Table Data To PDF From MySQL Database

Question

Generate HTML Table Data From MySQL Database using pdo query in php

Ravishankar N · Answer

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(); ?>