Find Jobs
Hire Freelancers

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

$50-400 USD

Completed
Posted almost 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.
Project ID: 4520430

About the project

2 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I'm interested in this project, please refer to PM for details.
$200 USD in 2 days
5.0 (12 reviews)
4.3
4.3
2 freelancers are bidding on average $180 USD for this job
User Avatar
Hello, please check PM.
$160 USD in 7 days
5.0 (89 reviews)
5.8
5.8
User Avatar
I can do this for you
$333 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Mecklenburg, United States
5.0
92
Payment method verified
Member since Jun 25, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.