Datatable column limit after changing "sServerMethod": "Get", to "sServerMethod": "POST",
Datatable column limit after changing "sServerMethod": "Get", to "sServerMethod": "POST",
movieguy255
Posts: 1Questions: 1Answers: 0
I am able to get datatables to load with both vertical and horizontal scrolling. Howver after the 12th column the html table loads but thats it. I welcome any suggestioins
<?php
error_reporting(E_ALL);
$serverName = "evvapp004";
$connectionOptions = array("Database"=>"ThermoQualityData");
$conn = sqlsrv_connect( $serverName, $connectionOptions);
$tsql = "SELECT * from MyTable;
```$stmt = sqlsrv_query( $conn, $tsql);
error_reporting(E_ALL);
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="/css/jquery.dataTables.css">
<style type="text/css" class="init">
</style>
<center><img src = "/js/2.png"></center>
<script type="text/javascript" charset="utf8" src="/js/jquery.js"></script>
<script>
$(document).ready(function() {
$('#example').DataTable( {
"scrollY": 200,
"scrollX": true
} );
} );
</script>
</head>
<body>
<table id="example" class="display nowrap" cellspacing="0" width="100%">
<thead>
<tr>
<th>col 1</th>
<th>col 2`</th>
<th>col 3</th>
<th>Col 3</th>
<th>Col 4</th>
<th>Col 5</th>
<th>col 6</th>
<th>col 7</th>
<th>col 8 </th>
<th>col 9</th>
<th>col 10</th>
<th>col 11</th>
<th>col 12/th>
<th>col 13</th>
<th>col 14</th>
```
</thead>
<tbody>
<?php
error_reporting(E_ALL);
while($row = sqlsrv_fetch_array ($stmt )){
?>
``` <tr>
````<td><?=$row['col 1']?></td>
<td><?=$row['col 2']?></td>
<td><?=$row['col 3']?></td>
<td><?=$row['Col 4']?></td>
<td><?=$row['Col 5']?></td>
<td><?=$row['dept']?></td>
<td><?=$row['col 6']?></td>
<td><?=$row['col 7']?></td>
<td><?=$row['col 8']?></td>
<td><?=$row['col 9']?></td>
<td><?=$row['col 10']?></td>
<td><?=$row['col 11']?></td>
<td><?=$row['col 12']?></td>
<td><?=$row['col 13']?></td>
<td><?=$row['col 14']?></td>
```
<?php
error_reporting(E_ALL);
}
?>
</table>
</body>
```</html>