Amfphp与Flex交互:读取mysql数据

服务器端代码,amfphp的services目录下建立readData.php文件,代码如下

<?php
    class ReadDB
    {
              function getData()
             {
                  mysql_connect("localhost","root","root");
                  mysql_select_db("mmmm");
                  mysql_query("SET NAMES UTF8");
                  $sql="select * from mmmm";
                  return mysql_query($sql);
             }
    }
?>

 

flex代码

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" backgroundColor="#FFFFFF">
    <mx:RemoteObject id="myservice" fault="FaultHandler(event)" showBusyCursor="true" source="ReadDB" destination="amfphp">
        <mx:method name="getData" result="ReadHandler(event)" />
    </mx:RemoteObject>

 

<mx:Script>
        <![CDATA[
            import mx.managers.CursorManager;
            import mx.rpc.events.ResultEvent;
            import mx.rpc.events.FaultEvent;
            //注：错误处理函数
            private function FaultHandler(fault:FaultEvent):void
            {
                 //注：删除忙状态光标             
                 CursorManager.removeBusyCursor();
                 //注：返回的错误信息，让其在result_test中显示出来
                 result_text.text = "code:/n" + fault.fault.faultCode + "/n/nMessage:/n" + fault.fault.faultString + "/n/nDetail:/n" + fault.fault.faultDetail;
            }

            private function ResultHandler(evt:ResultEvent):void
            {
                 //注： 将获得的结果转化为String类型，并交给result_text显示出来
                 result_text.text = evt.message.body.toString(); 

            }
           
            private function ReadHandler(evt:ResultEvent):void 
            {
                 dg.dataProvider = evt.result;
            }                
        ]]>
    </mx:Script>

    <mx:TextArea x="10" y="36" width="319" height="113" id="result_text"/>
    <mx:Label x="10" y="10" text="Result:"/> 
    <mx:DataGrid x="337" y="36" width="821" id="dg" height="319">
        <mx:columns>
            <mx:DataGridColumn headerText="lastname" dataField="lastName"/>
            <mx:DataGridColumn headerText="firstname" dataField="firstName"/>
            <mx:DataGridColumn headerText="phone" dataField="phone"/>
            <mx:DataGridColumn headerText="email" dataField="email"/>
        </mx:columns>
    </mx:DataGrid>
    <mx:Button x="1058" y="363" label="view" click="myservice.getOperation('getData').send();" width="100"/>
  
</mx:Application>