个人中心
gpt4 book ai didi

php - 从数据库中拉出的级联下拉框

转载 作者：搜寻专家 更新时间：2023-10-31 22:13:14 25 4
gpt4 key购买 nike

我正在尝试使用 php 和 ajax 制作两个从数据库填充的下拉框。第一个下拉框只有一个选择，但是当您选择它时，它应该填充第二个下拉框，其中包含从数据库中提取的我学校的不同部门。选择一个部门时，该部门的所有类(class)都应显示在第三个下拉框中。现在我只是想让下拉框包含所有要填充的部门，当你点击它时它现在不会填充任何东西。我认为在下拉框中写入部门名称的循环存在问题。这是我的代码

索引.php

<html>
    <head>
        <meta http-equiv="Content-Type" 
            content="text/html; charset=iso-8859-1">
        <script language="javascript" type="text/javascript">

            function getXMLHTTP() { //function to return the xml http object
                var xmlhttp=false;    
                try{
                    xmlhttp=new XMLHttpRequest();
                }
                catch(e)    {        
                    try{            
                        xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
                    }
                    catch(e){
                        try{
                            xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
                        }
                        catch(e1){
                            xmlhttp=false;
                        }
                    }
                }

                return xmlhttp;
            }

            function getDept() {        

                var strURL="findDept.php";
                var req = getXMLHTTP();

                if (req) {

                    req.onreadystatechange = function() {
                        if (req.readyState == 4) {
                            // only if "OK"
                            if (req.status == 200) {                        
                                document.
                                    getElementById("deptdiv").
                                        innerHTML=req.responseText;
                            } else {
                                alert("There was a problem " +
                                    "while using XMLHTTP:\n" + req.statusText);
                            }
                        }                
                    }            
                    req.open("GET", strURL, true);
                    req.send(null);
                }        
            }
            function getCourse(deptId) {        
            var strURL="findCourse.php?dept="+deptId;
            var req = getXMLHTTP();

            if (req) {
                req.onreadystatechange = function() {
                        if (req.readyState == 4) {
                            // only if "OK"
                            if (req.status == 200) {                        
                                document.
                                    getElementById('coursediv').
                                        innerHTML=req.responseText;
                            } else {
                                alert("There was a problem " +
                                    "while using XMLHTTP:\n" + req.statusText);
                            }
                        }                
                    }            
                    req.open("GET", strURL, true);
                    req.send(null);
                }
            } 
        </script>
    </head>
    <body bgcolor= 'red' >
        <p>
            <font size="8" face="arial" 
                color="black">WELCOME TO SCHEDULE BUILDER</font>
        </p>
        <form method="post" action="" name="form1">
            <table width="60%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                    <td width = "150">Semester</td>
                    <td width="150">
                        <select name="semester onChange="getDept()">
                            <option value="">Select Semester</option>
                            <option value ="1">Spring 2012</option>
                        </select>
                    </td>
                </tr>
                <tr style="">
                    <td>Department</td>
                    <td >
                        <div id="deptdiv">
                            <select name="department">
                                <option>Select Department</option>
                            </select>
                        </div>
                    </td>
                </tr>
                <tr style="">
                    <td>Course</td>
                    <td >
                        <div id="coursediv">
                            <select name="course">
                                <option>Select Department First</option>
                            </select>
                        </div>
                    </td>
                </tr>
                <tr>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                </tr>
                <tr>
                <td>&nbsp;</td>
                <td>&nbsp;</td>
                </tr>
            </table>
        </form>
    </body>
</html>

查找部门.php

<?
    $link = mysql_connect("sql2.njit.edu", "sk442_proj", "jZ1MOA0X");
    if (!link) {
        die('Could not connect: ' . mysql_error());
    }
    mysql_select_db("sk442_proj");
    $query="SELECT abbrev FROM department";
    $result=mysql_query($query);
?>
<select name="department" onchange="getCourse(this.value)">
    <option>Select Department</option>
<? while($row=mysql_fetch_array($result)) { ?>
    <option value=$row['abbrev']><?=$row['abbrev']?></option>
<? } ?>
</select>

最佳答案

这是我使用的动态下拉列表，也许它会有所帮助:

主.php

include('pla2.php');
<script>
$(document).ready(function() {
    $('#wait_1').hide();
    $('#drop_1').change(function(){
      $('#wait_1').show();
      $('#result_1').hide();
      $.get("pla2.php", {
        func: "drop_1",
        drop_var: $('#drop_1').val()
      }, function(response){
        $('#result_1').fadeOut();
        setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
      });
        return false;
    });
});


function finishAjax(id, response) {
  $('#wait_1').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
} 
</script>
<select name="drop_1" id="drop_1">

      <option value="" selected="selected" disabled="disabled">Select a Category</option>

      <?php getTierOne(); ?>

    </select> 

    <span id="wait_1" style="display: none;">
    <img alt="Please Wait" src="ajax-loader.gif"/>
    </span>
    <span id="result_1" style="display: none;"></span> 
    <span id="wait_2" style="display: none;">
    <img alt="Please Wait" src="ajax-loader.gif"/>
    </span>
    <span id="result_2" style="display: none;"></span>

解放军2.php

function getTierOne()
{
    $catresult = mysql_query("SELECT DISTINCT category FROM categories") 
    or die(mysql_error());

      while($tier = mysql_fetch_array( $catresult )) 

        {
           echo '<option value="'.$tier['category'].'">'.$tier['category'].'</option>';
        }

}

//**************************************
//     First selection results     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}

function drop_1($drop_var)
{  
    include_once('db.php');
    $result = mysql_query("SELECT DISTINCT level1 FROM categories WHERE category='$drop_var'") 
    or die(mysql_error());

    echo '<select name="drop_2" id="drop_2">
          <option value=" " disabled="disabled" selected="selected">Choose one</option>';

           while($drop_2 = mysql_fetch_array( $result )) 
            {
              echo '<option value="'.$drop_2['level1'].'">'.$drop_2['level1'].'</option>';
            }

    echo '</select>';

关于php - 从数据库中拉出的级联下拉框，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/10113971/

25 4 0
文章推荐： php - 用 PHP 显示 MYSQL。想要将选定的行移动到另一个 sql 表并从现有表中删除
文章推荐： objective-c - AFNetworking pod install 使用未解析的标识符方法
文章推荐： php - 在 fetch_assoc 之前，mysql 中有多少行？
文章推荐： PHP领域模型
搜寻专家
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com