send post data from flash to php/mySQL and display results in flash 1

[brownfox]

Could someone explain to me simply how to connect flash with my server and vice versa?
My flash movie takes a var from the URL string:
<param name="movie" value="product_info.swf?products_id=918">
and
<embed src="product_info.swf?products_id=918"...>
Getting the value of products_id is easy but I want to send the var products_id to a php page, do some mySQL on it and return the results to my flash movie. I'm using loadVariables (or sendAndLoad) but nothing comes back. I know the scripts are ok as i've tried to send the vars by getURL("page.php","_blank","POST") and it works but loadVars() doesn't. Thanks in advance!

 

[billwatson]

you have to send the loadvars object

myLoadVars.sendandload("some.php",myloadvars,"POST");

ive got a couple of examples if you need them

 

[brownfox]

I think I do need them. I will change my code to the above and get back to you with the results. Thanx 4 your response!

 

[billwatson]

made this a week or so for someone else on this forum

http://billwatson2.no-ip.info/public/db.swf

files

http://billwatson2.no-ip.info/public/basics.zip

then added a bit more functionality

http://billwatson2.no-ip.info/public/flash/mysql.swf

files

http://billwatson2.no-ip.info/public/bitmore.zip

 

[brownfox]

Cheers mate, it's working now. I do think flash is a bit buggy in places, would you agree?

 

[billwatson]

for sure

with sendandload i get unpredictable results if i dont add the full url to the php file

always works with full url often works without but then for no good reason stops working

go figure

 

[brownfox]

I dont get this line when displaying received data:

for (i=0; i<this.n; i++) {

where is the n from?

 

[brownfox]

Hi Bill, the query is working but I'm not able to display the received data. The problem is here:

for (i=0; i<this.n; i++) {
messages.text += this["products_image"+i];
}

Any ideas?

 

[brownfox]

No ignore that, the n comes from the php file. I am only returning one record so the for loop is not needed. It works! Brilliant, thanks again!