recognise a logged on user

[freddyw]

Hi there. Is there a way to recognise the user that is logged on, on other pages of my site.

 

For example I want it to say Hello (first_name). Rather than username. form the first name they enetered when signing up. id connect to the db (obviously, but after that im stumped.

[bundyxc]

Try something similar to this:

 

$sql = "SELECT `firstName` FROM `users` WHERE `username`=" . $username;
$query = mysql_query($sql);
$fetch = mysql_fetch_assoc($query);
print($fetch['firstName']);

[kratsg]

Try something similar to this:

 

$sql = "SELECT `firstName` FROM `users` WHERE `username`=" . $username;
$query = mysql_query($sql);
$fetch = mysql_fetch_assoc($query);
print($fetch['firstName']);

 

I think he needs a way to get users to log on first.

 

In that case, I suggest you check out this tutorial:http://fishbowl.pastiche.org/2004/01/19/persistent_login_cookie_best_practice/

[freddyw]

no i already have users to log on

[kratsg]

no i already have users to log on

 

Use whatever method in your cookies/sessions that they log on with to fetch their information from the database:

 

Try something similar to this:

 

$sql = "SELECT `firstName` FROM `users` WHERE `username`=" . $username;
$query = mysql_query($sql);
$fetch = mysql_fetch_assoc($query);
print($fetch['firstName']);