Bonjour,
Je souhaite utiliser le plug-in JQuery DataTables, mais j'obtiens le message suivant :
"DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error"
JSON : (valide avec JSONLint)
Code:
1
2
3
4
5
6
7
8
9
10
11 [{"sEcho":1,"iTotalRecords":4411,"iTotalDisplayRecords":4411,"aaData":[ ["MARTIN STEPHANE","DS50610","pantalon HV(ref 3)","44","4","Commande"," "], ["MARTIN STEPHANE","DS50610","blouson de froid (ref 6B)","XL","2","Commande"," "], ["MARTIN STEPHANE","DS50610","T Shirt HV (ref 13)","XL","4","Commande"," "], ["MARTIN STEPHANE","DS50610","Chaussure de securite basse (ref 2\/3)","43","1","Commande"," "], ["MARTIN STEPHANE","DS52411","pantalon HV(ref 3)","44","4","Commande"," "], ["MARTIN STEPHANE","DS52411","T Shirt HV (ref 13)","XL","5","Commande"," "], ["MARTIN STEPHANE","DS52411","Chaussure de securite basse (ref 2\/3)","43","1","Commande"," "], ["MARTIN STEPHANE","DS52411","Chaussure de securite PTFE ( ref 3-1)","43","1","Commande"," "], ["DUPONT ROBERT","DC22811","Combinaison HV(ref 5)","3","1","Commande"," "], ["DUPONT ROBERT","DC22811","Surveste de pluie HV ( ref 6A )","M","1","Commande"," "]]}
Code:
1
2
3
4
5
6
7
8 <script language="javascript"> $(document).ready(function() { $('#tabliste').dataTable( { "bProcessing": true, "bServerSide": true, "sAjaxSource": "server_processing_mssql.php" } ); });
Merci pour votre aideCode:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 <table id="tabliste"class="dataTable" width="100%"> <thead> <tr> <th width="20%">Agent</th> <th width="10%">N°Cde</th> <th width="20%">Désignation Article</th> <th width="5%">Taille</th> <th width="5%">Qté</th> <th width="10%">Etat</th> <th width="30%">Observation</th> </tr> </thead> <tbody> <tr> <td colspan="7" class="dataTables_empty">Loading data from server</td> </tr> </tbody> </table>