[RESOLVED] Problem Refreshing Form and Retaining Values

pblancher

The form I am creating has a Country/Territory set of drop downs. The code currently has the main form, with a second form inside strictly for country. Country is populated from a database. When "Country" is changed (Javascript OnChange) it resubmits the form to itself to get the associated Territories populated.

This part works fine.

The problem is that some of the form has been filled out already and when it does its postback on itself, all of that form information is lost.

How do I retain this information when it does its postback.

Thanks in Advance,

Phil

thorpe

you will need to submit it back to the form when your OnChange is fired. this is a javascript issue really, but if you want to post some code someone might give it a shot, or you may have more luck in a javascript board.

Merve

I have no idea what the problem is until you post some code but...

<input type="text" name="blah" id="blah" value="<?php echo $_POST['blah']; ?>" />

If you post some code, board members may be able to help you further. We're not psychic; we don't know what you're talking about unless we have something to base our help on. 🙂

pblancher

First, Merve: Nice to see Chrétien still gets some mention 🙂

Second, the $_POST[] stuff worked.

My next problem has to do with the nested form:

I have a hidden field which is to fire the MySQL insert of the form on postback. However when I submit the second form (nested inside the first to trigger the Country/Territory posting) I cant get them to separate. Its either it will do the Insert, or If I zero out the trigger inside the second form, it messes up the submit of the final information.

Adding code here

<?php
include('../../_includes/functions.php');
$countryid=$_POST[countryid];
$added=false;
$is_admin=true;

if($_POST["dosave"]=="1"){
	$sql_insert="INSERT INTO `mi_store_operators` (`id`,`store_operator_name`,`corporate_business_num`,`corporate_name`,`store_name`,`store_street_address`,`store_city`,`store_prov_terr`,`store_phone_num`,`store_fax_num`,`store_email`,`store_category`,`store_sub_category`,`store_size`,`store_shelf_avail`,`store_monthly_charge`,`store_paypal_info`,`store_req_percentage`,`store_sus`,`store_photo_location`,`store_username`,`store_password`)";
	$sql_insert.="VALUES (";
	$sql_insert.="NULL,'".$_POST["store_operator_name"]."','".$_POST["corporate_business_num"]."','".$_POST["corporate_name"]."','".$_POST["store_name"]."','".$_POST["store_street_address"]."','".$_POST["store_city"]."','".$_POST["store_prov_terr"]."','".$_POST["store_phone_num"]."','".$_POST["store_fax_num"]."','".$_POST["store_email"]."','".$_POST["store_category"]."','".$_POST["store_sub_category"]."','".$_POST["store_size"]."','".$_POST["store_shelf_avail"]."','".$_POST["store_monthly_charge"]."','".$_POST["store_paypal_info"]."','".$_POST["store_req_percentage"]."','".$_POST["store_sus"]."','".$_POST["store_photo_location"]."','".$_POST["store_username"]."','".$_POST["store_password"]."'";
	$sql_insert.=");";

$open_db = new DB;
	mysql_query($sql_insert);

$newid = mysql_insert_id();
open_db.close;	

$added=true;
}
?>
<HTML>
<HEAD>
	<script language=javascript src=/_includes/date-picker.js></script>
	<script language="javascript">
	var tmpBuffer='';

function validation(){
	var msg='';
	if(document.forms[0].name.value==''){msg+='\n  -Name';}

	if(msg==''){
		return true;
	}else{
		alert('You forgot to fill the following fields:\n' + msg);
		return false;
		}
	}				 
