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 :
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
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'} ]) });
Sur ma page web, j'ai :
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; }
Mais ma grid ne se remplie pas... Où est mon erreur ?
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]}
Merci de votre aide une fois de plus!
Partager