Jquery DataTables server-side avec sql server [Résolu]

[lecimerien]

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"
					} );
			});

Code :

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>

Merci pour votre aide

[SpaceFrog]

php ?
utilise json_encode ...

[Bovino]

JSON : (valide avec JSONLint)

Faut le dire vite... Ton JSON commence par un crochet ([) et fini par une accolade (}), il peut difficilement être valide.

[lecimerien]

Merci pour vos réponses
SpaceFrog : J'utlise bien Php et echo json_encode( $output );pour générer le json.
Bovino : c'est une erreur de copie désolé, le crochet de gauche est en trop.

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"," "]]}

[danielhagnoul]

Bonsoir

Un test rapide ne donne aucune erreur.

Code :

1
2
3
4
5
var json ='{"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"," "]]}';
 
var r = JSON.parse( json );
 
console.log( r );

[lecimerien]

Bonjour,
J'ai fini par trouvé j'avais une erreur dans mon fichier server_processing_mssql.php lors du traitement des variables
$_GET['iDisplayStart'] et $_GET['iDisplayLength'].
Merci

Petite question sinon, si j'ai un accent dans mes données, il remplace la chaine par null.

[SpaceFrog]

utf8 power ...
http://j-willette.developpez.com/tut...-site-en-utf8/

[Alexandrebox]

Tu peux nous dire ce que c'était comme solution dont tu parles ?
Voici ce que j'ai fait mais j'ai toujours la même erreur concernant json

Code :

if ( isset( $_GET['iDisplayStart'] ) && $_GET['iDisplayLength'] != '-1' )

D'avance je vous remercie