php, mySQL and flash

Anon

Hi,
I am trying to build a site which incorporates php mySQL and flash technologies, but I don't know if flash will
be able to extract information from mySQL and dynamically display it on my pages. Have
anyone ever done something like that? I will
love to see some demo. Please reply. Thank you in advance.

Anon

The only thing that I have done is pulled dynamic text into my flash movie to do this I simply used get variables from within the flash movie to call on a php script that would query my database and return a urlencoded query string with the variables that i wanted to use. Let me know if that makes sense.

Anon

It does make sense, so you can hack it to
do what you want, but is there a cleaner way that I can simply qeury the db from within
flash directly. Just curious. Thanks

Anon

As far as I know no, The limitations currently set forth by flash only warrant you to read varibales in from a text file. So that is in essence what you would be doing with your php script. What I mean is right now without generator you could read a text file with something like this in it:

a1=sad&a2=sdsd&name=sdsd

So you could query your db and do the same thing with a php script but it would limit how much data you could pass to the movie, that is the only down fall that I can see

Anon

How are you limited on the data you can pass? I've used this method before to pass pretty large blocks of data.

Anon

I don't know much about macromedia generator. Can generator pull information from mySQL database?
I need to pull out like a list of objects
which match some criteria in the database?
Will it be better if I have flash call some
php script pages and let those php scripts
take care of the db query? I don't really
need to have flash on the pages (although it will be nice 🙂 ), but that will eliminate the need for generator and smart hack jobs.

Anon

I've never worked in Genrator. Supposedly it's pretty nice. I'm almost positive it'd have some kindof odbc solution to access MySQL. But Generator costs a LOT of money... well a lot of money when compared to PHP. ..grin..
But it'd probably work fine using flash, and having flash call a PHP script that returns an urlencoded list of variables with your data.

Anon

Great!!! that's what I am going to do.
Flash -> php script -> mySQL

Another question I have is does php support
flash moive, will php touch anything
inside the <embed> tag? I don't think it
will, but just want to make sure.

Anon

An other altenative to Macromedia generator seams to be Swift-generator. It has mysql drivers and I think will help you to generate what you need. I gonna try to use it, so maybe more news later ... http://www.swift-tools.com/

Anon

Sorry about ths...