Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

Adding extra info from SQL to display member details

by

Tips and Tricks HQ Support Portal › Forums › WP eMember › WP eMember Tweaks › Adding extra info from SQL to display member details

Tagged: database, eMember, mysql, phpMyAdmin

  • This topic has 5 replies, 2 voices, and was last updated 12 years, 11 months ago by e49.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • April 25, 2010 at 10:55 pm #1129
    e49
    Member

    Hi all, MAJOR WP & PHP NEWBIE HERE so please be gentle… LOL…

    I like this plugin and am trying to display a lil bit more info for my customers to see on my web site.

    The plan is with the already exsisting set up of the customers login page, after they login as follows…

    (ie

    You are logged in as: username

    Your membership level is: level

    Your Account Status: active

    Your Account Expires: April 25, 2011

    >Logout

    >My Secure RSS

    >Edit Profile

    )

    Then under this I would like to add more fields to display, I already have the SQL fields set up in the database and I enter them manually there (or if so can I set that in wordpress also)… I just need to set up the string on the particular users page so it would show…

    You are logged in as: username

    Your membership level is: level

    Your Account Status: active

    Your Account Expires: April 25, 2011

    Your extra info: HERE

    Your extra info: HERE

    Your extra info: HERE

    Your extra info: HERE etc…

    >Logout

    >My Secure RSS

    >Edit Profile

    )

    The customers does not need to edit this info, it would be left strictly for me to change either in SQL or if it can be edited on the wordpress add/edit members tab.

    Hope I hear back from anyone who can help… Thanks :D

    April 26, 2010 at 7:53 am #20088
    amin007
    Participant

    Open the “wp_eMember1.php” file and search for the following function:

    function eMember_login_widget()

    The code in that function is what displays those stuff in the login widget. So, retrieve your data from the SQL database for that member and display it there.

    April 26, 2010 at 8:05 am #20089
    e49
    Member

    Does the widget function display the same as what would if I place it on main content of the page… If not where would I need to find it… Cheers… :D

    April 26, 2010 at 8:26 am #20090
    amin007
    Participant

    It’s the same function that displays it on both places.

    April 26, 2010 at 8:45 am #20091
    e49
    Member

    Great I have found it and started testing… Now I will need to replace some other areas to complete the modified function.

    It is now currently showing…

    $output .= ‘
    ‘ . EMEMBER_LOGGED_IN_LEVEL;

    $output .= ‘<label class=”eMember_highlight”>’.$username.'</label>’;

    How do I edit the EMEMBER_LOGGED_IN_LEVEL to display something else for e.g. Membership Number.

    Also how do I call the SQL over from the table to replace the .$username. cos on my SQL it shows that it is user_name

    Is there another file I need to find to edit this function…? Cheers… :D

    April 26, 2010 at 10:17 am #20092
    e49
    Member

    Hey all is good, I’ve figured it out, kudos to me and yourself for all your help… Cheers…

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • WP PDF Stamper Documentation
  • WP Photo Seller Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial
  • WP Photo Seller Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2023 | Tips and Tricks HQ