<?php
//Basic Config
error_reporting(E_ALL | E_STRICT);  //設定Error Report的等級
date_default_timezone_set('Asia/Taipei');  //設定時區為台北
//Include path
//比較需要注意的是這邊新增了一個 library 的 PATH 路徑，用來供 ZFAMF 的資料互相存取
define ('P_S', PATH_SEPARATOR);
set_include_path('.' .P_S .'library' .P_S .'../application/models/' .P_S .get_include_path());
//載入 ZFAMF 類別檔
require_once 'library/Zend/Amf/Server.php';
//載入我們的 HELLOW 類別檔
require_once 'hellow.php';
//建立 ZENDAMF SERVER
$server = new Zend_Amf_Server();
//著名我們這裡面有一個 CLASS 叫做 HELLOW
$server->setClass("hellow");
//執行結果
echo( $server -> handle() );
?>

<?php
define("dbserver","localhost");
define("dbusername","root");
define("dbpassword","");
define("dbname","db_test");
 
class hellow {
	public  function sayHello($name){
		//甚麼都不做，就回傳字串
		return "中文測試 : ".$name;
	}
	public function getDbData(){
		$db = new mysqli ( dbserver, dbusername, dbpassword, dbname );
		$db->query ( "SET NAMES 'utf8'" );
		$query = "select *
            from bloglink";
		$result = $db->query ( $query );
		$db->close();
		//將讀取出的資料放入陣列中
		for($i=0;$i<$result->num_rows;$i++){
			$test[$i] = $result->fetch_assoc();
		}
		//回傳陣列
		return $test;
	}
	public function getDbDataResult(){
		$db = new mysqli ( dbserver, dbusername, dbpassword, dbname );
		$db->query ( "SET NAMES 'utf8'" );
		$query = "select *
            from bloglink";
		$result = $db->query ( $query );
		$db->close();
		//直接回傳 MYSQL 的 RESULT 物件
		return $result;
	}
}
?>

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical" fontSize="16">
	<mx:Script>
		<![CDATA[
			import flash.net.navigateToURL;
			import mx.collections.ArrayCollection;
			import mx.rpc.events.ResultEvent;
			private function getZendAMF():void{
				this.ro.sayHello("中文傳值 許功蓋");
			}
			private function getZendAMFDB():void{
				this.ro.getDbData();
				this.ro.getDbDataResult();
			}
			private function resultHandler(event:ResultEvent):void{
				this.ZendResult.dataProvider = event;
			}
			private function clickHandler():void{
				var url:String = this.bloglink.selectedItem.m_url;
				var req:URLRequest = new URLRequest(url);
				navigateToURL(req,"_blank");
			}
		]]>
	</mx:Script>
	<mx:TextInput text="{this.ro.sayHello.lastResult}"/>
	<mx:Button label="按下後使用 RemoteObject 取回 ZendAMF 後端資料" click="getZendAMF()"/>
	<mx:DataGrid id="bloglink" dataProvider="{this.ro.getDbData.lastResult}" width="600" height="250" itemClick="clickHandler()">
		<mx:columns>
			<mx:DataGridColumn headerText="標題" dataField="m_title"/>
			<mx:DataGridColumn headerText="日期" dataField="m_date" width="150"/>
		</mx:columns>
	</mx:DataGrid>
	<mx:Button label="使用 ZENDAMF 取得資料庫的資料" click="getZendAMFDB()"/>
	<mx:Label text="ZENDAMF 直接回傳 MySQL RESULT 卻只有拿到空的 OBJECT"/>
	<mx:DataGrid id="ZendResult" width="600" height="250"/>
 
	<mx:RemoteObject id="ro" destination="zend" source="hellow">
		<mx:method name="getDbDataResult" result="resultHandler(event)"/>
	</mx:RemoteObject>
</mx:Application>