Project Detail

Drag & Drop Photos / Update MySQL

Drag & Drop Photos / Update MySQL is project number 270293
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: devcenter

Budget: $30-250

Created: 06/04/2008 at 2:33 EDT

Bid Count: 3

Average Bid:
$ 32

06/11/2008 at 2:33 EDT

Project Creator: aguaweb
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (2 reviews)

Description

I am creating an interface for a client where they can drag and drop images to arrange the photo order. The new order must then update a MySQL database using PHP.

Database Fields: - Primary key is combination of photo_id and model_id
photo_id
model_id
photo_position

After the photos are reordered, it needs to update the photo_position field for the specified photo_id/model_id combination.

Here's the code I'm using... the drag and drop is working, but the database is not being updated. I'm told the javascript should refresh the page automatically and run the PHP script but I'm not very experienced with AJAX.

********************************************************************************************************************
MY CODE:

<?php
// (db connect & call recordset)

$model_id = $_GET['model_id'];

foreach(explode(",",$_GET['order']) as $key=>$value) {
mysql_query("UPDATE tbl_model_photo SET photo_position='" . $i . "' WHERE model_id = $model_id and photo_id = '" . $value . "'");
$i++;
}
?>

<html>
<body>
<div id="photo_arrange">
<?php do { ?>
<div id="photo_<?php echo $photo_id; ?>">
<img src="../images/models/photos/<?php echo $model_id; ?>/<?php echo $photo_id; ?>.jpg" />
</div>
<?php } while ($row_rs_photo = mysql_fetch_assoc($rs_photo)); ?>
</div>

<script type="text/javascript">
new Sortables($('photo_arrange'), {
onComplete: function() {
new Ajax("model_arrange.php?model_id=<?php echo $model_id; ?>&order="+this.serialize(function(el) {
return el.id.replace("photo_","");
})).request();
}
});
</script>

</body>
</html>

********************************************************************************************************************
JAVASCRIPT CODE:
Attached in file.

Additional files submitted:
mootools.js

Report Violation

Job Type

See more: ., call, code, connect, database, images, javascript, key, mysql, page, photo, photos, php, php script, script, sql database, update

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

06-04-2008 03:14 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

I can do it within hours. I've experienced this kind of task. Thanks.

samsolutions21

0 days

06-05-2008 06:24 EDT

(No Feedback Yet)

I am ready to start

kunnal

2 days

06-05-2008 12:51 EDT

(No Feedback Yet)

Sir I will do this for you.And u will appreciate my work thanks

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.