想了解Ajax+juqery+php之两个selectoption控件传值的新动态吗？本文将为您提供详细的信息，我们还将为您解答关于ajax传两个参数到controller的相关问题，此外，我们还将为

想了解Ajax+juqery+php 之两个select option控件传值的新动态吗？本文将为您提供详细的信息，我们还将为您解答关于ajax传两个参数到controller的相关问题，此外，我们还将为您介绍关于ajax 获取 后台数据，前端 select option中显示出来、ajax动态生成select option、ajax异步获取数据，动态添加select标签中的option、javascript select options 排序(保持option 对象完整性)的新知识。

• Ajax+juqery+php 之两个select option控件传值（ajax传两个参数到controller）
• ajax 获取 后台数据，前端 select option中显示出来
• ajax动态生成select option
• ajax异步获取数据，动态添加select标签中的option
• javascript select options 排序(保持option 对象完整性)

Ajax+juqery+php 之两个select option控件传值（ajax传两个参数到controller）

<?PHP

for($i=0;$i<$num;$i++)

{

$n=$i+1;

echo "<tr><td align=center id=th2>$n";

$idd='stt_'.$i ;

echo "<input type=text name=kname[$i] value='$kname[$i]' placeholder='单位检索'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]'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,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,$dept_no)=$sql4_exe->fetch()) {

#echo "$employee_no-$name-$dept_no";

$a[$i]=array('empl'=>$employee_no,'dep'=>$dept_no);

$i++;

}

}

ELSE if($dept_clear=='J11040'){

$sql4="select employee_no,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,'dep'=>$dept_no);

$i++;

}

}

else{

$dep_no1=substr($dept_clear,5)."0";

list($sqlcnt)=field_ora("select count(*) from psm_double_work where depart_no='$dep_no1'");

if ($sqlcnt>0)

{

$sql4="select 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,$dept_no)=$sql4_exe->fetch()) {

# echo "$employee_no-$name-$dept_no";

$a[$i]=array('empl'=>$employee_no,'dep'=>$dept_no);

$i++;

}

}

else

{

$dep_no2=substr($dept_clear,3)."000";

list($sqlcnt2)=field_ora("select count(*) from psm_double_work where depart_no='$dep_no2'");

if ($sqlcnt2>0)

{

$sql4="select 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,$dept_no)=$sql4_exe->fetch()) {

#echo "$employee_no-$name-$dept_no";

$a[$i]=array('empl'=>$employee_no,'dep'=>$dept_no);

$i++;

}

}

else

{

$dep_no3=substr($dept_clear,2)."0000";

$sql4="select 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,'dep'=>$dept_no);

$i++;

}

list($employee_no,$dept_no)=$sql4_exe->fetch();

if (!$employee_no) {

$sql5="select 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,$dept_no)=$sql5_exe->fetch()) {

#echo "$employee_no-$name-$dept_no";

$a[$i]=array('empl'=>$employee_no,'dep'=>$dept_no);

$i++;

}

}

}

}

}

echo json_encode($a);

?>

ajax 获取 后台数据，前端 select option中显示出来

/*
*select_id select 的ID
*area_clsss 展示地名的class如span.a1中的a1
＊index 要默认select地区，避免默认一个城市
*/
  function make_select(select_id,area_clsss,index,type,tab_id){
     var $select = $('#'+select_id);
     $.ajax({url: 'get_report_city.PHP?date='+date,async: false,dataType: 'json',success: function (response) {
              $select.empty();
              if (response.status == true) {
                  $('span.'+area_clsss).text(response.area[index]);//默认表格展示第一个地区的数据
                  get_list(date,response.area[index],tab_id);
                      $.each(response.area,function (k,v) {
                        if(k==index){ 
                           var opt = new Option(v,v);//默认第一个  new Option(v,v,true)  chrome 不兼容！
                              $(opt).attr("selected","selected");//由于new Option(v,true)默认selected 不兼容chrome 采取的办法
                        }else{
                               var opt = new Option(v,v);
                          }
                               $select.append(opt);
                      });
                    }
            }});
  }