Hi, I need to create a PHP script to edit/update database entry.
Let me describe in details.
A MySql table contans 8 columns:
1. id
2. Name
3. image1
4. image1-type
5. image2
6. image2-type
7. image3
8. image3-type
(note: the image columns DO NOT contain entire image, only the URL of the image path is stored here, actual image has to be uploaded to the physical directory on the server)
Ok, now what I need is following:
1. Edit Page:
The page is accessed like this: [login to view URL] (someID will be passed from another page that calls this page)
Now, based on this 'id' you need to fetch the data and display like this:
Name
Image1
Image2
Image3
(note: Actual images will be displayed on the page)
Each of this image is clickable.
When you click the image, a File Browse field appears neaxt to the image implying the user can select another file to replace the origional. At the same time, the image is no longer clickable.
Along with File browse field, a cancle button also appears. Which when clicked will hide the file browse field and simultaniously turn the image back to clickable.
Now the user will have the option to update either one or any or all the images.
So for example, if the user wants to just update say image 2 and 3, the image1 should remain as it is.
When the user updates, the old images will be removed from the directory and the new ones will be copied to the directory as well as database entries updated.
2. Add Page:
Similarly a secon PHP page is required to ADD new entries.
If you have any questions, let me know.
Time frame is ASAP.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
PHP / MySql