有只小跳蛙
ajax.php<?php $link=mysqli_connect("localhost","root","123456"); mysqli_select_db($link,"demo"); error_reporting(0); $make =$_GET["make"]; $model = $_GET["model"]; $year = $_GET["year"]; $oem = $_GET["oem_number"]; $lug = $_GET["lug_number"]; $image = $_GET["lug_number"];if($make!=""){ $res = mysqli_query($link,"SELECT * FROM models WHERE make_id= $make"); echo "<select id='modeldd' onchange='change_model()'>"; echo "<option selected = '' disabled=''>";echo "Select Model";echo "</option>"; while($row=mysqli_fetch_array($res)) { echo "<option value = '$row[model_id]'>"; echo $row["model"]; echo "</option>"; } echo "</select>";}if($model!=""){ $res = mysqli_query($link,"SELECT * FROM year WHERE model_id= $model"); echo "<select id='yeardd' onchange='change_year()'>"; echo "<option selected = '' disabled=''>";echo "Select Year";echo "</option>"; while($row=mysqli_fetch_array($res)) { echo "<option value = '$row[year_id]'>"; echo $row["year"]; echo "</option>"; } echo "</select>";}if($year!=""){ $res = mysqli_query($link,"SELECT * FROM oem WHERE year_id= $year"); echo "<select id='oemdd' onchange='change_oem()'>"; echo "<option selected = '' disabled=''>";echo "Select OEM number";echo "</option>"; while($row=mysqli_fetch_array($res)) { echo "<option value = '$row[oem_id]'>"; echo $row["oem_number"]; echo "</option>"; } echo "</select>";}if($oem!=""){ $res = mysqli_query($link,"SELECT * FROM lug_num WHERE oem_id= $oem"); echo "<select id='lugdd' onchange='change_lug()'>"; echo "<option selected = '' disabled=''>";echo "Select lug number";echo "</option>"; while($row=mysqli_fetch_array($res)) { echo "<option value = '$row[lug_id]'>"; echo $row["lug_number"]; echo "</option>"; } echo "</select>";}if($lug!=""){ $res = mysqli_query($link,"SELECT * FROM fix_type WHERE lug_id= $lug"); echo "<select>"; echo "<option selected = '' disabled=''>";echo "Select fix type";echo "</option>"; while($row=mysqli_fetch_array($res)) { $test = $row["fix_name"]; echo "<option value = '$row[fix_id]'>"; echo $row["fix_name"]; echo "</option>"; } echo "</select>";}$img = ""if($image!=""){ $res = mysqli_query($link,"SELECT * FROM lug_num WHERE lug_id= $image"); $array = array(); ?><br><br><div id = img_lug><?php while($row=mysqli_fetch_array($res)) { $img = $row["image"]; //echo $img; ?><img src="<?php echo $img; ?>" width='200' height='200' /><?php } ?></div><?php } ?>索引.php<?php $link=mysqli_connect("localhost","root","123456"); mysqli_select_db($link,"demo");?><!DOCTYPE html><html><head> <title></title></head><body> <form name="form1" action="" method="post"> <table> <tr> <td>Select Make</td> <td><select id="makedd" onchange="change_make()"> <option>Select</option> <?php $res = mysqli_query($link,"SELECT * FROM `manufacturer`"); while($row=mysqli_fetch_array($res)) { ?> <option value="<?php echo $row["make_id"];?>"><?php echo $row["make"] ?></option> <?php } ?> </select></td> </tr> <tr> <td>Select Model</td> <td> <div id="model"> <select> <<option selected="" disabled="">Select Manufacturer</option> </select> </div> </td> </tr> <tr> <td>Select Year</td> <td> <div id="year"> <select> <option>Select Year</option> </select> </div> </td> </tr> </tr> <tr> <td>Select OEM Number</td> <td> <div id="oem"> <select> <option>Select OEM Number</option> </select> </div> </td> </tr> <tr> <td>Select lug Number</td> <td> <div id="lug"> <select> <option>Select Lug Number</option> </select> </div> </td> </tr> <tr> <td>Select Fix type</td> <td> <div id="fix" > <select> <option>Select Fix type</option> </select> </div> </td> </tr> <tr> <td>Image from lug</td> <td><div id="image"> </div> </td> </tr> </table> <?php include "ajax.php"; ?><img src="<?php include "ajax.php"; echo $img; ?>" width='200' height='200' /><?php ?> </form><script type="text/javascript">function change_make(){ var xmlhttp=new XMLHttpRequest(); xmlhttp.open("GET","ajax.php?make="+document.getElementById("makedd").value,false); xmlhttp.send(null); document.getElementById("model").innerHTML=xmlhttp.responseText;}function change_model() { var xmlhttp=new XMLHttpRequest(); xmlhttp.open("GET","ajax.php?model="+document.getElementById("modeldd").value,false); xmlhttp.send(null); document.getElementById("year").innerHTML=xmlhttp.responseText;}function change_year() { var xmlhttp=new XMLHttpRequest(); xmlhttp.open("GET","ajax.php?year="+document.getElementById("yeardd").value,false); xmlhttp.send(null); document.getElementById("oem").innerHTML=xmlhttp.responseText;}function change_oem() { var xmlhttp=new XMLHttpRequest(); xmlhttp.open("GET","ajax.php?oem_number="+document.getElementById("oemdd").value,false); xmlhttp.send(null); document.getElementById("lug").innerHTML=xmlhttp.responseText;}function change_lug() { var xmlhttp=new XMLHttpRequest(); xmlhttp.open("GET","ajax.php?lug_number="+document.getElementById("lugdd").value,false); xmlhttp.send(null); document.getElementById("fix").innerHTML=xmlhttp.responseText;}</script></body></html>