联系电话:0755-27515592
最新动态:

zencart教程

zencart新增categories分类表字段步骤

点击数:11542015-07-14 10:10:37 来源: 外贸网站建设,深圳外贸网站建设,深圳网站建设,外贸商城网站制作-亿恩科技

新闻摘要:zencart新增分类字段步骤 1.categories表新增字段related_categories、related_products ALTER TABLE `categories` ADD `related_categories` VARCHAR ( 255 ) NOT NULL , ADD `related_products` VARCHAR ( 255 ) NOT NULL ; 2.修改admin\ca

zencart新增分类字段步骤

1.categories表新增字段related_categories、related_products

ALTER TABLE `categories` ADD `related_categories` VARCHAR( 255 ) NOT NULL , ADD `related_products` VARCHAR( 255 ) NOT NULL;

2.修改admin\categories.php

大概212行

$insert_sql_data = array('parent_id' => $current_category_id,
                                 'date_added' => 'now()');

改为

$insert_sql_data = array('parent_id' => $current_category_id,
                                 'date_added' => 'now()',
                                 'related_categories'=>$_POST['related_categories'],
                                 'related_products'=>$_POST['related_products']);


大概239行

$update_sql_data = array('last_modified' => 'now()');

改为

$update_sql_data = array('last_modified' => 'now()','related_categories'=>$_POST['related_categories'],'related_products'=>$_POST['related_products']);

大概776行
在代码

$contents[] = array('text' => '<br />' . TEXT_CATEGORIES_DESCRIPTION . $category_inputs_string);

下面一行新增

$contents[] = array('text' => '<br />关联分类ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_categories', '', zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name'))); $contents[] = array('text' => '<br />关联产品ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_products', '', zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name')));


大概834行
在代码

$contents[] = array('text' => '<br />' . TEXT_CATEGORIES_DESCRIPTION . $category_inputs_string);

下面一行新增

$contents[] = array('text' => '<br />关联分类ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_categories', zen_get_related_categories($cInfo->categories_id), zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name'))); $contents[] = array('text' => '<br />关联产品ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_products', zen_get_related_products($cInfo->categories_id), zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name')));


3.admin\includes\functions\extra_functions\目录下新建文件extra_functions.php
写入以下代码:

复制代码
<?php function zen_get_related_categories($category_id) { global $db; $category = $db->Execute("select related_categories
                              from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_categories'];
} function zen_get_related_products($category_id) { global $db; $category = $db->Execute("select related_products
                              from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_products'];
} ?>
复制代码

 

4.前台显示新增字段,includes\functions\extra_functions\目录下新建文件extra_functions.php

写入以下代码:

复制代码
<?php function zen_get_related_categories($category_id) { global $db; $category = $db->Execute("select related_categories
                              from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_categories'];
} function zen_get_related_products($category_id) { global $db; $category = $db->Execute("select related_products
                              from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_products'];
} ?>
复制代码

接着,在前台页面tpl_index_categories.php、tpl_index_product_list.php里面适当位置调用新增字段值

echo zen_get_related_categories($current_category_id); echo zen_get_related_products($current_category_id);
【责任编辑:(Top) 返回页面顶端
贴心
全国7×24小时客服热线
安全
病毒杀除率高于99%
稳定
网站可用性高于99.9%
实力
服务68家上市企业及集团公司
亿恩科技手机站
关注亿恩科技微信

亿恩科技—企业信息化一站式服务专家


Copyright © 2008- 深圳市亿恩科技有限公司版权所有 粤ICP备15056041号

联系我们 | 常见问题 | 在线留言 | 支付方式 | 软件开发 | 我的观点 | 资质荣誉 | 服务流程