# Flash MX and database interaction

**URL:** https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804
**Category:** flash
**Created:** [May 16, 2002, 6:13pm UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804 "2002-05-16T18:13:36Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 16, 2002, 6:13pm UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/1 "2002-05-16T18:13:36Z")

</div>

Hello there,

Im hoping that someone out there has been successful doing what I have been unable to do…that is use mx to communicate with a database…not using CF.

I guess what I am looking for is how to feed flash mx variables from a database and recover data filled into the the flash mx page from flash mx to the data base server.

Example: using the flash mx text field, dropdown or radio button objects, how do you pass information into the flash page, and how do you recover the selected user information from the forms so that it may be transferred from the client to the server. 😉

thanks,  
.k

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 17, 2002, 2:34am UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/2 "2002-05-17T02:34:12Z")

</div>

That’s a pretty complex thing… most of mine still have glitches in them. We do however have some people with this experience here at Kirupa.

I personaly, have some PHP docs that work to communicate with a mysql database. If your server is using those, I will be happy to send them to you with some explination as to what they are doing.

As for receiving the stuff into Flash… you use the loadVariables(); method to accomplish this.

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 17, 2002, 11:47am UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/3 "2002-05-17T11:47:26Z")

</div>

thanks so much

so now what I am after is how do you go from flash (the presentation layer) to PHP (thin middle layer). I don’t know a thing about PHP, but I do know as with any web scripting language its mode of operation is like ASP. In other words you need to submit to a server to have any action happening…right?

Therefore what is important is not the server submit, but how the information gets from flash to the page before submit of the page (im thinking outloud). If I can get information from flash to ASP, the rest (communication with the data layer) I can handle.

.k

At least I think this what I would need to know.  
Hopefully this not entirely a dumb question.

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 17, 2002, 9:35pm UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/4 "2002-05-17T21:35:04Z")

</div>

What do you mean without using CF ??

And MX features a new way to communicate with PHP : loadVars objects. Not very clear to me how this works, but I heard it’s great.

pom 0]

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 18, 2002, 1:53am UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/5 "2002-05-18T01:53:39Z")

</div>

Well… one thing to note is that if you call loadVariables(); from Flash it will send every variable on the main timeline to whatever doc you name in the method. I know that’s pretty strange… it’s called loadVariable, not sendVariable, but it does in fact send variables.

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 19, 2002, 4:51pm UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/6 "2002-05-19T16:51:34Z")

</div>

Thanks for all your help. I am afraid I do need to draw _from_ the database…bummer. Next version may support the problem.

hmmm, I will email Colin Mock and see what he has to say.  
I will post any news I get.

Clarification:  
CF=Cold Fusion. Its now part of the whole MX solution…Macromedia seems to have it all figured out, but the snag here is that we are not working with ColdFusion servers.

Thanks again.  
.k

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 20, 2002, 3:53am UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/7 "2002-05-20T03:53:24Z")

</div>

oh… well you can communicate with cold fussion I think that you just need to go through something else to get it to work right, or something like that. I’ll look it up in my server book.  
I’m sure there’s a way with Flash5.0

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 20, 2002, 5:28pm UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/8 "2002-05-20T17:28:42Z")

</div>

hey upuaut8 if you don’t mind, can you send the php files with an example of an fla that it works to me? nothing fancy, just something to help get the understanding. my email is rabrown@apex2000.net

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 21, 2002, 3:32am UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/9 "2002-05-21T03:32:30Z")

</div>

no problem… I’ll pack them up into a zip

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 21, 2002, 10:46am UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/10 "2002-05-21T10:46:17Z")

</div>

If you can share with the rest of us, it would be much appreciated.

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 21, 2002, 12:20pm UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/11 "2002-05-21T12:20:51Z")

</div>

this is all great. i look forward to checking out your php files.  
.k

---

<div class="post-metadata">

### Author: ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)
#### Post date: [May 21, 2002, 8:33pm UTC](https://forum.kirupa.com/t/flash-mx-and-database-interaction/1804/12 "2002-05-21T20:33:01Z")

</div>

bump… so I remember to do this tonight
