<?php
//header("Content-Type:text/html;charset=utf-8");require '../public/conn.php'; class User
{
public $id;
public $matters; //预约事项
public $creator; //创建人
public $group;
public $generalhospital;
public $branchcourts;
public $creationdate;
public $guid;
}$link = datalink('mssql');
$table_name = 'table_name'; /*如果你牛叉的数据库表名是中文,记得加上这句:*/
$table_name = iconv('UTF-8', 'GB2312', 'T_matters');
$result=sqlsrv_query($link, "select * from ".$table_name);/*query语句:*/
if($result){
//echo "查询成功";
while ($row = sqlsrv_fetch_array($result,SQLSRV_FETCH_ASSOC))
{
$user = new User();
$user->id = $row["id"];
$user->matters = $row["matters"];
$user->creator = $row["creator"];
$user->generalhospital = $row["generalhospital"];
$user->branchcourts = $row["branchcourts"];
$user->creationdate = $row["creationdate"]->format('Y-m-d H:i:s');
$user->guid = $row["guid"];
//$data[]=$user;
}
$json = json_encode($data);//把数据转换为JSON数据.
//echo "{".'"user"'.":".$json."}";
echo $json;
}else{
echo "查询失败";
}sqlsrv_close($link); ?>以上代码只要是中文数据就获取不了我用print_r($row); 是可以打印出所有的数据的.
//header("Content-Type:text/html;charset=utf-8");require '../public/conn.php'; class User
{
public $id;
public $matters; //预约事项
public $creator; //创建人
public $group;
public $generalhospital;
public $branchcourts;
public $creationdate;
public $guid;
}$link = datalink('mssql');
$table_name = 'table_name'; /*如果你牛叉的数据库表名是中文,记得加上这句:*/
$table_name = iconv('UTF-8', 'GB2312', 'T_matters');
$result=sqlsrv_query($link, "select * from ".$table_name);/*query语句:*/
if($result){
//echo "查询成功";
while ($row = sqlsrv_fetch_array($result,SQLSRV_FETCH_ASSOC))
{
$user = new User();
$user->id = $row["id"];
$user->matters = $row["matters"];
$user->creator = $row["creator"];
$user->generalhospital = $row["generalhospital"];
$user->branchcourts = $row["branchcourts"];
$user->creationdate = $row["creationdate"]->format('Y-m-d H:i:s');
$user->guid = $row["guid"];
//$data[]=$user;
}
$json = json_encode($data);//把数据转换为JSON数据.
//echo "{".'"user"'.":".$json."}";
echo $json;
}else{
echo "查询失败";
}sqlsrv_close($link); ?>以上代码只要是中文数据就获取不了我用print_r($row); 是可以打印出所有的数据的.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货