wordpress框架搜索功能+分页+排序

今天药忘吃喽~ 2023-01-22 15:55 55阅读 0赞

$count = $wpdb->get_results("SELECT count(id) FROM wp_shangjia");
    		$c = (array)$count['0'];
    		$ss = $_GET['ss'];
    		$count1 = $wpdb->get_results("SELECT count(id) FROM wp_shangjia where sh_name like '%$ss%'");
    		$c1 = (array)$count1['0'];
    	if($ss){
        
    		
    		$pageSize = 7; //每页显示数据条数
    		$totalNum = $c1['count(id)'];//数据总条数
    		$totalPageCount = intval($totalNum/$pageSize); //总页数
    		$nowPage = isset($_GET['page1']) ? intval($_GET['page1']) : 1;//判断当前页是哪一页
    		$prev = ($nowPage-1 <= 0) ? 1 : $nowPage-1;//上一页
    		$next = ($nowPage+1 >= $totalPageCount) ? $nowPage+1 : $totalPageCount;//下一页
    		$offset = ($nowPage-1)*$pageSize;//偏移量
    		$data = $wpdb->get_results("SELECT * FROM wp_shangjia where sh_name like '%$ss%' order by id limit $offset,$pageSize");
    		$count = $wpdb->get_results("SELECT count(id) FROM wp_shangjia where sh_name like '%$ss%'");
    		$c = (array)$count['0'];
    		
    	}else{
        
    		$pageSize = 7; //每页显示数据条数
    		$totalNum = $c['count(id)'];//数据总条数
    		$totalPageCount = intval($totalNum/$pageSize); //总页数
    		$nowPage = isset($_GET['page1']) ? intval($_GET['page1']) : 1;//判断当前页是哪一页
    		$prev = ($nowPage-1 <= 0) ? 1 : $nowPage-1;//上一页
    		$next = ($nowPage+1 >= $totalPageCount) ? $nowPage+1 : $totalPageCount;//下一页
    		$offset = ($nowPage-1)*$pageSize;//偏移量
    		$data = $wpdb->get_results("SELECT * FROM wp_shangjia order by id limit $offset,$pageSize");
    		$count = $wpdb->get_results("SELECT count(id) FROM wp_shangjia");
    		$c = (array)$count['0'];
    	}
    		if($_GET['page1']){
        
    			$dq = $_GET['page1'];
    			$x = (($dq-1)*$pageSize);
    		}
    		foreach ($data as $k => $v){
        
    			$v = (array)$v;
    			$x = $x+1;
    			echo $x;
    			}