1. <script src="https://code.jquery.com/jquery-3.3.1.js"></script>
2. <script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
3. <link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css">
4. <?php
5.  
6. include("includes/db.php");
7. $query=mysql_query("select * from vouchers");
8. $rowcount=mysql_num_rows($query);
9.  
10. ?>
11.  
12. <table border="1" align="center" id="example" class="display" style="width:100%">
13. <thead>
14. <tr>
15. <td>Lot #</td>
16. <td>Date</td>
17. <td>Operator</td>
18. <td>Item Name</td>
19. <td>I Voucher#</td>
20. <td>Voucher Value</td>
21. <td>Voucher #</td>
22. <td>Gateway Ref</td>
23. <td>Gateway IP</td>
24. <td>Gateway Port</td>
25. </tr>
26. </thead>
27. <?php
28.  
29. $sum=0;
30. for($i=1;$i<=$rowcount;$i++)
31. {
32.  
33.         $row=mysql_fetch_array($query);
34.         $sum += $row["v_value"];
35.  
36.  
37. ?>
38. <tr>
39. <td><?php echo $row["lot"] ?> </td>
40. <td><?php echo $row["date"] ?></td>
41. <td><?php echo $row["operator"] ?></td>
42. <td><?php echo $row["i_name"] ?></td>
43. <td><?php echo $row["i_v_no"] ?></td>
44. <td><?php echo $row["v_value"] ?></td>
45. <td><?php echo $row["v_no"] ?></td>
46. <td><?php echo $row["g_ref"] ?></td>
47. <td><?php echo $row["g_ip"] ?></td>
48. <td><?php echo $row["g_port"] ?></td>
49. </tr>
50. <?php
51. }
52. ?>
53. <tr>
54. <td></td>
55. <td></td>
56. <td></td>
57. <td></td>
58. <td></td>
59. <td><?php echo $sum; ?></td>
60. </tr>
61. </table>
62.  
63. <script>
64. $(document).ready(function() {
65.     $('#example').DataTable();
66. } );
67. </script>