I have a database that holds information for my young piano students, their assignments etc … .
I would like to allow them to choose a virtual “sticker” image when they complete a piece.
Is there a way to show a set of images, allow them to select one, and then cause that image to be assigned into an image field in my database.
I don’t see a way to display or select images other than “upload”. I do not want the user to have to upload anything, just to choose from a set I can already display.
What would be the best way to go about:
Displaying a set of images, allowing someone to select one somehow, and on that selection trigger, to assign the selected image to the image field in the database.
To make things more complicated I want to do this for only a set of of items per students, their completed pieces.
So I can envision creating a filtered set of data but would like allow selection for each filtered item in the database.
How would I go about refreshing after insertion of the image (assuming one can do this).
Any suggestions? Thanks!!