RE: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-07 Thread Cor
: flashcoders-boun...@chattyfig.figleaf.com [mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Glen Pike Sent: dinsdag 6 september 2011 22:35 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP Hi, You can post multidimensional arrays

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-06 Thread Glen Pike
[mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Karl DeSaulniers Sent: dinsdag 6 september 2011 3:54 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP Hi Cor, Assuming you know enough php to set up the file for connecting to your

[Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Cor
I have a editable datagrid which I fill from mySQL with PHP. So far works good. But when items are changed (edit, added, deleted), I want them to save the data in my mySQL database. My values are in this multi-dimensional indexed array, which elements all contain a associative array:

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Karl DeSaulniers
Hi Cor, Assuming you know enough php to set up the file for connecting to your database, you can insert into your database with the following example. function addDescription($id, $name, $description) { //Escape any data being inserted $id = mysql_real_escape_string($id);

RE: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Cor
. Best regards, Cor van Dooren -Original Message- From: flashcoders-boun...@chattyfig.figleaf.com [mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Karl DeSaulniers Sent: dinsdag 6 september 2011 3:54 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Dave Watts
My problem is how to fetch my $_POST['VALUES'], which is the multi-dimensional  array: myArray[0[id]  myArray[0][name]  myArray[0][description] ... etc. I'm not a PHP expert, but in general you can't really submit an array as form data directly to a CGI program. You have to post

RE: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Cor
...@chattyfig.figleaf.com] On Behalf Of Dave Watts Sent: dinsdag 6 september 2011 5:27 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP My problem is how to fetch my $_POST['VALUES'], which is the multi-dimensional  array: myArray[0[id

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Karl DeSaulniers
...@chattyfig.figleaf.com] On Behalf Of Karl DeSaulniers Sent: dinsdag 6 september 2011 3:54 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP Hi Cor, Assuming you know enough php to set up the file for connecting to your database, you can

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Karl DeSaulniers
Of Dave Watts Sent: dinsdag 6 september 2011 5:27 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP My problem is how to fetch my $_POST['VALUES'], which is the multi-dimensional array: myArray[0[id] myArray[0][name] myArray[0

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Dave Watts
Do you mean that is it not possible to send an array from Flash to PHP in this way:        private function validateAndSend(e:MouseEvent):void {                form_variables = new URLVariables(); ...                form_variables.VALUES = myMultiDimArray;                

RE: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Cor
september 2011 6:07 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP I think you may be able to use the php split() or explode() on a array of data sent. but probably easier to split it up when gathering the info in flash. multiple small queries

RE: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Cor
: flashcoders-boun...@chattyfig.figleaf.com [mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Dave Watts Sent: dinsdag 6 september 2011 6:08 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP Do you mean that is it not possible

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Karl DeSaulniers
...@chattyfig.figleaf.com] On Behalf Of Dave Watts Sent: dinsdag 6 september 2011 5:27 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP My problem is how to fetch my $_POST['VALUES'], which is the multi-dimensional array: myArray[0[id

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Karl DeSaulniers
6 september 2011 6:07 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP I think you may be able to use the php split() or explode() on a array of data sent. but probably easier to split it up when gathering the info in flash. multiple

Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Karl DeSaulniers
...@chattyfig.figleaf.com] On Behalf Of Dave Watts Sent: dinsdag 6 september 2011 5:27 To: Flash Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP My problem is how to fetch my $_POST['VALUES'], which is the multi-dimensional array: myArray[0[id

RE: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP

2011-09-05 Thread Cor
Coders List Subject: Re: [Flashcoders] DataGrid: save multidim arrayfrom Flash to mySQL with PHP Correction... _parent.status = this.status; } }; mylv.sendAndLoad(http://yourwebsite.com/process.php;, myreply, POST); _parent.status = sending now