如何将一组 Flex 复选框发送到 mysql 服务器? [英] How to send an array of Flex checkboxes to a mysql server?

问题描述

我将 FB 用于 PHP 4.5、ZendAMF，并且我读到我不需要使用 HTTPService 来完成我想做的事情.

I am using FB for PHP 4.5, ZendAMF, and I read that I do not need to use HTTPService for what I want to do.

表结构:

people: {pID, pName}
departments: {deptID, deptName}
people_departments: {pID, deptName}

我有一个稍微复杂的 flex 脚本 People.mxml.在 PersonAdd 状态，我有一个表单，用于将数据发送到 mysql 服务器.在这种形式中，我有一个中继器，它将为我的数据库中的每个部门创建一个复选框.当我单击添加"按钮时，我想将数据插入到 people 和 people_departments 表中.

I have a slightly complex flex script, People.mxml. In the PersonAdd state, I have a form which will be used to send data to the mysql server. In that form , I have a repeater that will create a checkbox for every department in my database. When I click the Add button, I want to insert data into the people and people_departments tables.

中继代码:

<mx:HBox>
  <mx:Repeater id="checkBoxRepeater"
               dataProvider="{getDepartmentsResult.lastResult}">
    <s:CheckBox id="deptCB"
                label="{checkBoxRepeater.currentItem.deptName}"/>
  </mx:Repeater>
</mx:HBox>

在我的 peopleService.php 文件中，我将有函数 createPerson(People $item,$deptArray)，在该函数中，我将执行两个 SQL 查询.一个查询将数据插入 People 表，另一个查询将数据插入 people_departments，其中 people_departments.pID = 新插入人员的 ID.

In my peopleService.php file, I will have the function createPerson(People $item,$deptArray) and inside that function, I will execute two SQL queries. One query will insert data into the People table and the other one will insert data into people_departments, with people_departments.pID = ID of newly inserted person.

如您所见，在上面的Repeater代码中，复选框作为属性标签.但是，当我将 dept_Array(ArrayCollection 类型)发送到服务器时，前者需要包含 deptID.我该怎么做?

As you can see, in the Repeater code above, the checkbox as the attribute label. However, when I send the dept_Array (of type ArrayCollection) to the server, the former needs to contain deptIDs. How can I do so?

这是我在 People.mxml 中创建 dept_Array 以发送到服务器的方式:

This is how I create the dept_Array in People.mxml to send to the server:

protected function button_clickHandler(event:MouseEvent):void
{
 var dept_array:Array=[];
 var idx:int;
 var getDepts_array:ArrayCollection=new ArrayCollection;
 getDepts_array=getDepartmentsResult.lastResult as ArrayCollection;
 var len:int=getDepts_array.length;
 for (idx=0; idx < len; idx++)
 {
  if (deptCB[idx].selected)
  {
   dept_array.push(deptCB[idx].label); //here I need to be able to push the ID of selected department.
  }
 }
}

我正在使用 s:Checkbox 并且我没有 data 属性.mx:Checkbox 可以，但我无法在我的项目中使用 mx:Checkbox 组件.

I am using an s:Checkbox and I do not have the data property. mx:Checkbox does but I cannot use the mx:Checkbox component in my project.

我将不胜感激.另外，有没有更好的方法来做到这一点?

I would appreciate any help. Also, is there is a better way to do this?

推荐答案

我通过使用属性automationName 发送与 itemName 相关的 ID 显示为复选框标签解决了这个问题.

I solved the problem by using the attribute automationName to send the ID related to the itemName displayed as the checkbox label.

请注意，火花复选框不存在 data 属性.如果您使用 mx:Checkbox，您就有数据，您可以使用它来发送链接到您的相关项目的 ID.

Note that the data attribute does not exist for the spark checkbox. If you use the mx:Checkbox, you have data, and you can use it to send the ID linked to your item in question.

<mx:Tile id="myTile">
  <mx:Repeater id="checkBoxRepeater"
               dataProvider="{getItemsResult.lastResult}"
               startingIndex="0">
  <s:CheckBox label="{checkBoxRepeater.currentItem.myItemName}"
              id="checkbox"
              automationName="{String(checkBoxRepeater.currentItem.myItemID)}"
              change="checkbox_changeHandler(event,event.currentTarget.repeaterIndex)"/>^
  </mx:Repeater>
</mx:Tile>

我知道这可能不是最好的解决方案，但我显然是第一个完成这项普通任务的人，这对我很有用.

I know that this may not be the best solution, but I am apparently the first person to do this commonplace task, and this worked for me.

然后，发送所选复选框的 ID 数组，我使用以下代码，在我的 submitBtn_clickHandler 函数中定义:

And then, the send the array of the IDs of the selected checkboxes, I use the following code, defined in my submitBtn_clickHandler function:

var items_array:Array=[];
var idx:int;
var getitems_array:ArrayCollection=new ArrayCollection;
getitems_array=getItemsResult.lastResult as ArrayCollection;
var len:int=getitems_array.length;
for (idx=0; idx < len; idx++)
  {
    var element:CheckBox=myTile.getElementAt(idx) as CheckBox;
    if (element.selected)
    {
      items_array.push(element.automationName);
    }
  }

然后我将 items_array 作为附加参数传递给我的 ItemService.createItem 函数.

I then pass items_array as an additional parameter to my ItemService.createItem function.

这篇关于如何将一组 Flex 复选框发送到 mysql 服务器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！