Form Submit - refresh page

[Cyberspace]

I have a form that adds records to a database, in my code i have a table above the form that displays the table information, i would like when the user submits the form that the page automatically displays the record and refreshes the page with the table updated with the record, can anyone provide some help on how to do this?

 

My code is:

 

<?php  
$WalkNo = $_GET['WalkNo'];

$WalkNo = mysql_real_escape_string($WalkNo);
$Venue = mysql_real_escape_string($Venue);
$WalkDate = mysql_real_escape_string($WalkDate);
$Leader = mysql_real_escape_string($Leader);

$account = mysql_fetch_array(mysql_query("SELECT * FROM walks WHERE WalkNo='$WalkNo'")); 


?> 
</table> 
<table class="join" cellspacing="0" width="861">
	<tr>
		<td class="Header">WalkNo</td>
		<td class="Body"><?php echo $account["WalkNo"]; ?></td>
	</tr>
	<tr>
		<td class="Header">Venue</td>
		<td class="Body"><?php echo $account["Venue"]; ?></td>  
	</tr>
	<tr>
		<td class="Header">WalkDate</td>
		<td class="Body"><?php echo $account["WalkDate"]; ?></td>
	</tr>
	<tr>
		<td class="Header">Leader</td>
		<td class="Body"><?php echo $account["Leader"]; ?></td>
	</tr>
</table>
<p> <hr class="hr_blue"/></p>

<font face="Arial" size="3"> Walk Participants</font>
<p></p>


<?php

$WalkNo = $_GET['WalkNo'];

$query = "SELECT w.WalkNo,
                 m.MemberRef,
                 m.Forename,
                 m.Surname,
                 w.DateJoined
          FROM members m,
               walker w
          WHERE w.MemberRef=m.MemberRef AND w.WalkNo='$WalkNo'";

$result = mysql_query($query) or die('Query error!<br />Error:' . mysql_error() . 'Query: <pre>' . $query . '</pre>');

if(mysql_num_rows($result) == 0)
{
     print "No Participants exist";
}
else{
?>
<table class="join" cellspacing="0" width="861">
  <tr>
<td class="Header">WalkNo</td>
<td class="Header">Member Ref</td>
<td class="Header">Forename</td>
<td class="Header">Surname</td>
<td class="Header">DateJoined</td>
  </tr>
<?php
    while ($account = @mysql_fetch_assoc($result))
    {
?>
  <tr>
<td class="Body"><?php echo $account["WalkNo"]; ?></td>
<td class="Body"><?php echo $account["MemberRef"]; ?></td>
<td class="Body"><?php echo $account["Forename"]; ?></td>
<td class="Body"><?php echo $account["Surname"]; ?></td>
<td class="Body"><?php echo $account["DateJoined"]; ?></td>
  </tr>

<?php 
}
}
?> 
</table>
<?php 


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

    $error_stat = 0; 
    $message = 0;  
    $MemberRef_message = '';  
    $Password_message = ''; 
    $Password2_message = ''; 
    $User_message = ''; 
    $Walk_message = ''; 
    $Add_message = '';

    $MemberRef = mysql_real_escape_string(stripslashes($_POST['MemberRef'])); 
    $Password = mysql_real_escape_string(stripslashes($_POST['Password'])); 
     
//Error checking   

// MemberRef Check)   
if (!$MemberRef) {  
//Set the error_stat to 1, which means that an error has occurred  
    $error_stat = 1;  

//Set the message to tell the user to enter a username  
    $MemberRef_message = '*Please enter MemberRef*';  
}  

else if (!ctype_digit($MemberRef)) {   
   $error_stat = 1;   
   $MemberRef_message .= '*MemberRef must be a number*';   
}  

if (!$Password) {  
//Set the error_stat to 1, which means that an error has occurred  
    $error_stat = 1;  

//Set the message to tell the user to enter a password  
    $Password_message = '*Please enter a Password*';  

} 



// Walker Check

