通过下面三个函数对url的get参数进行处理
得到a标签的href 如
$all=convertUrlQuery(urldecode($_SERVER['QUERY_STRING'] ));//urldecode解决中文乱码 获取参数数组
href="<?php echo creats("category",$all)."category=花束"?>"
function convertUrlQuery($query)//提取参数数组
{
$queryParts = explode('&', $query);
$params = array();
foreach ($queryParts as $param) {
$item = explode('=', $param);
$params[$item[0]] = $item[1];
}
return $params;
}
function arr2str($arr)//将处理后get参数数组链接成字符串
{
$ret = "";
reset($arr);
foreach ($arr as $k=>$v)
{
$tmp = "$k"."=". "$v";
$ret .= $tmp."&";
}
return $ret;
}
function creats($s,$all){//去除原有的参数
if(!empty($all[$s])){
unset($all[$s]);
$str="search.php?".arr2str($all);
}else{
$str="search.php?".arr2str($all);
}
return $str;
}
通过get参数进行查询
$use=$_GET["use"];
$variety=$_GET["variety"];
$category=$_GET["category"];
if(empty($variety)&&empty($use)&&empty($category)){
$sql = "SELECT * FROM product limit".strval(($num+($num-1)*28)-1).",28";
}else{
$sql = "SELECT * FROM product where (1=1)";
if(!empty($use)){
$sql.="and purpose='".$use."'";
}
if(!empty($variety)){
$sql.="and variety='".$variety."'";
}
if(!empty($category)){
$sql.="and category='".$category."'";
}
}
$result = $conn->query($sql);