Advertisement
kerlser

php check

Jul 18th, 2024 (edited)
261
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.31 KB | None | 0 0
  1. <?
  2.  
  3. // Sort Action
  4.  
  5. // Get VARS ///////////////////////
  6. $neworder = $_REQUEST['neworder'];
  7. $myOrder = "";
  8. if ($_REQUEST['check'] == "1"){
  9.     $myDB = "bb_portfolio";
  10. } else if ($_REQUEST['check'] == "2"){
  11.     $myDB = "bb_still_life";
  12. }  else if ($_REQUEST['check'] == "3"){
  13.     $myDB = "bb_cgi";
  14. } else if ($_REQUEST['check'] == "4"){
  15.     $myDB = "bb_location";
  16. } else if ($_REQUEST['check'] == "5"){
  17.     $myDB = "bb_commercial";
  18. } else if ($_REQUEST['check'] == "specialsets"){
  19. $myDB = "bb_specialsets";
  20. } else if ($_REQUEST['check'] == "contact"){
  21.     $myDB = "bb_contact";
  22.     $myOrder = "normal";
  23. }
  24. ///////////////////////////////////////
  25.  
  26. include ('includes/connect.inc.php');
  27.  
  28. // New Order ////////////////////////
  29. $neworderSort = array ();
  30. $neworder = explode(',',$neworder);
  31. foreach($neworder AS $id){
  32.     $id = str_replace ("item-","",$id);
  33.     array_push ($neworderSort, $id);
  34. }
  35. $neworderSortLength = count ($neworderSort);
  36.  
  37.  
  38. if ($myOrder == "normal") {
  39.     for ($i=0;$i<$neworderSortLength;$i++){
  40.         mysqli_query("UPDATE $myDB
  41.                 SET sortid = '$i'
  42.                 WHERE id = $neworderSort[$i]");
  43.     }
  44. } else {
  45.     // IN THIS CASE IN REVERSE ORDER !!! //
  46.  
  47.     for ($i=0;$i<$neworderSortLength;$i++){
  48.  
  49.         $j = $neworderSortLength - $i;
  50.  
  51.         mysqli_query("UPDATE $myDB
  52.                 SET sortid = '$j'
  53.                 WHERE id = $neworderSort[$i]");
  54.     }
  55. }
  56.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement