HELP HELP HELP......why do my drop down list have no values when i try to submit

horse1970 · May 21, 2009

This is doing my head in. I have three drop down lists which are populated from a mysql database, and change when you select a value from the previous drop down list. They are a state, post code and suburb. So when you select state it gives you the post codes for the state and when you select the post code it gives you the suburbs. These are all generating fine but when i send the form for validation and submit it to send a email the id of the suburb field is saying that it is empty even though it contains data. My form is made up an index.php which contains the input, select and combos. The drop down lists for state, post code and suburb are generated from another php file. when it submits it uses a js file to validate the fields and then a mailer.php file to create the email message. the code for the each of the files is listed below. any help would be greatful appreciated am working to a deadline and everything is working without the drop down lists but as soon as i do it all falls apart

index.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Personal Finance</title>

.block { display: block; }

form.cmxform label.error { display: none; }

</style>

</head>

<body>

<p>

<label for="age">Are you over 18 years of age? *</label>

</select>

<label for="age" class="error">Please Select One</label>

</p>

<p>

<label for="borrow">How much money would you like to borrow? *</label>

</select>

<label for="borrow" class="error">Please Select One</label>

</p>

<p>

<label for="employ">Are you currently employed? *</label>

</select>

<label for="employ" class="error">Please Select One</label>

</p>

<p>

<label for="earn">How much do you earn each week (NET), this is after tax, including benefits? *</label>

</select>

<label for="earn" class="error">Please Select One</label>

</p>

<legend>Gender *</legend>

Male

</label>

Female

</label>

<label for="gender" class="error">Please select your gender</label>

</fieldset>

<p>

<label for="fname">First Name *</label>

</p>

<p>

</p>

<p>

</p>

<p>

<label for="phone">Phone Number *</label>

</p>

<p>

</p>

<?

echo "State : <font id=state><select>\n";

echo "<option value='0'>============</option> \n" ;

echo "</select></font>\n";

echo "Post Code : <font id=pcode><select>\n";

echo "<option value='0'>==== none ====</option> \n" ;

echo "</select></font>\n";

echo "Store : <font id=store><select>\n";

echo "<option value='0'>==== none ====</option> \n" ;

echo "</select></font>\n";

?>

function Inint_AJAX() {

try { return new ActiveXObject("Msxml2.XMLHTTP"); } catch(e) {} //IE

try { return new ActiveXObject("Microsoft.XMLHTTP"); } catch(e) {} //IE

try { return new XMLHttpRequest(); } catch(e) {} //Native Javascript

alert("XMLHttpRequest not supported");

return null;

};

