as3 -> php -> MySQL problem

[Beyond Flash]

I have a ton of information that I need to pass to a database using php and MySQL.

The problem I am having is when I use the following:
var saveVars:URLVariables = new URLVariables();
then save an array to the saveVars:
saveVars.ya = ya; //ya is an array
it puts each ya element in its own variable IE:
if there are 3 elements:
ya=element1&ya=element2&ya=element3

Is there a way to pass the array 'as is' to php? IE
ya=element1,element2,element3
??

Thanks,
Beyond Flash

[marlopax]

Option I

var separator:String="|";
var saveVars:URLVariables = new URLVariables();
saveVars.prop="VAR1";
saveVars.prop+=separator+"VAR2";
saveVars.prop+=separator+"VAR3";
saveVars.prop+=separator+"VAR4";

trace(saveVars.prop);
trace(saveVars.prop.split("|"));
//PHP side you can do whatever you like, as I shown in here, in FLASH.

Option II

var saveVars:URLVariables = new URLVariables();
saveVars.prop=new Array();
saveVars.prop.push("VAR1");
saveVars.prop.push("VAR2");
saveVars.prop.push("VAR3");
saveVars.prop.push("VAR4");

trace(saveVars.prop);
//PHP side you can do whatever you like, as I shown in here, in FLASH.

marlopax

[Beyond Flash]

That isn't quite what I am looking for.

The variables already are in an array.

Want I want to do is pass the entire array to the php so I can insert them into the database as it.

In other words if there is an array in flash as so:

var myArray = new Array();
myArray = 2,3,4,5,5,6;
trace(myArray);

The output is:
2,3,4,5,5,6

I want to take that array and put it into a MySQL field as
2,3,4,5,5,6

Is this possible?

[marlopax]

What is in your php side and how do you setup the database?

And how do you want it back into flash?




marlopax

[Beyond Flash]

I am just receiving the posted variables and putting them into the database.

I have to keep the indexes in the correct spots because I have multiple variables which are arrays and not all array elements have data in them (some are undefined).

IE:

var ya:Array =   new Array( , , ,2, 5, 3, 2)
var ya2:Array = new Array(2, ,4,2, ,)

I would like to post it to the PHP script like flash traces the array ie trace(ya)

I would also like to insert it into the ya field of the database the same way.

This way, when I bring it back into flash, I will be able to bring the array into flash like it was submitted.

[marlopax]

var ya:Array = new Array( , , ,2, 5, 3, 2)
var ya2:Array = new Array(2, ,4,2, ,)

How do you create this type of data in an Array? Are those are String? Or int?

What is the problem you are having right now? What Error or Warning you are having?



marlopax

[Beyond Flash]

The values in the array are ints

I am not getting any error messages.

When I attempt to post to the php script and it puts the data in the database, it only inserts the LAST element from the array.

[arkitx]

Post your PHP code and MySQL structure. including AS3 code.


arkitx