php select传参数,Ajax+juqery+php 之两个select option控件传值

阳光穿透心脏的1/2处 2022-11-13 09:28 127阅读 0赞

for($i=0;$i

$n=$i+1;

echo "

$n";

$idd='stt\_'.$i ;

echo "";

$add='add\_'.$i ;

echo "

$id1='user\_'."$i";

echo "

echo"

echo "";

$(".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

$("").val(data\[i\].empl).text(data\[i\].empl+'-'+data\[i\].name+'-'+data\[i\].dep).appendTo($("\#user\_"+next));

\},

error:function() \{ alert("error"); \}

\});

//find\_user.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);

php select传参数,Ajax+juqery+php 之两个select option控件传值

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 select option 根据后台值选中

相关获取select框的option值

相关 php select传参数,Ajax+juqery+php 之两个select option控件传值

相关转：jquery获得select option的值和对select option的操作

相关 jQuery获取select中所有option值

相关参数传值，传引用，传值，传指针

相关 jquery给select控件添加值的方法

相关 vue select传多个值，传多个值的方法

相关 jquery获得select option的值和对select option的操作

相关 select option两个问题求指教