Form reloads

[aoneill]

After updating my database the form reloads. I need it to load a THANK YOU! html file only. I'm not sure if I'm using action="<?php echo $_SERVER['PHP_SELF'];?>" correctly. Thank you!


<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<input type="hidden" name="user_id" value="<?php echo $row['user_id'];?>">
<table id="wrapper">
<tr align="center" bgcolor="#333333">
<td colspan="4"><p><span class="style7">Henry County RC Club<br>
P.O. Box 3268<br>
McDonough, GA. 30253-9998<br>
Membership / Renewal Application Form</span></p></td>
</tr>
<tr align="center" bgcolor="#333333">
<td colspan="4"><p><span class="style7">Please make the necessary changes and click UPDATE to complete the process.<br>
Fields marked * are required.</span></p></td>
</tr>
<tr bgcolor="#333333">
<td align="center"><span class="type style8">* First Name</span><span class="type style3"></span></td>
<td height="1"><input name="first_name" type="text" id="first_name" value="<?php echo $row['first_name'];?>" size="25" />
<td align="center" class="type style8">* Last Name</td>
<td height="1"> <input name="last_name" type="text" id="last_name" value="<?php echo $row['last_name'];?>" size="25" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" span class="style8">* Address</span></td>
<td colspan="3"><input name="address" type="text" id="address" value="<?php echo $row['address'];?>" size="30" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" span class="style8">Address 2</td>
<td colspan="3"> <input name="address_2" type="text" id="address_2" value="<?php echo $row['address_2'];?>" size="30" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* City</td>
<td> <input name="city" type="text" id="city" value="<?php echo $row['city'];?>" size="25" />
<td align="center" class="type style8">* State</td>
<td width="0"> <input name="state" type="text" id="state" value="<?php echo $row['state'];?>" size="15" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Zip</td>
<td colspan="3"> <input name="zip" type="text" id="zip" value="<?php echo $row['zip'];?>" size="10" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Daytime Phone</td>
<td> <input name="day_phone" type="text" id="day_phone" value="<?php echo $row['day_phone'];?>" size="12" /></td>
<td align="center" class="type style8">Evening Phone</td>
<td width="0"> <input name="night_phone" type="text" id="night_phone" value="<?php echo $row['night_phone'];?>" size="12" /></td>
</tr>
<tr bgcolor="#333333" >
<td align="center" class="type style8">Cell Phone</td>
<td colspan="3"> <input name="cell_phone" type="text" id="cell_phone" value="<?php echo $row['cell_phone'];?>" size="12" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Email</td>
<td> <input name="email" type="text" id="email" value="<?php echo $row['email'];?>" size="30"></td>
<td align="center" class="type style8">* AMA#</td>
<td width="0"> <input name="ama" type="text" id="ama" value="<?php echo $row['ama'];?>" size="15" /></td>
</tr>
<tr bgcolor="#333333">
<td colspan="4" align="right">
<input type="submit" name="submit" value="submit" /></td>

</tr>
</table>
</form>

<?php





if (isset($_POST['submit']))

{
$row = $_POST['user_id'];
$f_name = $_POST['first_name'];
$l_name= $_POST['last_name'];
$f_address= $_POST['address'];
$s_address= $_POST['address_2'];
$city= $_POST['city'];
$state= $_POST['state'];
$zip= $_POST['zip'];
$day_phone= $_POST['day_phone'];
$night_phone= $_POST['night_phone'];
$cell_phone= $_POST['cell_phone'];
$email= $_POST['email'];
$ama= $_POST['ama'];

$query = "UPDATE member_data SET first_name= '$f_name', last_name= '$l_name', address= '$f_address', address_2= '$s_address', city= '$city', state= '$state', zip= '$zip',
day_phone= '$day_phone', night_phone= '$night_phone', cell_phone= '$cell_phone', email= '$email', ama= '$ama' WHERE user_id= '$row'";



$result = mysql_query($query);


include '../member_update/app_received.html'; // load thank you page


}



?>

[shortj75]

instead of useing $_SERVER[PHP_SELF] i just have the the form action to the pagename (example form.php)


