all groups > flash data integration > january 2007 >
You're in the

flash data integration

group:

Flash with phpMyAdmin


Flash with phpMyAdmin Evegate
1/15/2007 4:43:34 PM
flash data integration:
I have a phpMyAdmin database with 1 table and multiple fields set up. I also
have my website completely in Flash 8. I'm struggling to find out how to create
multiple drop down menus in Flash that show in a line using the entries under
the fields in phpMyAdmin. Depending on what is selected by the user I then want
the results displayed in a box in Flash.
I'm sure this is possible but can anyone help?!
Re: Flash with phpMyAdmin Scott Johnson
1/16/2007 5:55:54 AM
Just a little to help you get on track.

phpMyAdmin is not really a database, it is the front-end application to
administer the database. Check with your site host to determine what
actual database you have or when you log into the phpMyAdmin, it should
tell you what database it is for.
It probably is for a mySQL database, this seems to be the most common
and in my opinion the easiest to use.

Flash does not directly connect to a mySql database as far as I know, so
you will need to set up a back-end page to pull the data you want and
format it as a variable=data output and then have flash load the
variables from that page. Or better yet have the page formatted in an
XML doc and have flash load it into an XML object and then you can
manipulate it as you please in one big chunk.

This may seem like a great deal of work, but it is fairly simple. I
don't have time right now to detail it out, but I am sure by the time I
get off work on of the flash pros will chime in and help.

Don't give up.

Scotty

[quoted text, click to view]
Re: Flash with phpMyAdmin MotionMaker
1/16/2007 3:11:34 PM
I believe a phpMyAdmin database is really a mySQL database and phpMyAdmin is
just a PHP script that provides a web user interface to the mySQL database.

To have Flash communicate with a mySQL database you would use a server
scripting language most likely PHP. That script would perform the queries on
the mySQL database. You could use Flash Actionscript LoadVars or XML class to
send and receive the data to the PHP script and the PHP script deals with the
mySQL database.

On the Flash side your LoadVars or XML onLoad methods will have the data you
need to populate the Flash UI items such as you drop down menus.
AddThis Social Bookmark Button