GET 提交时出现乱码

Question

function net_list(){
global $_REQUEST,$_GET;
$friend_link_id=$_GET["friend_link_id"];
$get_site_data=D('Get_site_data');
import("ORG.Util.Page"); //导入分页类\ThinkPHP\Lib\ORG\Util\Page.class.php
import('ORG.Util.HashMap');
$map = new HashMap(); 
if(!empty($_REQUEST['listRows'])) {
$listRows  =  $_REQUEST['listRows'];
}else{
$listRows=1; //listRows标识每页显示多少条记录12
}


if(!empty($_REQUEST['pagerank'])) {
$pagerank  =  $_REQUEST['pagerank'];
$map->put('_string',"pagerank <=". $pagerank  );
}

if(!empty($_GET['site_name'])) {

$site_name  =  urldecode($_GET['site_name']);
$map->put('site_name',array('like',"%".$site_name."%"));
}


 




  $order='link.friend_link_id desc'; //listRows标识每页显示多少条记录
          $map->put('link.audit_of',array('eq',"2"));


foreach($map as $key=>$val) {//保留检索参数
if(is_array($val)) {
foreach ($val as $t){
$p->parameter .= $key.'[]='.urlencode($t)."&";
}
}else{
$p->parameter .= $key.'[]='.urlencode($t)."&"; }
}
//count函数参数是查询条件,默认没有where的条件限制
$friend_link=D('friend_link');
//$where='link.audit_of=2 ';

print_r($map);

$count=$friend_link->table($this->DB_PREFIX."friend_link link")
->join($this->DB_PREFIX."get_site_data data on link.friend_link_id=data.friend_link_id")
->join($this->DB_PREFIX."site_class  cata on cata.site_class_id=link.site_class_id")
->where($map)
->count();

$p= new Page($count,$listRows); //根据总数和每页显示记pageview生成Page类的对象

$vo=$friend_link->table($this->DB_PREFIX."friend_link link")
->join($this->DB_PREFIX."get_site_data data on link.friend_link_id=data.friend_link_id")
->join($this->DB_PREFIX."site_class  cata on cata.site_class_id=link.site_class_id")
->field('data.*,link.site_name,cata.classname,link.friend_link_id,link_property,link.qq')
->where($map)
->order($order)
->limit($p->firstRow.','.$p->listRows)->findall();

    echo $friend_link->getlastsql();
if(get_url()){
      $vars =__ACTION__.'/'.get_url();//检索参数  POST
}else{
  $vars =__ACTION__;//检索参数  POST
}
//$URL =get_url('',2);//检索参数　　GET     
$page=front_multi($count, $listRows, $_GET["p"], $vars);//总记录数，每页记录数，当前页数，传递链接
    $this->assign("page",$page);
$this->assign("URL",$URL);
$this->assign("vo",$vo);
$this->assign("friend_link_id",$friend_link_id);
$this->display();
}}

Answer 1

SELECT data.*,link.site_name,cata.classname,link.friend_link_id,link_property,link.qq FROM cnnet21_friend_link link LEFT JOIN cnnet21_get_site_data data on link.friend_link_id=data.friend_link_id LEFT JOIN cnnet21_site_class cata on cata.site_class_id=link.site_class_id WHERE ( `site_name` LIKE '%?%' ) AND ( `google` > 0 ) AND ( `baidu` > 0 ) AND ( `alexa` > 0 ) AND ( link.audit_of = '2' ) ORDER BY link.friend_link_id desc LIMIT 0,1 [ 宇]变成了[?]

Answer 2

前台给传递的参数加编码 &site_name=<?php echo urlencode($site_name);?>
或者给你的链接加编码 encodeURI(url);

Answer 3

先看从数据库中取出来是不是乱码,是不是数据库字符集和PHP程序的字符集不一致?

Answer 4

同意2楼
site_name=<?=urlencode($site_name)?>
获取:$site_name=$_GET['site_name'];