Flash to PHP to Mysql help.

[hooligan2001]

Hey peeps, ive been fiddling with mysql and php on a newbie level, and i was wondering if you could help me out. I was just wondering how things work. How im supposed to pack things and send it to the next thing. Like how do i pack and send a variable called numCo = 7; and send it to php. And then have php insert that var into mysql.

I found this in a tutorial i was working with and realise its how you submit the info to my sql

        //  Setup query
        $q = "INSERT INTO `dbUsers` (`username`,`password`,`email`) "
            ."VALUES ('".$_POST["username"]."', "
            ."PASSWORD('".$_POST["password"]."'), "
            ."'".$_POST["email"]."')";
        //  Run query
        $r = mysql_query($q); 

But how do i set a variable up in flash to send to php.

Its really urgent ive been trying to understand this for a while but i keep finding different ways people do it and im getting confussed.

[bs_grewal]

first of all u need to create 3 text boxes in flash file with the var names "username,password,email"

then place a button for submit and use this script on the button

on (release, keyPress "<Enter>") {
getURL("https://www.domainName/login.php", "", "POST");
}

i don't know is ur query in php file is ok or have some error, but this action send the data out of flash.

[hooligan2001]

so do i have to have the variables i want to post in text boxes? How do i send them if their on the _root timeline?

I cant see any variables declared in this

on (release, keyPress "<Enter>") {
getURL("https://www.domainName/login.php", "", "POST");
}

how does php know which variables to read?

[swap_meet]

Hi there,
Try something like:

code:

---

on (release, keyPress "<Enter>") {

getURL("https://www.domainName/login.php?var=whatever", "GET");

}

---

[bs_grewal]

sorry
use this

Originally posted by bs_grewal
first of all u need to create 3 text boxes in flash file with the var names "username,password,email"

then place a button for submit and use this script on the button

on (release, keyPress "<Enter>") {
getURL("https://www.domainName/login.php?username=vari&password=var&email=var", "", "POST");
}

i don't know is ur query in php file is ok or have some error, but this action send the data out of flash.

[Musicman]

Hi,

it is generally considered a bad idea to send passwords via the query string, bacause they will show up in the browser history
If you want to use this kind of technique, the coding would be
geturl("http://www.somesite.com/script.php?var1="+var1+"&var2="+var2,"");

If you want to send just specific vars to a new page, with post, use loadvars.send()

Musicman

[bs_grewal]

yh Musicman, u r right
i uselly connect database with asp so i use flash objects to send this kind of data, i m not a php expert so i suggest this method.

[hooligan2001]

Thanks guys, another quick question is,

In a tutorial i seen them put a _root in the first arrgument instead of "" whats the difference?

so this

getURL("https://www.domainName/login.php?username=vari&password=var&email=var", "", "POST");

change to this.

getURL("https://www.domainName/login.php?username=vari&password=var&email=var", _root, "POST");

[Musicman]

Hi,

the empty argument seems to be one of those nice little undocumented features that work.
It is up to you to find out whether it is equivalent to _root or this (and rather irrelevant if you only use that code on the main timeline)

@bs_grewal: flash does not know the difference between asp and php servers

Musicman

[hooligan2001]

The same tutorial that showed me that _root thing which doesnt seem to work show me this now it doesnt work but i cant get it to work.

everything is set up the vars are in place but i think its this script thats bad

on(release) {
var lowscore = _root.lowscore;
var lowplayer = _root.lowplayer;
var pAbility = _root.pAbility;
var scoreid = scoreid;
var num = _root.num;
loadVariables("http://localhost/updatescore.php", _root, "POST");
}

now i dont see the variables passed to the script in the line loadVariables("http://localhost/updatescore.php", _root, "POST");

And their is also a input text box on the time line with the name newplayer on it that is suppossed to get sent to it.

Now it doesnt seem to work. I think i can see why bt i dont know how to re write the

loadVariables("http://localhost/updatescore.php", _root, "POST");

line

[Musicman]

Hi,

if your variables are on the main timeline, the code before loadvariables is simply unnecessary.
If they are in a movieclip, the code will not send anything reasonable

I just replied to another thread and suggested use of loadvars object in place of loadvariables - this would be an option for you as well

Musicman

[hooligan2001]

Yeh the button is inside a movieclip and the actions on the movieclip. Is

onClipEvent(data){
gotoAndStop(20);
}

So on this line how does it know what variables to pass?

loadVariables("http://localhost/updatescore.php","", "POST");

Shouldnt that line contain some sort of variable names like suggested by swap_meet. Or does flash send every variable to the php file? Seems pointless.

Like shouldnt it be like this

loadVariables("http://localhost/updatescore.php?lowplayer=lowplayer&hiplayer=hiplayer","", "POST");

I dont know the propper syntax. For the ?lowplayer part. Does it go.
?("the variable name in the php file")=("where the variable is in flash)

so like this

?phpvarname=_root.flashvarname

??

[swap_meet]

Hi again hooligan (fellow Melbournian),
You can define your variables if you use what Musicman suggested (using the LoadVars object).
Here is an example:

myData = new LoadVars()
myData .pass_var = this.pass_var;
myData .sendAndLoad("http://localhost/updatescore.php, myData , "POST")

myData.onLoad = function(){ 
placeData();
    };
placeData= function(){
if(myData.checklog == 1){
    this.var_name = myData.status;
    this.gotoAndPlay(1);
} else if(myData.checklog == 2){
    this.var_name = myData.status;
    this.gotoAndStop(3);
}
}

then your PHP may look soething like:

$pass_var = $_POST['pass_var'];

// do whatever you like here, query, update etc.

//output for flash
if ($result)
{
   print "&status=DATA TRANSFER COMPLETE&checklog=1";
   } else {
   print "&status=THE DATA COULD NOT BE TRANSFERED&checklog=2";
   }
   print "&";
} 

HTH

[bs_grewal]

Originally posted by Musicman

@bs_grewal: flash does not know the difference between asp and php servers

Musicman

yes Musicman flash doesn't know the difference between asp and php but i was talking about myself that i don't know the php.