Yes, you are right, I have entry only for Bangladesh, Spain and Turkey. Just as a test.
As you mentioned I have added another Combo. As I click on Country, 2nd Combo get changed, but doesn't show anything. I think, it cannot accessing the 'Combo2Conct.php' file. Could be there any quotation or symbol problem in my code. Full code as:
Code:
<script>
function run() {
var str = document.getElementById("Combo1").value;
document.getElementById("Text1").value = str;
(function($){
$.ajax({
url: 'http://raihans.co.uk/source/Combo2Conct.php',
data: 'Country_Name=' + str,
method: 'post',
success: function(result){
$('#Combo2').empty().append(result);
}
});
})(jQuery); }
</script>
<form method="post" action="http://raihans.co.uk/source/Combo2Conct.php"></form>
<select name="Combo1" id="Combo1" onchange="run()">
<option value="" selected>Select a country</option>
<?php $link = mysql_connect("Domain_Name","DB_User","DB_User_pwd");
if (!$link) { die('Could not connect to Database: ' . mysql_error());
}
mysql_select_db("DB_Name",$link);
$category = "SELECT Country_Name FROM Test_Country";
$query_result = mysql_query($category);
while($result = mysql_fetch_assoc($query_result)) { ?>
<option value = "<?php echo $result['Country_Name']?>"><?php echo $result['Country_Name']?></option>
<?php
} ?>
</select>
<select name="Combo2" id="Combo2">
<option value="" selected>Select a state</option></select>
TextBox1: <input type="text" id="Text1" placeholder="get value on option select"><br>
and Combo2Conct.php as:
PHP Code:
<?php
$CName=isset($_POST['Country_Name'])? $_POST['Country_Name'] : '';
if(!$CName){die();}
<?php $link = mysql_connect("Domain_Name","DB_User","DB_User_pwd");
if (!$link) { die('Could not connect to Database: ' . mysql_error());
}
mysql_select_db("DB_Name",$link);
$category = "SELECT State_Name FROM Test_State LEFT JOIN Test_Country USING (CountryID) WHERE Country_Name='$CName'";
$query_result = mysql_query($category);
while($result = mysql_fetch_assoc($query_result)) { ?>
<option value = "<?php echo $result['State_Name']; ?>"><?php echo $result['State_Name']; ?></option>
<?php
}
?>
Thanking you again.
Raihan
Bookmarks