Redirecting - kind of - PHPBuilder Forums

Redirecting - kind of

Frapster

Below is a script I've adapted from a tutorial. I've been through 2 or 3 different efforts at having the script 'redirect' to a different page after it's done submitting but all of my efforts have been fruitless.

I tried modifying 'header' info but unfortunately that errors out. I then tried to establish a javascript redirection using php but that kept mucking up as well. Can anyone point me to a page that might help me achieve what I want to achieve? Specifically I want to have the lines just after the <body> tag submit and then 'redirect' to a page entitled 'quiz.php?n=1'.

Thanks and regards!

Rob

<?php
//open database
 $dbhost = 'changed';
 $dbuser = 'changed';
 $dbpass = 'changed';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');

 $dbname = 'colorology';
mysql_select_db($dbname);
?>
<html>
<head>
<title>Get Your Personalized Colorology&trade;</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
	background-color: #000000;
}
.style10 {color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; }
.style33 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: #FFFFFF; }
.style39 {
	color: #FFFFFF;
	font-weight: bold;
	font-size: 14px;
	font-family: Arial, Helvetica, sans-serif;
}
.style40 {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 12px;
}
-->
</style></head>
<body>

<?php
 if(isset($_POST['add']))
 {
 $gender = $_POST['gender'];
 $birthday = $_POST['birthday'];
 $city = $_POST['city'];
 $state = $_POST['state'];
 $status = $_POST['status'];
 $products = $_POST['products'];

 $query = "INSERT INTO quiz (gender, birthday, city, state, status, products) VALUES ('$gender', '$birthday', '$city', '$state', '$status', '$products', '$stores')";
 mysql_query($query) or die('Error, insert query failed');

echo "A new name has been added.";
}
 else
 {
 ?>
<form method="post" action="stats.php">
  <table width="400" border="0" align="center" cellpadding="3" cellspacing="1">
    <tr align="center" valign="top" bgcolor="#CC00CC">
      <td colspan="2"><span class="style39">Get your personalized Colorology&trade;. </span></td>
    </tr>
    <tr align="left" valign="top" bgcolor="#FF99FF">
      <td colspan="2"><span class="style40">Tell us about yourself. </span></td>
    </tr>
    <tr valign="top">
      <td width="30%"><span class="style10">Gender:</span></td>
      <td width="70%"><table width="100%"  border="0" cellspacing="2" cellpadding="0">
        <tr>
          <td width="10%" class="style33"><input name="gender" type="radio" value="Male"></td>
          <td width="90%" class="style33">Male</td>
        </tr>
        <tr>
          <td width="10%" class="style33"><input name="gender" type="radio" value="Female"></td>
          <td width="90%" class="style33">Female</td>
        </tr>
      </table></td>
    </tr>
    <tr valign="top">
      <td width="30%"><span class="style10">Birthday:</span></td>
      <td width="70%"><input name="birthday" type="text" id="birthday"></td>
    </tr>
    <tr valign="top">
      <td width="30%"><span class="style10">City:</span></td>
      <td width="70%"><input name="city" type="text" id="city"></td>
    </tr>
    <tr valign="top">
      <td width="30%"><span class="style10">State:</span></td>
      <td width="70%"><select name="state" size=1 >
<option selected value="AK">AK</option>
<option value="AL">AL</option>
<option value="AR">AR</option>
<option value="AZ">AZ</option>
<option value="CA">CA</option>
<option value="CO">CO</option>
<option value="CT">CT</option>
<option value="DC">DC</option>
<option value="DE">DE</option>
<option value="FL">FL</option>
<option value="GA">GA</option>
<option value="HI">HI</option>
<option value="IA">IA</option>
<option value="ID">ID</option>
<option value="IL">IL</option>
<option value="IN">IN</option>
<option value="KS">KS</option>
<option value="KY">KY</option>
<option value="LA">LA</option>
<option value="MA">MA</option>
<option value="MD">MD</option>
<option value="ME">ME</option>
<option value="MI">MI</option>
<option value="MN">MN</option>
<option value="MO">MO</option>
<option value="MS">MS</option>
<option value="MT">MT</option>
<option value="NC">NC</option>
<option value="ND">ND</option>
<option value="NE">NE</option>
<option value="NH">NH</option>
<option value="NJ">NJ</option>
<option value="NM">NM</option>
<option value="NV">NV</option>
<option value="NY">NY</option>
<option value="OH">OH</option>
<option value="OK">OK</option>
<option value="OR">OR</option>
<option value="PA">PA</option>
<option value="RI">RI</option>
<option value="SC">SC</option>
<option value="SD">SD</option>
<option value="TN">TN</option>
<option value="TX">TX</option>
<option value="UT">UT</option>
<option value="VA">VA</option>
<option value="VT">VT</option>
<option value="WA">WA</option>
<option value="WI">WI</option>
<option value="WV">WV</option>
<option value="WY">WY</option>
<option value="CANADA">Canada</option>
<option value="UK">United Kingdom</option>
<option value="EUROPE">Europe</option>
<option value="Other">Other</option>
</select></td>
    </tr>
    <tr valign="top">
      <td width="30%"><span class="style10">Occupation or Year in School: </span></td>
      <td width="70%"><input name="status" type="text" id="status"></td>
    </tr>
    <tr valign="top">
      <td width="30%"><span class="style10">Do you use these products? </span></td>
      <td width="70%"><table width="100%"  border="0" cellspacing="2" cellpadding="0">
        <tr>
          <td width="10%" class="style33"><input name="products" type="radio" value="Yes"></td>
          <td width="90%" class="style33">Yes</td>
        </tr>
        <tr>
          <td width="10%" class="style33"><input name="products" type="radio" value="No"></td>
          <td width="90%" class="style33">No</td>
        </tr>
        <tr>
          <td class="style33">&nbsp;</td>
          <td class="style33">&nbsp;</td>
        </tr>
      </table></td>
    </tr>
    <tr>
      <td width="30%">&nbsp;</td>
      <td width="70%"><input name="add" type="submit" id="add" value="Continue"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
  </table>
</form>
<?php
 }
 ?>
