Resultset de PHP a Flash sin escalas
Ahora con la nueva version de AMFPHP es posible enviar un resultset directamente a Flash desde PHP.
Lo unico que hay que hacer es, el query en PHP y enviar el resultset a FLASH asi de simple.
Servicio resultset.php
<?php
class resultset{
function resultset(){
$this->methodTable = array(
"getData" => array(
"description" => "Regresa un Resultset",
"access" => "remote"
),
"conect" => array(
"description" => "Conecta a la base de datos",
"access" => "private"
)
);
}
function conecta() {
$host = "tuHost";
$username = "tuUsuario";
$passwd = "tuPassword";
$database = "nombreDeTuBaseDeDatos";
$con = mysql_connect($host, $username, $passwd);
mysql_select_db($database, $con);
return $con;
}
function getData(){
$con = $this->conecta();
$table = "tuTabla"
$sql = "select * from $table order by id DESC";
$res = mysql_query($sql);
mysql_close($con);
return $res;
}
}
Llamando al servicio resultset desde Flash
[as]
import mx.remoting.Service;
import mx.rpc.FaultEvent;
import mx.remoting.PendingCall;
import mx.rpc.ResultEvent;
import mx.rpc.RelayResponder;
//Cambia por la ruta a tu gateway
var urlGateway:String = “http://www.tmeister.net/amfphp/gateway.php”;
var services:String = “resultset”;
var myService:Service = new Service(urlGateway, null, services, null, null);
var calling:PendingCall = myService.getData();
calling.responder = new RelayResponder(this, “getData_Result”);
function getData_Result(obj:ResultEvent) {
rows = obj.result._items;
for (var info in rows) {
trace(“id => “+rows[info].id);
trace(“name => “+rows[info].name);
trace(“description => “+rows[info].description);
trace(“price => “+rows[info].price);
trace(“————————————–”);
}
}
[/as]
por ultimo la estructura de nuestra tabla
CREATE TABLE products ( id int(11) NOT NULL auto_increment, name varchar(255) NOT NULL default '', description text NOT NULL, price varchar(6) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; INSERT INTO products VALUES (1, 'Evanescence Anywhere But Home (w/ bonus DVD)', 'a little description', '22.99'); INSERT INTO products VALUES (2, 'Evanescence ORIGIN', 'Description here... : P', '10.88'); INSERT INTO products VALUES (3, 'Evanescence Fallen', 'Another good CD.', '13.49');
enjoy 