Opnion needed for best database method php/mysql security wise

Discussion in 'Programming' started by kindy, Mar 29, 2009.

  1. #1
    Hi I am creating multi user script.

    I need your opinion as to whether I should merge all new user data into 1 database and allocate each entry by user_id

    example:

    Table: Books
    book_name, author, user_id

    -or-

    give each user their own database

    example:

    Table: clientsname_Books
    book_name, author


    The reason why I am asking for an opnion is because I am trying to work out the most secure approach to prevent SQL injections deleting the entire database, or making it harder for an attacker to delete everyone elses data? what do you think?
     
    kindy, Mar 29, 2009 IP