flash data integration: Best way to communicate with MySQL? -- flash data integration

You're in the

flash data integration

group:

Best way to communicate with MySQL?

LucaLT
11/22/2006 5:07:09 PM

flash data integration:

Hello everyone,

I'm here seeking some advice for an application I'm about to build. This
application hopefully will be used in the recording studio facility where I
work. The purpose of the application is to store information about each studio
session. I've never build an application of this kind so I'm not sure about
what would be the best coding practices. I think I have enough AS skills to
create such a project, but since I'll be using a MySQL database to store ad
retrieve data for the first time, I was wondering if you guys could give me
some advice. I alredy know how to use PHP and LoadVars to send data from Flash
to MySQL, and also how to send back the data in xml format. What I'm not sure
is how to retrieve data for different queries. Would be better to create a XML
object for each different query with a different LoadVars object for sending
the right variable for a particular query, or is there a better way to make the
whole process more efficient? I hope this make some sort of sense. Thanks in
advance for the help

-Luca

Re: Best way to communicate with MySQL?

cosu
11/27/2006 1:25:08 PM

Luca,

I'm looking for the same answer... You will need PHP or ASP also... The
easyest way seems to be through a XML connector. Search online Flash support
for MySQL PHP FLASH and you will get a 6 steps tutorial. Unfortunately they
place the data into components and that doesn't work for me... Have no idea
how to simply place the data into an array...

-Cosu

Re: Best way to communicate with MySQL?

LucaLT
12/1/2006 11:09:23 PM

cosu,
thanks for your reply. I know I need PHP or some other server side technology.
In my particular case I'm using PHP. I have done most of my project already. I
used several LoadVars and XML objects, basically one for each query. I haven't
check out the tutorial, but my question was more in general. My system work,
but since I'm not an experienced programmer, I was wondering if the way I'm
doing things are efficient.
If you need help storing the data into an array I probably can help you. There
is also a simple video tutorial on gotoandlearn.com. I used that ine to get
things started.

Re: Best way to communicate with MySQL?

Perry
12/5/2006 4:20:22 PM

http://www.amfphp.org/

once youÂ´ve experienced this open source project, youÂ´ll never want
again to "manually" create XML or LoadVars objects.

check it out, itÂ´s GREAT!

perry

LucaLT schrieb:
[quoted text, click to view]

Re: Best way to communicate with MySQL?

LucaLT
12/6/2006 12:00:00 AM

Thanks a lot for the tip Perry. I've been reading about amfphp lately and it
seems awesome. The only thing is that it's kind of hard for me to get that
installed on the server where my application in supposed to work. The iT
deparment in my school is a bit reluctant when it comes to add software that
it's not already in their protocols, but I'll definetely check it out.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the flash data integration group.

home · blog · groups

Questions? Comments? Contact the dn