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.

  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)
    SEMrush
    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
    SEMrush
  2. sarahk

    sarahk iTamer Staff

    Messages:
    26,241
    Likes Received:
    3,867
    Best Answers:
    108
    Trophy Points:
    665
    #2
    That sounds exactly right.
     
    sarahk, May 25, 2020 IP
  3. iago111

    iago111 Greenhorn

    Messages:
    30
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    8
    #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 Greenhorn

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