FLEX文件 teacherevalute.mxml <?xml version="1.0" encoding="utf-8"?> <mx:Module xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" width="686" height="470" initialize="readXmlFile()" > <mx:Script> <!--[CDATA[ import mx.utils.ObjectProxy; import mx.rpc.events.ResultEvent; import mx.controls.*; import mx.events.*; import mx.controls.SWFLoader; import mx.collections.ArrayCollection; import mx.managers.PopUpManager; import mx.managers.DragManager; private var dragManager:DragManager; private var phpStr:String; [Bindable] private var optFlag:String;//操作标记,如:"query"是查询 private var login_result:String; private var arrayc:ArrayCollection=new ArrayCollection(); private var array:Array=new Array(); private var medalsAC:ArrayCollection = new ArrayCollection(); //读取配置文件 private function readXmlFile():void{ var loader:URLLoader=new URLLoader(new URLRequest("phpsrc/config/config.xml")); loader.addEventListener(Event.COMPLETE,handleCompleted); } private function handleCompleted(event:Event):void { var configXML:XML=XML(event.target.data); phpStr=configXML.phpRootUrl; userRequest.url=phpStr+"teacherevalute.php"; //Alert.show(userRequest.url); userRequest.send(); // ArrayCollectiondate(); //initApp(); } private function resultHandler(event:ResultEvent):void{ try{ chart.dataProvider = new ArrayCollection([{ Country: "非常好", Gold: userRequest.lastResult.dataroot.datalist.first1}, { Country: "好", Gold: userRequest.lastResult.dataroot.datalist.first2}, { Country: "差", Gold: userRequest.lastResult.dataroot.datalist.first3} ]); }catch(e:Error){ login_result="error"; } if(login_result=="error"){ Alert.show("查询失败!"); } } /** * 关闭窗口 */ private function closePanel():void{ PopUpManager.removePopUp(this); } // private var medalsAC:ArrayCollection = new ArrayCollection( [ // { Country: "美国", Gold: 35, Silver:39, Bronze: 29 }, // { Country: "中国", Gold: 32, Silver:17, Bronze: 14 }, // { Country: "俄罗斯", Gold: 27, Silver:27, Bronze: 38 } ]); private function displayGold(data:Object, field:String, index:Number, percentValue:Number):String { var temp:String= (" " + percentValue).substr(0,6); return data.Country + ": " + '/n' + "个数: " + data.Gold + '/n' + temp + "%"; } ]]--> </mx:Script> <!-- Define custom colors for use as pie wedge fills. --> <mx:SolidColor id="sc1" color="blue" alpha=".6"/> <mx:SolidColor id="sc2" color="red" alpha=".6"/> <mx:SolidColor id="sc3" color="0x663300" alpha=".6"/> <!-- This Stroke is used for the callout lines. --> <mx:Stroke id="callouts" weight="2" color="0x999999" alpha=".8" caps="square"/> <!-- This Stroke is used to separate the wedges in the pie. --> <mx:Stroke id="radial" weight="1" color="0xFFFFCC" alpha=".3"/> <!-- This Stroke is used for the outer border of the pie. --> <mx:Stroke id="pieborder" color="0x000000" weight="2" alpha=".5"/> <mx:HTTPService id="userRequest" url="" useProxy="false" method="POST" result="resultHandler(event)" > <mx:request xmlns=""> <optFlag>{optFlag}</optFlag> </mx:request> </mx:HTTPService> <mx:Panel title="课程评价" height="100%" width="100%" layout="absolute" fontSize="15"> <mx:PieChart id="chart" height="373" width="575" paddingRight="5" paddingLeft="5" showDataTips="true" dataProvider="{medalsAC}" fontSize="19" fontWeight="bold" x="35" y="10"> <!-- --> <mx:series> <mx:PieSeries nameField="Country" labelPosition="callout" field="Gold" labelFunction="displayGold" calloutStroke="{callouts}" radialStroke="{radial}" stroke="{pieborder}" fills="{[sc1, sc2, sc3]}" > <!-- Clear the drop shadow filters from the chart. --> <mx:filters> <mx:Array/> </mx:filters> </mx:PieSeries> </mx:series> </mx:PieChart> <mx:Button x="585" y="374" label="返回" click="closePanel()" width="71" height="40" fontSize="18"/> </mx:Panel> </mx:Module> 配置文件: <?xml version="1.0" encoding="utf-8"?> <config> <phpRootUrl>http://192.168.8.108/armyDemo/phpsrc/</phpRootUrl> <pageNumber>20</pageNumber> </config> PHP文件: teacherevalute.php <?php require_once (dirname(_FILE_) . '/dbcon/mysqlconnect.php'); //$optFlag=$_POST[optFlag]; $irt=MysqlConnect(); if($irt==0) { print errorMessage2xml("error"); break; } $SQL1 = "select count(*) as mm1 from tbl_class_evaluate where class_evaluate =/"非常好/";"; $SQL2 = "select count(*) as mm2 from tbl_class_evaluate where class_evaluate ='好';"; $SQL3 = "select count(*) as mm3 from tbl_class_evaluate where class_evaluate ='差';"; $result1 = mysql_resultTo2DAssocArray($SQL1); $result2 = mysql_resultTo2DAssocArray($SQL2); $result3 = mysql_resultTo2DAssocArray($SQL3); $recXml='<dataroot><datalist><first1>'; $recXml.=$result1[0][mm1]; $recXml.='</first1><first2>'; $recXml.=$result2[0][mm2]; $recXml.='</first2><first3>'; $recXml.=$result3[0][mm3]; $recXml.='</first3></datalist></dataroot>'; print $recXml; //print "result1-->".$result1[0][mm1].";".$result2[0][mm2]."<--result3--->".$result3[mm3]; ?>