87,989
社区成员
发帖
与我相关
我的任务
分享
<table class="tbl" border="0" cellpadding="0" cellspacing="0" width="100%" align="center" id="tbl1">
<thead>
<tr>
<th width="20%">Name(姓 名)</th>
<th width="20%">Title(職 位)</th>
<th width="25%">Responsible Depaartment責任部门</th>
<th width="17%">Extension(聯系電話)</th>
</tr>
</thead>
<tbody>
<?$newRows = 2;
if(count($tmpDataArray)>0){
foreach($tmpDataArray as $tmpData){
$newRows--;
$tmpDataArray2 = explode("::",$tmpData);?>
<tr>
<td align="center"><select id="tabData11[]" name="tabData11[]" onchange="getDetail(this.value)" style="width:90%">
<? $strSql = "SELECT Distinct T_Name FROM bit.cpardata ";
$query = $WORKFLOW->dbCon->getQuery($strSql);
while($rs = $WORKFLOW->dbCon->getData($query)){?>
<option value="<?=$rs['T_Name']?>"<?=$tmpDataArray2[0]==$rs['T_Name'] ? 'selected="selected"':''?>><?=$rs['T_Name']?></option><? }?>
</select> </td> ///选择值后,要得到对应的 tabData12[],tabData13[] ,tabData14[]
<td align="center"><input type="text" id="tabData12[]" name="tabData12[]" value="<?=$tmpDataArray2[1]?>" readonly="true" style="width:90%"></td>
<td align="center"><input type="text" id="tabData13[]" name="tabData13[]" value="<?=$tmpDataArray2[2]?>" readonly="true" style="width:90%"></td>
<td align="center"><input type="text" id="tabData14[]" name="tabData14[]" value="<?=$tmpDataArray2[3]?>" readonly="true" style="width:90%"></td>
</tr>
<? }
}
for($loop=0;$loop<$newRows;$loop++){?>
<tr>
<td align="center"><select id="tabData11[]" name="tabData11[]" onchange="getDetail(this.value)" style="width:90%">
<? $strSql = "SELECT Distinct T_Name FROM bit.cpar_data_detail ";
$query = $WORKFLOW->dbCon->getQuery($strSql);
while($rs = $WORKFLOW->dbCon->getData($query)){?>
<option value=<?=$rs['T_Name']?>><?=$rs['T_Name']?></option><? }?>
</select> </td> ///选择值后,要得到对应的 tabData12[],tabData13[] ,tabData14[]
<td align="center"><input type="text" id="tabData12[]" name="tabData12[]" readonly="true" style="width:90%"></td>
<td align="center"><input type="text" id="tabData13[]" name="tabData13[]" readonly="true" style="width:90%"></td>
<td align="center"><input type="text" id="tabData14[]" name="tabData14[]" readonly="true" style="width:90%"></td>
</tr>
<?}?>
</tbody>
</table>
function getDetail(val){
<? $strSql = " SELECT vcarNo,T_Name,T_title,T_area,T_Tel FROM bit.cpardata_detail Where T_Name ='".val."' ";
$query = $WORKFLOW->dbCon->getQuery($strSql);
$rs = $WORKFLOW->dbCon->getData($query); ?>
// document.getElementById("tabData12[]").value =<? $rs['T_title'] ?>;
// document.getElementById("tabData14[]").value =<? $rs['T_area'] ?>;
// document.getElementById("tabData15[]").value =<? $rs['T_Tel'] ?>;
}