Skip navigation
gold987987987
gold987987987
Currently Being Moderated

Show records from current user.  PHP, mySQL, CS3

Jun 5, 2009 12:09 PM

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??

2588 Views   8 Replies   Latest reply: noiseboy1970, Feb 27, 2012 2:21 PM
 
Replies
  • DwFAQ
    Currently Being Moderated
    1. DwFAQ,
    Jun 5, 2009 12:11 PM   in reply to gold987987987
    Report

    You have to create session variables for the info you'd like displayed then echo the variables on the page.

     
    |
    Mark as:
  • gold987987987
    Currently Being Moderated
    2. gold987987987,
    Jun 5, 2009 12:22 PM   in reply to DwFAQ
    Report

    Would you be able to tell me how to do this or could you point me in the right direction?

    Thanks!

     
    |
    Mark as:
  • gold987987987
    Currently Being Moderated
    3. gold987987987,
    Jun 5, 2009 2:10 PM   in reply to gold987987987
    Report

    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?

    Thanks!

     
    |
    Mark as:
  • bregent
    Currently Being Moderated
    4. bregent,
    Jun 5, 2009 5:05 PM   in reply to gold987987987
    Report

    gold987987987 wrote:

     

    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?

    Thanks!

    Yes, that is the most common method.

     
    |
    Mark as:
  • David_Powers
    Currently Being Moderated
    5. David_Powers,
    Jun 6, 2009 2:02 AM   in reply to gold987987987
    Report

    gold987987987 wrote:

     

    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.

     
    |
    Mark as:
  • gold987987987
    Currently Being Moderated
    6. gold987987987,
    Jun 6, 2009 5:21 PM   in reply to David_Powers
    Report

    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!

     
    |
    Mark as:
  • noiseboy1970
    Currently Being Moderated
    7. noiseboy1970,
    Feb 27, 2012 2:20 PM   in reply to David_Powers
    Report

    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?

     

    Thanks....Mark

     
    |
    Mark as:
  • noiseboy1970
    Currently Being Moderated
    8. noiseboy1970,
    Feb 27, 2012 2:21 PM   in reply to noiseboy1970
    Report

    PS....I'm using CS5.5

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points