Bonjour !

C'est encore moi avec mes stupides problèmes >_<

Cette fois c'est juste que je souhaite remplir ma grid avec des données que je récupère de ma base de données avec PHP.

Mon grid store :
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
 var gridStore = new Ext.data.Store({
        id: 'gridStore',
        proxy: new Ext.data.HttpProxy({
                  url: 'Ecom/model/ActionPlanDAO.php'
              }),
        reader: new Ext.data.JsonReader({
          root: 'results',
          totalProperty: 'total',
          id: 'Action_Id'
        }, [
            // set up the fields mapping into the xml doc
            // The first needs mapping, the others are very basic
            {name: 'Action_Id', mapping: 'Action_Id'},
            {name: 'Metric_Cd'},
            {name: 'Metric_N'},
            {name: 'Metric_Active_Fg'},
            {name: 'Metric_Update_dt'},
            {name: 'Action_Status_N'},
            {name: 'Council_Chair_Id'},
            {name: 'Metric_Id'},
            {name: 'Action_Root_Cause'},
            {name: 'Action_Impact'},
            {name: 'Action_Target_dt'},
            {name: 'Action_Status_Cd'},
            {name: 'Action_Update_dt'},
            {name: 'Action_Comment1'},
            {name: 'Chair_Name'},
            {name: 'Chair_email'},
            {name: 'Comgroupdesc'},
            {name: 'Super_comgroup_Cd'},
            {name: 'Super_comgroupdesc'},
            {name: 'Comgroup'},
            {name: 'Action_Create_dt'}
        ])
    });
Ma partie php (fichier ActionPlanDAO.php) :
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
$response = mysql_query($request) or die(mysql_error());
        $result = $response;
    $nbrows = mysql_num_rows($result);    
    if($nbrows>0){
        while($rec = mysql_fetch_array($result)){
            $arr[] = $rec;
        }
         if (version_compare(PHP_VERSION,"5.2","<")){    
            require_once("./JSON.php"); //if php<5.2 need JSON class
            $json = new Services_JSON();//instantiate new json object
            $jsonresult=$json->encode($arr);  //encode the data in json format
        } else {
            $jsonresult = json_encode($arr);  //encode the data in json format
        }
        echo '{"total":"'.$nbrows.'","results":'.$jsonresult.'}';
    } else {
        echo '{"total":"0", "results":""}';
    }
        return $response;
    }
Sur ma page web, j'ai :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
{"total":"5","results":[{"0":"APT","Metric_Cd":"APT","1":"Average Payment Terms","Metric_N":"Average Payment Terms","2":"1","Metric_Active_Fg":"1","3":"2010-07-16","Metric_Update_dt":"2010-07-16","4":"Opened","Action_Status_N":"Opened","5":"2","Action_Id":"2","6":"7","Council_Chair_Id":"7","7":"1","Metric_Id":
"1","8":"61 days","Action_Root_Cause":"61 days","9":"back to the target 59days","Action_Impact":"back to the target 59days","10":"2010-09-30","Action_Target_dt":"2010-09-30","11":"A1","Action_Status_Cd":"A1","12":null,"Action_Comment1":null,"13":"2010-07-30","Action_Update_dt":"2010-07-30","14":"2010-07-09","
Action_Create_dt":"2010-07-09","15":"Marcel Felix","Chair_Name":"Marcel Felix","16":"b@fr.ibm.com","Chair_email":"b@fr.ibm.com","17":"IT PRODUCTS","Comgroupdesc":"IT PRODUCTS","18":"HDW","Super_comgroup_Cd":"HDW","19":"EQUIPMENT","Super_comgroupdesc":"EQUIPMENT","20":"H2","Comgroup":"H2"},..blabla]}
Mais ma grid ne se remplie pas... Où est mon erreur ?

Merci de votre aide une fois de plus!