Üstadım sql servislerini yeniden başlattım, sql modülünden kastını anlamadım kusuruma bakma. Kodlarım da aşağıdaki gibi ;
server_procecssing.php <?php
$table = "Erp_Inventory";
$primaryKey = 'RecId';
$sql_details = array(
'user' => 'sa',
'pass' => 'sqlşifrem',
'db' => 'databaseadım',
'host' => '192.168.1.9'
);
$columns = array(
array('db' => 'RecId', 'dt' => 0),
array('db' => 'InventoryCode', 'dt' => 1),
array('db' => 'InventoryName', 'dt' => 2)
);
require( 'ssp.class.php' );
echo json_encode(
SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
);HTML tarafı ; <!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0">
<title>DataTables - Server-side processing</title>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.24/css/jquery.dataTables.min.css">
</head>
<body class="dt-example">
<div class="container">
<section>
<table id="example" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>RecId</th>
<th>Malzeme Kodu</th>
<th>Malzeme Adı</th>
</tr>
</thead>
<tfoot>
<tr>
<th>RecId</th>
<th>Malzeme Kodu</th>
<th>Malzeme Adı</th>
</tr>
</tfoot>
</table>
</section>
</div>
</body>
<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script type="text/javascript" language="javascript" src="https://cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" language="javascript" class="init">
$(document).ready(function() {
$('#example').dataTable( {
"processing": true,
"serverSide": true,
"ajax": "scripts/server_processing.php"
} );
} );
</script>
</html>
ssp.class.php dosyanı yedekle hocam atacağım linktekiyle değiş:
https://github.com/AndreaUnlimited/dataTablesSQLSRVSSP/blob/master/ssp.class.php