akremedy on formedit select multiple submit as POST or GET array

Wed, 22 Apr 2009 12:10:57 +0300

Thanks Tony, that helps explain the reference I saw in the docs to the comma separated string...it just wasn't looking like that was how the data was posting. I think I was dancing all around the simple solution here but didn't quite see it.

Thanks again!

tony on formedit select multiple submit as POST or GET array

Wed, 22 Apr 2009 06:44:28 +0300

Hello,

When we have a multiple select the data from select is posted separated with comma - i.e. key1,key2...

Here is what I do in PHP suppose this is a filed myname then

$lid = $_GET['myname'];

$selects = explode(",",$lid);

This will return array of type array('key1',key2,...);

Hope this helps

Regards

Tony

akremedy on formedit select multiple submit as POST or GET array

Mon, 20 Apr 2009 11:50:48 +0300

I'm looking for some advice on how to handle <select multiple> submits from jqGrid. I'm using formedit, version 3.5A2.

Again, this is a <select> field with multiple selections possible. I'm using GET now for easier troubleshooting...if it matters. Note that everything works fine when only one option is selected. When multiple options are selected, only the last one is actually recognized on the backend (insert into db via php). I see multiple selections get sent in the GET, but not as an array.

I have fixed this in two ways, but one breaks something else, and the other one requires a hack to grid.common.js.

Fix #1: in colModel, simply define the name of the <select> field as "name[]" - giving the square brackets makes it recognizable as an array. The problem is that I dynamically set <options> into this field, and the function doesn't like field names with "[" or "]".

Fix #2: in grid.common.js, in the createEl function, append the square brackets to the field name: options.name = options.name+"[]"; . This actually works just fine in all of the testing that I've done, but wondering if there is a better way.

For reference:

colModel:

{name:"username",index:"username",width:500,align:'left',editable:true,edittype:'select',editoptions:{title:'Use <ctrl> left-click to select multiple people.',fixedsize:5,multiple:true,value:":"}}

the function that sets "username":

beforeShowForm:function(formid){
    $.ajax({
        url:".assets/admin_funcs.php?oper=selpplsel&fid="+fid+"&lid="+row_id,
        datatype:"script",
        mtype:"GET",
        success:function(response) {
            $('#username',formid).children().remove().end().html(response);
        }
    })
},

the php insert:

$pid = $_GET['username'];
$lid = $_GET['lid'];
foreach ($pid as $p) {
$ins = "INSERT INTO people2links (pid,lid) VALUES('$p','$lid')";
@mysql_query($ins) or die("error".mysql_error());
}

Thanks in advance,

Adam

jQuery Grid Plugin - jqGrid - Topic: formedit select multiple submit as POST or GET array

akremedy on formedit select multiple submit as POST or GET array

tony on formedit select multiple submit as POST or GET array

akremedy on formedit select multiple submit as POST or GET array