In Progress

Need Bulk Photo Upload / Photo Sort script for php4 / mysql5 project

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]

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. [url removed, login to view]$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 ([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.

Skills: AJAX, HTML5, jQuery / Prototype, MySQL, PHP

See more: php server selected project, may need jquery, max auto, photo name, bulk file, small php script variable, mysql sort field, jquery upload photo, bulk transaction, jquery file upload error, insert variable, php upload test script, jquery error fix, ajax text files, read file error number, easy ajax mysql table, aspect jquery, date mysql sort, php read large file, work user php project, php ajax thumbnail, order photo, jquery sort php, jquery file upload test, php4 script

About the Employer:
( 92 reviews ) Mecklenburg, United States

Project ID: #4520430

Awarded to:


Hi, I'm interested in this project, please refer to PM for details.

$200 USD in 2 days
(12 Reviews)

2 freelancers are bidding on average $180 for this job


Hello, please check PM.

$160 USD in 7 days
(89 Reviews)

I can do this for you

$333 USD in 5 days
(0 Reviews)