Chargement d'un fichier XML

**Hesiode** · 11/07/2011, 13h38

Bonjour,

J'ai un bout de code tout simple qui affiche une grid :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>My First Grid</title>
 
<link rel="stylesheet" type="text/css" media="screen" href="css/redmond/jquery-ui-1.8.14.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />
 
<script src="js/jquery.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-en.js" type="text/javascript"></script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>
 
<script type="text/javascript"> 
$(document).ready(function (){
jQuery("#list1").jqGrid({
   	url:'data.php',
	datatype: "xml",
   	colNames:['Inv No','Date', 'Client', 'Amount','Tax','Total','Notes'],
   	colModel:[
   		{name:'id',index:'id', width:75},
   		{name:'invdate',index:'invdate', width:90},
   		{name:'name',index:'name', width:100},
   		{name:'amount',index:'amount', width:80, align:"right"},
   		{name:'tax',index:'tax', width:80, align:"right"},		
   		{name:'total',index:'total', width:80,align:"right"},		
   		{name:'note',index:'note', width:150, sortable:false}		
   	],
   	rowNum:10,
   	autowidth: true,
   	rowList:[10,20,30],
   	pager: jQuery('#pager1'),
   	sortname: 'id',
    viewrecords: true,
    sortorder: "desc",
    caption:"XML Example"
}).navGrid('#pager1',{edit:false,add:false,del:false});
});
</script> 
 
<body>
<table id="list1"></table>
<div id="pager1"></div>
</body>
</html>

avec un fichier de données tout aussi simple :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
<?xml version='1.0' encoding='utf-8'?> 
<rows><page>1</page><total>2</total><records>13</records><userdata name='tamount'>3820.00</userdata><userdata name='ttax'>462.00</userdata><userdata name='ttotal'>4284.00</userdata><row id='13'><cell>13</cell><cell>2007-10-06</cell><cell><![CDATA[Client 3]]></cell><cell>1000.00</cell><cell>0.00</cell><cell>1000.00</cell><cell><![CDATA[]]></cell></row><row id='12'><cell>12</cell><cell>2007-10-06</cell><cell><![CDATA[Client 2]]></cell><cell>700.00</cell><cell>140.00</cell><cell>840.00</cell><cell><![CDATA[]]></cell></row><row id='11'><cell>11</cell><cell>2007-10-06</cell><cell><![CDATA[Client 1]]></cell><cell>600.00</cell><cell>120.00</cell><cell>720.00</cell><cell><![CDATA[]]></cell></row><row id='10'><cell>10</cell><cell>2007-10-06</cell><cell><![CDATA[Client 2]]></cell><cell>100.00</cell><cell>20.00</cell><cell>120.00</cell><cell><![CDATA[]]></cell></row><row id='9'><cell>9</cell><cell>2007-10-06</cell><cell><![CDATA[Client 1]]></cell><cell>200.00</cell><cell>40.00</cell><cell>240.00</cell><cell><![CDATA[]]></cell></row><row id='8'><cell>8</cell><cell>2007-10-06</cell><cell><![CDATA[Client 3]]></cell><cell>200.00</cell><cell>0.00</cell><cell>200.00</cell><cell><![CDATA[]]></cell></row><row id='7'><cell>7</cell><cell>2007-10-05</cell><cell><![CDATA[Client 2]]></cell><cell>120.00</cell><cell>12.00</cell><cell>134.00</cell><cell><![CDATA[]]></cell></row><row id='6'><cell>6</cell><cell>2007-10-05</cell><cell><![CDATA[Client 1]]></cell><cell>50.00</cell><cell>10.00</cell><cell>60.00</cell><cell><![CDATA[]]></cell></row><row id='5'><cell>5</cell><cell>2007-10-05</cell><cell><![CDATA[Client 3]]></cell><cell>100.00</cell><cell>0.00</cell><cell>100.00</cell><cell><![CDATA[no tax at all]]></cell></row><row id='4'><cell>4</cell><cell>2007-10-04</cell><cell><![CDATA[Client 3]]></cell><cell>150.00</cell><cell>0.00</cell><cell>150.00</cell><cell><![CDATA[no tax]]></cell></row></rows>

le probleme vient de cette ligne :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

url:'data.php',

quand je met data.xml cela fonctionne, quand je met data.php ça ne fonctionne plus... Du coup impossible de générer du xml via une requête php.

D'où peut venir le problème ?

Merci

**sekaijin** · 11/07/2011, 13h42

ton xml est correctement généré via ton php ?
le mime type est-il correct ?

A+JYT
PS: il y a un forum JQuery pour les questions JQuery

