PHP - Redirect From Header With Conditional Statement

I have a membership directory that I've been working with for a long time, and recent server upgrades with MySQL, PHP, etc. forced me to do some recoding. While I was doing that, I wanted to try and make some improvements. I must give a brief description of the intent, and then the results I got, so someone can sort out the problem for me. I have a query that selects all "Agent" members, then orders them by County, then by Company Name. What I am trying to do is create a new heading in my list every time the County information changes as the list is sorted and output to my table.   I am going to attache 2 .php files with my code. The agent_member_list.php is the original code that pulls all of the members properly, and results can be viewed he http://www.nmlta.org...member_list.php   The agent2_member_list.php is where I'm trying to insert the new conditional statement to print my County headings when a new County is encountered in the results. The heading actually works, and changes correctly, but the problem is that the first member entry in every county is not printed in the output. I know the query is correct, so I'm sure I've got the conditional "if" for checking County field wrong, or misplaced.  Here is the link to it: http://www.nmlta.org...member_list.php   I'm hoping someone can spot my error pretty quickly, I only dabble in this very rarely.  Thanks for any help! Attached Files  agent2_member_list.php   5.06KB   3 downloads  agent_member_list.php   4.82KB   2 downloads

I have the following code which seems to be in error in the conditional statement.
The queries to the database produce the expected results, and the echo statements work OK.
I want to make a selection based on whether data exists in the database for passState when passState=1.

Can anyone tell me what is wrong with the conditional statement?

Code: [Select]
<?php
$query1 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 1 ORDER BY quizTitle ASC, passState DESC, userDate DESC ");

$query2 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' AND passState = 0 ORDER BY quizTitle ASC, passState DESC, userDate DESC "); 
 ?>
                <table width="778" style="font-size:16px">
                  <tr>
 <?php
