index.php:
mygrid = new dhtmlXGridObject('gridbox');
mygrid.setImagePath("../common/imgs/");
mygrid.setHeader("name,id,pass,ins_dt,upd_dt");
mygrid.setInitWidths("120,100,120,80,80");
mygrid.setColAlign("left,left,right,center,left");
mygrid.setColTypes("ed,ed,ed,ed,ed");
mygrid.getCombo(5).put(2,2);
mygrid.setColSorting("str,str,str,str,str");
mygrid.setSkin("dhx_skyblue");
mygrid.init();
mygrid.attachEvent("onRowSelect", function(id,ind){
if (ind == 0 ){
dhxWins = new dhtmlXWindows();
var w1 = dhxWins.createWindow("w1", 20, 30,700, 400);
dhxWins.setImagePath("../common/imgs/");
w1.setText(id);
w1.attachURL("../common/attach_url_ajax_inner.html");
return true;
}
});
mygrid.loadXML("connector.php");
var dp = new dataProcessor("connector.php");
dp.init(mygrid);
connector.php
[code]
include (‘grid_connector.php’);
$server = “localhost”;
$user = “root”;
$pass = “”;
$db_name= “dtb_cw_test”;
$res=mysql_connect($server, $user, $pass);
mysql_query(“set names UTF8”);
mysql_select_db($db_name);
require("grid_connector.php");
require("db_mssql.php");
$grid = new GridConnector($res,"MsSQL");
$grid->render_sql("TM_Staff","seq","name,id,pass,ins_dt,upd_date");[/code]
The aboave code didnt display the data from mysql database.
showing the error like
Error type: loadxml
description: incorrectxml
plz help me. How to display the data from mysql db directly.
thanks in advance…