Problem of fetching data using php using dhtmlx

I am using this code



ff














    



    



    



    







    









this is my php file <?php

//set content type and xml tag

header("Content-type:text/xml");

print("<?xml version=\"1.0\"?>“);







//define variables from incoming values



if(isset($_GET[“posStart”]))



$posStart = $_GET[‘posStart’];



else



$posStart = 0;



if(isset($_GET[“count”]))



$count = $_GET[‘count’];



else



$count = 100;







//connect to database



$link = mysql_pconnect(“localhost”, “root”, “”);



$db = mysql_select_db (“sampleDB”);







//query to products table



$sql = “SELECT * FROM products”;



    if(isset($_GET[“name_mask”]))



        $sql.=” Where nm like ‘“.$_GET[“name_mask”].”%’";







//if this is first query - get total number of records in query result



if($posStart==0){



$sqlCount = "Select count() as cnt from ($sql) as tbl”;



$resCount = mysql_query ($sqlCount);



$rowCount=mysql_fetch_array($resCount);



$totalCount = $rowCount[“cnt”];



}



    //order by



    $columns = array(“nm”,“code”,“num_val”);



    if(isset($_GET[“orderby”])){



        if($_GET[“direct”]==‘des’)



            $direct = “DESC”;



        else    



            $direct = “ASC”;



        $sql.=" Order by “.$columns[$_GET[“orderby”]].” “.$direct;



    }



    



//add limits to query to get only rows necessary for output



$sql.= " LIMIT “.$posStart.”,”.$count;



    



        



    $res = mysql_query ($sql);



//output data in XML format



print(“”);



while($row=mysql_fetch_array($res)){



print(“<row id='”.$row[‘id’].“'>”);



print(“”);



print($row[‘nm’]); //value for product name



print(“”);



print(“”);



print($row[‘code’]); //value for internal code



print(“”);



print(“”);



print($row[‘num_val’]); //value for price



print(“”);



print(“”);



}



print(“”);



?>







please tell me solutions

Your code seems correct. To simplify server side operations related DHTMLX component you try to use dhtmlxConnectors. Please find more information here dhtmlx.com/dhxdocs/doku.php?id=d … nector:toc