if ($query1) {
while ($row1 = mysql_fetch_array($query1))
{
           echo'<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row1['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row1['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row1['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row1['userScore']}".'/'."{$row1['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';                  
}
}else{
while ($row2 = mysql_fetch_array($query2))
{

              echo '<td width="13"></td>
                    <td width="137" style="vertical-align:middle; text-align:left;">' ?> <?php echo "{$row2['quizTitle']} <br />\n"; ?> <?php echo '</td>
                    <td width="13"></td>
                    <td width="132" style="vertical-align:middle; text-align:left;;">' ?> <?php echo "{$row2['userDate']} <br />\n"; ?> <?php echo '</td>
                    <td width="22"></td>
                    <td width="112" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 1) {echo "<img src=' ../wood/wood_tool_images/tick2.png' /><br />\n";}?> <?php echo '</td>
                    <td width="30"></td>
                    <td width="103" style="text-align:center; text-align:center;">' ?> <?php if ("{$row2['passState']}" == 0) {echo "<img src=' ../wood/wood_tool_images/cross2.png' /><br />\n";} ?> <?php echo '</td>
                    <td width="19"></td>
                    <td width="126" style="vertical-align:middle; text-align:center;">' ?> <?php echo "{$row2['userScore']}".'/'."{$row2['totalScore']} <br />\n"; ?> <?php 
  echo '</td>
                    <td width="23"></td>
                    </tr>';
                  
}
}
 ?>
                </table>

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=318784.0

hey guys trying to find out what the short name of FireFox2 is. (for example the "IE 6" in this code) What would it be for firefox versions 2?

Code: [Select]
<!--[if IE 6]>
<meta http-equiv="refresh" content="0; url=http://example.com/">
<![endif]-->
THANKS!!!

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=342336.0

How can one re-direct a visitor, without using a header re-direct?  I'd like a page to show up, then after about 5 seconds I need the visitor sent to another page.  How can I do this?

Hi all, I am having a time with my coding. The codes for the form.php will add to the db if the action is giving as form.php. I am trying to get the page to redirect to the login.php. so I put the header function in. It redirects to the login.php as the header but does not add data to the db. So I tried to put the code login.php in the action for the form but it does not add to the db. Where can I put the redirect so it adds to data to the db and goes to the next page.???????

<?php
@include_once ("Connections/connect_to_mysql.php");

  $err='';

  if($_POST["submit"]){
 
    // Validate form data

    if($_POST["firstname"]=='') $err.='Please enter First Name<br>';
    if($_POST["email"]=='') $err.='Please enter Email<br>';



    if($err==''){

      // Check if there are duplicate entries in the 'contacts' table

      $results = mysql_query("SELECT id FROM `Members` WHERE firstname='".addslashes($_POST["firstname"])."' and Email='".addslashes($_POST["email"])."'");
      if($row = mysql_fetch_array($results)){
        $err.='Can not add duplicate entry<br>';
      }
      else{

        // adding new record to 'contacts' table

        mysql_query("INSERT INTO Members (firstname,lastname,country,Email)
                    values ('".addslashes($_POST["firstname"])."','".addslashes($_POST["lastname"])."','".addslashes($_POST["country"])."','".addslashes($_POST["email"])."')");

       // redirecting to success screen
      if($_POST['id']){
         header("Location: login.php");
      exit;
      }
      }
    }
  }

?>
<html>
<head>
<title>Add New Contact</title>
</head>

<body>

<h2>Register with us</h2>

<?php echo $err==''?'''<p style="color:red;">'.$err.'</p>') ?>

<form method="post" action="form.php">

<table border="0">
<tr>
<td valign="middle">First Name:</td>
<td><input type="text" name="firstname" size="30" value="<?php echo htmlspecialchars($firstname) ?>"></td>
</tr>
<tr>
<td valign="middle">Last Name:</td>
<td><input type="text" name="lastname" size="30" value="<?php echo htmlspecialchars($lastname) ?>"></td>
</tr>
<tr>
<td valign="middle">Country:</td>
<td><input type="text" name="country" size="30" value="<?php echo htmlspecialchars($country) ?>"></td>
</tr>
<tr>
<td valign="middle">Email:</td>
<td><input type="text" name="email" size="30" value="<?php echo htmlspecialchars($email) ?>"></td>
</tr>
</table><br>

<input type="submit" name="submit" value=" Submit! ">

</form>

</body>
</html>

If I do something like header(Location: www.url.com).  Is there a way that url.com would be able to get the IP from the server that did the redirect?  It looks like $_SERVER["REMOTE_ADDR"] returns the clients IP address which isnt what I need.

Thanks

Hey here is my code im trying to redirect  the index.php to index.php?id=1
the way i have done it doesn't look really good is there a better way to do it please?

im trying to redirect to id=1 because otherwise i wont be able to echo out anything...

id 1 is default category so is there a way to tell it if  $id is empty echo from id 1?

<?php   

        $id = $_GET['id']; 
if($id == ''){
echo "<meta http-equiv=Refresh content=0;url=index.php?id=1>";

}
        $result = mysql_query("SELECT * FROM pages WHERE id='$id' ",$connect);
        while($row = mysql_fetch_assoc($result))
             {
        echo $row['anything1']; 
        echo $row['anything2']; 
} 
?>

I have an html login page. Once a user is verified through the PHP page they get redirected to another page. For some reason once I have validated that the user exists I get the message that is was successful but the page will not redirect. This is my script I use on my HTML page to pass the parameters:

Code: [Select]
$(document).ready(function() {
$('#submit').click(function() {
var username = $('input[name=username]');
var password = $('input[name=password]');
var data = 'username=' + username.val() + '&password=' + password.val();

.ajax({
url: "login.php",
type: "GET",
data: data,
cache: false,
success: function() {
alert("SUCCESS");
}
});
return false;
});
});
And this is my PHP page:

Code: [Select]
<?php

$username = ($_GET['username']) ? $_GET['username'] : $_POST['username'];
$password = ($_GET['password']) ? $_GET['password'] : $_POST['password'];

if ($_POST) $post=1;

$userFound = false;
$memberId = "";

// Create connection string, Note, params are as follow
// mysql_connect(databaseLocation, username, password)
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die("Could not connect: " . mysql_error());
  }
mysql_select_db("memberdb", $con); 
// SQL Query
$result = mysql_query("SELECT memberId, firstName, lastName, username, password FROM member");
while($row = mysql_fetch_array($result))
{
if ($username == $row["username"] && $password == $row["password"])
{
echo "<h1>Welcome " . $row["firstName"] ." ". $row["lastName"]  . "! </h1></br>";
$userFound = true;
$memberId = $row["memberId"];
}
}
// If User is found, continue on to next page, if not redirect to index.html
if ($userFound)
{
echo "<h2>Login Successful</h2>";
echo "<h3>Page will redirect</h3>";
header( "url=menu.html?memberId=" . $memberId);
}
else
{
echo "<h2>LOGIN FAILED</h2>";
echo "<h3>Page will redirect</h3>";
header( "refresh: 1; url=index.html#loginPage");
}
?>
It does the echo successfully but hangs on the part where is says :

Quote

header( "url=menu.html?memberId=" . $memberId);


How can I get it to redirect?

Thanks

I am using a header redirect after a user makes a post which goes to their post.

example they made a post which has an id of 236, then the url redirect would be

index.php?forum=1&topic=1&post=236#p236

i have the <a name> set up on each post and it works fine until the post is on a different page.
the url should be:

index.php?forum=1&topic=1&page=2&post=236#p236

but how would i be able to tell the header redirect which page to go to. I was thinking if statements like:

if ($number_of_results >=10) { $page = 2; }

but that would involve alot of if statements with no way of knowing how many pages the topic could have.

Is there an easier way?

Here is the webpage.php which executes data entered in the email form. I want to display a webpage which would confirm that the email has been sent but the header redirect does not work. An email gets sent but a blank page is displayed instead of confirmation. Can anyone help? this is urgent


<?php error_reporting(6143); 

require_once('recaptchalib.php');

$publickey = "6Ldmbr8SAAAAAGT17oCjkB8Y60kSqvq_0w7APAJp"; 
$privatekey = "6Ldmbr8SAAAAAMY5lEl-7LnkWCovoFa9G7Vl3_kA";

isset($_POST['Email']) ? $Email = $_POST['Email'] : $Email = "";
isset($_POST['name']) ? $name = $_POST['name'] : $name = "";
isset($_POST['surname']) ? $surname = $_POST['surname'] : $surname = "";
?>

<meta http-equiv="content-type" content="text/html; charset=iso-8859-2">

<body bgcolor="#000000"></body>

<link href="loginmodule.css" rel="stylesheet" type="text/css" />

<?php

if (isset($_POST['Submit']))
{
//Validate form
$errormessage = "";

$resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

if ($name == '') { $errormessage .= "<li>Please provide your name.</li> ";}
if ($surname == '') { $errormessage .= "<li>Please provide your surname.</li>";}
if ($Email == '') { $errormessage .= "<li>What is your e-mail address?</li>";}
if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $Email)){ $errormessage = $errormessage . "<li>This is not a valid email address!

</li>";}
if (!$resp->is_valid) {
     // What happens when the CAPTCHA was entered incorrectly
    $errormessage .= "<li>Please rewrite captcha characters</li>";
}

echo "</ul></p>";
//If errors, return error message(s) and form 
if ($errormessage != "")
{ ?>
    
    <span class="link1"><a href="index.php">back to home page/a></span>
     <img src="images/clack.JPG">
<table align="center">
       <p align="center" class="err_bold">correct the following errors:</p> <span class="text_err"><ul><?=$errormessage?></span>
                        </table>

<?php
include("email-form.php");

} else {
//If good, mail to DL 
$email_subject = "Hello, you have a new message";  
$email_headers = "From: $name [$Email] \r\n";


$to = "blablabla@hotmail.com";
$message_content = 
 "----------------------------------------------------------------------------------\n".
 " Hello\n".

 
 "name: $name\n".
 "surname: $surname\n".
 "E-mail: $Email\n".

 
 "-----------------------------------------------------------------------------------\n\n";
       
       
   
//Email message to Requestor
   
if (mail($to, $email_subject, $message_content, $email_headers))
{
//Display Sent Confirmation (Successful or NOT!) ?>
        <?php
        header ("Location: http://www.google.co.uk"); 
exit; ?>
<?php
}
}
} else {
?>
<span class="link1"><a href="index.php">back to home page</a></span>
<img src="images/clack.JPG"><br>
<p class="err" align="center">Please fill the form below<br/></p>

<?php include("email-form.php");?>
    
<?php 
};

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
   <style>
   .error {color: #FF0000;}
   h6
   {
     font-family: bookman old style;
     font-size:20px;
     text-align: center;
     font-weight: normal;
  }
  h5
  {
    font-family: bookman old style;
    font-size:15px;
    text-align: center;
    font-weight: normal;
  }
  </style>
  <?php
  $nameErr = $emailErr = $websiteErr = $categoryErr;
  $name = $email = $comment  = $website = $reset = $category;
     if ($_SERVER["REQUEST_METHOD"] == "POST") {
       if (empty($_POST["name"])) {
         $nameErr = "Name is required";
       } else {
         $name = test_input($_POST["name"]);
         if (!preg_match("/^[a-zA-Z ]*$/",$name)) {
           $nameErr = "Only letters and white space allowed"; 
         }
       }
       
       if (empty($_POST["email"])) {
         $emailErr = "Email is required";
       } else {
         $email = test_input($_POST["email"]);
         if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
           $emailErr = "Invalid email format"; 
         }
       }
         
       if (empty($_POST["website"])) {
         $websiteErr = "URL is required";
       } else {
         $website = test_input($_POST["website"]);
         if (!preg_match("/\b(?:(?:https?|ftp):\/\/|www\.)[-a-z0-9+&@#\/%?=~_|!:,.;]*[-a-z0-9+&@#\/%=~_|]/i",$website)) {
           $websiteErr = "Invalid URL"; 
         }
       }
    
       if (empty($_POST["comment"])) {
         $comment = "";
       } else {
         $comment = test_input($_POST["comment"]);
       }
       if (empty($_POST["category"])) {
         $categoryErr = "Category is required";
       } else {
         $category = test_input($_POST["category"]);
       }
if (!empty($_POST['name']) && !empty($_POST['email']) && !empty($_POST['website']) && !empty($_POST['category'])) {
 $myemail = "links@loadsofads.com";
 $subject = "Link Submission";
 $message = "Your Link Submission form has been submitted by:
 Website Name: $name
 E-mail: $email
 URL: $website
 Category: $category
 Description:
 $comment";
 mail($myemail, $subject, $message);
 header('location:submitthanks.php');
  }}
  function test_input($data) {
     $data = trim($data);
     $data = stripslashes($data);
     $data = htmlspecialchars($data);
     return $data;
  }
?>
  <?php include'header.php'?>
  <h6>Link Submission</h6>
  <h5><p><span class="error">* required field.</span></p>
  <form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>"> 
     Name Of Site: <input type="text" name="name" value="">
     <span class="error">* <?php echo $nameErr;?></span>
     <br><br>
     E-mail: <input type="text" name="email" value="">
     <span class="error">* <?php echo $emailErr;?></span>
     <br><br>
     URL: <input type="text" name="website" value="">
     <span class="error">* <?php echo $websiteErr;?></span>
     <br><br>
     Description: <textarea name="comment" rows="5" cols="40"></textarea>
     <br><br>
  Category Of Site: <select size="1" name="category"> 
     <option value=""> -- Please select -- </option>    
     <option>Arts</option>     
     <option>Business</option>     
     <option>Computers</option>     
     <option>Games</option>     
     <option>Health</option>     
    <option>Home</option>     
    <option>Kids and Teens</option>     
    <option>News</option>     
    <option>Recreation</option>     
    <option>Reference</option>     
    <option>Science</option>     
    <option>Shopping</option>     
    <option>Society</option>     
    <option>Sports</option>     
    <option>World</option>
   </select><span class="error">* <?php echo $categoryErr;?></span>
    <br><br>
    <input type="submit" name="submit" value="Submit"> <input type="reset" name="reset" value="Reset Form">
 </form>
<?php include'footer.php'?>

Hello All,   OK so I have been at this for a few days now and everywhere I go to learn or read information it says the same thing, to redirect the code is header('location:mypage.php');exit();   but it just will not redirect it every thing I try it does not load the redirect page. it clears the form and sits there, I do not know why! Can please someone please help me and see why it is not doing it?   Thanks  

I cannot use a header redirect anymore because I'm echo'ing out in the header.php file for the navigation, which will echo out a profile and settings button ONLY if the user is logged in, it's basically a simple if statement with session variables.

Now when the user goes to the login page and has successfully logged in I'd like to redirect the user to the main page, but of course this won't work since I have already an echo in the header.php file for the navigation.

So my question is, is there a workaround or alternate redirect for this case?

Hi Everyone,

I'm having a bit of a problem if someone could help me with?

I have a simple registration form with fields userid, username, password, clientaddress

So when the user logs in with their username and password it will redirect to their client address but I cant get the redirect working. Here is my code:

Code: [Select]
$clientaddress = trim($_POST['clientaddress']);

$_SESSION['start'] = time();
 header("Location:$clientaddress"); 
 exit;
}

also note if I add:

Code: [Select]
$clientaddress = 'http://www.google.com';

it redirects ok to google. It's getting the field from the database I think thats the problem

Can somone help it just wont redirect to the client address