update multiple table fetch data in grid

seema · December 19, 2011, 1:10pm

Hi ,

I am using 4 tables to show data and when i am trying to update the data then it will not work . can you please tell me how i update the data.

below is my code

var mygrid = new dhtmlXGridObject(‘products_grid’);
mygrid.setImagePath(“<?php echo base_url();?>public/js/codebase/imgs/”);
mygrid.setHeader(“id,Catgeory,Subcategory,Subsubcategory,Tutorial Name,File Name”);
mygrid.attachHeader("#select_filter,#select_filter,#select_filter,#select_filter,#select_filter,#select_filter")
mygrid.setInitWidths("*,150,150,150,150,150");
mygrid.setColAlign(“left,left,left,left,left,right”);
mygrid.setColSorting(“str,str,str,str,str,str”);
mygrid.setColTypes(“ch,link,ed,ed,ed,ed”);

											mygrid.setSkin("modern");
											mygrid.enableSmartRendering(true)
											mygrid.enableMultiselect(true)
											mygrid.init();
											mygrid.enableSmartRendering(true);
											//gridQString = "<?php echo base_url();?>category_module/show_data";//save query string to global variable (see step 5 for details)
											
											gridQString="<?php echo base_url();?>public/dhtmlx_file/02_rendering_connector.php";
											
											mygrid.loadXML(gridQString );
										
											var dp = new dataProcessor("<?php echo base_url();?>public/dhtmlx_file/02_rendering_connector.php");
											dp.init(mygrid);

require_once(“config.php”);
$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_select_db($mysql_db);

function color_rows($row){
	if ($row->get_index()%2) {
		$row->set_row_style("background-color: light gray");
	}
}
require("grid_connector.php");
$grid = new GridConnector($res);

$grid->dynamic_loading(100);
$grid->enable_log("log.txt"); 
$grid->event->attach("beforeRender","color_rows");
$grid->event->attach("beforeUpdate","myUpdate");

function myUpdate($action){

mysql_query(“UPDATE category_table SET category_name=’{$action->get_data(‘category_name’)}’ WHERE category_id=’{$action->get_id()}’”);
$action->success();
}

 $sql="SELECT  t.tutorial_id as id,ssc.sub_sub_category_id as id,sc.sub_category_id as id, c.category_id as id, t.tutorial_name,t.file_name,t.	tutorial_content,ssc.sub_sub_category_name,ssc.sub_sub_category_content,sc.sub_category_name,sc.sub_category_content,c.category_name,c.category_desc FROM tutorial_table t LEFT JOIN 
 	  sub_sub_category_table ssc ON t.sub_sub_category_id = ssc.sub_sub_category_id LEFT JOIN
	  sub_category_table sc ON ssc.sub_category_id = sc.sub_category_id LEFT JOIN 
	  category_table c ON ssc.category_id = c.category_id";
	  

 $grid->render_sql($sql,"id","id,category_name,sub_category_name,sub_sub_category_name,tutorial_name,file_name");

plaese solved my problem as soon as possible.

Stanislav · December 20, 2011, 12:34pm

do you have any records in log.txt for the problematic case ?

seema · December 20, 2011, 1:06pm

Hi ,

thanks for reply

yes in log file i have got the below result

SELECT * FROM tutorial_table LIMIT 0,100

SELECT COUNT(*) as DHX_COUNT FROM tutorial_table

Done in 0.0050661563873291s

====================================
Log started, 19/12/2011 12:12:48

SELECT * FROM tutorial_table LIMIT 0,100

SELECT COUNT(*) as DHX_COUNT FROM tutorial_table

Done in 0.0026199817657471s

====================================
Log started, 19/12/2011 12:12:53

SELECT * FROM tutorial_table LIMIT 0,100

SELECT COUNT(*) as DHX_COUNT FROM tutorial_table

Done in 0.014091014862061s

====================================
Log started, 19/12/2011 12:12:35