</script>   
<link href="/_admin/style.css" rel="stylesheet" type="text/css">	
</HEAD>
<BODY bgcolor="#FFFFFF" topmargin=0 leftmargin=0 marginwidth=0 marginheight=0>
<FORM name="mainform" ACTION="add.php" method="POST"><!-- onSubmit="return validation();">-->
<input type="hidden" name="dosave" value="1">
<TABLE WIDTH="100%" align="center" border="0">
	<tr>
		<td align="center"><BR><font class="txtPageHdr">Adding a Store</font><BR><BR></td>
	</tr>
	<tr><td WIDTH="100%" align="center">
	<TABLE WIDTH="250" align="center" border="0">
	<?if(!$added){?>
		<TR>
			<TD align="left"><FONT class=txtReg>Store Operator Name&nbsp;</FONT><br>
			<input type="text" name="store_operator_name" value="<? echo $_POST[store_operator_name]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Store Corporate Business Number&nbsp;</FONT><br>
			<input type="text" name="corporate_business_num" value="<? echo $_POST[corporate_business_num]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Store Corporate Name&nbsp;</FONT><br>
			<input type="text" name="corporate_name" value="<? echo $_POST[corporate_name]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Store Store Name&nbsp;</FONT><br>
			<input type="text" name="store_name" value="<? echo $_POST[store_name]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Store Street Address&nbsp;</FONT><br>
			<input type="text" name="store_street_address" value="<? echo $_POST[store_street_address]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Store City&nbsp;</FONT><br>
			<input type="text" name="store_city" value="<? echo $_POST[store_city]; ?>" size="40"></td>
		</TR>
		<TR>			
			<TD align="left"><FONT class=txtReg>Store Country&nbsp;</FONT><br>
			<form action="add.php" method="post" name="getcountry">
				<select name="countryid" onchange="this.form.submit()"><? showcountry($countryid); ?>				
			</select>
			<input type="hidden" name="dosave" value="0">
			</form>
			<input name="store_country" type="hidden" value="<? echo $countryid; ?>">
			</td>
			<TD align="left"><FONT class=txtReg>Store Province/State&nbsp;</FONT><br>
			<select name="store_prov_terr"><? showprovince($countryid); ?>
			</select>
			</td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Store Phone Number&nbsp;</FONT><br>
			<input type="text" name="store_phone_num" value="<? echo $_POST[store_phone_num]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Store Fax Number&nbsp;</FONT><br>
			<input type="text" name="store_fax_num" value="<? echo $_POST[store_fax_num]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Store email address&nbsp;</FONT><br>
			<input type="text" name="store_email" value="<? echo $_POST[store_email]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Store Category&nbsp;</FONT><br>
			<input type="text" name="store_category" value="<? echo $_POST[store_category]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Store Sub-Category&nbsp;</FONT><br>
			<input type="text" name="store_sub_category" value="<? echo $_POST[store_sub_category]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Store Size (sq. feet)&nbsp;</FONT><br>
			<input type="text" name="store_size" value="<? echo $_POST[store_size]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Shelf Space available&nbsp;</FONT><br>
			<input type="text" name="store_shelf_avail" value="<? echo $_POST[store_shelf_avail]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Monthly Charge for Shelf Space&nbsp;</FONT><br>
			<input type="text" name="store_monthly_charge" value="<? echo $_POST[store_monthly_charge]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Paypal Link Address&nbsp;</FONT><br>
			<input type="text" name="store_paypal_info" value="<? echo $_POST[store_paypal_info]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Required percentage on sales&nbsp;</FONT><br>
			<input type="text" name="store_req_percentage" value="<? echo $_POST[store_req_percentage]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Shelf Unit Size&nbsp;</FONT><br>
			<input type="text" name="store_sus" value="<? echo $_POST[store_sus]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Store Photograph&nbsp;</FONT><br>
			<input type="file" name="store_photo_location" value="<? echo $_POST[store_photo_location]; ?>" size="40"></td>
		</TR>
		<TR>
			<TD align="left"><FONT class=txtReg>Username&nbsp;</FONT><br>
			<input type="text" name="store_username" value="<? echo $_POST[store_username]; ?>" size="40"></td>
			<TD align="left"><FONT class=txtReg>Password&nbsp;</FONT><br>
			<input type="password" name="store_password" value="<? echo $_POST[store_password]; ?>" size="40"></td>
		</TR>
 		<TR>		
			<TD align="center" colspan='2'><BR><INPUT TYPE="button" VALUE="  Back  " onClick="document.location='index.php';">&nbsp;&nbsp;&nbsp;<INPUT TYPE="SUBMIT" VALUE="   Add   "><BR><BR></TD>
		</TR>	
	<?}else{?>
		<TR>
			<TD colspan="2" align="center"><FONT class="txtReg"><b>Store added successfully !</b><br><br>What would you like to do ?<br><br></FONT></td>
		</TR>	
		<TR>		
			<TD colspan="2" align="center"><INPUT TYPE="button" VALUE="Manage Stores" onClick="document.location='index.php';">&nbsp;&nbsp;&nbsp;<INPUT TYPE="button" VALUE="Add Another Store" onClick="document.location='add.php';"><BR><BR></TD>
		</TR>
	<?}?>	
	</TABLE>
</td></tr></table>
</FORM>
</body>
</HTML>

Jasp182

Nesting forms sounds a little messy. There are plenty of ways to clean that up.

Instead of making the second form nested and submitting it when the select box changes, why not include it in the main form and use a JS function to change the values as needed.

So, instead of adding an additional hidden field called "dosave" (which is probably the reason for the conflict), you can stick to one "dosave" field and change it's value from the JS function. So, instead of onChange= form submit in the select box...onChange could call the JS function (and you can pass parameters if necessary). And that way you could also change the action parameter of the form as well and if everything in the JS function is successful, call form submit from the JS function (document.forms.(form name).submit()).

You might also want to validate your post vars before sticking them in your INSERT query. I always stuff my POST arrays in my own arrays and validate them - a good way to spoof-proof your forms as well as good practice to always check/validate your data.

pblancher

Can you suggest how to change the select box when it has to be populated from MySql.

The first function "showcountry" grabs the list of countries from a table in MySql
The second function (the reason for the postback) "showprovince" populates the state/province/territory based on the countryid passed to it. How do I get that to fire without PHP parsing it?