$(document).ready(function() {
var table = $('#players').dataTable({
initComplete: function () {
this.api().columns().every( function () {
var column = this;
var select = $('')
.appendTo( $(column.footer()).empty() )
.on( 'change', function () {
var val = $.fn.dataTable.util.escapeRegex(
$(this).val()
);
column
.search( val ? '^'+val+'$' : '', true, false )
.draw();
} );
column.data().unique().sort().each( function ( d, j ) {
select.append( '' )
} );
} );
},
dom: 'BRfrtip',
ajax: {
url: "/tables/playerStats.php"
},
scrollY: "640px",
scrollX: true,
scrollCollapse: true,
paging: false,
fixedColumns: {
leftColumns: 2
},
order: [[ 1, "asc" ]],
buttons: [ 'colvis' ],
columns: [
{data: "id", visible: false},
{data: "Player"},
{data: "Position"},
{data: "Species"},
{data: "Height"},
{data: "Weight"},
{data: "Rookie?"},
{data: "Team"},
{data: "Division"},
{data: "Conference"},
{data: "PER"},
{data: "EFF"},
{data: "ORtg"},
{data: "DRtg"},
{data: "FloorP"},
{data: "AST/TO"},
{data: "GP"},
{data: "Min"},
{data: "FGM"},
{data: "FGA"},
{data: "3PM"},
{data: "3PA"},
{data: "FTM"},
{data: "FTA"},
{data: "Off"},
{data: "Reb"},
{data: "Ast"},
{data: "TO"},
{data: "Stl"},
{data: "BS"},
{data: "PF"},
{data: "Pts"},
{data: "FG%"},
{data: "3P%"},
{data: "FT%"},
{data: "MPG"},
{data: "RPG"},
{data: "APG"},
{data: "TPG"},
{data: "SPG"},
{data: "BPG"},
{data: "FPG"},
{data: "PPG"}
]
});
});