**Hesiode** · 11/07/2011, 13h51

En fait je viens de me rendre compte qu'en faisant un "echo" du xml cela fonctionne.

Je pensai que sans faire l'echo ça fonctionnait... comme quoi on en apprends tous les jours

**Hesiode** · 11/07/2011, 13h57

Si quelqu'un passe dans le coin j'aimerai bien savoir pourquoi dans mon fichier data.php
cela fonctionne :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
<?php
echo "<?xml version='1.0' encoding='utf-8'?> 
<rows><page>1</page><total>2</total><records>13</records><userdata name='tamount'>3820.00</userdata><userdata name='ttax'>462.00</userdata><userdata name='ttotal'>4284.00</userdata><row id='13'><cell>13</cell><cell>2007-10-06</cell><cell><![CDATA[Client 3]]></cell><cell>1000.00</cell><cell>0.00</cell><cell>1000.00</cell><cell><![CDATA[]]></cell></row><row id='12'><cell>12</cell><cell>2007-10-06</cell><cell><![CDATA[Client 2]]></cell><cell>700.00</cell><cell>140.00</cell><cell>840.00</cell><cell><![CDATA[]]></cell></row><row id='11'><cell>11</cell><cell>2007-10-06</cell><cell><![CDATA[Client 1]]></cell><cell>600.00</cell><cell>120.00</cell><cell>720.00</cell><cell><![CDATA[]]></cell></row><row id='10'><cell>10</cell><cell>2007-10-06</cell><cell><![CDATA[Client 2]]></cell><cell>100.00</cell><cell>20.00</cell><cell>120.00</cell><cell><![CDATA[]]></cell></row><row id='9'><cell>9</cell><cell>2007-10-06</cell><cell><![CDATA[Client 1]]></cell><cell>200.00</cell><cell>40.00</cell><cell>240.00</cell><cell><![CDATA[]]></cell></row><row id='8'><cell>8</cell><cell>2007-10-06</cell><cell><![CDATA[Client 3]]></cell><cell>200.00</cell><cell>0.00</cell><cell>200.00</cell><cell><![CDATA[]]></cell></row><row id='7'><cell>7</cell><cell>2007-10-05</cell><cell><![CDATA[Client 2]]></cell><cell>120.00</cell><cell>12.00</cell><cell>134.00</cell><cell><![CDATA[]]></cell></row><row id='6'><cell>6</cell><cell>2007-10-05</cell><cell><![CDATA[Client 1]]></cell><cell>50.00</cell><cell>10.00</cell><cell>60.00</cell><cell><![CDATA[]]></cell></row><row id='5'><cell>5</cell><cell>2007-10-05</cell><cell><![CDATA[Client 3]]></cell><cell>100.00</cell><cell>0.00</cell><cell>100.00</cell><cell><![CDATA[no tax at all]]></cell></row><row id='4'><cell>4</cell><cell>2007-10-04</cell><cell><![CDATA[Client 3]]></cell><cell>150.00</cell><cell>0.00</cell><cell>150.00</cell><cell><![CDATA[no tax]]></cell></row></rows>
";
?>

et cela ne fonctionne pas :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
<?xml version='1.0' encoding='utf-8'?> 
<rows><page>1</page><total>2</total><records>13</records><userdata name='tamount'>3820.00</userdata><userdata name='ttax'>462.00</userdata><userdata name='ttotal'>4284.00</userdata><row id='13'><cell>13</cell><cell>2007-10-06</cell><cell><![CDATA[Client 3]]></cell><cell>1000.00</cell><cell>0.00</cell><cell>1000.00</cell><cell><![CDATA[]]></cell></row><row id='12'><cell>12</cell><cell>2007-10-06</cell><cell><![CDATA[Client 2]]></cell><cell>700.00</cell><cell>140.00</cell><cell>840.00</cell><cell><![CDATA[]]></cell></row><row id='11'><cell>11</cell><cell>2007-10-06</cell><cell><![CDATA[Client 1]]></cell><cell>600.00</cell><cell>120.00</cell><cell>720.00</cell><cell><![CDATA[]]></cell></row><row id='10'><cell>10</cell><cell>2007-10-06</cell><cell><![CDATA[Client 2]]></cell><cell>100.00</cell><cell>20.00</cell><cell>120.00</cell><cell><![CDATA[]]></cell></row><row id='9'><cell>9</cell><cell>2007-10-06</cell><cell><![CDATA[Client 1]]></cell><cell>200.00</cell><cell>40.00</cell><cell>240.00</cell><cell><![CDATA[]]></cell></row><row id='8'><cell>8</cell><cell>2007-10-06</cell><cell><![CDATA[Client 3]]></cell><cell>200.00</cell><cell>0.00</cell><cell>200.00</cell><cell><![CDATA[]]></cell></row><row id='7'><cell>7</cell><cell>2007-10-05</cell><cell><![CDATA[Client 2]]></cell><cell>120.00</cell><cell>12.00</cell><cell>134.00</cell><cell><![CDATA[]]></cell></row><row id='6'><cell>6</cell><cell>2007-10-05</cell><cell><![CDATA[Client 1]]></cell><cell>50.00</cell><cell>10.00</cell><cell>60.00</cell><cell><![CDATA[]]></cell></row><row id='5'><cell>5</cell><cell>2007-10-05</cell><cell><![CDATA[Client 3]]></cell><cell>100.00</cell><cell>0.00</cell><cell>100.00</cell><cell><![CDATA[no tax at all]]></cell></row><row id='4'><cell>4</cell><cell>2007-10-04</cell><cell><![CDATA[Client 3]]></cell><cell>150.00</cell><cell>0.00</cell><cell>150.00</cell><cell><![CDATA[no tax]]></cell></row></rows>

