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

Question

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 :-

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

Mark Baker · Accepted Answer · 2010-06-09 13:30:57Z

3

Normalize your data tables

items table

id  | item_name
--------------
1  | Item A
2  | Item B

item_files table

id  | item_id | item_files  
----------------------------------- 
1  | 1      | file1.zip
2  | 1      | file2.zip
3  | 1      | file3.zip 
4  | 2      | file3.zip

edited Jun 9, 2010 at 13:30

answered Jun 9, 2010 at 13:25

Mark Baker

213k34 gold badges354 silver badges391 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wow Over a year ago

Thanks Mark Baker. Clear now.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related