[RESOLVED] PHP and Javascript

ali_p

I'm sooo stuck on this problem I've stopped believing that it is possible, perhaps someone can help.

I have a three tiered dynamic drop down menu which is being populated from my database. (I'll post the code below) Its works with Javascript which tells it to reload the page when an option in the drop down is selected. This is all fine and works a treat.

My problem happens when I already have a variable in the address bar, for instance "?id=345" as you can image when the page is reloaded this variable is lost and the page makes no sense.

I would like to know how to keep my original "?id=345" and still have the page reload with the variables passed by the drop down menu.

Heres some code to make things clearer.
First the request from the DB for the drop down values:


/////// NEW THREE TIER DROP DOWN ///////////////////

///////// Getting the data from Mysql table for first list box//////////
$quer2=mysql_query("SELECT DISTINCT longhaulcountry_name,longhaulcountry_code FROM longhaul_countries order by longhaulcountry_name"); 
///////////// End of query for first list box////////////

/////// for second drop down list we will check if category is selected else we will display all the subcategory///// 
//$cat=$HTTP_GET_VARS['cat']; // This line is added to take care if your global variable is off
if(isset($country) and strlen($country) > 0){
$quer=mysql_query("SELECT DISTINCT region_code,country_code,region_name FROM regions where country_code = '$country' order by region_name"); 
}else{$quer=mysql_query("SELECT DISTINCT region_code,country_code,region_name FROM regions order by region_name"); } 
////////// end of query for second subcategory drop down list box ///////////////////////////


/////// for Third drop down list we will check if sub category is selected else we will display all the subcategory3///// 
//$cat3=$HTTP_GET_VARS['cat3']; // This line is added to take care if your global variable is off
if(isset($region) and strlen($region) > 0){
$quer3=mysql_query("SELECT DISTINCT locality_code, region_code,locality_name FROM locality where region_code='$region' order by locality_name"); 
}else{$quer3=mysql_query("SELECT DISTINCT locality_code, region_code,locality_name FROM locality order by locality_name"); } 
////////// end of query for third subcategory drop down list box ///////////////////////////

///////// END //////////////////////////////////////

Next the code for the drop down menus:


////////// Starting of first drop downlist /////////
echo "<select name='country' onchange=\"reload(this.form)\"><option value='$acc_country_code'>$temp</option>";
while($noticia2 = mysql_fetch_array($quer2)) {
if($noticia2['longhaulcountry_code']==@$country){echo "<option selected value='$noticia2[longhaulcountry_code]'>$noticia2[longhaulcountry_name]</option>"."<BR>";}
else{echo "<option value='$noticia2[longhaulcountry_code]'>$noticia2[longhaulcountry_name]</option>";}
}
echo "</select>";

////////////////// This will end the first drop down list ///////////

////////// Starting of second drop downlist /////////
echo "<select name='region' onchange=\"reload3(this.form)\"><option value='$acc_region_code'>$tregion_name</option>";
while($noticia = mysql_fetch_array($quer)) {
echo "<option value='$noticia[region_code]'>$noticia[region_name]</option>";
}
echo "</select>";
////////////////// This will end the second drop down list ///////////


//////////        Starting of third drop downlist /////////
echo "<select name='locality' ><option value='$acc_locality_code'>$tlocality_name</option>";
while($noticia = mysql_fetch_array($quer3)) { 
echo  "<option value='$noticia[locality_name]'>$noticia[locality_name]</option>";
}
echo "</select>";

And finally this is the Javascript that reloads the page. I'm not too sharp with JS but I was hoping that I could say something like :
var val3="<?print $acc_id;?>";

and incorporate it into the line whic has the self.location value.

<SCRIPT language=JavaScript>
function reload(form)
{

var val=form.country.options[form.country.options.selectedIndex].value;
self.location='editlonghaul_accomodation.php?country=' + val ;
}
function reload3(form)
{
var val=form.country.options[form.country.options.selectedIndex].value;
var val2=form.region.options[form.region.options.selectedIndex].value;

self.location='editlonghaul_accomodation.php?country=' + val + '&region=' + val2 ;
}

</script>

Anyway thats my problem , any help at all would be greatly appreciated.

Thanks

dougal85

"?id=345"

As you used in your example, is just information you want to send as a $_GET? Then you want to follow a link on another page and preserve this information?

Well, Can't you just add it to the link ur as well as the new information?

For example;
"?id=345&something=666"

Is that what you mean? or am i not understanding you correctly.

stolzyboy

what i'm assuming is he gets to the ?id=345 page... but when he's selecting the drop downs, it's submitting a form via javascript to repopulate the next drop down, etc...

so he wants to keep that id after the drop downs are selected

is that correct ali?

ali_p

Thats exactly it Stolzyboy! I need a way to preserve my "?id=345" and not loose it when my page reloads with the drop down menus. I need to pass php to javascript,... i think.

stolzyboy

you could always put the form action as action="page.php?id=345", of course you'd have to dynamically fill it, but i believe that should work... then you should still be able to get that variable with $_GET['id']

ali_p

Thanks stolzyboy.

Sorry i didn't explain that this ?id=345 is not necessarly always 345, its dynamic so it would depend on what the user has clicked on. So i can't hard code a 'id' number into the form. I think the only way would be to carry the 'id' to the javascript onload function somehow, but i don't know how to translate it .

stolzyboy

i didn't say hard code it, i said you'd have to dynamically fill it 😉

if they click a link with ?id=345 in it

you can do

<form action="page.php?id=<? echo $_GET['id']; ?>"> which will be <form action="page.phpid=345">

with a link of id=987

it'd be <form action="page.phpid=987">

and son on...

...and of course you should clean your variable... but that is the general idea

then once the form is submitted, you will still be able to get the id from $_GET['id']

ali_p

Thanks Stolzyboy,
I think i know what you are saying , however the action of my form is not reloading the page its the onchange=\"reload(this.form) which relies on javascript. And I can't just add the php <? echo $_GET['id']; ?> into it, it doesn't like it.

<SCRIPT language=JavaScript>
function reload(form)
{

self.location='editlonghaul_accomodation.php?country=' + val + '&region=' + val2 ;
}

</script>

stolzyboy

you should be able to "write" all the JS code with PHP, then the $_GET['id'] shouldn't be a problem

Eric_T

Here you go

test = '<?php echo($_Get[whatever];)?>'
Var new = test

ali_p

Thanks Eric, I modified my javascript to include the php (see below). Now its not reloading the page or giving me an error, have i put it in the right place??

<SCRIPT language=JavaScript>
function reload(form)
{
test = '<?php echo($_Get['acc_id'])?>'
Var new = test


var val=form.country.options[form.country.options.selectedIndex].value; 
self.location='editlonghaul_accomodation.php?acc_id=' + new + 'country=' + val ;
}
function reload3(form)
{
var val=form.country.options[form.country.options.selectedIndex].value; 
var val2=form.region.options[form.region.options.selectedIndex].value; 

self.location='editlonghaul_accomodation.php?country=' + val + '&region=' + val2 ;
}

</script>

stolzyboy

not sure if the JS ;'s will create parse error issues or not... it's untested so there may be parse errors and what not

<?php
echo "<SCRIPT language=JavaScript>
function reload(form)
{
var val=form.country.options[form.country.options.selectedIndex].value; 
self.location='editlonghaul_accomodation.php?acc_id=' + " . $_GET['acc_id'] . " + '&country=' + val ;
}
function reload3(form)
{
var val=form.country.options[form.country.options.selectedIndex].value;
var val2=form.region.options[form.region.options.selectedIndex].value;

self.location='editlonghaul_accomodation.php?acc_id=' + " . $_GET['acc_id'] . " + '&country=' + val + '&region=' + val2 ;
}
</script>";

ali_p

That works a treat!! Thats exactly what i was looking for. Thank you both for your help, I have learnt something new today 😃

stolzyboy

cool, glad i could help out

stolzyboy

Weedpacket

ali_p wrote:

test = '<?php echo($_Get['acc_id'])?>'
Var new = test

What is it I say about coding by cut-and-paste? :glare:

stolzyboy

Weedpacket wrote:
What is it I say about coding by cut-and-paste? :glare:

he cut-n-pasted mine 😉