代码未能将查询条件传递给URL - Code failing to pass query criteria to URL

Code failing to pass query criteria to URL

本文关键字：URL 条件查询代码 | 更新日期: 2023-09-27

我的问题是，由于我将SWITCH函数添加到使用cat_id进行查询的代码中，因此代码不能再将查询条件传递给用于分页的URL。cat_id是一个categoryID，它作为外键保存在子表中。

这是我的代码，如果你可以帮助:

$criteria = array('ctitle', 'csubject', 'creference', 'cat_id', 'cmaterial', 'ctechnic', 'cartist', 'csource', 'cposture', 'stolen');
$likes = "";
$url_criteria = '';
foreach ( $criteria AS $criterion ) {
        if ( ! empty($_POST[$criterion]) ) {
                $value = ($_POST[$criterion]);
                $likes .= " AND `$criterion` LIKE '%$value%'";
    switch ($criterion) {
                    case 'cat_id':
                        $likes .= " AND `$criterion`='$value'";
                        break;
                    default:
                        $likes .= " AND `$criterion` LIKE '%$value%'";
                        break;
                $url_criteria .= '&amp;'.$criterion.'='.htmlentities($_POST[$criterion]);
                }
        } elseif ( ! empty($_GET[$criterion]) ) {
                $value = mysql_real_escape_string($_GET[$criterion]);
                $likes .= " AND `$criterion` LIKE '%$value%'";
    switch ($criterion) {
                    case 'cat_id':
                        $likes .= " AND `$criterion`='$value'";
                        break;
                    default:
                        $likes .= " AND `$criterion` LIKE '%$value%'";
                        break;
                $url_criteria .= '&amp;'.$criterion.'='.htmlentities($_GET[$criterion]);
        } //var_dump($likes);
        }
}
$sql = "SELECT * FROM collections WHERE c_id>0" . $likes . " ORDER BY c_id ASC";

$url_criteria .= '&amp;'.$criterion.'='.htmlentities($_POST[$criterion]);

在

之后

default: 
...
break;

所以它永远不会被执行

您不需要将$url_criteria放在交换机中。它不会被处理，也不会被PHP执行

<?php
switch ($criterion) {
    case 'cat_id':
        $likes .= " AND `$criterion`='$value'";
        break;
    default:
        $likes .= " AND `$criterion` LIKE '%$value%'";
        break;
//removed from here 
}
// put it here
$url_criteria .= '&amp;'.$criterion.'='.htmlentities($_POST[$criterion]);