I am learning PHP by building a simple real estate management system. I have a form where people can add details of a house and it is added to a table called "properties". I then wanted the ability to add multiple images of the house which will then be shown as a gallery when the house is viewed.
I made a separate table to handle the image paths called "propertyimages". I can link the rows in this table with the property through the ID from the "properties" table. But my question is how can I save the image-paths with the id of the property if the property itself hasn't been saved to the table yet?
In other words, it would be easier if the property is first saved, then adding images since I have the property ID to then save the image paths, but I only have one form so how can I do this at the same time?