[RESOLVED] Custom "Welcome" after login

suthen_cowgirl

Forgive me, I REALLY suck at code. I'm more of a design person.

And I'm sure the answer is out there on the internet but I can't find it because I'm not sure what to search for, I've tried.

After someone logs in I want it to say "welcome" and their first_name. I have it doing this after they register and it logs them in, but thats because it specifically gets their first name from the form when they register. But logging in its only asking for their email address and password on the form, but i'd like it to then retrieve the first_name that corresponds from the database and put it on the members page. I know its a matter of writing a function, but like I said I suck at that.

Here's what happens on the login page:

// if $submit variable set, login info submitted:
if(isset($_POST["Submit"])) {
    // Check fields were filled in
    field_validator("Email Address", $_POST["email"], "email");
    field_validator("Password", $_POST["password"], "string", 6, 16);

// if there are $messages, errors were found in validating form data
if($messages){
    doIndex();
    exit;
}

// now check the email/pass pair match those stored in the db:
if( !($row = checkPass($_POST["email"], $_POST["password"])) ) {
    // email/passwd string not correct, create an error message:
    $messages[]="Incorrect email/password, please try again";
}

/*
If there are error $messages, errors were found in validating form data above.
Call the 'doIndex()' function (which displays the login form) and exit.
*/
if($messages){
    doIndex();
    exit;
}

/*
If we got to this point, there were no errors - start a session using the info
returned from the db:
*/
cleanMemberSession($row["email"], $row["password"]);

// and finally forward user to members page
header("Location: members.php");
} else {
    // The login form wasn't filled out yet, display the login form for the user to fill in:
    doIndex();
}

And where should it go, before or after the initialization of the session?

NogDog

Presumably you are doing some sort of database query to check the user name/password, yes? If so, just add the name field to the query, then if the login is successful you can add the name to the $_SESSION array.

suthen_cowgirl

yeah, I suck at this...

So based on this chunk:

    // now check the email/pass pair match those stored in the db:
    if( !($row = checkPass($_POST["email"], $_POST["password"])) ) {
        // email/passwd string not correct, create an error message:
        $messages[]="Incorrect email/password, please try again";
    }

I tried adding:

	global $name; 

$name="SELECT first_name FROM users WHERE".$row["email"]."and".$row["password"];

And added $name to:

    cleanMemberSession($row["email"], $row["password"], $name);

Then in members.php, the page login.php redirects to, I added $name to:

print("Welcome to the members page <b>".$name."</b>.<br>\n");

But it doesnt work..

NogDog

Can you show us the code for your checkPass() function?

suthen_cowgirl

function checkPass($email, $password) {
    global $link;

$query="SELECT email, password FROM users WHERE email='$email' and password='$password'";
$result=mysql_query($query, $link)
    or die("checkPass fatal error: ".mysql_error());

// Check exactly one row is found:
if(mysql_num_rows($result)==1) {
    $row=mysql_fetch_array($result);
    return $row;
}
//Bad Login:
return false;
}

NogDog

OK, I would change the query in that function to:

$query="SELECT email, password, first_name FROM users WHERE email='$email' and password='$password'";

Then in the main script:

    /*
    If we got to this point, there were no errors - start a session using the info
    returned from the db:
    */
    cleanMemberSession($row["email"], $row["password"]);
    // add this to save first name in session data
    $_SESSION['first_name'] = $row['first_name'];

Then on any of your session-controlled pages, you can use $_SESSION['first_name'] to address the user.

suthen_cowgirl

Thank you very much for your help!!