4 {{ upvoteCount | shortNum }}
4 {{ upvoteCount | shortNum }}

Wordpress : Want To Display Query Result Table in User Dahboard

by IMGem
3 replies
Hi Everyone,

On my company website i need to provide clients with personalised information regarding their order status. I have all the data required in database already.

I will create them a user ID as "subscriber group" and in Dashboard want to display simple information in table format from a simple query "Select * From Clients where ID= user_ID".

Can someone please indicate, how to achieve this ? Got no experience with PHP.
#dahboard #display #query #result #table #user #wordpress
  • Profile picture of the author festi9
    Originally Posted by IMGem View Post

    Hi Everyone,

    On my company website i need to provide clients with personalised information regarding their order status. I have all the data required in database already.

    I will create them a user ID as "subscriber group" and in Dashboard want to display simple information in table format from a simple query "Select * From Clients where ID= user_ID".

    Can someone please indicate, how to achieve this ? Got no experience with PHP.
    I think you should contact RichBeck he is great in the WP plugin Stuff
    {{ DiscussionBoard.errors[7647702].message }}
  • Profile picture of the author festi9
    Also would suggest you David V
    {{ DiscussionBoard.errors[7647725].message }}
  • Profile picture of the author David V
    IMgem, there are plenty of warriors that are willing to help you with this, but the way your question is presented makes it a little difficult to give you a reasonably short yet appropriate answer.

    Here's what I mean:
    I have all the data required in database already.
    Ok, how did it get there and is it in a wp core table options array or did you create your own table? Through a form, shopping cart order, phpmyadmin, msaccess on your desktop, etc..?

    I will create them a user ID
    How will you do that? Through form, shopping cart order, phpmyadmin, etc...?

    There could be a short answer, or a really long drawn out answer.

    Got no experience with PHP.
    This abruptly puts a stop to anyone giving you a solid answer since understanding the answer will require teaching you php as well.

    Unless your question is really "pointed" and exact, it will not be as simple as giving you a snippet of php to display the DB info.

    Just to display the info on the dashboard (assuming you mean WP dashboard), you'll need to know how to create a custom meta box on the dashboard, how to tap into the WordPress settings API to create the table, and some more......
    See what I'm getting at?
    {{ DiscussionBoard.errors[7654175].message }}

Trending Topics