'name', 'dt' => 0 ), array( 'db' => 'mobile', 'dt' => 1 ), array( 'db' => 'city', 'dt' => 2 ), array( 'db' => 'email_address', 'dt' => 3 ), array( 'db' => 'request_date', 'dt' => 4, 'formatter' => function( $d, $row ) { return date( 'm/d/Y h:i:s a', strtotime($d)); } ), array( 'db' => 'gender', 'dt' => 5 ), array( 'db' => 'car', 'dt' => 6 ), array( 'db' => 'source', 'dt' => 7 ) ); // SQL server connection information $sql_details = array( 'user' => 'balubaid_core3_leads', 'pass' => 'Vision@2050', 'db' => 'balubaid_core3_leads', 'host' => 'localhost' ); /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * If you just want to use the basic configuration for DataTables with PHP * server-side, there is no need to edit below this line. */ require( 'ssp.class.php' ); echo json_encode( SSP::complex( $_GET, $sql_details, $table, $primaryKey, $columns,null,$status ) );