javascript - How to cycle through tasks and keep track of it in PHP -


i'm developing web application in php in user can create tasks other users compete.

those tasks stored in mysql database.

my question is, how can cycle through tasks database , present users while keeping track of tasks user has completed avoid presenting same task user. while providing user created task number of users have completed his/her task.

how can accomplish in php?

well, far can see, think many - - many relational tables looking for, assuming user can many tasks , task can done multiple users. need 3 tables:

  • tasks: task_id, task_name, whatever_else_you_need_like_details

  • users: user_id, w/e

  • relations: task_id, user_id, status <- last 1 checking weather specific task done specific user or in general see tasks assigned user status , vica versa.

read on mano-to-many relations, foreign keys , left/right joins:)


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -