Actionscript 3 MySQL query using PHP

Question

Want to send in State, City, County variables from Flash to PHP page:

function retrieve() {

 var scriptRequest:URLRequest = new URLRequest("http://localhost:8080/GSM/KJVold.php");
 var scriptLoader:URLLoader = new URLLoader();
 var scriptVars:URLVariables = new URLVariables();

 scriptLoader.addEventListener(Event.COMPLETE, handleLoadSuccessful);
 scriptLoader.addEventListener(IOErrorEvent.IO_ERROR, handleLoadError);

 scriptVars.State = this.whichState;
 scriptVars.City = this.whichCity;
 scriptVars.County = this.whichCounty;

 scriptRequest.method = URLRequestMethod.POST;
 scriptRequest.data = scriptVars;

 scriptLoader.load(scriptRequest);

 function handleLoadSuccessful($evt:Event):void
 {
 MovieClip(parent).info_txt.text = scriptRequest;

 }

My PHP page reads:

//connection to database stuff

$result = mysql_query("SELECT info FROM kjvold WHERE State='$State' AND City='$City' AND 

County='$County'");

while($row = mysql_fetch_array($result))
{
print "info = " . $row['info'];
}

When I trace actionscipt variables I see named pairs going to page. When I hard code PHP page I can see the right output, but when trying to use variables to PHP in the text box I get object URLRequest not the County info I'm seeking. It sure would help if someone can help me with this. Thanks in advance, Annie.

Waleed Amjad · Accepted Answer · 2009-09-18 11:28:17Z

1

I've never used ActionScript before but in your PHP script instead of

$County
$State 
$City

I'm quite sure you need to use

$_POST["County"]
$_POST["State"]
$_POST["City"]

Also it might be an idea to escape your SQL query from injections or other invalid inputs by wrapping the variable in a mysql_real_escape_string() function

Ie:

$_POST["County"]

Becomes:

mysql_real_escape_string($_POST["County"])

answered Sep 18, 2009 at 11:28

Waleed Amjad

6,8284 gold badges37 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Actionscript 3 MySQL query using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related