RecordSet/DataGlue -amfphp

[heyder]

Wondering what I need to do to be able to use the DataGlue API, or if it even works with amfphp.

I've been able to get data back from php/mySql and populate a combobox but... I would like to figure out how to bind the data using DataGlue.

When I recieve the data back using amfphp is that considered a RecordSet or do I have to create a RecordSet in flash using

new RecordSet (colunmNames) or something

[freddycodes]

Depends on how you are getting the data, if you simple return the result of a query from your class, it is a recordset in flash.

Consider this class I use to get data from a people database in MySQL. Both getPeople and getPersonById will return a recordset to flash.

PHP Code:

<?php
class People
{
    var $db;
    var $DBHOST =  "localhost";
    var $DBUSER = "********";
    var $DBPASS = "*********";
    var $DBNAME = "********";
    
    function People()
    {
        $this->methodTable = array(            
            "getPeople" => array(                
            "description" => "Return a list of people from the database.", 
            "access" => "remote", 
            "roles" => "role, getPeople", 
            "arguments" => array ()),
            "getPersonById" => array(                
            "description" => "Return a person detail", 
            "access" => "remote", 
            "roles" => "role, getPersonById", 
            "arguments" => array ("person_id"))
        );    
        $this->db = mysql_connect($this->DBHOST, $this->DBUSER, $this->DBPASS);
        mysql_select_db($this->DBNAME);
    }

    function getPeople() {
        return mysql_query("SELECT person_id, person_name_first, person_name_last from person");
    }

    function getPersonById($person_id) {
        return mysql_query("SELECT * from person WHERE person_id = '$person_id'");
    }

}

?>

So if I call the getPeople method I get three fields back id firstname and lastname. Here is what my actionscript might look like.

#include "NetServices.as"
#include "NetDebug.as"
#include "DataGlue.as"
init = false;
if(defaultGateway == undefined) defaultGateway = "http://freddy/amf2/simpleGateway.php";
function connect() {
    if(init == false) {
        init = true;
        NetServices.setDefaultGatewayURL(defaultGateway);
        conn = NetServices.createGatewayConnection();
        myservice = conn.getService("People", this);
        myservice.getPeople();
    }
}
connect();
function getPeople_Result(result) {
    DataGlue.bindFormatStrings (myList, result, "#person_id# = #person_name_first# #person_name_last#");    
}
stop();

AS you can probably see its fairly simple to use.

Or if you want to have labels and data in the listbox you can use the bindFormatFunction method like

#include "NetServices.as"
#include "NetDebug.as"
#include "DataGlue.as"
init = false;
if(defaultGateway == undefined) defaultGateway = "http://freddy/amf2/simpleGateway.php";
function connect() {
    if(init == false) {
        init = true;
        NetServices.setDefaultGatewayURL(defaultGateway);
        conn = NetServices.createGatewayConnection();
        myservice = conn.getService("People", this);
        myservice.getPeople();
    }
}
connect();
function getPeople_Result(result) {
    DataGlue.bindFormatFunction (myList, result, myCustomFunc); 
}

function myCustomFunc ( record )
{
    var myLabel = record.person_name_last + ", " + record.person_name_first;
    return {label: myLabel, data: record.person_id};
}
stop();

[heyder]

Sweet, thanks so much for the example code, I've just started playing around with this stuff so the more code samples I can get my hands on the better.