Breaking News: Grepper is joining You.com. Read the official announcement!

serial number in pdf in html code using php

Enchanting Eel answered on September 30, 2020 Popularity 3/10 Helpfulness 1/10

answer serial number in pdf in html code using php

serial number in pdf in html code using php

Comment

-1

<?php  
 function fetch_data()  
 {  
      $output = '';  
      $conn = mysqli_connect("localhost", "root", "", "f1software"); 

        //$site_cd=$_POST['site_cd'];

      // $sql1 = "SELECT * FROM newsite";  
      // $result1 = mysqli_query($conn, $sql1);  

      $sql = "SELECT site_cd,item_cd,item_name,qty FROM newsite ORDER BY site_cd ASC";  
      $result = mysqli_query($conn, $sql);  
      while($row = mysqli_fetch_array($result))  
      {       
       
      $output .= '<tr>  
                          <td>1</td>  
                          <td>'.$row["site_cd"].'</td>  
                          <td>'.$row["item_cd"].'</td>  
                          <td>'.$row["item_name"].'</td>  
                          <td>'.$row["qty"].'</td>
                     </tr>  
                          ';  
      }  
 
      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("Quantity Availablity Report");  
      $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);  
      // $image = pdf_open_image_file($pdf, "jpeg", "https://www.iconfinder.com/data/icons/social-messaging-ui-color-shapes/128/document-circle-blue-512.png"); pdf_place_image($pdf, $image, 50, 650, 0.25);
      $obj_pdf->Image('https://icon2.cleanpng.com/20180624/qoc/kisspng-computer-icons-desktop-wallpaper-5b2ff7a8c65759.3456430915298702488124.jpg',10,-1,70);
      $obj_pdf->AddPage();  
      $content = '';  
      $content .= '  
      <h4 align="center" >Neelam Construction</h4><br /> 
      <table border="1" cellspacing="0" cellpadding="3">  
           <tr>  
                <th width="10%">Sr. No</th>
                <th  width="22.5%">Site Code</th>  
                <th width="22.5%">Item Code</th>  
                <th width="22.5%">Item Name</th>  
                <th width="22.5%">Total Qunatity</th>
                
           </tr>  
      ';  
      $content .= fetch_data();  
      $content .= '</table>';  
      $obj_pdf->writeHTML($content);  
      $obj_pdf->Output('file.pdf', 'I');  

 }  
 ?>  
 <!DOCTYPE html>  
 <html>  
      <head>  
           <title>SoftAOX | Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP</title>  
           <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />    
          <style type="text/css">
            body
    {
    counter-reset: Serial;           /* Set the Serial counter to 0 */
    }
            tr td:first-child:before
    {
  counter-increment: Serial;      /* Increment the Serial counter */
  content: counter(Serial); /* Display the counter */
    }
          </style>

      </head>  
      <body>  
           <br />
           <div class="container">  
                <h4 align="center" > Generate HTML Table Data To PDF From MySQL Database Using TCPDF In PHP</h4><br />  
                <div class="table-responsive">  
                	<div class="col-md-12" align="right">
                     <form method="post">  
                          <input type="submit" name="generate_pdf" class="btn btn-success" value="Generate PDF" />  
                     </form>  
                     </div>
                     <br/>
                     <br/>
                     <table class="table table-bordered">  
                          <tr>  
                <th width="10%">Sr. No</th>              
                <th width="22.5%">Site Code</th>  
                <th width="22.5%">Item Code</th>  
                <th width="22.5%">Item Name</th>  
                <th width="22.5%">Total Qunatity</th>
                 
                
                          </tr>  
                     <?php  
                     echo fetch_data();  
                     ?>  
                     </table>  
                </div>  
           </div>  
      </body>  
 </html>

Popularity 3/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: html pdf php serial-number using

Link to this answer
Share Copy Link

Contributed on Sep 30 2020

Enchanting Eel

0 Answers Avg Quality 2/10

serial number in pdf in html code using php

Contents

More Related Answers

serial number in pdf in html code using php

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.