# Send PHP variable value to AS3

**URL:** <https://forum.kirupa.com/t/send-php-variable-value-to-as3/330846>\
**Category:** programming\
**Created:** [March 28, 2013, 10:59am UTC](https://forum.kirupa.com/t/send-php-variable-value-to-as3/330846 "2013-03-28T10:59:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marcus\_Montz](https://avatars.discourse-cdn.com/v4/letter/m/57b2e6/32.png) [@Marcus\_Montz](https://forum.kirupa.com/u/Marcus_Montz)\
**Post date:** [March 28, 2013, 10:59am UTC](https://forum.kirupa.com/t/send-php-variable-value-to-as3/330846/1 "2013-03-28T10:59:53Z")

</div>

[SIZE=2][AS3 Code]  
import flash.net.URLLoader;  
import flash.net.URLRequest;  
import flash.events.Event;

var phpFile:String = “connect.php”;

function loadFile(evt:MouseEvent):void{  
var myLoader:URLLoader = new URLLoader();  
var myRequest:URLRequest = new URLRequest(phpFile);  
myLoader.dataFormat = URLLoaderDataFormat.VARIABLES;  
myLoader.load(myRequest);  
myLoader.addEventListener(Event.COMPLETE, loadComplete);  
}

function loadComplete(evt:Event):void{  
testing.text += evt.target.data.return\_msg;  
}

loadButton.addEventListener(MouseEvent.CLICK, loadFile);

* * *

[PHP Code – connect.php]  
\<?php  
$host = ‘localhost’;  
$port = ‘5432’;  
$user = ‘postgres’;  
$db = ‘db\_name’;  
$pass = ‘test’;

$connectString = ‘host=’ . $host . ’ port=’ . $port . ’ dbname=’ . $db . ’ user=’ . $user . ’ password=’ . $pass;

$link = pg\_connect ($connectString);

if (!$link)  
{  
die('Error: Could not connect: ’ . pg\_last\_error());  
}  
else  
{  
echo “Database Connection: Success!\<br\>”;

```
$query = 'SELECT * FROM students;';
$result = pg_query($query);

if (!$result)
{
    echo "Problem with query " . $query . "&lt;br&gt;";
    echo pg_last_error();
    exit();
}
else
{        
      $trows = pg_affected_rows($result);

```

[/SIZE] echo “return\_msg=” . $trows;[SIZE=2]  
[/SIZE][SIZE=2] }  
}  
pg\_close($link);  
?\>  
[SIZE=2]  
[SIZE=3]  
My problem is _[SIZE=2]$trows[/SIZE]_ returns an undefined/null value to _[SIZE=2]evt.target.data.return\_msg[/SIZE]_[/SIZE]  
[SIZE=3]But when I test another php file, with the following code:

[SIZE=2]\<?php  
$trows = 123;  
echo “return\_msg=” . $trows;  
?\>[/SIZE]

…_[SIZE=2]$trows[/SIZE]_ works just fine.

Help much appreciated. Thanks.[/SIZE]  
[/SIZE]  
[/SIZE]