Okay this question is for the PHP Gurus. I trying to create an application with php and oracle database. Can this be done! I am just looking for your inputs and adise on how to tackle this.
1. I have a folder on my local server that contain imges. (temp_images).
2. I also have a folder on the save server that will house the images perminently. (permanent_images)
3. I have a oracle database that contains info about the images.
(parcel_id, datetime, folder_number.)
4. I want to create a web interface that will do the following.
a) I Load all the images from the temp_images directory into a drop down list.
b) Have a form (on the right side of the drop down list) that will have 3 fields for the user to enter info in, parcel_number, datetime, folder_number.
c) I user clicks on an image from the drop down list and enter the info on the right.
d) Click add record and the following should happen.
-this info should be added to table named ae72 in the oracle database.
-parcel_number in the parcel_number field, datetime in the datetime field, and folder_number in the folder_number field.
-the image that this info is associated with should be copied to the sub folder named (folder_number) in the permanent_image folder.
-Delete the image from the temp_image folder.
e) to make matter complicated, the sub folder in the permanent_image folder should only hold up to 1000 image max.
Wow, I just want to know how to get started and if it is possible to do this with php?