flash and mysql

can we root flash so that it works like a php web page and prints data from a mysql database??

[BlodoPKNZ]

Yes we can if you make a php script which reads from the database itself, then posts the variables directly to the swf.

but what do i write in flash that posts it to the flash movie/site/script thing! its confusing!!

where in php/html you would assign varibles like $yea, how can you do that in flash??

[Milkdrop]

im pretty usre goolge would find you a decent article about this. I really dont have a clue about flash. I think its ****.

im just starting to use it, Macromedia flash is ****, theres better ones on the market like swish (thats wot i use) but ive tried searching google and it just ranges in different things and they dont work!!

[Milkdrop]

yeah swish is amazing little app.

its very good isnt it? they say that it can be used with mysql and php but i still havent found that gold tut!!

[BlodoPKNZ]

Dont know about swish, i use Macromedia Flash MX and think its a great app. Easy with intuitive interface etc. If swish supports the use of actionscript, you could just use loadvars to get all the variables from a php file, like this:

myvars = new loadVars();
myvars.load("somefile.php");

yea ive worked out how to link the mysql connection into it (by the use of macromedia flash mx) but the prob i have is getting it to write the variables!

how is that done?

do i assign a variable to each text/image or whatever in the actionscript??

[BlodoPKNZ]

Image in actionscript? lol

And arent the variables assigned automatically? I mean the loadvars command will obviously load variables not the entire file, so if you have a variable $foo in the php code, and load it you dont need to process it, you can use it straight away. I think so at least.

no no, as in, with a php file, when you want to load a variable or show it (print, echo...) you print or echo it yea, how can that be done in flash? thro text boxs?

[BlodoPKNZ]

Isnt it obvious? You just make a dynamic text box, give it a varname then use actionscript to "hardcode" them.

oh... ok i get it...