Problem with PHP/AS3 - Display PHP query results back to flash via AS3

Question

Ive made a query in PHP, and I'm trying to send the results back into Flash via AS3, but it's throwing up this error...

Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs. at Error$/throwError() at flash.net::URLVariables/decode() at flash.net::URLVariables() at flash.net::URLLoader/onComplete()

Here is the relevant part of the PHP and AS3 code, including the query. The Flash variable rssAdd is passed over to the PHP which is using it in the PHP query accordingly.

$url = $_POST['rssAdd'];
$query= SELECT title
FROM Feed
WHERE category = (SELECT category
FROM Feed
WHERE url =$url) AND url!=$url;
$result = mysql_query($query);
echo  $query;

Here is the AS3 code I've done so far.

function recommendation(){

var request:URLRequest = new URLRequest("url");
request.method = URLRequestMethod.POST

var recVars:URLVariables = new URLVariables();

recVars.rssAdd=rssAdd;
request.data = recVars

var loader:URLLoader = new URLLoader(request);
loader.addEventListener(Event.COMPLETE, onComplete);
loader.dataFormat = URLLoaderDataFormat.VARIABLES;
loader.load(request);

function onComplete(event:Event):void{
recommend.text = event.target.data;
}
 }

Any help would be most appreciated, thanks.

no, I hadnt, thanks. It compiles now, although nothing is shown in the text box, when there should be a result. (i tested the query in HeidiSql, replacing $url, with the url that should be held in rssAdd, and there is a result.) — Dale J
– Dale J, Commented Apr 23, 2010 at 21:00

Danyal Aytekin · Accepted Answer · 2010-04-23 21:25:50Z

1

Have you checked what is coming back from the server running your PHP application? Checking the details of the request and the response, using Firefox and the Net panel of Firebug, could shed light on some other unexpected problem with the web server.

answered Apr 23, 2010 at 21:25

Danyal Aytekin

4,2453 gold badges39 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Dale J Over a year ago

The response from the PHP file is the query itself, the same response i get if I trace event.target.data.title in flash. Does that shed any more light on my problem? thanks.

Dale J Over a year ago

Not quite sure what you mean. The variable rssAdd is a String, containing a url.

Danyal Aytekin Over a year ago

In your onComplete() handler you have a variable called "recommend". What class is it and where was it declared (or was it dragged onto the stage in the IDE)? This could be a scope problem - first check that Publish Settings -> Flash -> Settings -> Strict Mode is checked. Also try moving onComplete() out of recommendation(). Rename it if necessary.

Danyal Aytekin Over a year ago

Also try changing "loader.dataFormat = URLLoaderDataFormat.VARIABLES;" to "loader.dataFormat = URLLoaderDataFormat.TEXT;"

Dale J Over a year ago

Oh I see, its text using the text tool. Its finding onComplete, since I put the trace in there.

|

Dale J · Accepted Answer · 2010-04-24 02:01:49Z

1

Fixed it with the following return:

$result = mysql_query($query);
$row=mysql_fetch_array($result);
print ("recTitle=".urlencode($row['title']));

answered Apr 24, 2010 at 2:01

Dale J

214 bronze badges

Collectives™ on Stack Overflow

Problem with PHP/AS3 - Display PHP query results back to flash via AS3

2 Answers 2

9 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related