I'm trying to display a list of items from the database and let the
user drag them around to sort them however they like. Each time they
drag something, a function should fire that loops through all of the
rows and saves the sort order to the database so that the next time
the user loads that page, everything is sorted like it was when they
left. I don't know much at all about AJAX/javascript so have just been
looking for tutorials/code samples to do this....I found something
that uses CakePHP's built in AJAX sortable. I've got the drag & drop
working, but it's not firing the function to go to the database.
Please help!!
VIEW:
<div id="items">
<?php
foreach ($items as $item): ?>
<div id="item_<?php echo $item['Item']['id']; ?>"
class="item">
<?php echo $item['Item']['name'];?>
</div>
<?php endforeach; ?>
</div>
<?php echo $ajax->sortable('items', array(
'tag' => 'div',
'only' => 'item',
'hoverclass' => 'selected',
'url' => array('controller' => 'items', 'action' => 'order')
));
?>
CONTROLLER:
function order() {
if ($this->RequestHandler->isAjax()) {
$ids= $this->params['form']['items'];
$i = 1;
foreach ($ids as $id) {
$this->Item->id = $id;
$this->Item->saveField('sort_order', $i++);
}
$this->autoRender = false;
}
}
I'm importing the 'Javascript', 'Ajax' Helpers in app_controller.php.
I also tried 'onUpdate' => array('controller' => 'items', 'action' =>
'order') instead of 'url' => array('controller' => 'items', 'action'
=> 'order')....but that doesn't work either.
Any help would be VERY much appreciated. Thank you!!
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
