I need to have the following for an existing php 4 / mysql 5 project.
1. Bulk upload photo (.jpg) capability
2. Sort photos capability
Hopefully both can be accomplished via jquery.
Both functions will need to interact with existing mysql table(s).
*Note* This must work with php version 4.4.8. It would of course be useful if it also works in php 5.
I can provide a partial phpinfo if needed.
Current php files and mysql tables will be attached via zip.
You can view the test server at [url removed, login to view]
Part 1: Bulk photo upload script
The user should be able to upload 10 to 15 photos at a time with a small text description for each. More than 15 photos is ok too as long as the script does not time out.
Script should read a variable 'rid' (e.g. [url removed, login to view]$rlist)
Each photo selected will require the following:
Resized on the fly into two versions (aspect ration kept the same)
Large resized to max width of 325px (and max height of 325px).
Thumbnail resized to max width of 100px (and max height of 100px).
Renamed as follows:
Large as [rid]_[value of field 'photoid' from mysql table 'tbl_photos']_[unix time stamp].jpg
Saved on server in default directory 'Images' as follows:
Large as ..\Images\[four digit year]\[week of the year#]\[name of photo as above]
Thumbnail as ..\Images\[two digit year]\[week of the year#]\[name of photo as above].jpg
Record added to 'tbl_photos' fields as follows:
'photoid' = auto-incrementing row id
'photolink' = as saved on server without ..\Images\
'photodesc' = text from description field associated with photo
'photorank' = ([rid][(either an auto-incrementing number or unix time stamp)])
'dateuploaded' = [date("U")]
and repeat with next photo selected, etc.
In the example I have on the test server:
The test transaction's rid=206618
I uploaded a file ([url removed, login to view]) on May 5, 2013 at 2:21:31pm EST
It is renamed to ..\Images\[url removed, login to view]
(granted, it should be ..\Images\2013\18\[url removed, login to view] but my script at [url removed, login to view] does not work correctly on the test server). [don't know why]
Saved on server as ..\Images\[url removed, login to view] for Large version and ..\Images\[url removed, login to view] for the thumbnail.
Record added to 'tbl_photos' currently as:
INSERT INTO `tbl_photos` (`photoid`, `reqid`, `photolink`, `photodesc`, `photorank`, `dateuploaded`) VALUES
(2866803, 206618, '[url removed, login to view]', 'test photo 1', 0, 1367781691)
Note: 'photorank' should be 20661801 or 1367781691 instead of 0 but I haven't implemented this yet (part of reason for this project)
Part 2: Sort Photos script
Currently most photos are added via [url removed, login to view] one at a time. They are eventually printed four to a page (reason for resizing) and displayed in the order in which they are uploaded. The problem happens when a user uploads 14 photos (14 used only as an example). If they need to change the first photo or have made an error in the upload order, there is no easy way for the user to change the photo ranking/order. I usually have to go in to the mysql table and manually "fix" it. You can see how the uploaded photos display in the example transaction by clicking the View button on photo_add.php.
What I'd like to see is perhaps a jquery or ajax display of the photo thumbnails for a particular transaction (rid). The ability to drag and drop would be very handy. This would change most likely the 'photorank' field in the table 'tbl_photos'. If there is an easier way, I'm open to suggestions.