I have simple table “task” in database. I am able to load, insert new records and update them successfully on client side and dataprocessor updates values correctly on server-side.
However when i perform drag-n-drop operations … they dont get saved to database (was expecting id’s to change for the database records after drag-n-drop)
What am i missing?
Loaded Files
[code]
[/code]
Javascript Code
[code]$(document).ready(function() {
grid = new dhtmlXGridObject(‘grid-box’);
grid.setImagePath(“dhtmlx/imgs/”);
grid.setHeader("Task");
grid.setInitWidths("300");
grid.enableAutoWidth(true);
grid.setColAlign("left");
grid.setColTypes("ed");
grid.setColSorting("na");
grid.enableAlterCss("","");
grid.enableAutoHeight(true);
grid.init();
grid.enableDragAndDrop(true);
grid.setDragBehavior('complex');
grid.enableRowsHover(true, "gridhover");
grid.load("plus/php/task.php");
var dp = new dataProcessor("plus/php/task.php");
dp.init(grid);
dp.setUpdateMode(true); // tried dp.setUpdateMode("row",true);
$('#new-task').click(function(){
rowid = (new Date()).valueOf();
grid.addRow(rowid,"New Task");
})
})[/code]
PHP Code
include("config.php");
require("dhtmlx/apps/connector/grid_connector.php");
$data = new GridConnector($conn);
$data->enable_log("task.txt");
$sql = "SELECT * FROM task";
$data->render_sql($sql,"id","text");