Multiple logins for Wordpress site + data table

Original Post:

1977

Free Member
May 10, 2012
273
27
I’m going to need a system for a new WP site that allows anyone that applies for access the ability to upload data in the form of best times for a competition.

(Only to upload their scores, nothing else)

The table needs to be automatically updated once the score is submitted, and I need the ability to manually remove anything if needed.

Do any of you have any experience with this sort of thing? If so what is the best approach/plugins etc.

Cheers
 

fisicx

Moderator
Sep 12, 2006
46,761
8
15,412
Aldershot
www.aerin.co.uk
Not complicated. You create a password protected page that contains a simple form. On submission the new data gets added to a database table.

You then have an admin area that displays all the data with an option to delete selected rows.

There are other similar ways to do this but it’s best never to allow this type of user any access to the dashboard. You set it up so when they login it takes them to the protected form. They can’t even edit their user profile.
 
  • Like
Reactions: 1977
Upvote 0

1977

Free Member
May 10, 2012
273
27
Not complicated. You create a password protected page that contains a simple form. On submission the new data gets added to a database table.

You then have an admin area that displays all the data with an option to delete selected rows.

There are other similar ways to do this but it’s best never to allow this type of user any access to the dashboard. You set it up so when they login it takes them to the protected form. They can’t even edit their user profile.
Thanks.

With regards to the database table, is there a plugin you’d recommend?
 
Upvote 0

fisicx

Moderator
Sep 12, 2006
46,761
8
15,412
Aldershot
www.aerin.co.uk
With regards to the database table, is there a plugin you’d recommend?
This would be a custom plugin. The plugin would create the database table on activation. There isn’t an off the shelf plugin that will do what you want.

But this is the sort of thing I and other plugin developers build all the time.
 
  • Like
Reactions: 1977
Upvote 0

UKSBD

Moderator
  • Dec 30, 2005
    13,033
    1
    2,831
    I’m going to need a system for a new WP site that allows anyone that applies for access the ability to upload data in the form of best times for a competition.

    (Only to upload their scores, nothing else)

    The table needs to be automatically updated once the score is submitted, and I need the ability to manually remove anything if needed.

    Do any of you have any experience with this sort of thing? If so what is the best approach/plugins etc.

    Cheers

    Why do you need the times added to the database?

    Will you display it on a website, or is it just for you to see?

    When you say "times" do you mean minutes and seconds it took for someone to do something?
     
    Upvote 0

    1977

    Free Member
    May 10, 2012
    273
    27
    Why do you need the times added to the database?

    Will you display it on a website, or is it just for you to see?

    When you say "times" do you mean minutes and seconds it took for someone to do something?
    Yep, minutes and seconds displayed to everyone.

    It’s for a competition and everyone competing will need to see everyone else’s times so they can try to beat them.
     
    Upvote 0

    Latest Articles

    Join UK Business Forums for free business advice