when do i write my data to the data base?
i am building an image map generator. each time an image is clicked the coords and a text box contents are to be saved somehow. i am expecting upto 50 lines of data (x coord, y coord and text) :
image7.jpg 123 123 wheel
image7.jpg 485 688 tyre
image7.jpg 456 595 bolt
later on i want to display the image and create the hotspots imsge map with the text data as alt tags.
i expect to have a data table with 4 columns:
1 image name
2 x_coord
3 y_coord
4 text for alt tags
do i collect 50 sets of data in a temp file or array or something and then write it to a database in one go ? my worry is that if i write to the database it may be a pain to edit any mistakes. so maybe some kind of preview table might be a good idea....
i am building an image map generator. each time an image is clicked the coords and a text box contents are to be saved somehow. i am expecting upto 50 lines of data (x coord, y coord and text) :
image7.jpg 123 123 wheel
image7.jpg 485 688 tyre
image7.jpg 456 595 bolt
later on i want to display the image and create the hotspots imsge map with the text data as alt tags.
i expect to have a data table with 4 columns:
1 image name
2 x_coord
3 y_coord
4 text for alt tags
do i collect 50 sets of data in a temp file or array or something and then write it to a database in one go ? my worry is that if i write to the database it may be a pain to edit any mistakes. so maybe some kind of preview table might be a good idea....
Comment