<?php
創(chuàng)新互聯(lián)專注于網(wǎng)站建設(shè),為客戶提供成都網(wǎng)站建設(shè)、成都網(wǎng)站設(shè)計(jì)、網(wǎng)頁設(shè)計(jì)開發(fā)服務(wù),多年建網(wǎng)站服務(wù)經(jīng)驗(yàn),各類網(wǎng)站都可以開發(fā),品牌網(wǎng)站建設(shè),公司官網(wǎng),公司展示網(wǎng)站,網(wǎng)站設(shè)計(jì),建網(wǎng)站費(fèi)用,建網(wǎng)站多少錢,價(jià)格優(yōu)惠,收費(fèi)合理。
for($i=0;$i<$num;$i++)
{
$n=$i+1;
echo "<tr><td align=center id=th3>$n";
$idd='stt_'.$i ;
echo "<input type=text name=kname[$i] value='$kname[$i]' placeholder='單位檢索' class='stt' id=\"$idd\" ></input>";
$add='add_'.$i ;
echo "<td><center><input type=text name=acc_name1[$i] value='$acc_name1[$i]' size=30></td>
<td><center><input type=text name=amt1[$i] value='$amt1[$i]' class='add' id=\"$add\" size=10></td>";
$id1='user_'."$i";
echo "<td ><select name=user[$i] id=\"$id1\">
</select>";
echo"</tr>";
}
echo "</table>";
?>
<script type="text/javascript">
$(".sty").change(function() {
var inno = this.value;
var next = this.id.split('_')[1];
$.ajax({
type:'post',
url:"find_user.php?"+ Math.round(Math.random()*100),
data:{"inno":inno},
contentType: "application/x-www-form-urlencoded; charset=utf-8",
success:function(data) {
data = eval('('+data+')');
$("#user_"+next).empty();
for(i=0;i<data.length;i++){
$("<option></option>").val(data[i].empl).text(data[i].empl+'-'+data[i].name+'-'+data[i].dep).appendTo($("#user_"+next));
}
},
error:function() { alert("error"); }
});
});
</script>
//find_user.php
<?php
require_once('/php/public/id.inc');
require_once('/php/public/opendb.inc');
require("/php/public/power.inc");
header("Content-type: text/html;charset=utf-8");
function field_ora($sql) {
global $dbhUTF;
$stmt = $dbhUTF->prepare("$sql");
if ($stmt->execute()) {
return $stmt->fetch();
}
}
$inno=$_POST[inno];
$sql_exx="select depart_no from acc_gl_depart where acc_depart_no='$inno'";
$sql_exp=$dbhUTF->prepare($sql_exx);
$sql_exp->execute();
list($dept_clear)=$sql_exp->fetch();
if($dept_clear=='516000'){
$sql4="select employee_no,name,get_depart(employee_no)
from employee
where depart_no ='$dept_clear' and lead_code='20' ";
$sql4_exe=$dbhUTF->prepare($sql4);
$sql4_exe->execute();
$i=0;
while (list($employee_no,$name,$dept_no)=$sql4_exe->fetch()){
#echo "$employee_no-$name-$dept_no";
$a[$i]=array('empl'=>$employee_no,'name'=>$name,'dep'=>$dept_no);
$i++;
}
}
elseif($dept_clear=='300001' or $dept_clear=='300002' or $dept_clear=='300003' or $dept_clear=='300004'){
$dep_no3=substr($dept_clear,0,2);
$sql4="select employee_no,name(employee_no),get_depart(employee_no)
from psm_double_work
where depart_no like '$dep_no3%'";
$sql4_exe=$dbhUTF->prepare($sql4);
$sql4_exe->execute();
$i=0;
while (list($employee_no,$name,$dept_no)=$sql4_exe->fetch()) {
#echo "$employee_no-$name-$dept_no";
$a[$i]=array('empl'=>$employee_no,'name'=>$name,'dep'=>$dept_no);
$i++;
}
}
ELSE if($dept_clear=='J11040'){
$sql4="select employee_no,name,get_depart(employee_no)
from employee
where depart_no ='$dept_clear' and lead_code='50'";
$sql4_exe=$dbhUTF->prepare($sql4);
$sql4_exe->execute();
$i=0;
while (list($employee_no,$name,$dept_no)=$sql4_exe->fetch()){
#echo "$employee_no-$name-$dept_no";
$a[$i]=array('empl'=>$employee_no,'name'=>$name,'dep'=>$dept_no);
$i++;
}
}
else{
$dep_no1=substr($dept_clear,0,5)."0";
list($sqlcnt)=field_ora("select count(*) from psm_double_work where depart_no='$dep_no1'");
if ($sqlcnt>0)
{
$sql4="select employee_no,name(employee_no),get_depart(employee_no)
from psm_double_work
where depart_no='$dep_no1' order by lead_code desc ";
$sql4_exe=$dbhUTF->prepare($sql4);
$sql4_exe->execute();
$i=0;
while (list($employee_no,$name,$dept_no)=$sql4_exe->fetch()) {
# echo "$employee_no-$name-$dept_no";
$a[$i]=array('empl'=>$employee_no,'name'=>$name,'dep'=>$dept_no);
$i++;
}
}
else
{
$dep_no2=substr($dept_clear,0,3)."000";
list($sqlcnt2)=field_ora("select count(*) from psm_double_work where depart_no='$dep_no2'");
if ($sqlcnt2>0)
{
$sql4="select employee_no,name(employee_no),get_depart(employee_no)
from psm_double_work
where depart_no='$dep_no2'";
$sql4_exe=$dbhUTF->prepare($sql4);
$sql4_exe->execute();
$i=0;
while (list($employee_no,$name,$dept_no)=$sql4_exe->fetch()) {
#echo "$employee_no-$name-$dept_no";
$a[$i]=array('empl'=>$employee_no,'name'=>$name,'dep'=>$dept_no);
$i++;
}
}
else
{
$dep_no3=substr($dept_clear,0,2)."0000";
$sql4="select employee_no,name(employee_no),get_depart(employee_no)
from psm_double_work
where depart_no='$dep_no3'";
$sql4_exe=$dbhUTF->prepare($sql4);
$sql4_exe->execute();
$i=0;
while (list($employee_no,$name,$dept_no)=$sql4_exe->fetch()) {
# echo "$employee_no-$name-$dept_no";
$a[$i]=array('empl'=>$employee_no,'name'=>$name,'dep'=>$dept_no);
$i++;
}
list($employee_no,$name,$dept_no)=$sql4_exe->fetch();
if (!$employee_no) {
$sql5="select employee_no,name(employee_no),get_depart(employee_no)
from employee
where depart_no='$dept_clear'";
$sql5_exe=$dbhUTF->prepare($sql5);
$sql5_exe->execute();
$i=0;
while (list($employee_no,$name,$dept_no)=$sql5_exe->fetch()) {
#echo "$employee_no-$name-$dept_no";
$a[$i]=array('empl'=>$employee_no,'name'=>$name,'dep'=>$dept_no);
$i++;
}
}
}
}
}
echo json_encode($a);
?>
當(dāng)前標(biāo)題:Ajax+juqery+php之兩個(gè)selectoption控件傳值
轉(zhuǎn)載來源:http://muchs.cn/article14/ihdcde.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供營銷型網(wǎng)站建設(shè)、網(wǎng)站收錄、全網(wǎng)營銷推廣、網(wǎng)站建設(shè)、品牌網(wǎng)站建設(shè)、服務(wù)器托管
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)