HEX
Server: Microsoft-IIS/8.5
System: Windows NT YDAWBH120 6.3 build 9600 (Windows Server 2012 R2 Standard Edition) AMD64
User: tentjecom_web (0)
PHP: 7.4.14
Disabled: NONE
Upload Files
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>';
	}
}
?>