# Loading Variables into Flash

**URL:** <https://forum.kirupa.com/t/loading-variables-into-flash/260469>\
**Category:** flash\
**Created:** [May 15, 2008, 11:18pm UTC](https://forum.kirupa.com/t/loading-variables-into-flash/260469 "2008-05-15T23:18:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![carlalwalker](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@carlalwalker](https://forum.kirupa.com/u/carlalwalker)\
**Post date:** [May 15, 2008, 11:18pm UTC](https://forum.kirupa.com/t/loading-variables-into-flash/260469/1 "2008-05-15T23:18:01Z")

</div>

Hi im having a bit of trouble getting my variables sent back to flash from php. Could someone please tell me where im going wrong. Im trying to create a simple login but im a bit new to actionscript and Iv spent hours searching forums and things. Thanks (Im using flash 8 if that helps)  
This is my code  
Actionscript  
logins = new LoadVars();  
login.onPress = function (){  
logins.user = user.text  
logins.password = password.text  
logins.sendAndLoad(“login.php”, login2, “POST”)  
};  
lvOut.onLoad = function (success)  
if (success) {  
if (this.writing == “OK”){  
gotoAndPlat(41); }  
else {  
gotoAndPlay(42); }  
}  
}

And the php script is  
\<?php  
$user = $\_POST[‘user’];  
$password = $\_POST[‘password’];

$conn = @mysql\_connect(“localhost”,“root”,“root”)  
or die(“sorry - could not connect to mysql”);  
$rs = @mysql\_select\_db(“movies”,$conn)  
or die(“problem with database”);  
$query = (“SELECT \* FROM customers WHERE Username = ‘$user’ AND Password = ‘$password’”);  
$rs = @ mysql\_query($query,$conn) or die(“unable to find records”);

if(@ mysql\_num\_rows($rs) == 1)  
{print “writing=Ok&”;}  
else  
{print “writing=Error&”;}

?\>

---

<div class="post-metadata">

**Author:** ![jon\_bla](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jon\_bla](https://forum.kirupa.com/u/jon_bla)\
**Post date:** [May 16, 2008, 3:42pm UTC](https://forum.kirupa.com/t/loading-variables-into-flash/260469/2 "2008-05-16T15:42:40Z")

</div>

Try this

```php

<?php
$user = $_GET['user'];
$password = $_GET['password']; // You can also use _REQUEST 

$conn = @mysql_connect("localhost","root","root")
or die("sorry - could not connect to mysql");
$rs = @mysql_select_db("movies",$conn)
or die("problem with database");
$query = ("SELECT * FROM customers WHERE Username = '$user' AND Password = '$password'");
$rs = @ mysql_query($query,$conn) or die("unable to find records");

if(@ mysql_num_rows($rs) == 1) 
{print "writing=Ok&";}
else
{print "writing=Error&";}

?>

```

---

<div class="post-metadata">

**Author:** ![jon\_bla](https://avatars.discourse-cdn.com/v4/letter/j/ecc23a/32.png) [@jon\_bla](https://forum.kirupa.com/u/jon_bla)\
**Post date:** [May 16, 2008, 3:47pm UTC](https://forum.kirupa.com/t/loading-variables-into-flash/260469/3 "2008-05-16T15:47:13Z")

</div>

Found a mistake on your Actionscript Code

```auto

logins = new LoadVars();
login2 = new LoadVars();
login.onPress = function (){
logins.user = user.text; 
logins.password = password.text;
logins.sendAndLoad("login.php", login2, "POST")
};
login2.onLoad = function (success)
if (success) {
if (login2.writing == "Ok"){
gotoAndPlat(41); }
else {
gotoAndPlay(42); }
}
}

```

Those are the only errors i could find rt now