Merci beaucoup
PS : Je suis sous IIS

**sekaijin** · 11/07/2011, 14h48

parce que php interprète <? comme étant le début d'un instruction php
le parseur php sur <?xml cherche à interprété xml qui est un commande inexistante.

regarde la FAQ et le forum de PHP c'est expliqué

Code xml :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php echo "<?xml version='1.0' encoding='utf-8'?>\n";?>
<rows>
  <page>1</page>
  <total>2</total>
  <records>13</records>
  <userdata name='tamount'>3820.00</userdata>
  <userdata name='ttax'>462.00</userdata>
  <userdata name='ttotal'>4284.00</userdata>
  <row id='13'>
    <cell>13</cell>
    <cell>2007-10-06</cell>
    <cell>
      <![CDATA[Client 3]]></cell>
    <cell>1000.00</cell>
    <cell>0.00</cell>
    <cell>1000.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='12'>
    <cell>12</cell>
    <cell>2007-10-06</cell>
    <cell>
      <![CDATA[Client 2]]></cell>
    <cell>700.00</cell>
    <cell>140.00</cell>
    <cell>840.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='11'>
    <cell>11</cell>
    <cell>2007-10-06</cell>
    <cell>
      <![CDATA[Client 1]]></cell>
    <cell>600.00</cell>
    <cell>120.00</cell>
    <cell>720.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='10'>
    <cell>10</cell>
    <cell>2007-10-06</cell>
    <cell>
      <![CDATA[Client 2]]></cell>
    <cell>100.00</cell>
    <cell>20.00</cell>
    <cell>120.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='9'>
    <cell>9</cell>
    <cell>2007-10-06</cell>
    <cell>
      <![CDATA[Client 1]]></cell>
    <cell>200.00</cell>
    <cell>40.00</cell>
    <cell>240.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='8'>
    <cell>8</cell>
    <cell>2007-10-06</cell>
    <cell>
      <![CDATA[Client 3]]></cell>
    <cell>200.00</cell>
    <cell>0.00</cell>
    <cell>200.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='7'>
    <cell>7</cell>
    <cell>2007-10-05</cell>
    <cell>
      <![CDATA[Client 2]]></cell>
    <cell>120.00</cell>
    <cell>12.00</cell>
    <cell>134.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='6'>
    <cell>6</cell>
    <cell>2007-10-05</cell>
    <cell>
      <![CDATA[Client 1]]></cell>
    <cell>50.00</cell>
    <cell>10.00</cell>
    <cell>60.00</cell>
    <cell>
      <![CDATA[]]></cell>
  </row>
  <row id='5'>
    <cell>5</cell>
    <cell>2007-10-05</cell>
    <cell>
      <![CDATA[Client 3]]></cell>
    <cell>100.00</cell>
    <cell>0.00</cell>
    <cell>100.00</cell>
    <cell>
      <![CDATA[no tax at all]]></cell>
  </row>
  <row id='4'>
    <cell>4</cell>
    <cell>2007-10-04</cell>
    <cell>
      <![CDATA[Client 3]]></cell>
    <cell>150.00</cell>
    <cell>0.00</cell>
    <cell>150.00</cell>
    <cell>
      <![CDATA[no tax]]></cell>
  </row>
</rows>

A+JYT

**Hesiode** · 11/07/2011, 15h19

P**** je suis trop c**.....

Merci beaucoup..

Chargement d'un fichier XML

jQuery

Vue hybride

Discussions similaires

Partager

Partager