File: D:/HostingSpaces/SBogers45/smuldersinterieurprojecten.nl/wwwroot/admin/php/fromjs/updateOrder.php
<?php
if(isset($_GET['array'])){
require_once '../connect.php';
$str = $_GET['array'];
$orderItemsArray = explode('-',$str);
foreach($orderItemsArray as $key => $value){
$temp = explode('|',$value);
$field = $temp[0];
$table = $temp[1];
$itemId = $temp[2];
$order = count($orderItemsArray) - $key ;
//update order in database
mysql_query('UPDATE '.$table.' SET '.$field.' = '.$order.' WHERE id = '.$itemId.' LIMIT 1');
// echo '<script type="text/javascript">alert(\'UPDATE '.$table.' SET '.$field.' = '.$order.' WHERE id = '.$itemId.' LIMIT 1\');</script>';
}
}
?>