I'm stuck, can you help???
I have a basic login page where the user is authenticated then directed to another page(User Home Page). Works great!
Problem is,...On the User Home Page, I'm trying to display the authenticated users data from the mySQL database but don't know how to retrieve that information and display it in the page.
Can you help??
How about this? Can I query a recordset with the user authentication session variable and then use that to populate my current user data fields?
Yes, that is the most common method.
Can I query a recordset with the user authentication session variable and then use that to populate my current user data fields?
Yes. How to do this is described in this article in the Dreamweaver FAQ.
Thanks David, I knew I was on the right track. I implemented everything and it still didn't work. I was starting to go crazy and then I decided to go over the code again. I found out that the code the recordset query was happening before the code for the session_start. So, I swapped them around and viola!!! It works! Thanks for your help!
David, looking through this post and the article to which it refers is getting me on the right track for what I want to do...but not completely. Perhaps you can help?
I am using the Authenticate User behaviour to check the validity of a user against a current database, but instead of 'username' and 'password' I am using the two fields for 'firstname' and 'surname' as these are seperate columns in the current database. If the person is listed they are then taken to a page where I want to use both of the above as session variables to display the names in a new form, but also to act as filters to then bring forth further information from the database into the same form.
I have tried the coding using the getUserDetails recordset that has been mentioned elsewhere in this thread, but obviously this has only the one filter.
How can I add the second filter to the code?
Is this possible?