how to make the submit button go to and refresh results page?

[shtoom]

CLICK HERE TO SEE THE SITE IN QUESTION

When you click the sign up button I want the browser to be directed to the results page. Please can someone show me how to do this?

This is the sign up page php:

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

     if (!get_magic_quotes_gpc()) {
         $id = addslashes($id);
        $name = addslashes($name);
         $email = addslashes($email);
          $course = addslashes($course);
           $question = addslashes($question);
    }

$dbh=mysql_connect ("localhost", "username", "password");
        mysql_select_db ("username");


   $sql = "INSERT INTO unrealtournament VALUES ('$id','$name','$email','$course','$question')";

    $result = mysql_query($sql) or print("Can't insert into table emaillist.<br />" . $sql . "<br />" . mysql_error());

    if ($result != false) {
        print "Your entry has successfully been entered into the database.";
    }

    mysql_close();
}
?>

<form  method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<table align="center" border="1" cellspacing="0" cellpadding="3">
<tr><td>Username:</td><td>
<input type="text" name="name" maxlength="40">

</td></tr>
<tr>
  <td>E-Mail:</td>
  <td>
<input type="text" name="email" maxlength="100">
</td></tr>
<tr>
  <td>Course:</td>
  <td>
<input type="text" name="course" maxlength="150">
</td></tr>
<tr>
  <td>Would you like: </td>
  <td>
<select name="question">
<option value="Death Match" selected="selected">Death Match</option>
<option value="Capture the Flag">Capture the Flag</option>
<option value="Both">Both</option>
</select>
</td></tr>
<tr><td colspan="2" align="right">
<input type="submit" name="submit" value="Sign Up">
</td></tr>
</table>
</form>

[clamcrusher]

    if ($result != false) {
        header('Location: http://example.com/results.php');
        exit;
    } 

Off Topic:


your code relies on the register_globals setting. this setting has been defaulted to off for years now, and if you want your code to be portable you should not rely on this setting. using variables created by register_globals can also have security implications.

use the superglobals instead eg
$_POST['id'] instead of $id

http://www.php.net/register_globals

[trhynard]

Sure, as long as nothing has been outputted to the browser, use

header('location: http://www.jamesgardner.lincoln.ac.uk/unrealtournament/results.php'); 

[shtoom]

clamcrusher

I added your code and when I sign up it takes me to index.php and I see this

Can't insert into table emaillist.
INSERT INTO emaillist (email) VALUES ('dtw@a')
Table 'jamesgar_jamesgar.emaillist' doesn't exist
Warning: Cannot modify header information - headers already sent by (output started at /home2/jamesgar/public_html/unrealtournament/index.php:6) in /home2/jamesgar/public_html/unrealtournament/index.php on line 93


and are you saying everywhere it says $id I replace it with $_POST['id']

Looks like something has been outputted to the browser

I added what you told me and I got this error
Warning: Cannot modify header information - headers already sent by (output started at /home2/jamesgar/public_html/unrealtournament/index.php:6) in /home2/jamesgar/public_html/unrealtournament/index.php on line 145

[clamcrusher]

you sent some output on line 6. output is text, html, or whitespace characters. you cannot send output before sending headers.

you can either use an html meta refresh, javascript redirect, or turn on output buffering by calling ob_start(); on the first line of your script.

[shtoom]

I just added ob_start(); and I get the same error

To use superglobals are you saying to replace $id with $_POST['id'] ? if so does it apply for all of them $name $_POST['name'] ect.. ?

Heres what the php now looks like:

<?php

ob_start();

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

     if (!get_magic_quotes_gpc()) {
         $id = addslashes($id);
        $name = addslashes($name);
         $email = addslashes($email);
          $course = addslashes($course);
           $question = addslashes($question);
    }

$dbh=mysql_connect ("localhost", "username", "password");
        mysql_select_db ("username");


   $sql = "INSERT INTO unrealtournament VALUES ('$id','$name','$email','$course','$question')";

    $result = mysql_query($sql) or print("Can't insert into table emaillist.<br />" . $sql . "<br />" . mysql_error());

if ($result != false) {
        header('Location: http://www.jamesgardner.lincoln.ac.uk/unrealtournament/results.php');
        exit;
    } 

    mysql_close();
}
?>

<div id="main">
Its time to get it on..
</div>

<form  method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<table align="center" border="1" cellspacing="0" cellpadding="3">
<tr><td>Username:</td><td>
<input type="text" name="name" maxlength="40">

</td></tr>
<tr>
  <td>E-Mail:</td>
  <td>
<input type="text" name="email" maxlength="100">
</td></tr>
<tr>
  <td>Course:</td>
  <td>
<input type="text" name="course" maxlength="150">
</td></tr>
<tr>
  <td>Would you like: </td>
  <td>
<select name="question">
<option value="Death Match" selected="selected">Death Match</option>
<option value="Capture the Flag">Capture the Flag</option>
<option value="Both">Both</option>
</select>
</td></tr>
<tr><td colspan="2" align="right">
<input type="submit" name="submit" value="Sign Up">
</td></tr>
</table>
</form><br />


</div>
</body>
</html>
<?php

ob_end_flush();

?>

[clamcrusher]

put it at the beggining of the file, on line 1.

you will also obviously need to fix your database error.

[shtoom]

wow thanks it works now!

Whats the error in the database?

and to use superglobals are you saying to replace $id with $_POST['id'] ? if so does it apply for all of them $name $_POST['name'] ect.. ?

[clamcrusher]

yes, all variables
http://www.php.net/manual/en/languag...predefined.php