Featured Articles
Announcing Pi
Technical Specifications
Raspberry Pi FAQs
Win a Pi
Raspberry Pi Wishlist
Actions
Forum Thread Details
  • Replies 9 replies
  • Subscribers 668 subscribers
  • Views 1871 views
  • Users 0 members are here
Related

MySql and Php

nicolaoscon96

Hello there,

 

I have a question and its not on electronics. I am building a website (to using MySQL and PHP) in order to control various things around the house (IoT). I manage to connect the database to the website all good until here but my question is...I am gonna have and other people added to the database each one with his/her own credentials (my family for example). How am I going to keep each one's settings separate? Can i create a new column in sql for each (e.g toggle button I add in PHP?) Is it cleaver to add a new table for each user that is added> (to half answer this question> adding another table I am going to overpopulate the database and its going to be a nightmare for maintenance and performance.

 

Any suggestions on this one?

 

Thanks a lot

nicolaoscon96

NcCon

Parents

  • Here is another idea:

     

    A users table, columns Id, Username, and User's name. Your choice if you need the name in multiple columns (first name, middle, last) or just one. It might be overkill, but other fields can be used to further describe the user, (gender, address, DOB, etc.) The username could be an email address or a unique name that the user chooses for him/herself to log in.

     

    Settings table, columns Id and setting description, such as Password, Color theme, Status (active, disabled), last log in date/time, etc.

     

    User_Settings table, columns id, user id, settings id, value

     

    Good luck with your project! sgarcia

Reply

  • Here is another idea:

     

    A users table, columns Id, Username, and User's name. Your choice if you need the name in multiple columns (first name, middle, last) or just one. It might be overkill, but other fields can be used to further describe the user, (gender, address, DOB, etc.) The username could be an email address or a unique name that the user chooses for him/herself to log in.

     

    Settings table, columns Id and setting description, such as Password, Color theme, Status (active, disabled), last log in date/time, etc.

     

    User_Settings table, columns id, user id, settings id, value

     

    Good luck with your project! sgarcia

Children
No Data