Below is a snippet of code that I've successfully implemented:
<script type="text/javascript">
$(document).ready(function() {
// Initializing the table
$('#table_1').tableDnD({
onDrop: function(table, row) {
$.tableDnD.serialize();
$.ajax({
type: "POST",
url: "test.php?"+$.tableDnD.serialize(),
data: "",
success: function(html){
alert("Success");
}
});
}
});
});
</script>
Sending data to test.php:
<?php
$table_1[] = $_GET['table_1'];
$i = 0;
if(!empty($table_1[0])){
foreach($table_1 as $value) {
foreach($value as $row){
$i++;
mysql_query("UPDATE mytable SET tableOrder='$i' WHERE id = '$row'");
}
}
}
?>
While the table_1 array retrieves data using $_GET, the aforementioned ajax code indicates we're sending with POST. Changing $_GET to $_POST leads to it not functioning anymore. Why could this be happening?