[code]
<form method="post" action="yourformpage.php">
<input type="hidden" name="user_id" value="<?php echo $row['user_id'];?>">
<table id="wrapper">
<tr align="center" bgcolor="#333333">
<td colspan="4"><p><span class="style7">Henry County RC Club<br>
P.O. Box 3268<br>
McDonough, GA. 30253-9998<br>
Membership / Renewal Application Form</span></p></td>
</tr>
<tr align="center" bgcolor="#333333">
<td colspan="4"><p><span class="style7">Please make the necessary changes and click UPDATE to complete the process.<br>
Fields marked * are required.</span></p></td>
</tr>
<tr bgcolor="#333333">
<td align="center"><span class="type style8">* First Name</span><span class="type style3"></span></td>
<td height="1"><input name="first_name" type="text" id="first_name" value="<?php echo $row['first_name'];?>" size="25" />
<td align="center" class="type style8">* Last Name</td>
<td height="1"> <input name="last_name" type="text" id="last_name" value="<?php echo $row['last_name'];?>" size="25" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" span class="style8">* Address</span></td>
<td colspan="3"><input name="address" type="text" id="address" value="<?php echo $row['address'];?>" size="30" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" span class="style8">Address 2</td>
<td colspan="3"> <input name="address_2" type="text" id="address_2" value="<?php echo $row['address_2'];?>" size="30" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* City</td>
<td> <input name="city" type="text" id="city" value="<?php echo $row['city'];?>" size="25" />
<td align="center" class="type style8">* State</td>
<td width="0"> <input name="state" type="text" id="state" value="<?php echo $row['state'];?>" size="15" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Zip</td>
<td colspan="3"> <input name="zip" type="text" id="zip" value="<?php echo $row['zip'];?>" size="10" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Daytime Phone</td>
<td> <input name="day_phone" type="text" id="day_phone" value="<?php echo $row['day_phone'];?>" size="12" /></td>
<td align="center" class="type style8">Evening Phone</td>
<td width="0"> <input name="night_phone" type="text" id="night_phone" value="<?php echo $row['night_phone'];?>" size="12" /></td>
</tr>
<tr bgcolor="#333333" >
<td align="center" class="type style8">Cell Phone</td>
<td colspan="3"> <input name="cell_phone" type="text" id="cell_phone" value="<?php echo $row['cell_phone'];?>" size="12" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Email</td>
<td> <input name="email" type="text" id="email" value="<?php echo $row['email'];?>" size="30"></td>
<td align="center" class="type style8">* AMA#</td>
<td width="0"> <input name="ama" type="text" id="ama" value="<?php echo $row['ama'];?>" size="15" /></td>
</tr>
<tr bgcolor="#333333">
<td colspan="4" align="right">
<input type="submit" name="submit" value="submit" /></td>

</tr>
</table>
</form>

<?php





if (isset($_POST['submit']))

{
$row = $_POST['user_id'];
$f_name = $_POST['first_name'];
$l_name= $_POST['last_name'];
$f_address= $_POST['address'];
$s_address= $_POST['address_2'];
$city= $_POST['city'];
$state= $_POST['state'];
$zip= $_POST['zip'];
$day_phone= $_POST['day_phone'];
$night_phone= $_POST['night_phone'];
$cell_phone= $_POST['cell_phone'];
$email= $_POST['email'];
$ama= $_POST['ama'];

$query = "UPDATE member_data SET first_name= '$f_name', last_name= '$l_name', address= '$f_address', address_2= '$s_address', city= '$city', state= '$state', zip= '$zip',
day_phone= '$day_phone', night_phone= '$night_phone', cell_phone= '$cell_phone', email= '$email', ama= '$ama' WHERE user_id= '$row'";



$result = mysql_query($query);


header("location: ../member_update/app_received.html");// redirect to  thank you page


}



?>
[/code]
and if you want to redirect them to the thankyou page you instead of trying to load it in within you form page you can change include to header("location: ../member_update/app_received.html")

[aoneill]

