douci2516 2016-03-18 04:27
浏览 29

jQuery动态追加选择BOX来调用PHP的mysql函数

How to call PHP Function From jQuery

getstudent('"+$("#classroom").val()+"')

I sure MySQL had 4 records about classroomid='c1'

But I can't show 4 records to selectbox student

In HTML

<select  name="classroom" id="classroom" class="required"><option value="c1" selected>Room-1</option><option value="c2">Room-2</option></select>

In jQuery

$("#selectstudent").append("<tr><td><select name='student["+x+"]' id='student"+x+"'><?=getstudent('"+$("#classroom").val()+"')?></select>")</td></tr>").trigger('create');

In PHP

function getstudent($roomid){
  $query = "Select studentid,studentname From student Where classroomid='$roomid' Order By studentid";
  $sql=mysql_query($query);
  if (mysql_num_rows($sql)){
    while ($rs = mysql_fetch_assoc($sql)){
      $str = $str."<option value='".$rs["studentid"]."'>".$rs["studentname"]."</option>";
    }
  }else{
    $str="";
  }
  //test//
  $str = $str."<option value=''>".$query."</option>";
  $str = $str."<option value=''>".mysql_num_rows($sql)."</option>";
  return $str;
}

I only got "Select studentid,studentname From student Where classroomid='c1' Order By studentid" And "0" in selectbox student

If I delete "Where classroomid='$roomid'" from $query,It can show all data into selectbox student

I paste "Select studentid,studentname From student Where classroomid='c1' Order By studentid" to querywindow of phpMyAdmin and run,It's show 4 records

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 我要一个分身加定位两个功能的安卓app
    • ¥15 基于FOC驱动器,如何实现卡丁车下坡无阻力的遛坡的效果
    • ¥15 IAR程序莫名变量多重定义
    • ¥15 (标签-UDP|关键词-client)
    • ¥15 关于库卡officelite无法与虚拟机通讯的问题
    • ¥15 目标检测项目无法读取视频
    • ¥15 GEO datasets中基因芯片数据仅仅提供了normalized signal如何进行差异分析
    • ¥100 求采集电商背景音乐的方法
    • ¥15 数学建模竞赛求指导帮助
    • ¥15 STM32控制MAX7219问题求解答