如何将一组 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屋!