many users to access only their database information

Take a look at this article, it outlines some of the ways you can do something like this:

Using Participants Database with WordPress Users

Thanks Xnau Webdesign, looking quickly at the article its exactly what I was looking for. Thank you again and I will be going through this in its entirety this weekend.

cheers

Hi @xnau

Firstly great plugin!

I’ve read back on this thread and looked on your support documentation. Is it possible to use your plugin for the following scenario?

Is it possible to have a dropdown box on a participants record that allows you to select from a list of existing WP_Users to allows them editor access to the record and then a second dropdown box that allows you to select from a list of WP_Users (maybe more than one) to have read only access?

I basically want to be able to select from a list of WP_Users and allow edit access level and then select other users for read only. I don’t want all participants data to be accessible to everyone.

I hope this makes sense.

Thanks

• This reply was modified 7 years, 2 months ago by welsh10.
• This reply was modified 7 years, 2 months ago by welsh10.

It does make sense, and it’s possible with some coding skills.

If I were doing something like this, I’d define a shortcode that presents the dropdowns. The code that generates the dropdowns would set up the options by querying the database directly for a list of record ids (for the read-only record) or private ids (for the editable record). That is where you would apply your criteria for which records go in each list.

To generate the record edit URL, you could use a plugin function like this:

Participants_Db::get_record_link( $private_id )

then for your read-only record URL, a function like this:

Participants_Db::single_record_url( $id )

Finally, the dropdown selects a URL, which doesn’t actually do anything, so depending on what you wanted to happen when the user makes a selection, you could use some javascript to use the URL to take the user to the selected page.

• This reply was modified 7 years, 2 months ago by xnau webdesign.

@xnau

Thank you for the response. This sounds complicated to achieve without advanced Php coding skills?

Do you have any .php scripts that I can use to cut lines from and use as a guide. I may be able to get this working with some heavy reading and a bit of support.

Thanks

Yes, it’s not something you’d be able to do without some good coding skills. I don’t have anything that would get you started on this, it’s not something I’ve had anybody ask for before, I’m sorry.

@xnau Thanks for responding. That’s a shame.