germanmary asked 9 years ago
Hi abu,
I have a small issue and doubts,
I have two tables
table1 and table2
i have done the grids. in table2 page i have used the dropdown call back method
it works fine
i would like to updated the status in the first table based on the status selected in the second page.
i have tried with custom event but it is not getting updated.
can you guide me how to do it?
Thanks
Abu Ghufran answered 9 years ago
In the on_update event of second grid page, you can execute a sql command that update the first table.
germanmary answered 9 years ago
yes i have tried that also
but it is not updated
i will paste my code in pastebin
please tell me the problem where it occurs
Abu Ghufran answered 9 years ago
Code looks fine, please add some debugging lines in callback to check the issue.
function update_by($data)
{
ob_start();
print_r($data);
$arr = ( ob_get_clean() );
$str = "UPDATE invopo_quotationmaster SET status='ordered'
WHERE quotationid = {$data["quotationid"]}";
mysql_query($str);
echo $arr;
phpgrid_error($str);
}
Abu Ghufran answered 9 years ago
Try following steps.
1) Open grid in firefox
2) Press F12, firebug mode.
3) Do an update on grid
4) Check firebug POST ajax call of update
5) Check the ajax Response tab of that call.
What ever you echo in that function should be printed along in ajax response tab.
