php and flash

[raghunath]

Hi all,

I want to send data from flash to mysql using PHP ... and also i want to display the data on flash from mysql using PHP...

can it be possible if so please provide me a small example ...

thank ...

[northmantif]

import flash.net.URLVariables;
import flash.net.URLLoader;
import flash.net.URLRequest;
import flash.net.URLRequestMethod;
import flash.events.Event;
import flash.net.URLLoaderDataFormat;
import flash.net.sendToURL;
import flash.net.navigateToURL;

var uv:URLVariables = new URLVariables();
var ur:URLRequest = new URLRequest();
var ul:URLLoader = new URLLoader();

var data1:Number = 4;
var data2:String = "text";
uv.data1 = data1;
uv.data2 = data2;

ur.data = uv;
ur.method = URLRequestMethod.POST;
ur.url = "urlToThePHPFile/connect.php";
ul.addEventListener(Event.COMPLETE, onDataProvided);
ul.dataFormat = URLLoaderDataFormat.VARIABLES;
ul.load(ur);

function onDataProvided(e:Event):void
{
    trace(e.target.data.output);
}

connect.php

PHP Code:

<?php
$d1 = $_POST['data1'];
$d2 = $_POST['data2'];
if($d1 == 4 && d2 == "text" )
{

    print('output=Put some clothes on you fool!!!');
    
}
else
{
    $output = 'let me guess someone stole your sweetroll';
    print("output=$output");

}
?>

[ASWC]

You use a gateway of some sort or even better amfphp but this is probably to much here. To run queries in mysql you do something like this in your php:

PHP Code:

$db = mysql_connect("database link", "username" , "password");
$dbselect = mysql_select_db("mydatabase", $db);//select your database
$query = "select * from mytable";
$query_result = mysql_query($query);