How to upload multiple files for a record in PHP/Mysql

Question

I am looking to build a table in PHP/MySQL where NAME, ADDRESS, MOBILE, CERTIFICATE of a candidate can be stored. In CERTIFICATE field (column) I want to store multiple certificates of the candidate. Could anyone please let me know how multiple files can be store in a column and how to access it later?

I would suggest to store each certificate separately and have a OneToMany relation to the table, that hold old those certificates. But if you think that you do not need to store it this way, try to store all certificates as a json value in a text field — pomaxa
– pomaxa, Commented Sep 8, 2020 at 13:25

O. Jones · Accepted Answer · 2020-09-08 12:26:15Z

2

You don't store multiples of anything in a single column value. That's not the way SQL databases work. You make a separate table, maybe called cert. It will have, at least, these columns.

cert_id        INT  autoincrementing primary key
candidate_id   INT  the id of the candidate owning this certificate
certificate    (You didn't tell us the data type of this)

Then, a candidate can have zero, one, or more certificates. This is called a one-to-many relationship in the parlance of entity-relationship database design.

Pardon me for being so blunt. But you still have time to avoid this common, but very serious, mistake of trying to put multiple things in one column value. It's a mistake that can make your system hard to maintain in the future.

edited Sep 8, 2020 at 12:26

answered Sep 8, 2020 at 11:27

O. Jones

110k17 gold badges134 silver badges187 bronze badges

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

Collectives™ on Stack Overflow

How to upload multiple files for a record in PHP/Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related