How do I print the page without the datatable

Question

I'm trying to print the data from the sql for record purposes but I'm using datatable so when I try to click print, the record doesn't show everything. It only shows the current data from the page 1 of the datatable. How will I do it? Plus, when I tried printing it, the display also shows the include function of the php. Javascript solutions are allowed. Here is my code

        <?php include ('sidebar.php'); ?>
    <main id="playground">
    <?php include ('header.html'); ?>

    <div class="container-fluid">
      <div class="row">
        <div class="col-md-12">


          <section class="panel panel-info">
            <header class="panel-heading">
              <h4 class="panel-title">List of employees</h4>
            </header>
            <div class="panel-body">

          <?php
            include('configuration.php');
            $sql = "SELECT  firstname, lastname, status, idnumber FROM employees ORDER BY lastname ASC";
            $result = $conn->query($sql);
          ?> 
              <table class="table table-striped datatable" id="datatables" >
                <thead>
                  <tr>
                    <th>Last Name</th>
                    <th>First Name</th>
                    <th>ID Number</th>
                  </tr>
                </thead>



                   <?php
                      if ($result->num_rows > 0) { // output data of each row?>
                       <tbody>
                        <button onclick="myFunction()">Print this page</button>
                           <?php  while($row = $result->fetch_assoc()) {
                              if($row['status']=='p'){
                      ?>

                              <?php {                         //this form will display the set of pending applications

                                      echo'<tr>';
                                      echo '<td>' . $row['lastname'] . '</td>';
                                      echo '<td>' . $row['firstname'] . '</td>';
                                      echo '<td>' . $row['idnumber'] . '</td>';
                                  echo'</tr>';
                                  }
                              ?>

                      <?php    } //if statement
                               } //while statement
                      ?>
                        </tbody>  
                      </table>


                      <?php
                      }else {
                          echo "0 results";
                      }
            ?>



            </div>
          </section>
          <!-- end of STRIPED ROWS TABLE -->

        </div> <!-- / col-md-12 -->
      </div> <!-- / row -->
    </div> <!-- / container-fluid -->


      </main> <!-- /playground -->




        <?php include ('notifications.html'); ?>



        <div class="scroll-top">
          <i class="ti-angle-up"></i>
        </div>
      </div> <!-- /animsition -->


    <script>
    function myFunction() {
        window.print();
    }
    </script>

      </body>
    </html>

possibly duplicate of http://stackoverflow.com/questions/468881/print-div-id-printarea-div-only — Parth Trivedi, Jan 02 '16 at 14:04
Hello! I used myFunction() which calls window.print() if you seen my code :) @ParthTrivedi — Regina, Jan 02 '16 at 14:13
I have read and used the code from the website you have given. These (at symbol) media print { body * { visibility: hidden; } #section-to-print, #section-to-print * { visibility: visible; } #section-to-print { position: absolute; left: 0; top: 0; } } but how do I make my datatable work? Where I can print all the records from the table. @ParthTrivedi — Regina, Jan 02 '16 at 14:20
You can use datatable print button. Please check https://datatables.net/reference/button/print and https://datatables.net/extensions/buttons/examples/print/customisation.html — Parth Trivedi, Jan 02 '16 at 14:27
Great! This is exactly what I was looking for! @ParthTrivedi — Regina, Jan 02 '16 at 14:35
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/99528/discussion-between-parth-trivedi-and-regina). — Parth Trivedi, Jan 02 '16 at 14:38

Parth Trivedi · Accepted Answer · 2016-01-02T14:50:16.073

2

Please use

$('#datatables').DataTable( {
    buttons: [
        'print'
    ]
} );

Please check Document and Reference

edited Jan 02 '16 at 14:50

answered Jan 02 '16 at 14:41

Parth Trivedi

3,802
1
20
40

score 2 · Answer 2 · answered Dec 27 '16 at 08:02

Use Below 2 functions:

function CreateTableFromObject(tblObj) {
    objHeader = JSON.parse(JSON.stringify(tblObj.buttons.exportData()))["header"];
    objRows = JSON.parse(JSON.stringify(tblObj.buttons.exportData()))["body"];

    //Check If Action Exists in Table and remove it
    var index = objHeader.indexOf('Action');
    if (index > -1) {
        objHeader.splice(index, 1);
    }

    tblToPrint = "<table style='border: 1px solid black; border-collapse: collapse;'><thead><tr>";
    $.each(objHeader, function (key, value) {
        tblToPrint += "<th style='border: 1px solid black;'>" + value + "</th>";
    });
    tblToPrint += "</tr></thead><tbody>";
    $.each(objRows, function (key, value) {
        tblToPrint += "<tr>";
        //If action exists then decrease target by 1
        if (index > -1) {
            target = value.length - 1;
        }else {
            target = value.length;
        }
        for (var i = 0; i < target; i++) {
            tblToPrint += "<td style='border: 1px solid black;'>" + value[i] + "</td>";
        }
        tblToPrint += "</tr>";
    });
    tblToPrint += "</tbody></table>";
    return tblToPrint;
}


function PrintWindowAddParts() {
        var tblObj = $("#YourTable").DataTable();
        var tblViewRMA = CreateTableFromObject(tblObj);
        var printContents = "<div class='dataTables_wrapper form-inline dt-bootstrap'>" + tblViewRMA + "</div>";
        var size = 'height=' + $(window).height() + 'px,width=' + $(window).width() + 'px';
        var mywindow = window.open('', 'PRINT', size);
        mywindow.document.write('<html><head><title>' + "My Title" + '</title>');
        mywindow.document.write('</head><body >');
        mywindow.document.write('<h4>' + "My Title" + '</h4>');
        mywindow.document.write(printContents);
        mywindow.document.write('</body></html>');
        mywindow.document.close();
        mywindow.focus();
        mywindow.print();
        mywindow.close();
        return true;
    }

Your Print function is Ready.

How do I print the page without the datatable

2 Answers2