if (isset($_POST['submit']) && $error_stat == 0) {  

$account = mysql_query("SELECT * FROM walker WHERE MemberRef='$MemberRef'"); 
$numrows = mysql_num_rows($account); //get rows returned 

if($numrows == 0) 
{  
    $error_stat = 1;  
    $Walk_message = '*Member Ref number does not exist*';  
}  


// MemberRef and Password Check

else if (isset($_POST['submit']) && $error_stat == 0) {  

$account = mysql_query("SELECT * FROM members WHERE MemberRef='$MemberRef' AND  Password='$Password'"); 
$numrows = mysql_num_rows($account); //get rows returned 

if($numrows == 0) 
{  
    $error_stat = 1;  
    $User_message = '*Incorrect Password*';  
} 



if (isset($_POST['submit']) && $error_stat == 0) {  

$account = mysql_query("SELECT * FROM walker WHERE MemberRef='$MemberRef' AND  WalkNo='$WalkNo'"); 
$numrows = mysql_num_rows($account); //get rows returned 

if($numrows == 1) 
{  
    $error_stat = 1;  
    $Walk_message = '*User is already on walk*';  
}  

      
if (isset($_POST['submit']) && $error_stat == 0) {  
   
   mysql_query("INSERT INTO walker (MemberRef, WalkNo, DateJoined) VALUES ('$MemberRef', '$WalkNo',NOW())");   
   echo "<h4>You has been successfully added to the walk program</h4>";
   }
}
} 
}
}
?>


<hr class="hr_blue"/></p><font face="Arial" size="3">Join Walk
</font><form method="post" class="addwalkerform" action=""> 
   
</font> 
<fieldset> 
<label for="MemberRef">MemberRef:</label>   
<input name="MemberRef" type="text" id="MemberRef" value="<?php echo $_POST['MemberRef']; ?>"/>  
<span class="redboldtxt"><?php echo "$MemberRef_message";?></fieldset></span>   
</fieldset> 

<fieldset> 
<label for="Password">Password:</label>   
<input name="Password" type="text" id="Password" value="<?php echo $_POST['Password']; ?>"/>  
<span class="redboldtxt"><?php echo "$Password_message";?></fieldset></span> 
<span class="redboldtxt"><?php echo "$Password2_message";?></fieldset></span> 

<fieldset>  
<p class="submit"><input type="submit" name="submit" value="Join Walk" /> <span class="redboldtxt"><?php echo "$User_message";?></fieldset></span>
<p></p>

<span class="redboldtxt"><?php echo "$Walk_message";?></fieldset></span> 
<span class="redboldtxt"><?php echo "$Add_message";?></fieldset></span> 
</fieldset> 
</fieldset> 
</form> 

[Northern Flame]

well after the user submits,

have the page that processes the form

display the table with the table information

AFTER inserting the new information.

that should show the updated results

[Cyberspace]

well after the user submits,

have the page that processes the form

display the table with the table information

AFTER inserting the new information.

that should show the updated results

 

Is there a simple way of doing this?

[poleposters]

If I've read you right.

 

On the form page where the user enters data, there is also a table that displays the data currently in the database.

 

If this is the case you can just reload the page and the data will be updated.

 

use this on your form action page

 

header('Location: '.'processform.php');

 

That will reload the form page

[Cyberspace]

If I've read you right.

 

On the form page where the user enters data, there is also a table that displays the data currently in the database.

 

If this is the case you can just reload the page and the data will be updated.

 

use this on your form action page

 

header('Location: '.'processform.php');

 

That will reload the form page

 

 

Hey thanks for the reply, im just wondering do i put that line in:

 

</font><form method="post" class="addwalkerform" action=""> 

 

inside form action?

[BlueSkyIS]

this is extraordinarily basic PHP. you might want to back up:

 

http://www.tizag.com/phpT/forms.php

 

[poleposters]

The action="" is the link to the script that processes the form. As far as I can see( I haven't read your code thoroughly) the same page also processes the form. so action="the name of your page"