<? PHP
class myRecordSet
{
function myRecordSet()
{
// 設定資料庫 //主機位置、使用者、密碼
$link = mysql_connect("localhost","myDBUser","myDBPassword");
mysql_select_db ("MyDBName",$link); //資料庫名稱

$this->methodTable = array(
"getRecords" => array(
"description" => "Returns some records",
"access" => "remote",
)
);
}

// 讀取資料
function getRecords()
{
return mysql_query(sprintf("select myColumn1、myColumn2 from myTable order by myColumn1 asc")); //欄位1,欄位2 // 資料表 // 以欄位1排序
}
}
?>

// remoting 相關
import mx.remoting.Service;
import mx.remoting.PendingCall;
import mx.remoting.RecordSet;
import mx.remoting.debug.NetDebug;
import mx.rpc.RelayResponder;
import mx.rpc.ResultEvent;
import mx.rpc.FaultEvent;
import mx.events.*;

// 開始偵錯
NetDebug.initialize();

// 設定 gateway 和 Responder
var gatewayUrl:String = "http://localhost/flashservices/gateway.php"
Responder = new RelayResponder(this、"handleResult"、"handleError");
_service = new Service(gatewayUrl、null、"labs.myRecordSet.myRecordSet"、null、Responder);

// 傳回資料，並將資料置入資料網格
var pc:PendingCall = _service.getRecords(["myColumn1"、"myColumn2"]); //欄位1,欄位2

datagrid1.columnNames = ["myColumn1"、"myColumn2"]; //欄位1,欄位2
datagrid1.getColumnAt(1).width = 100;
datagrid1.getColumnAt(0).headerText = "欄位1";
datagrid1.getColumnAt(1).headerText = "欄位2";
datagrid1.sortableColumns = false;

// 無誤時傳回正確結果
function handleResult(re:ResultEvent):Void{
var mydata:RecordSet = RecordSet(re.result);
datagrid1.dataProvider = mydata;
}

// 有誤時傳回錯誤報告
function handleError(fe:FaultEvent)
{
trace('Error!');
}

// 重新整理按鈕的設定
button1.clickHandler = function(){
datagrid1.removeAll();
var pc:PendingCall = _service.getRecords(["myColumn1"、"myColumn2"]); //欄位1,欄位2
}