[MySQL] php avec mysql utilisant php myAdmin

bonjour,
j'ai commencé de faire mon premiere panel grid en utilisant le plaguin 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>";
?>

mon 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 peut pas récuperer les données en provenance de la base le grid naffiche rien dans son body qui doit étre contient les enregistrements alors que dans le console de l'outil de développement de mon navigateur chrome 10+ ne signale aucun erreur ,et je pense encore l'erreur n'est pas servenue en provenance de ma grid peut étre dans mon code php . et merci davance