i m using dhtmlxgrid but when i update the row then it will

Discontinued products Uncategorized discussions
#1

Hello,



i m using the below code please tell me what i do or some other way to update the row













    mygrid = new dhtmlXGridObject(‘gridbox’);

    mygrid.setImagePath(‘dhtmlxGrid/codebase/imgs/’);

    mygrid.setHeader(“Add/Del,ShotID,Shotstatus,TaskID,Taskref,Task-Note,Alloted Mandays,UserID,TaskStatus,StartDate,EndDate,Task Priority,Next-Sub,Last-Sub,Actual Mandays,Supervisor”);

    mygrid.setColTypes(“link,ch,txt,ed,ed,ed,ed,ed,ed,ed,dhxCalendarA,ed,ed,ed,ed”);

    mygrid.setSkin(“modern”)

    

    mygrid.attachHeader("#connector_text_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter, ,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_text_filter,#connector_select_filter,#connector_select_filter,#connector_select_filter,#connector_text_filter")

    

    mygrid.setColSorting(“connector,int,connector”)



    mygrid.init();

    mygrid.enableSmartRendering(true);

    mygrid.enableMultiselect(true);

        mygrid.loadXML(“connector.php”);

    var dp = new dataProcessor(“connector.php”);

    dp.init(mygrid);

    



and this is my code



$res=mysql_connect(“localhost”,“root”,"");

    mysql_select_db(“kanibrainnew1”);

    require_once("…/dhtmlxConnector_php/codebase/grid_connector.php");

    $grid = new GridConnector($res);

    $grid->dynamic_loading(100);







function myUpdate($action){



mysql_query(“UPDATE shot SET userID=’{$action->get_value(‘name’)}’ WHERE id=’{$action->get_id()}’”);

$action->success();

}





$grid->render_sql(“select * from shot,shotTaskArtist where shotTaskArtist.projID = shot.projID and shot.projID=‘om’ and shotTaskArtist.shotID = shot.shotID”,“shotID”,“shotID,shotStatus,taskID,TaskREF,task_note,mandays,userID,taskStatus,startDate,endDate,priority,naxt_sub,last_sub,actualMandays,supervisorName”);







please reply me as soon as possible





thanks
#2

Your code looks correct. If you have problems with Grid and Connectors configuration you can contact sales@dhtmlx.com and request for code customization