[!--quoteo(post=363563:date=Apr 11 2006, 03:47 AM:name=shortj75)--][div class=\'quotetop\']QUOTE(shortj75 @ Apr 11 2006, 03:47 AM) [snapback]363563[/snapback][/div][div class=\'quotemain\'][!--quotec--]
instead of useing $_SERVER[PHP_SELF] i just have the the form action to the pagename (example form.php)
[code]
<form method="post" action="yourformpage.php">
<input type="hidden" name="user_id" value="<?php echo $row['user_id'];?>">
<table id="wrapper">
<tr align="center" bgcolor="#333333">
<td colspan="4"><p><span class="style7">Henry County RC Club<br>
P.O. Box 3268<br>
McDonough, GA. 30253-9998<br>
Membership / Renewal Application Form</span></p></td>
</tr>
<tr align="center" bgcolor="#333333">
<td colspan="4"><p><span class="style7">Please make the necessary changes and click UPDATE to complete the process.<br>
Fields marked * are required.</span></p></td>
</tr>
<tr bgcolor="#333333">
<td align="center"><span class="type style8">* First Name</span><span class="type style3"></span></td>
<td height="1"><input name="first_name" type="text" id="first_name" value="<?php echo $row['first_name'];?>" size="25" />
<td align="center" class="type style8">* Last Name</td>
<td height="1"> <input name="last_name" type="text" id="last_name" value="<?php echo $row['last_name'];?>" size="25" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" span class="style8">* Address</span></td>
<td colspan="3"><input name="address" type="text" id="address" value="<?php echo $row['address'];?>" size="30" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" span class="style8">Address 2</td>
<td colspan="3"> <input name="address_2" type="text" id="address_2" value="<?php echo $row['address_2'];?>" size="30" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* City</td>
<td> <input name="city" type="text" id="city" value="<?php echo $row['city'];?>" size="25" />
<td align="center" class="type style8">* State</td>
<td width="0"> <input name="state" type="text" id="state" value="<?php echo $row['state'];?>" size="15" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Zip</td>
<td colspan="3"> <input name="zip" type="text" id="zip" value="<?php echo $row['zip'];?>" size="10" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Daytime Phone</td>
<td> <input name="day_phone" type="text" id="day_phone" value="<?php echo $row['day_phone'];?>" size="12" /></td>
<td align="center" class="type style8">Evening Phone</td>
<td width="0"> <input name="night_phone" type="text" id="night_phone" value="<?php echo $row['night_phone'];?>" size="12" /></td>
</tr>
<tr bgcolor="#333333" >
<td align="center" class="type style8">Cell Phone</td>
<td colspan="3"> <input name="cell_phone" type="text" id="cell_phone" value="<?php echo $row['cell_phone'];?>" size="12" /></td>
</tr>
<tr bgcolor="#333333">
<td align="center" class="type style8">* Email</td>
<td> <input name="email" type="text" id="email" value="<?php echo $row['email'];?>" size="30"></td>
<td align="center" class="type style8">* AMA#</td>
<td width="0"> <input name="ama" type="text" id="ama" value="<?php echo $row['ama'];?>" size="15" /></td>
</tr>
<tr bgcolor="#333333">
<td colspan="4" align="right">
<input type="submit" name="submit" value="submit" /></td>

</tr>
</table>
</form>

<?php
if (isset($_POST['submit']))

{
$row = $_POST['user_id'];
$f_name = $_POST['first_name'];
$l_name= $_POST['last_name'];
$f_address= $_POST['address'];
$s_address= $_POST['address_2'];
$city= $_POST['city'];
$state= $_POST['state'];
$zip= $_POST['zip'];
$day_phone= $_POST['day_phone'];
$night_phone= $_POST['night_phone'];
$cell_phone= $_POST['cell_phone'];
$email= $_POST['email'];
$ama= $_POST['ama'];

$query = "UPDATE member_data SET first_name= '$f_name', last_name= '$l_name', address= '$f_address', address_2= '$s_address', city= '$city', state= '$state', zip= '$zip',
day_phone= '$day_phone', night_phone= '$night_phone', cell_phone= '$cell_phone', email= '$email', ama= '$ama' WHERE user_id= '$row'";
$result = mysql_query($query);
header("location: ../member_update/app_received.html");// redirect to  thank you page
}
?>
[/code]
and if you want to redirect them to the thankyou page you instead of trying to load it in within you form page you can change include to header("location: ../member_update/app_received.html")
[/quote]


It worked! Thank You!!!