close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Making User's Firstname appear after Login

Thread began 1/01/2012 6:05 pm by sholzy | Last modified 6/20/2012 10:04 am by Jason Byrnes | 2637 views | 9 replies |

sholzy

Making User's Firstname appear after Login

Hello please, I am having a problem with getting security assist to make the user name appear after login. It keeps showing the user's ID number instead. I have tried creating a recordset and filtering it to point to the session variable "SecurityAssist_UserID" but it still doesnt seem to work. Please help. Find the code below

RECORDSET CODE

$colname_welcome = "-1";
if (isset($_SESSION['SecurityAssist_UserID'])) {
$colname_welcome = (get_magic_quotes_gpc()) ? $_SESSION['SecurityAssist_UserID'] : addslashes($_SESSION['SecurityAssist_UserID']);
}
mysql_select_db($database_TsrConn, $TsrConn);
$query_welcome = sprintf("SELECT UserTitle, UserFirstName FROM tsr_users WHERE UserEmail = %s", GetSQLValueString($colname_welcome, "text"));
$query_limit_welcome = sprintf("%s LIMIT %d, %d", $query_welcome, $startRow_welcome, $maxRows_welcome);
$welcome = mysql_query($query_limit_welcome, $TsrConn) or die(mysql_error());
$row_welcome = mysql_fetch_assoc($welcome);


THEN I ECHOED THE CODE BELOW IN THE BODY

<?php echo "Welcome, {$_SESSION['SecurityAssist_UserID']}"; ?>

Sign in to reply to this post

CraigRBeta Tester

you are echoing the session id, try changing the line

php:
<?php echo "Welcome, {$_SESSION['SecurityAssist_UserID']}"?>



to

php:
<?php echo "Welcome, ".$row_welcome['UserFirstName']; ?>



which will take the value from your recordset

Sign in to reply to this post

Magega49

Show username after login

Hi, I m Trying to set user firstname to show after login but it dont work for me...

When I do it it show me the first persona that was register on my web site but it wont show the person that is Login...

I need help please...

Sign in to reply to this post

Jason ByrnesWebAssist

on the login page, open the server behaviors panel, then double click the Authenticate user server behavior. On the third step of the authenticate user server behavior add the User name column to the list of columns to store in a session variable on login.

on the page you wish to show the users name, drag the username session variable from the bindings panel.

Sign in to reply to this post

Magega49

Show First name

Hi, Thank you for the firts part tip... It work but it show the ID number and it wont show the name????

Sign in to reply to this post

Jason ByrnesWebAssist

if it is showing the id number, you have used the binding for the user ID session, not the user name session.

Sign in to reply to this post

Magega49

Thank you!!!!

Hello Mr. Jason,

Thank you for the tips... It work out putty good for me...

Thanks!

Sign in to reply to this post

Magega49

User full detail

Hi, I will like to know how I can keep my self uptodate when I get a new user via e-Mail...

Also I want to know how to see user email and login detail in case I have to check something on them...

Please.....

Sign in to reply to this post

Jason ByrnesWebAssist

you would need to use universal Email to send an email when a new user is registered.


to create a user management section, you would need to use data assist.

Sign in to reply to this post

johna1964

This post has been deleted.

loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...