Flash - Get PHP data problem.. +rep

[Blinger1]

Hello everyone.

I have an annoying problem with Flash.
I want to get the data from a PHP page (which collects data from a MySQL database). That part works alright for what is needed.

Show Hide

http://freyta.net/mysql/hot.php?name=shane

is the link to the data.

Now I load my data data using

onClipEvent (load) {
    i = new LoadVars();
    i.load("http://freyta.net/mysql/hot.php?name=shane", this, "GET");
} 

which recieves the data "127="...

How do I get rid of that equals sign :S


Sorry for the really dumb question

[Rapidshare]

It works?

[Blinger1]

No, it has the stupid equals sign...
I can't just load the data "127"... (it works fine on the webpage but when i load it into flash it adds the = sign)

[Yonder]

show the flash page.. please and your php source.

[Blinger1]

http://freyta.net/mysql/hot.phps
http://freyta.net/mysql/gayz.fla

(its the little square box with all the code for the fla )

edit:

Maybe it is just my PC but it wants to download the phps

Here is the code in the spoiler

Show Hide

<?php
include 'sqlConnection.php'; 
$test = $_GET[name];

$getuser = mysql_query("SELECT * FROM name WHERE name = '$test'");


while ($user = mysql_fetch_array($getuser)){


//echo ("name=$user[name]");
echo ("$user[hot]");
}
?>

[L?KE]

To be sure you could shortern the string to three in flash (duno how) or in php:

$user = $user[hot];
$user = substr($user,0,-1);

Edited by ,Jess, (Forum Super Moderator): Double posts merged due to lag.

[Protege]

If I remember correctly, flash can read data like this:

&name=that
&this=poop

This is loading data using LoadVars

ActionScript:

data = new LoadVars();
data.load( "http://www.disasterpiece.co.uk/flashData.php" );
data.onLoad = function( success )
{
    if( success )
    {
        trace( data.myMessage );
    }
} 

Returns
"Joygasmic ****"

The PHP page if you're interested whats on it (doesn't have to be a php page, can be a html/text/etc page)

Live content:
"&myMessage=Joygasmic ****"

PHP code:

<?php
// Using PHP just to explain
$variable = 'Joygasmic ****';
echo '&myMessage=' . $variable;
?>

Hope this helped.

[Blinger1]

Okay that worked ! (it got the variable properlly)

But, now my rotation won't work :S?

onClipEvent (load) {
    data = new LoadVars();
    data.load("http://www.freyta.net/flashData.php");
    data.onLoad = function(success) {
        i = data.myMessage;
        if (success) {
            trace(i);
            if (_root.mcobj._rotation<tobe) {
                _root.mcobj._rotation++;
            }
        }
    };
} 

Why doesn't that work?

This is really stupid :eusa_wall

[Protege]

I dont understand what you are trying to do, explain more and I can help you.

[Blinger1]

Okay...

Here is my idea.
I want to make an application called the 'hot-o-dometer'. Its like a speedometer but instead of saying mph or kmph, it tells you how 'hot' you are..

How it works:
I get a variable (which we called myMessage) from a remote location, and then dial turns that many degrees to point to how 'hot' you are..


Does that make sense?