doumin1897 2016-12-10 03:03
浏览 28
已采纳

如何使用MySql从phy中的comboBox中获取选定的值?

I'm trying to get the selected value from my comboBox in PHP inside a while loop fetching MySQL results. How could I do it?

<?php
    include ("../conex.php");

    $conSql = ("CALL LISTAR_ASIGNATURAS()");
    $datos=mysqli_query($conex,$conSql);

    echo "<a style='font-size:16px;' href='../index.html'>Volver Atras</a>";
    echo " "; 
    echo "<select name='asigna' id='y' style='width:280px; height:23px;'>"; 
    echo "<option value='0'>Seleccione una Asignatura...</option>";

    while($fila=mysqli_fetch_assoc($datos)) {   
        echo "<option value='".$fila["cod_asignatura"]."'>".$fila["nom_asignatura"]. "</option>";
    }
    echo "</select>";
    echo " ";

    echo "<input type='submit' onclick=location.href='listarasig2.php?codA=".$selected_val."' value='Buscar'>";
?>
  • 写回答

1条回答 默认 最新

  • douyou2368 2016-12-10 03:46
    关注

    You could do something like this in jQuery.

    $('#testCombo').change(function() {
      var cboValue = this.value;
      var link;
      link = "location.href='listarasig2.php?codA=" + cboValue;
      $('#testSubmit').attr('onclick', link);
    });
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
    <select id="testCombo">
      <option value="0">test0</option>
      <option value="1">test1</option>
      <option value="2">test2</option>
      <option value="3">test3</option>
    </select>
    
    <input type="submit" id="testSubmit" />

    or if you still want to use PHP, you could do something like this.

    echo "<a style='font-size:16px;' href='../index.html'>Volver Atras</a>";
    echo " <form action='' method='get'>";
    echo "<select name='asigna' id='y' style='width:280px; height:23px;'>";
    echo "<option value='0'>Seleccione una Asignatura...</option>";
    while ($fila = mysqli_fetch_assoc($datos)) {
      echo "<option value='".$fila["cod_asignatura"].
      "'>".$fila["nom_asignatura"].
      "</option>";
    }
    echo "</select>";
    echo " ";
    echo "<input type='submit' value='Get Value'>";
    echo "</form>";
    echo "<input type='submit' onclick=location.href='listarasig2.php?codA=".$_GET['asigna'].
    "' value='Buscar'>";

    </div>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

    报告相同问题?

    悬赏问题

    • ¥20 C语言字符串不区分大小写字典排序相关问题
    • ¥15 关于#python#的问题:我希望通过逆向技术爬取1688搜索页下滑加载的数据
    • ¥15 学习C++过程中遇到的问题
    • ¥15 关于Linux的终端里,模拟实现一个带口令保护的屏保程序遇到的输入输出的问题!(语言-c语言)
    • ¥15 学习C++过程中遇到的问题
    • ¥15 请问,这个嵌入式Linux系统怎么分析,crc检验区域在哪
    • ¥15 二分类改为多分类问题
    • ¥15 Unity微信小游戏上调用ReadPixels()方法报错
    • ¥15 如何通过求后验分布求得样本中属于两种物种其中一种的概率?
    • ¥15 q从常量变成sin函数,怎么改写python代码?