Need Bulk Photo Upload / Photo Sort script for php4 / mysql5 project
$50-400 USD
Completed
Posted about 11 years ago
$50-400 USD
Paid on delivery
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 [login to view URL]
user= user1
pw= pass1234
---------------------------------------------------------
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. [login to view URL]$rlist[0])
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 ([login to view URL]) on May 5, 2013 at 2:21:31pm EST
It is renamed to ..\Images\[login to view URL]
(granted, it should be ..\Images\2013\18\[login to view URL] but my script at [login to view URL] does not work correctly on the test server). [don't know why]
Saved on server as ..\Images\[login to view URL] for Large version and ..\Images\[login to view URL] for the thumbnail.
Record added to 'tbl_photos' currently as:
INSERT INTO `tbl_photos` (`photoid`, `reqid`, `photolink`, `photodesc`, `photorank`, `dateuploaded`) VALUES
(2866803, 206618, '[login to view URL]', '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 [login to view URL] 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.