# URLLoader and PHP not functioning

**URL:** https://forum.kirupa.com/t/urlloader-and-php-not-functioning/283884
**Category:** flash
**Created:** [March 12, 2009, 3:08am UTC](https://forum.kirupa.com/t/urlloader-and-php-not-functioning/283884 "2009-03-12T03:08:38Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![tokth](https://avatars.discourse-cdn.com/v4/letter/t/85f322/32.png) [@tokth](https://forum.kirupa.com/u/tokth)
#### Post date: [March 12, 2009, 3:08am UTC](https://forum.kirupa.com/t/urlloader-and-php-not-functioning/283884/1 "2009-03-12T03:08:38Z")

</div>

I am having an issue in getting flash to call my PHP script and then get the variables back into flash once the PHP script has queried a mysql database. I have tried to chop things in the php script down to their bare essentials. I am new to AS3 so I am having some trouble integrating the two. I know that my DB info and querying works so it must be something with passing data between flash and PHP.

**AS3**

import caurina.transitions._;  
import fl.controls.DataGrid;  
import fl.controls.ScrollPolicy;  
import flash.events._;  
import [flash.net](http://flash.net).\*;

var pass:String="";  
var user:String="";  
var vars:String="";  
//trace(user);  
//trace(pass);  
var goalview:DataGrid = new DataGrid();

function mainRequest(e:MouseEvent) {  
// Prepare request

```
var request:URLRequest = new URLRequest("http://goaltracker.us/BrianPage/app/flashapp/scripts/authenticate.php");
request.method = URLRequestMethod.GET;

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

function completeHandler(evt:Event) {

    user = evt.target.data.user;
    pass = evt.target.data.pass;

```

// vars = evt.target.data.vars;  
// trace('auth is ’ + vars);  
trace('username is ’ + user);

```
    trace('password is ' + pass);

```

// if (vars== “TRUE”) {

//load a custom function  
firsthomeview();  
// }  
}

}

**PHP**

\<?php

$user = $\_GET[‘user’];  
$pass = $\_GET[‘pass’];

$dbuser=“gtracker\_mobile”;  
$dbpass=“F34712738a”;  
$dbname=“gtracker\_mobile”;  
$dbhostname=“[h50mysql53.secureserver.net](http://h50mysql53.secureserver.net)”;

```
mysql_connect($dbhostname, $dbuser, $dbpass) or die ('MySQL connect failed. ' . mysql_error());
mysql_select_db($dbname) or die(mysql_error());

```

// does user exist?

$query = “SELECT username,password FROM user\_tbl WHERE username=’$user’”;  
$check\_database = mysql\_query($query);  
$row = mysql\_fetch\_assoc($check\_database);

if ($row != NULL){  
extract($row);

```
    $user = $row["username"];
    $pass = $row["password"];

```

}

echo “user=$user”;  
echo “pass=$pass”;

?\>