switch not getting value
Posted on
16th Feb 2014 07:03 pm by
admin
what am i doing wrong?
i want to populate the country list according to the category
i want to switch in case CategoryID=1 and CatID2=2 in the country_list table
then call on "alpha" to populate the dropdown list via ajax
the form:
Code: <!--
The following file was created by Iwo Kadziela at TECHROAM: http://www.techroam.com
This file uses MySql database and AJAX to create autopopulating dynamic select boxes.
<html>
<head>
<script src="request.js"></script>
<script type="text/javascript">
function getfirst(dd1)
{
clearSelect = document.getElementById('thirdbox');
clearSelect.options.length = 1;
//above code clears the third select box when re-clicking the first select box
var idx = dd1.selectedIndex;
var first = dd1[idx].value;
var par = document.forms["theform"];
var parelmts = par.elements;
var prezsel = parelmts["secondbox"];
if (first != "Select Something One")
{
Http.get({
url: "./alpha.php?alpha=" + first + "%",
callback: fillPrez,
cache: Http.Cache.Get
}, [prezsel]);
}
}
function getsecond(dd1)
{
var idx = dd1.selectedIndex;
var second = dd1[idx].text;
var par = document.forms["theform"];
var parelmts = par.elements;
var prezsel = parelmts["thirdbox"];
if (second != "Select Something Two")
{
Http.get({
url: "./beta.php?state=" + second,
callback: fillPrez,
cache: Http.Cache.Get
}, [prezsel]);
}
}
function fillPrez(xmlreply, prezelmt)
{
if (xmlreply.status == Http.Status.OK)
{
var prezresponse = xmlreply.responseText;
var prezar = prezresponse.split("|");
prezelmt.length = 1;
prezelmt.length = prezar.length;
for (o=1; o < prezar.length; o++)
{
prezelmt[o].text = prezar[o];
prezelmt[o].value = prezar[o];
}
}
else
{
alert("Cannot handle the AJAX call.");
}
}
function getthird(dd1,dd2) {
var idx = dd1.selectedIndex;
var third = dd1[idx].text;
if (third != "Select The Final")
{
Http.get({
url: "./final.php?state=" + dd2 + "&city=" + third,
callback: getit,
cache: Http.Cache.Get
});
}
}
function getit(xmlreply){
if (xmlreply.status == Http.Status.OK)
{
document.getElementById("final").innerHTML= xmlreply.responseText;
}
else
{
alert("Cannot handle the AJAX call.");
}
}
</script>
<style>
body {
width:800px;
margin: 0px auto;
text-align:center;
}
p {display:inline;margin:20px;}
div {clear:both;width:800px;border:1px solid #999;padding:20px;margin:20px 0px 20px 0px;}
</style>
</head>
<body>
<form name="theform">
<p>
<select name="firstbox" size="13" style="position: relative; width: 215px;" onChange="getfirst(this);">
<option value="">Select Something One</option>
<?php
do {
?>
<option value="<?php echo $row_RsCategories['CategoryID']?>"><?php echo $row_RsCategories['CategoryName']?></option>
<?php
} while ($row_RsCategories = mysql_fetch_assoc($RsCategories));
$rows = mysql_num_rows($RsCategories);
if($rows > 0) {
mysql_data_seek($RsCategories, 0);
$row_RsCategories = mysql_fetch_assoc($RsCategories);
}
?>
</select>
</p>
<p>
<select name="secondbox" size="13" style="position: relative; width: 215px;" onChange="getsecond(this);">
<option>Select Something Two</option>
</select>
</p>
<p>
<select id="thirdbox" name="thirdbox" size="13" style="position: relative; width: 215px;" onChange="getthird(this, document.theform.secondbox.options[document.theform.secondbox.selectedIndex].value);">
<option>Select The Final</option>
</select>
</p>
</form>
<center>THE FINAL CONTENT PULLED FROM DATABASE</center>
<div id="final"></div>
</body>
</html>
<?php
mysql_free_result($RsCategories);
?>
alpha.php
Code: </php
$dbconnection = mysql_connect ("localhost", "root", "") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("international", $dbconnection) or die("Couldn't open database: ".mysql_error());
$alpha=$_GET['alpha'];
switch ($alpha)
{
case 1:
$result = mysql_query("SELECT CountryName from country_list WHERE CategoryID = '".$_GET['alpha']."'");
break;
case 2:
$result = mysql_query("SELECT CountryName from country_list WHERE CatID2 = '".$_GET['alpha']."'");
break;
while ($row = mysql_fetch_array($result)) {
echo "|" . $row['CountryName'];
}
?>
No comments posted yet
Your Answer:
Login to answer
97 
15 
Other forums
Code clarification
Hi
In the following code what could be the "search_print()" and where it could be
cookie problem
I hv a website url
In this site main menu functionality based on cookie when user click on parti
Getting the full city list from maxminds geoip database
I am suprised I can't find any references to this.
I have maxminds geoip lite installed and i
Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.newbie question about multiple queries
hi everyone,
I'm sorry to ask such a basic question, but I'm young and trying to learn php on my
defining website tags
Hi,
What would be the best way to define tags for my site, such as website title, url etc.Displaying data from database into a 2 dimensional table
Good day!
I'm a beginner in PHP and I'm not expecting a full coding for this qestion. I'm jus
Using loop to count number of entries
I'm writing a program that must ask user to type in numbers. After each entry, the program has to re
Facebook status update API
Hello,
So, I'm trying to create my first Facebook application with PHP.
Basic ideas fo
PHP Programming error. Please help!
Hi there,
Am making a website for a friend and have encountered a problem that i need fixing
