I want to keep the drop down box value

Expand Post »

Hey,
My code i pretty messed up at the moment but i was hoping someone could help me change it so that when the form is reloaded the 2nd time round that the value in the drop down menu that's selected stays after the reload.

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
<!doctype html public "-//w3c//dtd html 3.2//en">
 
<html>
 
<head>
 
<title>Postcode and Address Selection Test</title>
 
<SCRIPT language=JavaScript> //Reloads the page
function reload(form)
{
var val=form.postcode.value;
self.location='dd.php?postcode=' + val;
}
 
function reload2(form)
{
var val=form.postcode.value;
var val2=form.suburb.options[form.suburb.options.selectedIndex].value;
self.location='dd.php?postcode=' + val + '&suburb=' + val2;
}
 
</script>
</head>
 
<body>
<?
@$postcode=$_GET['postcode']; // Use this line or below line if register_global is off
@$suburb=$_GET['suburb']; 
 
 
/////// for suburb drop down list we will check if postcode is entered else we will display all the suburbs///// 
if(isset($postcode) and strlen($postcode) > 0){
$query=mysql_query("SELECT DISTINCT suburb FROM post2 where postcode=$postcode order by suburb"); //Table called POST2
}
 
////////// end of query for second subcategory drop down list box /////////////////////////////////////////////
 
echo "<form method=post name=f1 action='dd-check.php'>";//Goes to dd-check to check posted variables
 
//Page Reloads after 4 digits are entered///<<<<--------------POSTCODE FIELD-------<<<<<<<<<<<<<<
echo "Postcode: <input name='postcode' type=text onkeyup=\"if(this.value.length>3)reload(this.form);else return false;\" value=$postcode>";  
echo"<input value='Load Suburbs' type='button' onclick=\"reload(this.form)\"> Click to Load Suburbs for this Postcode.";
 
//////////////////Starting of suburb drop downlist///<<<<--------------SUBURB-------<<<<<<<<<<<<<
echo"<br><br>";
echo"Suburb: ";
echo "<select name='suburb' onchange=\"reload2(this.form)\"><option value='$suburb'>Select Suburb</option>"; // onchange=\"reload(this.form)\"
while($pop = mysql_fetch_array($query)) { 
if($pop['postcode']==@$suburb){
echo  "<option value='$suburb'>$pop[suburb]</option>";
}else{
echo "<option selected value='$suburb'>$pop[suburb]</option>";}
}
 
echo "</select>";
//////////////////  This will end the suburb drop down list ///////////
 
 
//-----------------------------------------------
 
echo "<br><br><input type=submit value=Submit>";
echo "</form>";
?>
</body>
<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>

<title>Postcode and Address Selection Test</title>

<SCRIPT language=JavaScript> //Reloads the page
function reload(form)
{
var val=form.postcode.value;
self.location='dd.php?postcode=' + val;
}

function reload2(form)
{
var val=form.postcode.value;
var val2=form.suburb.options[form.suburb.options.selectedIndex].value;
self.location='dd.php?postcode=' + val + '&suburb=' + val2;
}

</script>
</head>

<body>
<?
@$postcode=$_GET['postcode']; // Use this line or below line if register_global is off
@$suburb=$_GET['suburb']; 


/////// for suburb drop down list we will check if postcode is entered else we will display all the suburbs///// 
if(isset($postcode) and strlen($postcode) > 0){
$query=mysql_query("SELECT DISTINCT suburb FROM post2 where postcode=$postcode order by suburb"); //Table called POST2
}

////////// end of query for second subcategory drop down list box /////////////////////////////////////////////

echo "<form method=post name=f1 action='dd-check.php'>";//Goes to dd-check to check posted variables

//Page Reloads after 4 digits are entered///<<<<--------------POSTCODE FIELD-------<<<<<<<<<<<<<<
echo "Postcode: <input name='postcode' type=text onkeyup=\"if(this.value.length>3)reload(this.form);else return false;\" value=$postcode>";  
echo"<input value='Load Suburbs' type='button' onclick=\"reload(this.form)\"> Click to Load Suburbs for this Postcode.";

//////////////////Starting of suburb drop downlist///<<<<--------------SUBURB-------<<<<<<<<<<<<<
echo"<br><br>";
echo"Suburb: ";
echo "<select name='suburb' onchange=\"reload2(this.form)\"><option value='$suburb'>Select Suburb</option>"; // onchange=\"reload(this.form)\"
while($pop = mysql_fetch_array($query)) { 
if($pop['postcode']==@$suburb){
echo  "<option value='$suburb'>$pop[suburb]</option>";
}else{
echo "<option selected value='$suburb'>$pop[suburb]</option>";}
}

echo "</select>";
//////////////////  This will end the suburb drop down list ///////////


//-----------------------------------------------

echo "<br><br><input type=submit value=Submit>";
echo "</form>";
?>
</body>

Thankyou,
Billy

Last edited by BillyMako; Aug 9th, 2008 at 11:24 am.

Similar Threads

assign database value as selected value in a drop down box in PHP
resultset from drop down box in JSP
Content Changes across pages via Drop-Down Box in ASP.NET
Drop down box won't shut off video on reverse in IE in JavaScript / DHTML / AJAX
Drop down box not working in ASP.NET

BillyMako

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

16 posts
since Jan 2008

Permalink

Aug 11th, 2008

Re: I want to keep the drop down box value

First, the form seems to be submitting as soon as I enter the fifth value in postcode? Not sure you want this behavior, but maybe you do, but it feels a little out of control to the user.

I think I would test when you are writing the <option> tags for the drop down if the item has been selected (submitted) before and do something like this...

JavaScript / DHTML / AJAX Syntax (Toggle Plain Text)
<?php
@suburb = $_POST['suburb'];
 
... more code goes here ...
 
while($pop = mysql_fetch_array($query)) { 
  $selected = ( $pop['postcode'] == $suburb ) ? ' selected' : '';
  echo  "<option value=\"$suburb\"$selected>$pop[suburb]</option>";
}
?>
<?php
@suburb = $_POST['suburb'];

... more code goes here ...

while($pop = mysql_fetch_array($query)) { 
  $selected = ( $pop['postcode'] == $suburb ) ? ' selected' : '';
  echo  "<option value=\"$suburb\"$selected>$pop[suburb]</option>";
}
?>

Shouldn't you be using POST methods for form submission? Why try and use both?
Why are you using the $suburb value for all of your option values?

Anyway, what I've got here is a quick test to see if the previously posted value is the same as the value you are writing to the current drop down option -- if it is it populates $selected with the string ' selected', and if not it populates it with an empty string ''

I don't know for certain -- looking at your page code -- that $pop['postcode'] is the correct value to compare to the option values, but something will be and then this should work.

Good luck

Last edited by langsor; Aug 11th, 2008 at 4:46 am.

langsor

Reputation Points: 30

Solved Threads: 36

Posting Whiz

Offline

389 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in JavaScript / DHTML / AJAX Forum Timeline: Filtered search function on a website

Next Thread in JavaScript / DHTML / AJAX Forum Timeline: How to replace the div content onclick?

DaniWeb Message

Cancel Changes

User Name
Password