|
|
Posted by strawberry on 06/08/06 12:39
Curiously, the last movie (movie_id 7) now always appears at the bottom
of the ranked list. Have I done something wrong or is my computer just
exercising some form of editorial control - after all, it is a Nicholas
Cage movie!?!
The rank order processing function looks like this:
function processMoviesOrder($key)
{
if (!isset($_POST[$key]) || !is_array($_POST[$key]))
return;
$movies = getMovies();
$queries = array();
$ranking = 1;
foreach ($_POST[$key] as $movie_id) {
if (!array_key_exists($movie_id, $movies))
continue;
$query = sprintf('update movies set ranking = %d where movie_id =
%d',
$ranking,
$movie_id);
mysql_query($query);
$ranking++;
}
and the complete presentation page now looks like this;
<?php
require_once('database.php');
require_once('movies.php');
if (!dbConnect()) {
echo 'Error connecting to database';
exit;
}
$movies = getMovies();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"DTD/xhtml1-strict.dtd">
<html>
<head>
<title>phpRiot Sortable Lists</title>
<link rel="stylesheet" type="text/css" href="styles.css" />
<script type="text/javascript"
src="../javascripts/prototype.js"></script>
<script type="text/javascript"
src="../javascripts/scriptaculous.js"></script>
</head>
<body>
<h1>phpRiot Sortable Lists</h1>
<ul id="movies_list" class="sortable-list">
<?php
foreach($movies as $movie) {
//$movie->movie_id is the movie_id
//$movie->title is the title
//$movie->description is the description
?>
<li id="movie_<?= $movie->movie_id ?>"><?=
$movie->title.$movie->description ?></li>
<?php } ?>
</ul>
<script type="text/javascript">
function updateOrder()
{
var options = {
method : 'post',
parameters :
Sortable.serialize('movies_list')
};
new Ajax.Request('processor.php', options);
}
Sortable.create('movies_list', { onUpdate : updateOrder });
</script>
</body>
</html>
the javascripts referred to come from the scriptaculous website
strawberry wrote:
> Perfect. Thank you very much.
>
> ZeldorBlat wrote:
> > strawberry wrote:
> > > I'm trying to extend the script(s) provided at
> > > www.phpriot.com/d/articles/client-side/sortable-lists-with-php-and-ajax/.
> > > I'm struggling with the foreach syntax - I guess I'm just a dummy. I
> > > still don't get it despite reading through http://uk.php.net/foreach.
> > >
> > > Basically, there's a movie table (`movie_id`, `title`, `description`,
> > > `ranking`).
> > >
> > > and a function that gets the movies:
> > >
> > > function getMovies()
> > > {
> > > $query = 'select movie_id, title, description from movies order
> > > by ranking, lower(title)';
> > > $result = mysql_query($query);
> > >
> > > $movies = array();
> > > while ($row = mysql_fetch_object($result)) {
> > > $movies[$row->movie_id] = $row->title;
> > > }
> > >
> > > return $movies;
> > > }
> > >
> > >
> > > and here's where the titles are displayed on the page:
> > >
> > > <ul id="movies_list" class="sortable-list">
> > > <?php foreach ($movies as $movie_id => $title) { ?>
> > > <li id="movie_<?= $movie_id ?>"><?= $title ?></li>
> > > <?php } ?>
> > > </ul>
> > >
> > > For each movie what do I need to do to echo the movie description -
> > > within the <li> statement for instance.
> > >
> > > Hope that makes sense. Any help appreciated.
> >
> > In the getMovies() function, change the while loop to something like
> > this:
> >
> > while ($row = mysql_fetch_object($result)) {
> > $movies[] = $row;
> > }
> >
> > And when you display them:
> >
> > foreach($movies as $movie) {
> > //$movie->movie_id is the movie_id
> > //$movie->title is the title
> > //$movie->description is the description
> > }
[Back to original message]
|