[Plugin] Plugin jQuery jqGrid

Bonjour,

Je suis débutant, j'ai commencé à faire mon premier jqgrid en utilisant le plugin jqGrid et j'ai utilisé xamp. Voici mon code php (example.php) :

Code:

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
 
<?php
 
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
include("dbconfig.php");
$page = $_GET['page'];
$limit = $_GET['rows'];
 $sidx = $_GET['sidx']; 
 $sord = $_GET['sord'];
 if(!$sidx) $sidx =1; 
 $db = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Connection Error: " . mysql_error()); 
 mysql_select_db($database) or die("Error connecting to db."); 
 $result = mysql_query("SELECT COUNT(*) AS count FROM invheader");
  $row = mysql_fetch_array($result,MYSQL_ASSOC); 
 $count = $row['count'];
 if( $count > 0 ) { $total_pages = ceil($count/$limit); } else { $total_pages = 0; }
 if ($page > $total_pages) $page=$total_pages; 
 $start = $limit*$page - $limit; 
 if($start <0) $start = 0;
 $SQL = "SELECT invid, invdate, amount, tax,total, note FROM invheader ORDER BY $sidx $sord LIMIT $start , $limit";
  $result = mysql_query( $SQL ) or die("Couldn't execute query.".mysql_error()); 
 if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") )
  { header("Content-type: application/xhtml+xml;charset=utf-8"); } 
 else { header("Content-type: text/xml;charset=utf-8"); } 
 echo "<?xml version='1.0' encoding='utf-8'?>";
 echo "<rows>";
    echo "<page>".$page."</page>";
    echo "<total>".$total_pages."</total>"; 
    echo "<records>".$count."</records>"; 
  while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { 
   echo "<row id='". $row[invid]."'>";
   echo "<cell>". $row[invid]."</cell>";
   echo "<cell>". $row[invdate]."</cell>";
   echo "<cell>". $row[amount]."</cell>";
   echo "<cell>". $row[tax]."</cell>";
   echo "<cell>". $row[total]."</cell>";
   echo "<cell><![CDATA[". $row[note]."]]></cell>";
   echo "</row>";
   } 
   echo "</rows>";
?>

Ma page index.html :

Code:

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
 
<html>
    <head>
        <title></title>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <link rel="stylesheet" type="text/css" media="screen" href="themes/coffee/grid.css" />
        <link rel="stylesheet" type="text/css" media="screen" href="themes/jqModal.css" />
        <script src="jquery.js" type="text/javascript"></script>
        <script src="jquery.jqGrid.js" type="text/javascript"></script> 
        <script src="js/jqModal.js" type="text/javascript"></script> 
        <script src="js/jqDnR.js" type="text/javascript"></script>
        <script type="text/javascript"> 
            jQuery(document).ready(function(){
                jQuery("#list").jqGrid({
                    url:'example.php',
                    datatype: 'xml',
                    mtype: 'GET',
                    colNames:['Inv No','Date', 'Amount','Tax','Total','Notes'], 
                    colModel :[
                        {name:'invid', index:'invid', width:55},
                        {name:'invdate', index:'invdate', width:90},
                        {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} ],
                    pager: jQuery('#pager'),
                    rowNum:10,
                    rowList:[10,20,30],
                    sortname: 'id',
                    sortorder: "desc",
                    viewrecords: true, 
                    imgpath: 'themes/basic/images',
                    caption: 'My first grid' });
            });
        </script>
    </head>
    <body>
       <table id="list" class="scroll"></table> 
       <div id="pager" class="scroll" style="text-align:center;"></div>
    </body>
</html>

Je ne peux pas récupérer les données en provenance de la base. Le grid n'affiche rien dans son body qui doit contenir les enregistrements alors que dans la console de l'outil de développement de mon navigateur chrome 10+, il ne signale aucune erreur, et je pense encore que l'erreur n'est pas survenue en provenance de ma grid. Ca vient peut-être de mon code php. S'il vous plait, je suis coincée à ce niveau. Est-ce que quelqu'un pourrait m'aider et merci d'avance.