Witam, mam już napisany kod w JavaScript, który odpowiada za przenoszenie moich danych z panelu do panelu poprzez metodę Drag'n'Drop. Niestety nie wiem jak napisać kod aby zapisywał przenoszenie do bazy MySQL. Oto mój kod: 

[PHP] pobierz, plaintext 
  1. <?php
  2. require_once "../silnik.php";
  3. require_once USTAWIENIA."szablon/admin.php";
  4.  
  5. echo "<script type='text/javascript'>
  6. $(document).ready(function() {
  7. 	$('.dragbox').each(function(){
  8. 		$('.dragbox').mouseover(function(){
  9. 			$(this).find('.dragbox-content').toggle();
  10. 		})
  11. 		$('.dragbox').mouseout(function(){
  12. 			$(this).find('.dragbox-content').toggle();
  13. 		})
  14. 		.click(function(){
  15. 			updateWidgetData();
  16. 		})
  17. 		.end()
  18. 	});
  19. 	$('.column').sortable({
  20. 		connectWith: '.column',
  21. 		handle: 'h2',
  22. 		cursor: 'move',
  23. 		placeholder: 'placeholder',
  24. 		forcePlaceholderSize: true,
  25. 		opacity: 0.4,
  26. 		start: function(event, ui){
  27. 			//Firefox, Safari/Chrome fire click event after drag is complete, fix for that
  28. 			if($.browser.mozilla || $.browser.safari) 
  29. 				$(ui.item).find('.dragbox-content').toggle();
  30. 		},
  31. 		stop: function(event, ui){
  32. 			ui.item.css({'top':'0','left':'0'}); //Opera fix
  33. 			if(!$.browser.mozilla && !$.browser.safari)
  34. 				updateWidgetData();
  35. 		}
  36. 	})
  37. 	.disableSelection();
  38. });
  39. function updateWidgetData(){
  40. 	var items=[];
  41. 	$('.column').each(function(){
  42. 		var columnId=$(this).attr('id');
  43. 		$('.dragbox', this).each(function(i){
  44. 			var item={
  45. 				id: $(this).attr('id'),
  46. 				order : i,
  47. 				column: columnId
  48. 			};
  49. 			items.push(item);
  50. 		});
  51. 	});
  52. 	var sortorder={ items: items };
  53.  
  54. 	# Tutaj powinien zanaleźć się kod do zapisu w bazie danych MySQL
  55.  
  56. }
  57. </script>";
  58.  
  59. if (isset($_GET['action']) && $_GET['action'] == "refresh") {
  60. 	$i = 1;
  61. 	$result = mysql_query("SELECT * FROM ".DB_PREFIX."panele WHERE panel_side='1' ORDER BY panel_order");
  62. 	while ($data = mysql_fetch_assoc($result)) {
  63. 		$result2 = mysql_query("UPDATE ".DB_PREFIX."panele SET panel_order='$i' WHERE panel_id='".$data['panel_id']."'");
  64. 		$i++;
  65. 	}
  66. 	$i = 1;
  67. 	$result = mysql_query("SELECT * FROM ".DB_PREFIX."panele WHERE panel_side='2' ORDER BY panel_order");
  68. 	while ($data = mysql_fetch_assoc($result)) {
  69. 		$result2 = mysql_query("UPDATE ".DB_PREFIX."panele SET panel_order='$i' WHERE panel_id='".$data['panel_id']."'");
  70. 		$i++;
  71. 	}
  72. 	$i = 1;
  73. 	$result = mysql_query("SELECT * FROM ".DB_PREFIX."panele WHERE panel_side='3' ORDER BY panel_order");
  74. 	while ($data = mysql_fetch_assoc($result)) {
  75. 		$result2 = mysql_query("UPDATE ".DB_PREFIX."panele SET panel_order='$i' WHERE panel_id='".$data['panel_id']."'");
  76. 		$i++;
  77. 	}
  78. 	$i = 1;
  79. 	$result = mysql_query("SELECT * FROM ".DB_PREFIX."panele WHERE panel_side='4' ORDER BY panel_order");
  80. 	while ($data = mysql_fetch_assoc($result)) {
  81. 		$result2 = mysql_query("UPDATE ".DB_PREFIX."panele SET panel_order='$i' WHERE panel_id='".$data['panel_id']."'");
  82. 		$i++;
  83. 	}
  84. }
  85. if ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['panel_id']) && isnum($_GET['panel_id']))) {
  86. 	$data = mysql_fetch_assoc(mysql_query("SELECT * FROM ".DB_PREFIX."panele WHERE panel_id='".$_GET['panel_id']."'"));
  87. 	$result = mysql_query("DELETE FROM ".DB_PREFIX."panele WHERE panel_id='".$_GET['panel_id']."'");
  88. 	$result = mysql_query("UPDATE ".DB_PREFIX."panele SET panel_order=panel_order-1 WHERE panel_side='$panel_side' AND panel_order>='".$data['panel_order']."'");
  89. 	redirect(FUSION_SELF.$aidlink);
  90. }
  91. if ((isset($_GET['action']) && $_GET['action'] == "setstatus") && (isset($_GET['panel_id']) && isnum($_GET['panel_id']))) {
  92. 	$result = mysql_query("UPDATE ".DB_PREFIX."panele SET panel_status='".intval($_GET['status'])."' WHERE panel_id='".$_GET['panel_id']."'");
  93. }
  94.  
  95. opentable($locale['400']);
  96. ?>
  97. 	<div class='column tbl2 col1' id='column2'>
  98. 		<?php $result = mysql_query("SELECT * FROM ".DB_PREFIX."panele WHERE panel_side='2' ORDER BY panel_order");
  99. 		while ($data = mysql_fetch_assoc($result)) { ?>
  100. 			<div class='dragbox' id='item<?= $data['panel_id'] ?>'>
  101. 				<h2>
  102. 					<div class='dragbox-name-content'><img src='<?= ADMIN ?>images/drag.png' alt='' /> <?= $data['panel_name'] ?></div>
  103. 					<div class='dragbox-content' style='display:none;'>
  104. 						<a href='panel_editor.php<?= $aidlink ?>&amp;action=edit&amp;panel_id=<?= $data['panel_id'] ?>&amp;panel_side=1' title='<?= $locale['434'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/edit.png' alt='<?= $locale['434'] ?>' /></a>
  105. 						<?php if ($data['panel_status'] == 0) { ?>
  106. 							<a href='<?= FUSION_SELF.$aidlink ?>&amp;action=setstatus&amp;status=1&amp;panel_id=<?= $data['panel_id'] ?>' title='<?= $locale['435'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/on.png' alt='<?= $locale['435'] ?>' /></a>
  107. 						<?php } else { ?>
  108. 							<a href='<?= FUSION_SELF.$aidlink ?>&amp;action=setstatus&amp;status=0&amp;panel_id=<?= $data['panel_id'] ?>' title='<?= $locale['436'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/off.png' alt='<?= $locale['436'] ?>' /></a>
  109. 						<?php } ?>
  110. 						<a href='<?= FUSION_SELF.$aidlink ?>&amp;action=delete&amp;panel_id=<?= $data['panel_id'] ?>&amp;panel_side=<?= $data['panel_side'] ?>' onclick='return confirm('<?= $locale['440'] ?>');' title='<?= $locale['437'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/delete.png' alt='<?= $locale['437'] ?>' /></a>
  111. 					</div>
  112. 					<div class='clear'></div>
  113. 				</h2>
  114. 			</div>
  115. 		<?php } ?>			
  116. 	</div>
  117. 	<div class='column tbl2 col2' id='column1'>
  118. 		<?php $result = mysql_query("SELECT * FROM ".DB_PREFIX."panele WHERE panel_side='1' ORDER BY panel_order"); 
  119. 		while ($data = mysql_fetch_assoc($result)) { ?>
  120. 			<div class='dragbox' id='item<?= $data['panel_id'] ?>'>
  121. 				<h2>
  122. 					<div class='dragbox-name-content'><img src='<?= ADMIN ?>images/drag.png' alt='' /> <?= $data['panel_name'] ?></div>
  123. 					<div class='dragbox-content' style='display:none;'>
  124. 						<a href='panel_editor.php<?= $aidlink ?>&amp;action=edit&amp;panel_id=<?= $data['panel_id'] ?>&amp;panel_side=1' title='<?= $locale['434'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/edit.png' alt='<?= $locale['434'] ?>' /></a>
  125. 						<?php if ($data['panel_status'] == 0) { ?>
  126. 							<a href='<?= FUSION_SELF.$aidlink ?>&amp;action=setstatus&amp;status=1&amp;panel_id=<?= $data['panel_id'] ?>' title='<?= $locale['435'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/on.png' alt='<?= $locale['435'] ?>' /></a>
  127. 						<?php } else { ?>
  128. 							<a href='<?= FUSION_SELF.$aidlink ?>&amp;action=setstatus&amp;status=0&amp;panel_id=<?= $data['panel_id'] ?>' title='<?= $locale['436'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/off.png' alt='<?= $locale['436'] ?>' /></a>
  129. 						<?php } ?>
  130. 						<a href='<?= FUSION_SELF.$aidlink ?>&amp;action=delete&amp;panel_id=<?= $data['panel_id'] ?>&amp;panel_side=<?= $data['panel_side'] ?>' onclick='return confirm('<?= $locale['440'] ?>');' title='<?= $locale['437'] ?>' class='tip'><img src='<?= THEMES ?>templates/images/delete.png' alt='<?= $locale['437'] ?>' /></a>
  131. 					</div>
  132. 					<div class='clear'></div>
  133. 				</h2>
  134. 			</div>
  135. 		<?php } ?>				
  136. 	</div>
  137. <?
  138. closetable();
  139. require_once USTAWIENIA."szablon/stopka.php";
  140. ?>
[PHP] pobierz, plaintext