//1.controller
class Goods extends Base
{
//商品列表
public function index($id){
$goodsModel = new goodsModel;
$goods = $goodsModel->getCatGoods($id);
$cat_name = $goodsModel->getCatName($id);
$this->assign('goods',$goods);
$this->assign('cat_name',$cat_name);
return $this->fetch('list');
}
//商品详情
public function detail($id){
$goodsModel = new goodsModel;
$goods = $goodsModel->getGoodsDetail($id);
$goods['goods_color'] = explode('|', $goods['goods_color']);
$goods['goods_color_desc'] = explode('|', $goods['goods_color_desc']);
$goods['goods_type'] = explode('|',$goods['goods_type']);
$comments = Db::name('comment c')->join('user u','c.user_id=u.id')->where('c.goods_id',$id)->field(['u.mobile','c.content','c.create_time'])->select();
$com_count = count($comments);
$this->assign('goods',$goods);//把数组打出来
$this->assign();
$this->assign('goods',$goods);
$this->assign('comments',$comments);
$this->assign('com_count',$com_count);
return $this->fetch('detail');
}
}
//2.model
class Goods extends Model
{
public function getCatGoods($id){
return $this->where('cat_id',$id)->where('is_on',1)
->field(['goods_name','goods_img','id','original_price','pro_price'])
->select();
}
public function getCatName($id){
return Db::name('category')->where('id',$id)->value('cat_name');
}
public function getGoodsDetail($id){
return $this->where('id',$id)->find();
}
public function getIndexGoods($cat_id){
return $this->where('cat_id',$cat_id)->where('is_on',1)
->field(['id','goods_name','goods_img','pro_price'])
->limit(6)
->order('id desc')
->select();
}
public function getHotGoods($cat_id){
return $this->where('cat_id',$cat_id)->where('is_on',1)->where('is_hot',1)
->field(['id','goods_name','goods_img','pro_price'])
->limit(4)
->order('id desc')
->select();
}
public function getCartGoods($id){
return $this->where('id',$id)->field(['goods_img','goods_name','pro_price','original_price'])->find();
}
}3.databareturn [
// 数据库类型
'type' => 'mysql',
// 服务器地址
'hostname' => '127.0.0.1',
// 数据库名
'databa
// 用户名
'username' => 'root',
// 密码
'password' => 'root',
// 端口
'hostport' => '',
// 连接dsn
'dsn' => '',
// 数据库连接参数
'params' => [],
// 数据库编码默认采用utf8
'charset' => 'utf8',
// 数据库表前缀
'prefix' => 'shop_',
// 数据库调试模式
最佳答案
