Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

flash and mysql 1

Status
Not open for further replies.

rninja

Technical User
Apr 11, 2001
381
US
I am trying to learn how to setup a flash to php to mysql example. To keep it simple, this is what I would like to do:

have the flash movie show a listing from mysql.
The mysql database will consist of only two fields: name and number.

I would like to see this sample created in the simplest method possible so I can practice.

I would appreciate assistance with this, I cannot seem to find a tutorial anywhere that keeps it to the bare minimum and simple.


Rninja

smlogo.gif

 
Bill,

I am still having problems and the tutorials I am finding do not make sense to me for some reason...

Rninja

smlogo.gif

 
kind of busy right now but give me 24 hrs or so and ill put together a very basic example for you to start with
 
Thanks Bill, I really appreciate it. I also had another minor problem with an image variable not showing up in the flash movie. Here are three links that are related but do not seem to work for me. My code is posted in the third link.


Rninja

sl.jpg

 
really basic example....just create a mysql database named products with a table produce containing 2 fields , product and quantity

the php will have to be changed to your database user name and password....i omitted the password from these files as i set it to none

in flash just change the url in the send and load function

play with it here


zipped files


ill take a look at the other problem later
 
Thanks Bill!

You definately deserve a star. Hopefully You can assist me with the other issue... I think it is rather small but i've tried so many things and I am not getting the image to show up truly dynamically from mysql, even though it outputs correctly from php...


Thanks again!

Rninja

sl_sm.jpg

 
for image problem try just saving image name in database and add .jpg at runtime

container.loadMovie(_root.output3 + ".jpg");
 
Funny thing is I keep getting undefined, now with your advice, it came out to be undefined.jpg

I am wondering what is going on with this issue, it seems a bit odd...

Rninja

sl_sm.jpg

 
I tried replacing the actual file name as "undefined.jpg" and it showed up, but it doesn't pick up the actual file name "jet.jpg" although it is echoed from the php script properly...

Rninja

sl_sm.jpg

 
strange.....only thing I dont like about your code is the duplicate use of output3...both as variable and text box instance name....dont think that's source of problem though

undefined suggests to me that the variable is not being properly returned from php

i suggest you drop lvout and just use lvin

myBtn.onRelease = function(){
lvIn.yes = yes.text;
lvIn.sendAndLoad(path + "test.php", lvIn, "POST");
};
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top