suchen

Heim >Backend-Entwicklung >PHP-Tutorial >jqgrid显示不了数据

jqgrid显示不了数据

WBOY
WBOYOriginal
2016-06-23 13:49:361266Durchsuche

jqgrid显示不数据，请各位大大帮忙看看 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>无标题文档</title><link rel="stylesheet" type="text/css" media="screen" href="css/ui-lightness/jquery-ui-1.8.2.custom.css" /><link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" /><script src="js/jquery-1.9.0.min.js" type="text/javascript"></script><script src="js/i18n/grid.locale-cn.js" type="text/javascript"></script><script src="js/jquery.jqGrid.min.js" type="text/javascript"></script><script type="text/javascript">$(function(){ jQuery("#list").jqGrid({   	url:'dd.php',	datatype: "json",	height: 255,	width: 600,   	colNames:['编号','名称','主屏尺寸','操作系统','电池容量', '价格(￥)','操作'], //数据列名称（数组）   	colModel:[ //数据列各参数信息设置   		{name:'sn',index:'sn', editable:true, width:80,align:'center',title:false,editable: true,edittype:"text"},   		{name:'title',index:'title', width:180,title:false, editable: true,sorttype:"text"},   		{name:'size',index:'size', width:120, editable: true,sorttype:"text"},		{name:'os',index:'os', width:120,editable:true,sorttype:"text"},   		{name:'charge',index:'charge', width:100,align:'center',editable:true,sorttype:"text"},		{name:'price',index:'price', width:80,align:'center',editable:true,sorttype:"text"},   		{name:'opt',index:'opt', width:80, sortable:false, align:'center',editable:true,sorttype:"text"}		   	],   	rowNum:50,	rowTotal: 2000,	rowList : [20,30,50],	loadonce:true,   	mtype: "GET",	rownumbers: true,	rownumWidth: 40,	gridview: true,   	pager: '#pager',   	sortname: 'id',    viewrecords: true,    sortorder: "asc",	caption: "Toolbar Searching"	});jQuery("#list").jqGrid('navGrid','#pager',{del:false,add:false,edit:false,search:false});jQuery("#list").jqGrid('filterToolbar',{stringResult: true,searchOnEnter : false});  }); </script></head><body><table id="list"></table><div id="page" ></div></body></html>


<?PHPinclude_once ("connect.php");	$page = $_GET['page'];		$limit = $_GET['rows'];		$sidx = $_GET['sidx'];		$sord = $_GET['sord'];		if (!$sidx)			$sidx = 1;        $where = '';        $title = uniDecode($_GET['title'],'utf-8');        if(!empty($title))            $where .= " and title like '%".$title."%'";        $sn = uniDecode($_GET['sn'],'utf-8');        if(!empty($sn))            $where .= " and sn='$sn'";		$result = mysql_query("SELECT COUNT(*) AS count FROM products where deleted=0".$where);		$row = mysql_fetch_array($result, MYSQL_ASSOC);		$count = $row['count'];		//echo $count;		if ($count > 0) {			$total_pages = ceil($count / $limit);		} else {			$total_pages = 0;		}		if ($page > $total_pages)			$page = $total_pages;		$start = $limit * $page - $limit;		if ($start<0) $start = 0;		$SQL = "SELECT * FROM products WHERE deleted=0".$where." ORDER BY $sidx $sord LIMIT $start , $limit";		$result = mysql_query($SQL) or die("Couldn t execute query." . mysql_error());		$responce->page = $page;		$responce->total = $total_pages;		$responce->records = $count;		$i = 0;		while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {			$responce->rows[$i]['id'] = $row[id];			$opt = "<a href='#'>修改</a>";			$responce->rows[$i]['cell'] = array (				$row['sn'],				$row['title'],				$row['size'],				$row['os'],				$row['charge'],				$row['price'],				$opt			);			$i++;		}		//print_r($responce);		echo json_encode($responce);								function uniDecode($str, $charcode) {	$text = preg_replace_callback("/%u[0-9A-Za-z]{4}/", toUtf8, $str);	return mb_convert_encoding($text, $charcode, 'utf-8');}function toUtf8($ar) {	foreach ($ar as $val) {		$val = intval(substr($val, 2), 16);		if ($val < 0x7F) { // 0000-007F			$c .= chr($val);		}		elseif ($val < 0x800) { // 0080-0800			$c .= chr(0xC0 | ($val / 64));			$c .= chr(0x80 | ($val % 64));		} else { // 0800-FFFF			$c .= chr(0xE0 | (($val / 64) / 64));			$c .= chr(0x80 | (($val / 64) % 64));			$c .= chr(0x80 | ($val % 64));		}	}	return $c;}?>


回复讨论(解决方案)

$text = preg_replace_callback("/%u[0-9A-Za-z]{4}/", toUtf8, $str);
应为
$text = preg_replace_callback("/%u[0-9A-Za-z]{4}/", 'toUtf8', $str);

xuzuning大大， 'toUtf8'加两个单引号，我加了不行，我不知道是不是文件的编码有问题，本地测试的时候，有些Js文件我改一下编码，就显不了数据库的数据了

