Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Apr 2008
    Location
    nasik, india
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question common database sharing?

    Hello!
    I am eager to know , can 2 websites share same database?
    That means can these 2 websites add/edit/update/delete the same table of that database?
    Please share views,examples or resources on this topic.
    Thanks!..............
    Naim

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,058
    Thanks
    10
    Thanked 96 Times in 94 Posts
    Simple answer is yes, the database does not care.
    Complex answers could occur if you mean 2 different hosts accessing the same database since then you have to configure MySQL to accept connections from remote hosts.

    Need more info.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    Regular Coder
    Join Date
    May 2008
    Location
    Ohio
    Posts
    231
    Thanks
    3
    Thanked 21 Times in 21 Posts
    You can also set up users and permissions so that one user can read the database while another can read/insert/delete/drop/alter. I often like to set up permissions that way when I'm still in testing phases of a script - I don't want people exploiting it and dropping my database because I forgot to escape some form values, ya know?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •