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=mysqli_query($con,"select * from minutes");
8. $rowcount=mysqli_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>Date</td>
16. <td>Time</td>
17. <td>Gateway Ref</td>
18. <td>Gateway IP</td>
19. <td>Gateway Port</td>
20. <td>Staff</td>
21. <td>Min GW</td>
22. <td>USSD</td>
23. <td>Balance</td>
24. <td>Problem</td>
25. <td>Action</td>
26. <td>Comments</td>
27. </tr>
28. </thead>
29. <?php
30.  
31. for($i=1;$i<=$rowcount;$i++)
32. {
33.  
34.         $row=mysqli_fetch_array($query);
35.  
36. ?>
37. <tr>
38. <td><?php echo $row["date"] ?> </td>
39. <td><?php echo $row["time"] ?> </td>
40. <td><?php echo $row["g_ref"] ?></td>
41. <td><?php echo $row["g_ip"] ?></td>
42. <td><?php echo $row["g_port"] ?></td>
43. <td><?php echo $row["staff"] ?></td>
44. <td><?php echo $row["m_gw"] ?></td>
45. <td><?php echo $row["m_ussd"] ?></td>
46. <td><?php echo $row["balance"] ?></td>
47. <td><?php echo $row["problem"] ?></td>
48. <td><?php echo $row["action"] ?></td>
49. <td><?php echo $row["comment"] ?></td>
50. </tr>
51. <?php
52. }
53. ?>
54. </table>
55.  
56. <script>
57. $(document).ready(function() {
58.     $('#example').DataTable({"lengthMenu": [[100, 200, 300, 400], [100, 200, 300, 400]]});
59. } );
60. </script>