我曾经为OpenCart 1.5制作了几个扩展,我想将它们"转换"到OpenCart 2.3.0.2。
我很难找到如何完成以下操作的2.3.0.2:
echo "Free Items Disabler started.<br>";
$sqll = "SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "'";
$result = mysql_query($sqll)or die(mysql_error());
$antall = mysql_num_rows($result);
echo "Products to check: ".$antall."<br>";
...
$this->session->data['success'] = 'Free Items Disabler has
disabled ' . $products_changed . ' products with no price!';
- 如何将消息打印到页面?Echo不会在任何地方显示。
- 如何计算查询结果?当我尝试时,页面总是停止工作。
我已经尝试查看其他2.3个延迟来弄清楚它,但是我找不到任何做类似事情的东西。我花了两天时间试图解决这个问题。
解决方案是:
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) ");
$num = $query->rows;
...
$this->session->data['success'] = 'Free Items Disabler has disabled ' . $products_changed . ' products with no price!';