hi,

This is done in flex 4 but its pretty much the same as flex 3 just need to replace the spark stuff with the mx stuff. Hopefully it will help

Application

========

<?xml version="1.0" encoding="utf-8"?>

<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"

   xmlns:s="library://ns.adobe.com/flex/spark"

   xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600" creationComplete="application1_creationCompleteHandler(event)">

<fx:Script>

<![CDATA[

import mx.collections.ArrayCollection;

import mx.controls.Alert;

import mx.events.FlexEvent;

import mx.rpc.events.FaultEvent;

import mx.rpc.events.ResultEvent;

[Bindable] private var clientsArray: ArrayCollection;

protected function lc_clients_faultHandler(event:FaultEvent):void

{

Alert.show("Connection failed","Error");

}

private function qryClients(res:ResultEvent):void

{

var dp:Array=new Array();

var i:Number=0;

while(i < res.result.length)

{

dp.push(res.result[i]);

i++;

}

clientsArray = new ArrayCollection(dp);

trace("hello");

}

protected function application1_creationCompleteHandler(event:FlexEvent):void

{

lc_clients.getOperation("getClients").send();

}

]]>

</fx:Script>

<fx:Declarations>

<s:RemoteObject id="lc_clients" fault="lc_clients_faultHandler(event)" showBusyCursor="true" source="lifecalc" destination="amfphp">

<s:method name="getClients" result="qryClients(event)"/>

</s:RemoteObject>

</fx:Declarations>

<mx:DataGrid id="dg" dataProvider="{clientsArray}" doubleClickEnabled="true" showHeaders="false" horizontalCenter="0" verticalCenter="0" width="500" height="400">

<mx:columns>

<mx:DataGridColumn headerText="Column 1" dataField="Firstname"/>

<mx:DataGridColumn headerText="Column 2" dataField="Surname"/>

<mx:DataGridColumn headerText="Column 3" dataField="DOB"/>

</mx:columns>

</mx:DataGrid>

</s:Application>

PHP

===

<?php

class lifecalc

{

var $db_host = 'localhost';

var $db_name = 'flashhub_lifecalc';

var $db_user = 'flashhub_lifecalc';

var $db_pwd = 'xxxxxx';

function lifecalc ()

{

// Define the methodTable for this class in the constructor

$this->methodTable = array(

"getClients" => array(

"description" => "Return a list of clients",

"access" => "remote"

)

);

}

function getClients ()

{

$mysql = mysql_connect($this->db_host, $this->db_user, $this->db_pwd);

mysql_select_db( $this->db_name);

$Query = "SELECT ID,Surname,Firstname,DOB from clients";

$Result = mysql_query( $Query );

while ($row = mysql_fetch_object($Result))

{

$ArrayOfClients[] = $row;

}

return( $ArrayOfClients );

}

}

?>

config-services

===========

<?xml version="1.0" encoding="UTF-8"?>

<services-config>

<services>

<service id="amfphp-remoting" class="flex.messaging.services.RemotingService" messageTypes="flex.messaging.messages.RemotingMessage">

<destination id="amfphp">

<channels>

<channel ref="remote"/>

</channels>

<properties>

<source>*</source>

</properties>

</destination>

</service>

</services>

<channels>

<channel-definition id="remote" class="mx.messaging.channels.AMFChannel">

<endpoint uri="http://flashhub.net/insurance/amfphp/gateway.php" class="flex.messaging.endpoints.AMFEndpoint"/>

</channel-definition>

<channel-definition id="local" class="mx.messaging.channels.AMFChannel">

<endpoint uri="http://localhost/amfphp/gateway.php" class="flex.messaging.endpoints.AMFEndpoint"/>

</channel-definition>

</channels>

</services-config>

Hi,

I have 2 definitions so that when compiling the application it can be compiled for both local development and for the release build if you look at the beginning of the xml it defines which end point is to be used.

Just note this is really old stuff now and probably using zendamf is an easier option(not necessarily the best option though).

If you like using amfphp, this is an example where you don't need to compile the gateway configuration xml into the application, basically you define your channel set at runtime. Sorry I can't post the php at the moment as I am not at home(having an easter holiday ) so currently don't have access to the local development environment or my host.

http://flashhub.net/filter/ (right click on app for the source).

David

Hi,

Unfortunately a lot of information on amfphp is spread over the internet and sometimes a little hard to follow, my personal preference is for amfphp due to its simplicity but the reality is Adobe have commited a lot of time and effort in giving us backend solutions for php through the zend framework.

Unless you are using flexbuilder which is now well and truly outdated it is best to use Flashbuilder and its DCD wizards which will help you by creating basic CRUD services for both the front end(actionscript) and the backend(php). There are lots of tutorials and blogs from Adobe and the community on Flashbuilders php wizards.

I haven't used amfphp for sometime now as I felt that for my clients it was a better choice to stick with products that are designed to work with Flahbuilder and fully supported by Adobe. If you wish to continue to work with amfphp  I can give you some links to my earlier stuff with amfphp once I return home from my vacation(I need access to my office so I can upload some code to my host).

David