Login Redirect Problem

Discussion in 'PHP' started by scottlpool2003, May 1, 2011.

  1. #1
    I'm having a little trouble redirecting a user to their profile.

    I need to direct them to:

    usergallery.php?username=usersname

    But instead it's just directing them to

    usergallery.php?username=$username

    <?php 
    session_start();
    
    $dbHost = "***"; // Database Connection Details - host
    $dbUser = "***"; // Database Connection Details - username
    $dbPass = "***"; // Database Connection Details - password
    $dbname = "***"; // Database Connection Details - database name
    
    $username = $_POST['username']; // Stores our inputted data in these variable names
    $password = $_POST['password']; // Stores our inputted data in these variable names
    
    $db = mysql_connect($dbHost,$dbUser,$dbPass); // Connection Code
    mysql_select_db($dbname,$db);                 // Connects to database
    
    $query = "SELECT username, password FROM users WHERE username = '$username' AND password = '$password'";
    
    $result = mysql_query($query, $db);
    if(mysql_num_rows($result)) {
       $_SESSION['loggedin'] = 1;
       header('Location: http://www.mydomain.com/lisa/usergallery.php?username=$username');
       exit(); } 
    else {
      echo "<script>alert(\"The username/password did not match.\");</script>";
    
       exit(); }
    ?>
    PHP:
    Would be very grateful for any help.
     
    scottlpool2003, May 1, 2011 IP
  2. scottlpool2003

    scottlpool2003 Well-Known Member

    Messages:
    1,708
    Likes Received:
    49
    Best Answers:
    9
    Trophy Points:
    150
    #2
    Fixed thanks.

    I put ' instead of "
     
    scottlpool2003, May 1, 2011 IP
  3. arjunskumar47

    arjunskumar47 Member

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    31
    #3
    You might be wrong here i guess.
    
    header('Location:http://mydom.com/lisa/usergallery.php?username='.$username);
    
    PHP:
    Cheers
     
    arjunskumar47, May 1, 2011 IP