How to make db structure for multiple input in MySQL and PHP

Posted by bob on Stack Overflow See other posts from Stack Overflow or by bob
Published on 2010-06-09T13:18:55Z Indexed on 2010/06/09 13:22 UTC
Read the original article Hit count: 122

Filed under:
|
|

Below is my current structure for MySQL database

id | item_name  | item_files 
------------------------------------------
1  | Item A     | file1.zip,file2.zip,file3.zip
2  | Item B     | file3.zip 

Example I create simple form to fill up Item Name and Multiple upload files then store it to db.

Question :-

  1. How to design the db structure for accept the multiple files?
  2. There have a way which I don't want to use explode, implode to get the file1.zip file2.zip file3.zip

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql