我正在尝试从排序为'utf8_general_ci'的表中检索数据,标题为'app_name'的列 字符串如:Plants vs. Zombies™2,포팡팡for Kakao,네이버 - Naver,μTorrent® - Torrent App。 当我尝试按如下方式查询表时: p>
<?php
$ con = mysql_connect('localhost','root','root')或 die('连接服务器时出错');
mysql_select_db('googleappanalysis',$ con);
if(isset($ _ POST ['appType']))
{
$ appType = $ _POST ['appType'];
$ month = $ _POST ['month'];
$ year = $ _POST ['year'];
}
$ monthYear = $ month。$ year;
mysql_query(“SET NAMES utf8”)
if($ appType ==“Apps with IA”){
$ sql =“SELECT app_name FROM MonthlyAppState WHERE is86 = 1 AND is86 IS NOT NULL AND monthYear ='“。$ monthYear。”';;
$ result = mysql_query($ sql);
} elseif($ appType ==“没有IA的应用程序”){
$ sql =“SELECT app_name FROM MonthlyAppState WHERE是86 = 0 AND is86 IS NOT NULL和monthYear ='“。$ monthYear。”'“;
$ result = mysql_query($ sql);
}
$ table = array();
$ table ['cols'] = array(
array('label'=> $ appType,'type'=>'string')
);
$ rows = array() ;
$ appendingString =“”;
while($ r = mysql_fetch_assoc($ result)){
$ temp = array();
$ temp [] = array('v'=>( string)$ r ['app_name']);
$ rows [] = array('c'=> $ temp);
$ appendingString = $ appendingString。“/”。$ r ['app_name'];
}
$ myFile =“logfile.txt”;
$ fh = fopen($ myFile,'w')或死(“无法打开文件”);
fwrite($ fh,$ appendingString);
fclose($ fh);
$ table ['rows'] = $ rows;
//将表格编码为JSON
$ jsonTable = json_encode($ table);
//设置标题; 前两个阻止IE缓存查询
标题('Cache-Control:no-cache,must-revalidate');
header('Expires:Mon,26 Jul 1997 05:00:00 GMT');
标题 ('Content-type:application / json');
echo $ jsonTable;
?>
code> pre>
jsontable抛出空值, file'logfile.txt'将unicode字符转换为'???' 如此处 p>
div>