I’m trying to get text from a database into Flash via PHP/MySQL.
While this works perfectly outside of Flash (ie. the text shows up fine if I just open the PHP file), I get an “undefined” in my textbox when I try to get the text in Flash.
My PHP file: (this may be sloppy, I’m still a beginner ;))
<?PHP
include ("conf.php");
$dh= $HTTP_POST_VARS["Page"];
$query = "SELECT * FROM denhaag WHERE ID = '1'";
$result = mysql_query($query)
or die (mysql_error());
while ($data = mysql_fetch_assoc($result)) {
extract ($data);
if ($dh == 'huis') {
$huis = $data['huis'];
echo "$huis";
}
elseif ($dh == 'uitgaan') {
$uitgaan = $data['uitgaan'];
echo "$uitgaan";
}
elseif ($dh == 'sport') {
$sport = $data['sport'];
echo "$sport";
}
elseif ($dh == 'geschied') {
$geschied = $data['geschied'];
echo "$geschied";
}
elseif ($dh == 'student') {
$student = $data['student'];
echo "$student";
}
else {
$home = $data['home'];
echo "$home";
}
} ;
?>
This code is in a button in Flash:
on(release)
{
Send = new LoadVars();
Received = new LoadVars();
Page = "huis";
Send.Page= Page;
Send.sendAndLoad("dh.php",Received);
ReceivedText= Received.huis;
Test.text = ReceivedText;
}
Any ideas?