How to send PHP data to Flash?

[freddycodes]

This will never work. You cannot return a query result identifier to a flash movie through LoadVars. You need to iterate through the recordset. and create something that flash can read. Or use remoting. Or even use xml or csv. Search the forums for recordset

[rubbersoul]

OK...now I'm totally confused....

[rubbersoul]

So, I've installed flash remoting......is what I want to do possible.....is it really that hard. For God's sake it's only one dynamic text box......

[CyanBlue]

Um... None of what I have replied were applied to your PHP file... How come??? You already know I am really bad at PHP, uh???

The bottom line is that you should really make that PHP script working with no error within the web browser and when that's done, that's time to use that data within the Flash and you do need to remember what I said up there in terms of getting rid of unnecessary output and having the variables in varName=value&varName=value pairs...

[JerryScript]

I just browsed through this thread, and I think you can get this working by adding this line before your echo line, but be warned I did not test it (my db is messy right now).

$result=str_replace("\\n","&",$result);

Hope that helps!

[rubbersoul]

Ya sorry Cyan....I have just been getting so much mixed responces that I don't know if I'm coming or going. I will try when I get home from work to do as you said and I will add the line that erry suggested also. Then (when it's still not working ) I will re-post the .fla and PHP for you guys to look at. Thanks for all the help.....so I geuss the whole 'Flash remoting' thing is unnecessary?

[CyanBlue]

Flash Remoting will be another way of doing it... It will be extremely useful if you are passing really big data and if you have to create an array with that data in Flash... Flash tends to be real slow when that happens, but if you use Flash Remoting, you can just send PHP array to Flash array... Simple, right??? That's one great reason to use Flash Remoting...

[rubbersoul]

Just as a side note......I just entered my URL from work and put the stats.php at the end of that URL and I get back....

Connected to mysql server localhost as user root
Database stats selected for use.

That's a step in the right direction.....no? Isn't that telling me that it did connect to mysql properly?

I think I will stay away from flash remoting right now....gotta eat this cake slowly.....

[CyanBlue]

Yes... That's correct, but you will need to reformat the output from your PHP script in the manner which Flash understands...

[rubbersoul]

Awesome.....I can feel it getting closer...LOL