Opencart 版本 1.5.5.1
我添加了一些代码:在主页中.php然后在 home.tpl 中显示
控制器:
<?php
class ControllerCommonHome extends Controller {
public function index() {
$this->document->setTitle($this->config->get('config_title'));
$this->document->setDescription($this->config->get('config_meta_description'));
$this->data['heading_title'] = $this->config->get('config_title');
$this->dell(); // Custom
if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/common/home.tpl')) {
$this->template = $this->config->get('config_template') . '/template/common/home.tpl';
} else {
$this->template = 'default/template/common/home.tpl';
}
$this->children = array(
'common/column_left',
'common/column_right',
'common/content_top',
'common/content_bottom',
'common/footer',
'common/header'
);
$this->response->setOutput($this->render());
}
// CUSTOM START HERE -------------------------------
protected function dell() {
$this->document->setTitle($this->config->get('config_title'));
$this->document->setDescription($this->config->get('config_meta_description'));
$this->data['heading_title'] = $this->config->get('config_title');
$this->load->model('catalog/item');
for($i=1; $i<=7; $i++) // START FROM 1
{
$menu = array(
'menu' => $i,
);
$results = $this->model_catalog_item->select_id_dell($menu);
if(isset($results)){
$this->data['dell'][] = array(
$results['show_product_id'],
$results['head_text'],
$results['title_text'],
);
}
$this->data['item'] = $this->model_catalog_item->select_item_dell($results);
foreach($this->data['item'] as $id){
$all_data = $this->model_catalog_item->select_description_dll($id);
if(isset($all_data)){
$this->data['product_dell'][$i][] = array(
$all_data['name'],
$all_data['shortDescription'],
$all_data['image'],
$all_data['price'],
);
//var_dump($this->data['product_dell'][1][1]);
}
}
}
}
}
?>
编辑 : 模型
public function select_description_dll($id){
$sql = "SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' && p.product_id = '" . $this->db->escape($id['product_id']) . "' GROUP BY p.product_id";
//echo $sql; exit;
$query = $this->db->query($sql);
return $query->row;
}
我$this->dell();
添加代码,我已经尝试var_dump($this->data['product_dell'][1][1])
并且它正在工作。
array(1) { [0]=> array(4) { [0]=> string(5) "AAAAA" [1]=> string(2) "aa" [2]=> string(3) "aaa" [3]=> string(2) "00" } }
但是在显示 home.tpl 中,它是这样的错误http://s1064.photobucket.com/user/blackarch01/media/2016-02-25_14-42-09_zpsqvd3odia.png.html?sort=3&o=0
就我而言,我将数据存储到数组中$product[1][1][1] until $product[7][7][7]
第 1 [1]
组菜单 1-7
子菜单的第 2 [1]
(例如 1 个菜单有 5 个孩子)
描述 1 个孩子的第 3 [1]
(如姓名、DLL)
然后,我使用for
来显示,它的工作是这样的$name = $product_dell[1][$i][0];
它写未定义的索引'name'
在控制器$all_data['name'],
和另一个中
当我尝试在视图中var_dump($product_dell[1][1]);
时,它正在工作(成功传递变量),idwk 为什么它是错误的以及如何修复此???
感谢您的评论,经过不断尝试,我得到了答案。
在将数据从模型传递到变量后Open cart (in my case)
像这样
$all_data = $this->model_catalog_item->select_description_dll($id);
我无法像这样传递数据(像这样从数据库中获取数据):
if(isset($all_data)){
$this->data['product_dell'][$i][] = array(
$all_data['name'], // Error undefined index name !!!
$all_data['shortDescription'], // Error undefined index shoertDescription !!!
$all_data['image'], // Error undefined index image !!!
$all_data['price'], // Error undefined index price !!!
);
}
所以我像这样更改variable
:
if(isset($all_data['name']))
$name = $all_data['name'];
else
$name = null;
然后再次存储到array
:
if(isset($all_data)){
$this->data['product_dell'][$i][] = array(
$name,
$.....,
);
}
它正在:)工作