php - 过滤器出现问题，不保存数据

Question

我编写了一些代码来过滤我的价格，但它没有保存该过滤器，我发布信息，当我刷新时，全部丢失。它只显示一页过滤器，我知道有更多项目，但它只显示一页。

if(isset($_POST['sort'])){
    $cena_no = trim($_POST['fl_cena_no']);
    $cena_lidz = trim($_POST['fl_cena_lidz']);
        if(empty($cena_lidz)){
            $cena_lidz = '99999999999999999999999999999999';
        }
        if(empty($cena_no)){
                $cena_no = '0';
        }
            $page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
            $pages = mysql_query("SELECT * FROM zirglietas_pardod");
            $pages = ceil(mysql_result($pages, 0) / 15);
            $querystring = "";
            foreach ($_GET as $key => $value) {
            if ($key != "page") $querystring .= "$key=$value&";
            }
            $result = mysqli_query($con,"SELECT * FROM zirglietas_pardod WHERE cena >= $cena_no AND cena <= $cena_lidz ORDER BY cena ASC LIMIT " . (($page - 1) * 15) . ", 15 ");
}

Mby 需要添加 session 吗？

(p.s 2小时后我会回来，我可以回复)

Answer 1

Yuhu，现在 session 保存数据，正在编写一些代码...

if(isset($_POST['sort'])){
     $cena_no = mysql_real_escape_string(trim($_POST['fl_cena_no']));
     $cena_lidz = mysql_real_escape_string(trim($_POST['fl_cena_lidz']));
        if(empty($cena_lidz)){
        $cena_lidz = '99999999999999999999999999999999';
        }
        if(empty($cena_no)){
        $cena_no = '0';
        }
        $_SESSION['sort'] = $_POST;
        $result = mysqli_query($con,"SELECT * FROM zirglietas_pardod WHERE cena >= $cena_no AND cena <= $cena_lidz ORDER BY cena ASC");
        }

并阅读

if (isset($_SESSION['sort'])){
        $cena_no = $_SESSION['sort']['fl_cena_no'];
        $cena_lidz = $_SESSION['sort']['fl_cena_lidz'];
        if(empty($cena_lidz)){
        $cena_lidz = '99999999999999999999999999999999';
        }
        if(empty($cena_no)){
        $cena_no = '0';
        }
        $result = mysqli_query($con,"SELECT * FROM zirglietas_pardod WHERE cena >= $cena_no AND cena <= $cena_lidz ORDER BY cena ASC");
                        }

并销毁 session ，现在我可以处理下一步了:)