1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

implement application for multiple users, starting with db

Discussion in 'Databases' started by iago111, May 25, 2020.

0
  1. #1
    Hello, I wrote an texteditor with PHP,JS,mySQL that can extract data from JSON, write JSON files, display the update time etc.. I use 2 tabels in the db for 'sections' and 'items' (fields: headline / text) (1:n)

    Now I want to implement this for multiple users.
    I can write a log-in system using another table for the users, but then I stuff all the user data into these 2 tables.

    I this is a common way to do this or are there better alternatives?
    Thanks
     
    Solved! View solution.
    iago111, May 25, 2020 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,500
    Likes Received:
    4,460
    Best Answers:
    123
    Trophy Points:
    665
    #2
    That sounds exactly right.
     
    sarahk, May 25, 2020 IP
  3. iago111

    iago111 Member

    Messages:
    99
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    33
    #3
    O.K., cool!
     
    iago111, May 26, 2020 IP
  4. #4
    That is how its done, but you need to either create a 4th table which will be the link between "section" and "login" table.
    This is the table which will store userid and sectionId (titles) created by this user.
     
    JEET, May 28, 2020 IP
  5. iago111

    iago111 Member

    Messages:
    99
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    33
    #5
    O.k. thanks, because I have n:n!!
     
    iago111, May 29, 2020 IP