UTF8字符无法正确显示数据和yadcf [英] UTF8 characters not displaying properly with datatables and yadcf
问题描述
我有:temps.php
我的服务器端处理脚本:
<?php
header(Content-Type:text / json; charset = utf-8);
require('ssp.class.php');
$ table ='articles';
$ primaryKey ='id';
$ columns = array(
array('db'=>'title','dt'=> 0),
array('db'=>'description' 'dt'=> 1));
$ sql_details = array(
'user'=>'root','pass'=>'pass','db'=>'test','host'=> localhost'
);
$ db = SSP :: db($ sql_details);
.....
if($ clause!==){
$ whereAll [] = $ clause;
$ _GET ['columns'] [$ i] ['search'] ['value'] =;
}}
echo json_encode(
SSP :: complex($ _GET,$ db,$ table,$ primaryKey,$ columns,null,
(!empty($ whereAll) ?implode(AND,$ whereAll):)
));
我有:temp.html:我的Javascript功能(基于datatables和yadcf)
$(document).ready(function(){
$(#example)。dataTable({
response:true,
processing:true,
serverSide:true,
ajax:scripts / temps.php,
columns [
// ID
null,
//分销商
null
//导演
]
})。yadcf([
// ID
{
column_number:0,
filter_type:text,
filter_reset_button_text:false
},
//摘要
{
column_number:1,
filter_type:text,
filter_delay:500,
filter_reset_button_text:false
}
]);
});
我有temp.html输出数据:(编辑因为很多代码是不相关的问题)
<!DOCTYPE html>
< div>
< head>
< meta http-equiv =Content-Typecontent =text / html; charset = utf-8/>
< meta name =DescriptionCONTENT =/>
..........
< table id =exampleclass =table table-striped table-bordered table-condensedcellspacing =0width =100% >
< thead>
< tr>
< div>< div> One< / div>< / th>
< div>< div> Two< / div>< / th>
< / tr>
< / thead>
< / table>
对于这么长的问题,对不起,但是还有什么可以改变,使UTF8正确显示在html页面上?我已经尝试了所有可以想到的变量和函数的组合;但不能使其工作。也许有一个js函数可以应用于某个地方?感谢您的帮助。
编辑:SQL结构供参考:
CREATE TABLE IF NOT EXISTS`articles`(
`id` int(11)NOT NULL,
`title` varchar(300)CHARACTER SET utf8 DEFAULT NULL,
`description` text CHARACTER SET utf8
)ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = latin1;
- 转储表`articles`的数据
INSERT INTO`articles`(`id`,`title`,`description`)VALUES
(1,'శశశీీివససతతతతత'概念英语第asv'),
(2,'asda','asdవㄧ'),
3,'sdfsadfsdf英语','sadf英');
您需要强制 utf8
$ db = SSP :: db ($ sql_details);
$ db-> exec(set names utf8);
或者,尝试将其作为参数传递:
$ sql_details = array(
'user'=>'root',
'pass'=>'ryan ',
'db'=>'edata',
'host'=>'localhost',
'charset'=>'utf8'
);
但是这并不适用于所有PHP版本。
PS:为什么将表格字段设置为类型为 utf8
,但表格字符集设置为 latin1
?
I have a mysql database that is in UTF8, I've properly output the letters before but cannot make my php do so with datatables using the ajax process. I have tried various methods to get the UTF8 to show, including, changing headers, using mysql functions, and changing the json encode function, but I cannot make it work. Please help me show UTF8 properly instead of ?s.
I have: temps.php My server side processing script:
<?php
header("Content-Type: text/json; charset=utf-8");
require( 'ssp.class.php' );
$table = 'articles';
$primaryKey = 'id';
$columns = array(
array( 'db' => 'title', 'dt' => 0 ),
array( 'db' => 'description', 'dt' => 1 ));
$sql_details = array(
'user' => 'root', 'pass' => 'pass', 'db' => 'test', 'host' => 'localhost'
);
$db = SSP::db($sql_details);
.....
if($clause !== ""){
$whereAll[] = $clause;
$_GET['columns'][$i]['search']['value'] = "";
}}
echo json_encode(
SSP::complex( $_GET, $db, $table, $primaryKey, $columns, null,
(!empty($whereAll) ? implode(" AND ", $whereAll) : "")
));
I have: temp.html: My Javascript function (based on datatables and yadcf)
$(document).ready(function(){
$("#example").dataTable({
"responsive": true,
"processing": true,
"serverSide": true,
"ajax": "scripts/temps.php",
"columns": [
// ID
null,
// Distributor
null
// Director
]
}).yadcf([
// ID
{
column_number: 0 ,
filter_type: "text",
filter_reset_button_text: false
},
// Abstract
{
column_number: 1,
filter_type: "text",
filter_delay: 500,
filter_reset_button_text: false
},
]);
});
And I have temp.html where the data is outputted: (redacted because a lot of the code is irrelevant to the question)
<!DOCTYPE html>
<div>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="Description" CONTENT=""/>
..........
<table id="example" class="table table-striped table-bordered table-condensed" cellspacing="0" width="100%">
<thead>
<tr>
<th><div>One</div></th>
<th><div>Two</div></th>
</tr>
</thead>
</table>
Sorry for such a long question; but what else can I change to make UTF8 properly show on the html page? I've tried all the combinations of variables and functions I can think of; but can't make it work. Perhaps there is a js function that could be applied somewhere? Thank you for the help.
Edit: SQL structure for reference:
CREATE TABLE IF NOT EXISTS `articles` (
`id` int(11) NOT NULL,
`title` varchar(300) CHARACTER SET utf8 DEFAULT NULL,
`description` text CHARACTER SET utf8
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- Dumping data for table `articles`
INSERT INTO `articles` (`id`, `title`, `description`) VALUES
(1, 'శ్రీనివాస్scddadas తామాడా', '新概念英语第asv'),
(2, 'asda', 'asdవా'),
3, 'sdfsadfsdf英语', 'sadf英');
You need to force utf8
in the PDO connection :
$db = SSP::db($sql_details);
$db->exec("set names utf8");
alternatively, try pass it as a param :
$sql_details = array(
'user' => 'root',
'pass' => 'ryan',
'db' => 'edata',
'host' => 'localhost',
'charset' => 'utf8'
);
But this does not work with all PHP versions.
PS: Why do you set the table fields to be of type utf8
, but the table character set to be latin1
?
这篇关于UTF8字符无法正确显示数据和yadcf的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!