另外我直接输出结果 


<?phpinclude_once ("connect.php");			$page = 1;	$limit = 12;	$sidx = 'id';		$sord = 'asc';		if (!$sidx)			$sidx = 1;        $where = '';        $title = "";        if(!empty($title))            $where .= " and title like '%".$title."%'";        $sn = "";        if(!empty($sn))            $where .= " and sn='$sn'";		$result = mysql_query("SELECT COUNT(*) AS count FROM products where deleted=0".$where);		$row = mysql_fetch_array($result, MYSQL_ASSOC);		$count = $row['count'];		//echo $count;		if ($count > 0) {			$total_pages = ceil($count / $limit);		} else {			$total_pages = 0;		}		if ($page > $total_pages)			$page = $total_pages;		$start = $limit * $page - $limit;		if ($start<0) $start = 0;		$SQL = "SELECT * FROM products WHERE deleted=0".$where." ORDER BY $sidx $sord LIMIT $start , $limit";		$result = mysql_query($SQL) or die("Couldn t execute query." . mysql_error());		$responce->page = $page;		$responce->total = $total_pages;		$responce->records = $count;		$i = 0;		while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {			$responce->rows[$i]['id'] = $row["id"];			$opt = "<a href='#'>修改</a>";			$responce->rows[$i]['cell'] = array ($row['sn'],$row['title'],$row['size'],	$row['os'],	$row['charge'],	$row['price'],$opt);			$i++;		}				echo json_encode($responce);?>









{"page":1,"total":2,"records":"14","rows":[{"id":"1","cell":["1001","\u82f9\u679ciPhone 4S\uff0816GB\uff09","3.5\u82f1\u5bf8 960x640\u50cf\u7d20 ","iOS 5.0","1420mAh","5150","\u4fee\u6539<\/a>"]},{"id":"2","cell":["1002","\u4e09\u661fI9100 GALAXY SII\uff0816GB\uff09","4.3\u82f1\u5bf8 800x480\u50cf\u7d20 ","Android OS 2.3 ","1650mAh ","3790","\u4fee\u6539<\/a>"]},{"id":"3","cell":["1003","HTC G11\uff08Incredible S\uff09","4\u82f1\u5bf8 800x480\u50cf\u7d20","Android OS 2.2 ","1450mAh","2232","\u4fee\u6539<\/a>"]},{"id":"4","cell":["1004","\u9b45\u65cfM9\uff088GB\uff09","3.5\u82f1\u5bf8 960x640\u50cf\u7d20","Android OS 2.3 ","1370mAh","1729","\u4fee\u6539<\/a>"]},{"id":"5","cell":["1005","\u5c0f\u7c73M1\uff08MIUI\uff09","4\u82f1\u5bf8 854x480\u50cf\u7d20","MIUI+\u539f\u751fAndroid","1930mAh","1999","\u4fee\u6539<\/a>"]},{"id":"6","cell":["1006","\u8bfa\u57fa\u4e9aC5-03","3.2\u82f1\u5bf8 640x360\u50cf\u7d20 ","Symbian S60V5","1000mAh","1164","\u4fee\u6539<\/a>"]},{"id":"7","cell":["1007","\u6469\u6258\u7f57\u62c9XT910\uff08DROID RAZR\uff09","4.3\u82f1\u5bf8 960x540\u50cf\u7d20 ","Android OS 2.3 ","1780mAh","3700","\u4fee\u6539<\/a>"]},{"id":"8","cell":["1008","\u8bfa\u57fa\u4e9aN8","3.5\u82f1\u5bf8 640x360\u50cf\u7d20 ","Symbian^3 ","1200mAh","2302","\u4fee\u6539<\/a>"]},{"id":"9","cell":["1009","\u534e\u4e3aU8860 Honor\uff08\u8363\u8000\uff09","4\u82f1\u5bf8 854x480\u50cf\u7d20","Android OS 2.3","1930mAh","1889","\u4fee\u6539<\/a>"]},{"id":"10","cell":["1010","\u4e09\u661fW999","3.5\u82f1\u5bf8 800x480\u50cf","Android OS 2.3 ","1500mAh ","12340","\u4fee\u6539<\/a>"]},{"id":"11","cell":["1011","\u9177\u6d3eN900+","3.2\u82f1\u5bf8 480x320\u50cf ","Windows CE 6.0 ","1500mAh ","6180","\u4fee\u6539<\/a>"]},{"id":"12","cell":["1012","\u9ed1\u83939800\uff08Torch\uff09","3.2\u82f1\u5bf8 480x360\u50cf\u7d20","BlackBerry OS 6","1300mAh","4900","\u4fee\u6539<\/a>"]}]}

可以显示了，我把那些转换函数都删除了

请参考jqGrid中文demo：http://blog.mn886.net/jqGrid/

Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：tkinkphp查询总是出现怪问题Nächster Artikel：PHP 删除文件

In Verbindung stehende Artikel

Mehr sehen