<div class="tab-inn">
   <div class="table-responsive table-desi">
       <table class="table table-hover">
           <thead>
              <tr>
                  <th>ID</th>
                  <th>Part Number</th>
                  <th>Bid</th>
                  <th>Model</th>
              </tr>
          </thead>
          <tbody>

           <?php while ($row = mysql_fetch_array($r_query)){ ?>
               <tr>
                 <td><?php echo $row['id']; ?></td>
                 <td><?php echo $row['partnumber']; ?></td>
                 <td><?php echo $row['bid']; ?></td>
                 <td><?php echo $row['model']; ?></td>
               </tr>
            <?php   } ?>
      </table>
   </div>
</div>
<script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" type="text/css" href="http://cdn.datatables.net/1.10.12/css/jquery.dataTables.min.css" />
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css" />

<script>
   $(document).ready(function (){
       var table = $('table').DataTable({
            dom: 'Bfrtip',
            buttons: ['copy', 'csv', 'excel', 'pdf', 'print','pageLength']
   });

   $('#mySearch').on('keyup redraw', function() {
        var searchString = '(' + $('#mySearch').val().split(' ').join('|') + ')';

        table.search(searchString, true).draw(true);
   });

</script>