Newb - so what's the relationship for flash, php, mysql, and xml

1

am i wrong in thinking that you can use just php, mysql, and flash to make a flash based site that uses dynamic data.

i’ve been told that using xml is also part of this equation but I’m confused on its connection. is it the same manner as a .txt file of old where php writes to that file and then flash reads it?

2

Pretty much yeah. But it’s not limited to that. XML doesn’t have to be a part of it, though using XML will provide a huge step forward in keeping things organised and structured. An XML file is prettier to look at and 1000 times as structured as using a .txt file. Basically, Flash calls PHP, PHP gets the SQL data, parses it into an XML file, which Flash will then read. Jubba/Vash wrote a great tutorial on it: http://www.kirupa.com/web/mysql_xml_php.htm

3

is there a way to skip the xml step or is that needed, or is some kind of text file is needed?

just seems like a lot of steps to get things working with a database, sorta makes me wonder why i shouldn’t just try and accomplish things in php and html.

4

You do not need the XML file of text file if you don’t have any use for it…
In other words, you can have your Flash call the PHP script and PHP does the database interaction and then returns the data back to Flash directly… :slight_smile:

5

Of course, that’s what we’re talking about, but for Flash to read it, you’ll need PHP to output the data in either the txt format or the xml format :stuck_out_tongue: I prefer XML because it is so, so superior to the messy txt format (var=foo&var2=foo2&var3=foo3…)

6

reading up through a lot of these tutorials i think i get it…thanks everyone for their input