第一种方式:【乱码】
header("Content-Type:text/html;charset=utf-8");
mysql_query("set names utf8");
第二种方式:【乱码】
mysql_query("set names utf8");
$sql="select * from app_swdr.swry";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)){
$response[]=$row;
}
foreach($response as $key => $value){
$newData[$key]=$value;
$newData[$key]["app_swdr.swry"]=urlencode($value["app_swdr.swry"]);
}
echo urldecode(json_encode($newData));
第三种方式:【乱码】
//设置编码格式为utf8
//$sql="set names utf8";
//mysql_query($sql,$link);
mysql_query("set names utf8");
//mysql_set_charset("utf8");
//查询数据
$sql="select * from app_swdr.swry";
$result=mysql_query($sql,$link);
//判断结果是否为空
if(!$result){
if(empty($result)){
echo "empty";
}
echo "failed";
exit;
}
//创建数据
$arry=array();
//转换为对象,处理数据
class Title{
public $id;
public $label;
public $name;
public $value;
}
while($row=mysql_fetch_object($result)){
$title = new Title();
$title -> id=$row ->id;
$title -> label=$row ->label;
$title -> name=$row ->name;
$title -> value=$row ->value;
$arry[]=$title;
}
//对变量进行json解码
$arrys=json_encode((array("state"=>"success","data"=>$arry)));
echo (urldecode($arrys));
//释放结果
mysql_free_result($result);
第四种方式:【字符串,可行】
$mysql = new SaeMysql();
$sql = "select * from app_swdr.swry";
$data = $mysql -> getData($sql);
var_dump($data);
for($i = 0;$i < count($data);$i++){
echo "id:".$data[$i][id]. "label:".$data[$i]['label']. "name:".$data[$i]['name']. "value:".$data[$i]['value']."<br/>\n";
}
if($mysql -> errno() != 0){
die("error:".$mysql -> errmsg());
}else{
echo "succeful";
}