how to create a report for each user based on there login or user id

I have not allowed any parameters to be passed to a forward facing report for security reasons. I don’t want to leave the door open for SQL Injection attempts. However, your specific need could be be achieved without added risk.

Can yo provide some more details?
Do you just need this done to one report?
What is your report called?
Do you have any other reports?

I’m thinking this would be a custom hack just for your version but I want to understand you need and usage better.

Aloha, Eli

Eli thank you very much for getting back to me !

Pretty simple concept we run a website for locksmiths in the automotive industry
they purchase keycodes from us .
we log all this into a table called code_log with 8 different columns inside vin, pin, returncode , ip techid, workid, locid,make ,type and these values are distinct per user
we need to be able to allow them to search this data by vin , etc and return this info to their member profile based on there userdid

1. yes one report for all user does the same thing
2. yes we will have others to make
3. report would be called My code History

thanks again your plugin is very cool nice to have SQL !!!
John

I think this is something I could do. I would hesitate to put unrestricted variables into the SQL for fear of abuse but a strictly controlled user_id would be save.

Is this something you would still like me to add? If so, would you be willing to give me WP Admin access to your site to make the necessary changes and test the report?

You can send direct email to me here:
wordpress at ieonly dot com

Eli,

Were you ever able to complete this? I am needing something VERY similar.

SELECT * FROM CODES WHERE {USER_ID}

Would show all records where User_ID (Or other WP Token) matches.

Any help would be appreciated.

Thanks,
Fernando

overdog never got back to me. I think I can make this change for you today though, if I keep it simple.

Just to make sure I’ve got it: You want a tag that you can use in your SQL statement that will be substituted for the $current_user->ID value of the user who is logged in viewing the report.

I think I could have this done by tomorrow.

Ok, I just released an update that allows you to use php in the sql query. Here is an example of a query that would show the display_name for the current_user:

SELECT display_name FROM wp_users WHERE ID = '<?php $current_user->ID ?>'

Please let me know how if this does the trick or if you were needing something else.

Aloha, Eli

Thanks, I will try this today. Can I use any toekn or only the user id?

Thanks!

You should be able to use any global variable or public function.

Let me know how you are wanting to use this and I will make sure it works that way.

Aloha, Eli

Yes,

I think this would be a good addition to the plugin, as I can see this plugin being used to create reports for end-users by defining the user ID in WP.

I will be using this to tie in a key generator DB and WP by allowing resellers to view all keys that their account is tied to in a specific page.

Reseller 1: Key 1, 3, 4, 5, 6, 9
Reseller 2: Key 2, 7, 8,

Make sense? Just thought you might like a reference as to how this is being used.

Cool,

I’m marking this topic resolved then, but please let me know if you need more help.

Aloha, Eli