問題描述
有人能告訴我這個網站上的示例代碼有什么問題嗎http://www.x-developer.com/php-scripts/loading-drop-downs-with-ajax-php-and-fetching-values-from-database-without-refreshing-the-page
Can some one tell me what's wrong with this example code on this site http://www.x-developer.com/php-scripts/loading-drop-downs-with-ajax-php-and-fetching-values-from-database-without-refreshing-the-page
基本上我做的和在 turorial 中完全一樣，問題是第二個下拉列表沒有顯示任何內容.我讀到有人忘記在頁面上添加一些 javascript 的評論之一.我該怎么做?
Basically i did exactly the same as in the turorial and the problem is that the 2nd drop down list is no showing anything. I read one of the comments that someone forgot to add in some javascript on the page. How do i do this?
我曾嘗試在該網站上發布一個問題，但一周以來沒有人回答，所以我來到了這里.
I have tried posting a question on that site but no one answered for a week now so I came here.
任何幫助將不勝感激.
這是我的 index.php 頁面
this is my index.php page
<?php
include('cn.php');
$sql_country = "SELECT * FROM COUNTRY";
$result_country = mysql_query($sql_country);
echo "<select name='country' onChange='get_cities(this.value)'>"; //get_cities is defined below
while($row_country = mysql_fetch_array($result_country))
{
echo "<option value='".$row_country['id']."'>".$row_country['country']."</option>";
}
echo "</select>";
echo "<select name='city' id='city'></select>"; //We have given id to this dropdown
?>
這是我的 get_cities.js 頁面
this is my get_cities.js page
function get_cities(country_id)
{
$.ajax({
type: "POST",
url: "cities.php", /* The country id will be sent to this file */
beforeSend: function () {
$("#city").html("<option>Loading ...</option>");
},
data: "country_id="+country_id,
success: function(msg){
$("#city").html(msg);
}
});
}
這是我的城市.php頁面
This is my cities.php page
<?php
include('cn.php');
// Code for cities.php
$country_id = $_REQUEST['country_id'];
$sql_city = "SELECT * FROM CITY WHERE country_id = '".$country_id."'";
$result_city = mysql_query($sql_city);
echo "<select name='city'>";
while($row_city = mysql_fetch_array($result_city))
{
echo "<option value='".$row_city['id']."'>".$row_city['city']."</option>";
}
echo "</select>";
?>
包含的cn.php"只是我與數據庫的連接.
The included 'cn.php' is just my connection to the database.
推薦答案
//Index.php
<?php
$conn = mysql_connect("localhost", "root", "root");
$db = mysql_select_db("country_example", $conn);
$sql_country = "SELECT * FROM country";
$result_country = mysql_query($sql_country);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Country List</title>
</head>
<body>
<?php
echo "<select name='country' onChange='get_cities(this.value)'>";
while($row_country = mysql_fetch_array($result_country))
{
echo "<option value='".$row_country['id']."'>".$row_country['country']."</option>";
}
echo "</select>";
echo "<div id='cityLayer'><select name='city' id='city'></select></div>";
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript">
function get_cities($country_id){
$.ajax({
url : "city.php?country_id="+$country_id,
cache : false,
beforeSend : function (){
//Show a message
},
complete : function($response, $status){
if ($status != "error" && $status != "timeout") {
$('#cityLayer').html($response.responseText);
}
},
error : function ($responseObj){
alert("Something went wrong while processing your request.
Error => "
+ $responseObj.responseText);
}
});
}
</script>
</body>
</html>
//City.php
<?php
$conn = mysql_connect("localhost", "root", "root");
$db = mysql_select_db("country_example", $conn);
$country_id = $_REQUEST['country_id'];
$sql_city = "SELECT * FROM cities WHERE country_id = '".$country_id."'";
$result_city = mysql_query($sql_city);
echo "<select name='city'>";
while($row_city = mysql_fetch_array($result_city))
{
echo "<option value='".$row_city['id']."'>".$row_city['city']."</option>";
}
echo "</select>";
?>
這篇關于ajax php 下拉列表的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！