function dochange(src, val) {

var req = Inint_AJAX();

req.onreadystatechange = function () {

if (req.readyState==4) {

if (req.status==200) {

document.getElementById(src).innerHTML=req.responseText;

}

};

req.open("GET", "locale.php?data="+src+"&val="+val);

req.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;charset=tis-620"); // set Header

req.send(null);

}

window.onLoad=dochange('state', -1);

</script>

<p>

<label for="other">Other Details / Comments</label>

</p>

<p>

<span class="error" style="display:none"> Please Enter Valid Data</span>

<span class="success" style="display:none"> form submit succesfully..........</span>

</p>

</fieldset>

</form>

</body>

</html>

locale.php (builds the drop down lists from a mysql database)

<?

$data=$_GET['data'];

$val=$_GET['val'];

$dbname = "pfc";

mysql_pconnect() or die ("Unable to connect to MySQL server");

if ($data=='state') {

echo "<select name=state id=state onChange=\"dochange('pcode', this.value)\">\n";

echo "<option value='0'>Choose a State</option>\n";

$result=mysql_db_query($dbname,"select id,description from states order by description");

while(list($id, $name)=mysql_fetch_array($result)){

echo "<option value=\"$id\" >$name</option> \n" ;

}

} else if ($data=='pcode') {

echo "<select name=pcode onChange=\"dochange('store', this.value)\">\n";

echo "<option value='0'>Select Post Code</option>\n";

$val2=$val;

$val = substr($val,0,2);

$result=mysql_db_query($dbname,"SELECT DISTINCT postcode FROM postcodes WHERE stateid = '$val2'ORDER BY postcode");

while(list($name)=mysql_fetch_array($result)){

echo "<option value=\"$name\" >$name</option> \n" ;

}

} else if ($data=='store') {

echo "<select name=store id=store>\n";

echo "<option value='0'>Select Store</option>\n";

$val2=$val;

$val = substr($val,0,4);

$result=mysql_db_query($dbname,"SELECT id, store FROM stores WHERE postcode= '$val2'ORDER BY store");

while(list($id, $name)=mysql_fetch_array($result)){

echo "<option value=\"$id\" >$name</option> \n" ;

}

echo "</select>\n";

?>

store.js

$(function() {

$(".submit").click(function() {

var age = $("#age").val();

var borrow = $("#borrow").val();

var employ = $("#employ").val();

var earn = $("#earn").val();

var haveyou = $("#haveyou").val();

var fname = $("#fname").val();

var lname = $("#lname").val();

var cemail = $("#cemail").val();

var selStore = $("#store").val();

var dataString = 'fname='+ fname + '&lname='+ lname + '&cemail=' + cemail + '&age=' + age + '&borrow=' + borrow + '&earn=' + earn + '&employ=' + employ + '&haveyou=' + haveyou + '&selStore=' + selStore;

alert (dataString);return false;

if(fname=='' || lname=='' || cemail=='' || other=='' || gender=='' || age=='' || borrow=='' || earn=='' || employ=='' || haveyou=='')

{

$('.success').fadeOut(200).hide();

$('.error').fadeOut(200).show();

}

else

{

$.ajax({

type: "POST",

url: "mailer.php",

data: dataString,

success: function(){

$('.success').fadeIn(200).show();

$('.error').fadeOut(200).hide();

}

});

}

return false;

});

mailer.php (creates the mail message and sends)

<?php

$dbname = "pfc";

mysql_pconnect() or die ("Unable to connect to MySQL server");

$result=mysql_db_query($dbname,"SELECT id, store, email, pfcemail FROM stores WHERE ID=11642 ORDER BY store");

while(list($id,$name,$email,$pfcemail)=mysql_fetch_array($result)) {

$var1=$email;

$var2=$pfcemail;

}

//build the mail message for the store

$msg="The details below have been submitted online at the pfc landing page from our digital advertising.\r\n";

$msg.="The sender has been advised that their details have been sent to your store.\r\n";

$msg.="Please contact this customer asap to follow up. Be sure to discuss their specific ID requirements with them.\r\n";

$msg.="All details as per online form:\r\n";

$msg.="\r\n";

$msg.="Name: ".$_POST["fname"]." ".$_POST["lname"]."\r\n";

$msg.="\r\n";

$msg.="Telephone: (".$_POST["areacode"].") ".$_POST["phone"]."\r\n";

$msg.="Email: ".$_POST["cemail"]."\r\n";

$msg.="State: ".$_POST["state"]."\r\n";

$msg.="Post Code: ".$_POST["pcode"]."\r\n";

$msg.="Store: ".$_POST["store"]."\r\n";

$msg.="Additional Information: ".$_POST["other"]."\r\n";

$msg.="\r\n";

$msg.="Are you over 18 years of age? ".$_POST["age"]."\r\n";

$msg.="How much money would you like to borrow? ".$_POST["borrow"]."\r\n";

$msg.="Are you currently employed? ".$_POST["employ"]."\r\n";

$msg.="How much do you earn each week? ".$_POST["earn"]."\r\n";

$msg.="Have you borrowed money from us before? ".$_POST["haveyou"]."\r\n";

//set up email for store

$recipient=$var1;

$subject="Personal Finance Lead";

$mailheaders="From: User<mail@domain.com> \r\n";

$mailheaders.="Reply-To: ME<mail@domain.com> \r\n";

$mailheaders.="Cc:" $var2" \r\n";

$mailheaders.="Bcc: mail@domain.com \r\n";

//send mail to Store

mail($recipient,$subject,$msg,$mailheaders);

mysql_close($con);

?>

BobcatM · May 21, 2009

Use the Code tags please.

horse1970 · May 21, 2009

What do you mena use the code tags

Ken2k7 · May 21, 2009

Wrap your code in

tags.

Like this -

<html>
....
</html>

And can you shrink down the code a bit? It's so long that most people don't wanna read all of it. Just post the relevant part(s).

horse1970 · May 21, 2009

I provided all the code so i didnt have to keep posting all the relevant code for someone that may have an answer. no idea how to edit the original post so will have to leave it as is. My problem is listed at top and the code is provided for someone to read if they think they may know what the solution is. sorry for being pedantic

neogemima · May 21, 2009

we are volunteering time. That's too much code for a free forum. Without looking through the code, what troubleshooting have you done? Echoed variables to be sure they contain values?

DarkSuperHero · May 21, 2009

ok i glanced... and happen to catch this...

<form class="cmxform" id="form1" method="get" action="">

whilst you are doing things like this...

$_POST["fname"]

you need to do things like this...

$_GET["fname"]

or change the form method.

Cheers!

Dathremar · May 21, 2009

What op said or you could also use:

$_REQUEST["variable_name"] which is substitute for both $_GET and $_POST

dreamwest · May 21, 2009

What op said or you could also use:

$_REQUEST["variable_name"] which is substitute for both $_GET and $_POST

If you know where the data is coming from, and the method used -then it's usually better to use $_POST or $_GET.

Otherwise, dont use $_REQUEST

another problem:

if you pass things in url (including session id), http referer will be leaked out when user click on a out linking url.

but if u hide it in <form action=post>, then this will not happend.

Sign In

HELP HELP HELP......why do my drop down list have no values when i try to submit

Recommended Posts

horse1970

Link to comment

Share on other sites

BobcatM

Link to comment

Share on other sites

horse1970

Link to comment

Share on other sites

Ken2k7

Link to comment

Share on other sites

horse1970

Link to comment

Share on other sites

neogemima

Link to comment

Share on other sites

DarkSuperHero

Link to comment

Share on other sites

Dathremar

Link to comment

Share on other sites

dreamwest

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information