|
代码:
<script language="JavaScript">
function copyToList(from,to) //from表示:包含可选择项目的select对象名字 to表示:列出可选择项目的select对象名字
//你可以根据你的具体情况修改
{
fromList = eval('document.forms[0].' + from);
toList = eval('document.forms[0].' + to);
if (toList.options.length > 0 && toList.options[0].value == 'temp')
{
toList.options.length = 0;
}
var sel = false;
for (i=0;i<fromList.options.length;i++)
{
var current = fromList.options;
if (current.selected)
{
sel = true;
if (current.value == 'temp')
{
alert ('你不能选择这个项目!');
return;
}
txt = current.text;
val = current.value;
toList.options[toList.length] = new Option(txt,val);
fromList.options = null;
i--;
}
}
}
function allSelect() //这是当用户按下提交按钮时,对列出选择的select对象执行全选工作,让递交至的后台程序能取得相关数据
{
List = document.forms[0].chosen;
if (List.length && List.options[0].value == 'temp') return;
for (i=0;i<List.length;i++)
{
List.options.selected = true;
}
}
function copyAll(from,to){
var fromList = eval('document.forms[0].' + from);
var toList = eval('document.forms[0].' + to);
if (toList.options.length > 0 && toList.options[0].value == 'temp')
{
toList.options.length = 0;
}
for (i=0;i<fromList.options.length;i++)
{
var current = fromList.options;
toList.options[toList.length] = new Option(current.text,current.value);
fromList.options = null;
i--;
}
}
function move(src, dest){
var index = src.selectedIndex;
if(index < 0) return;
var op = src.options[index];
var newOp = new Option(op.innerText, op.value);
dest.options.add(newOp);
src.remove(index);
}
</script>
<table border="0" align="center">
<form onSubmit="allSelect()">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td>
<select name="possible" size="20"
MULTIPLE width=200 style="width: 200px" ondblclick="move(this, document.all.chosen)">
<?php
if (mysql_connect('127.0.0.1','root','123')){
mysql_query("set names GBK;");
$query = "select * from oa.fieldinfo where tablename = '" . $_POST['sign'] . "'";// 从数据库中读取数据
if ($result=@mysql_query($query)){
$i=0;
while($rows=@mysql_fetch_array($result))
{
echo "<option value='$rows[fieldname]'>$rows[fieldcaption]</option>";
$rows_result[$i][0]=$rows[fielename];
$i++;
}
$num=$i-1;
mysql_free_result($result);
} else echo "执行SQL语句($query)失败:".mysql_error();
} else echo '数据库连接失败!';
?>
</select> </td>
<td><a href="javascript:copyToList('possible','chosen')">添加-></a><br>
<br>
<a href="javascript:copyAll('possible','chosen')">全部添加--></a>
<br><br>
</a><a href="javascript:copyToList('chosen','possible')"><-移除
</a><br><br> </a><a href="javascript:copyAll('chosen','possible')"><--全部移除</a>
<br></td>
<td>
<select name="chosen" size="20"
MULTIPLE width=200 style="width: 200px;" ondblclick="move(this, document.all.possible)">
</select> </td>
</tr> </form>
</table>
然后该如何POST右边框的值,下一页面如何接收?
请高手帮忙看看!
|