首页 \ 问答 \ 如何在OpenCart中以任何价格获得所有类别的产品？(How to get all products from category with any price in OpenCart?)

如何在OpenCart中以任何价格获得所有类别的产品？(How to get all products from category with any price in OpenCart?)

$data = array(
        'filter_category_id'  => $category_id,
    );

    $products = $this->model_catalog_product->getProducts($data);
 
 这是我用于按类别ID获取所有产品的内容。  
 我正在开发OpenCart 1.5.6的价格滑块，并且我注意到，每当我使用选定的价格范围执行查询时，上面的方法也会在该价格范围内给出结果。  
 我需要的是尽管价格每次都从特定类别获得所有产品。 我该怎么做呢？ 

$data = array(
        'filter_category_id'  => $category_id,
    );

    $products = $this->model_catalog_product->getProducts($data);
 
This is what I use to get all products by category ID. 
I am developing a price slider for OpenCart 1.5.6 and I've noticed that whenever I do a query with a selected price range, the method above also gives me results in that price range. 
What I need is to get all products from a specific category despite the price every time. How do I do this?

原文：https://stackoverflow.com/questions/42097833

更新时间：2023-01-23 17:01

最满意答案

 像这样尝试..  
  <?php
$a = array('a','aa','aaa');//assumed arrays
$b = array('b','bb','bbb');
$c = array('c','cc','ccc');
$query = "INSERT INTO table(id,a,b,c) ";
foreach ($a as $key => $value) {
    if($key == (count($a)-1)){
        $query.=" VALUES(12,'$a[$key]','$b[$key]','$c[$key]')";
    }
       else{
    $query.="VALUES(12,'$a[$key]','$b[$key]','$c[$key]') ,";
       }
}
echo $query;

?>
 
 输出：  
INSERT INTO table(id,a,b,c) VALUES(12,'a','b','c') ,VALUES(12,'aa','bb','cc') , VALUES(12,'aaa','bbb','ccc')

Try like this.. 
  <?php
$a = array('a','aa','aaa');//assumed arrays
$b = array('b','bb','bbb');
$c = array('c','cc','ccc');
$query = "INSERT INTO table(id,a,b,c) ";
foreach ($a as $key => $value) {
    if($key == (count($a)-1)){
        $query.=" VALUES(12,'$a[$key]','$b[$key]','$c[$key]')";
    }
       else{
    $query.="VALUES(12,'$a[$key]','$b[$key]','$c[$key]') ,";
       }
}
echo $query;

?>
 
Output: 
INSERT INTO table(id,a,b,c) VALUES(12,'a','b','c') ,VALUES(12,'aa','bb','cc') , VALUES(12,'aaa','bbb','ccc')

如何在OpenCart中以任何价格获得所有类别的产品？(How to get all products from category with any price in OpenCart?)

最满意答案

相关问答

php foreach循环与mysql(php foreach loop with mysql)[2022-03-11]

PHP foreach循环外循环(PHP foreach loop outside loop)[2022-03-02]

在foreach问题的PHP foreach(PHP foreach in foreach problem)[2022-01-23]

PHP Myqsl PDO代码效率 - Foreach循环中的Foreach循环(PHP Myqsl PDO code efficiency - Foreach loop within a foreach loop)[2023-06-16]

php切换使用字符串和foreach循环(php switch using strings and foreach loop)[2023-03-20]

PHP - MySQL - Foreach循环瓶颈(PHP - MySQL - Foreach loop bottleneck)[2022-09-16]

PHP循环使用foreach(PHP loop using foreach)[2022-04-24]

使用PHP foreach（）循环将数据输入MySQL表时使用空字符串(Empty Strings While Entering Data into MySQL table using PHP foreach() Loop)[2021-12-06]

PHP和MySQL不显示数据，不进入foreach循环(php and mysql not showing data, not entering foreach loop)[2022-06-06]

等于PHP参数和mysql数据使得foreach循环无法工作(equaling the PHP argument and mysql data makes foreach loop not work)[2024-01-31]

相关文章

最新问答