Code Theory: [database] List Positioner

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
phice
Moderator
Posts: 1416
Joined: Sat Apr 20, 2002 3:14 pm
Location: Dallas, TX
Contact:

Code Theory: [database] List Positioner

Post by phice »

This short theory of code will allow the user to move items (with numbers 1-*) to move his/her items up and down the list (within reason).

Code: Select all

number $pos position UP/DOWN
 if($move=="up")
   $setting = $pos-1;
 elseif($move=="down")
   $setting = $pos+1;
 else /* Error trap */
   die("Unable to determine movement.");
  if($move=="up" && $setting==0) /* Error trap */
    die("Error, cannot move #1 up.");
  query("SELECT * FROM `table` WHERE `position` > '$setting'");
    foreach($rowї'position'])
 if($move=="up")
      $setї$i] = $rowї'position']+1;
 elseif($move=="down")
      $setї$i] = $rowї'position']-1;
  foreach($set)
    query("UPDATE `table` SET `position` = '$setї$i]'");
  query("UPDATE `table` SET `position` = '$setting'");
This isn't actual coding, it's just a way how one would set up such a positioner. Feel free to use however you wish. :)
Image Image
Post Reply