</body>
</html>
<?php

//close database
mysql_close($conn);

 ?>

devinemke

Originally posted by Frapster
I tried modifying 'header' info but unfortunately that errors out.

i suspect you are refering to a "headers already sent" error message. you should do some basic reading on headers. what you basically need to do (in pseudo-code):

<?php
if (isset($_POST['add']))
{
	// code that connects to the database then does INSERT query then...
	header('location: http://www.frapster.com/quiz.php?n=1');
}
else
{
	// echo all of the HTML (with the form)
}
?>

Frapster

Thanks so much for the push in the right direction. I tried following your format but no matter what I did I would get errors. I followed your link and read up on 'headers' and what learned was that the code you gave me would error out if there was any kind of information passed to the server before that was processed. For example the following would error out.

<html>
<?php 
if (isset($_POST['add'])) 
{ 
    header('location: [url]http://www.australiangold.com/color/quiz.php?n=1[/url]'); 
} 
else 
{ 
} 
?>

The reason it errors out is two-fold. The 'html' tag for one and the spaces before the 'header' line and a space in first line of the code.

I had put this outside of the 'html' tag and had left the space in producing an error and on a whim decided to eliminate all unecessary spaces in the code.

This worked just fine at the top of my code before the 'html' tag.

<?php 
if(isset($_POST['add'])) 
{ 
header('location: [url]http://www.australiangold.com/color/quiz.php?n=1[/url]'); 
} 
else 
{ 
} 
?>

Now my darn script is working just fine! Thanks so much for your help. Couldn't have done it without you.

Regards,

Rob

Frapster

it keeps converting my URLs in the code. lol