Dear Sir,
I used the dataprocessor and get the data from the database show in the grid,
but it can’ t work. Please help,
the following code is get.php in use.
thank you.
<?php
//set content type and xml tag
//header(“Content-type:text/xml”);
print("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
//define variables from incoming values
if(isset($_GET[“posStart”]))
$posStart = $_GET[‘posStart’];
else
$posStart = 0;
if(isset($_GET[“count”]))
$count = $_GET[‘count’];
else
$count = 150;
//connect to database
$link = mysql_pconnect(“localhost”, “root”, “abc”);
$db = mysql_select_db (“abcd”);
//create query to products table
$sql = “SELECT * FROM test”;
//if this is the first query - get total number of records in the 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”];
}
//add limits to query to get only rows necessary for the output
$sql.= " LIMIT “.$posStart.”,".$count;
//query database to retrieve necessary block of data
$res = mysql_query ($sql);
//output data in XML format
print("");
while($row=mysql_fetch_array($res)){
print("<row id=’".$row[‘connectionID’]."’>");
print("");
print($row[‘dept’]); //value for connection ID
print("");
print("");
print($row[‘name’]); //value for name
print("");
print("");
print($row[‘eMail’]); //value for E-Mail
print("");
print("");
print($row[‘extNum’]); //value for ext Num
print("");
print("");
print($row[‘location’]); //value location
print("");
print("");
}
print("");
?>
a) Please be sure that you are using correct encoding ( both html page and data in DB use UTF )
b) Your data doesn’t contain special chars ( <, >, & ), in other case you need wrap data output as
print("<![CDATA[");
print($row['dept']); //value for connection ID
print("]]>");
Also, latest version of dataprocessor supports next command
dp.enableUTFencoding(true);
You can try to use it , if data from client side saved incorrectly in DB
Dear sir,
I set the charset is utf-8-unicode,
and how to download the new update of dataprocessor used in grid
And how to download the new update of dataprocessor used in grid.
Please contact us directly at support@dhtmlx.com and provide your reference number.
>>I set the charset is utf-8-unicode
If same encoding used on all stages - the data must be shown exactly as it stored in DB