I am creating a photo book app. Is it possible to upload multiple photos at the same time in one field?
What you want is a one-to-many relationship. For this you will need two tables:
- Your parent table, [photo_book]
- Your photos table, [photo_book_photos]
Table [photo_book_photos] will need at least 3 columns:
- A primary key, [id]
- A foreign key to the parent table, [photo_book_id]
- a column to store the photo, [photo]
Set column [photo_book_id] as a REF type to the parent table, and you should be able to add as many photos as needed.