会员中心—3—收藏商品

控制器-商品收藏：

    public function favorites(){
        $id = I("id");
        $uid = $_SESSION['qtuid'];
        $favlist=M('Favorites')->where(array('pro_id'=>$id,'user_id'=>$uid))->select();
        if($favlist==null){
            $goods = M("Product")->where(array('id'=>$id))->find();
            $m = M("Favorites");
            $m->user_id = $uid;
            $m->pro_id = $goods['id'];
            $m->ProductName = $goods['proname'];
            $m->addtime = time();
            if($m->add()){
                $data = 1;
            }else{
                $data = 0;
            }  
        }else{

            $data = 2;
        }
        $this -> ajaxReturn($data);

    }

模板：

<a href="javascript:void(0)" οnclick="tofavorites(<{$data.id}>);">收藏</a>
--------------------------------------
<script language="javascript">
    function tofavorites(id){
        $.post("<{:U('Product/favorites')}>", {"id":id },function(data){
        	if(data==1){
        		alert("收藏成功!");
        	}else if(data==2){
        		alert("您已收藏过该商品!");
        	}else{
        		alert("收藏失败!");
        	}
         } );
    }

</script>

控制器-收藏夹

    //收藏夹
    public function fav(){
    	$where['user_id']=$_SESSION['qtuid'];
	    //收藏列表
	    $m=M('Favorites');
    	$data=$m->join('RIGHT JOIN tp_product ON tp_favorites.pro_id = tp_product.id' )->where($where)->select();

        import("ORG.Util.Pager");
        $count = count($data);
        $page = new Page($count,6);
		$show = $page->show();
	    //收藏列表
	    $m=M('Favorites');
    	$favlist=$m->join('RIGHT JOIN tp_product ON tp_favorites.pro_id = tp_product.id' )->field('tp_favorites.*,tp_product.proname,tp_product.prophoto,tp_product.prointo')->where($where)->limit($page->firstRow.','.$page->listRows)->select();
        $this->assign("favlist",$favlist);
        $this->assign ('favcount', count($favlist));
        $this->assign("page",$show);

        $this->display();  		

    }

    //删除收藏商品
	public function favdelete(){
		$id = I("get.id");
		if($id>0){
			$m = M("Favorites");
			$del = $m->where(array('id'=>$id))->limit(1)->delete();
			if($del){
				$this->success("删除成功",U("Member/fav"));
			}else{
				$this->error("删除失败");
			}
		}
	
	}

收藏夹：

					<div class="col-md-9 col-sm-9">
						<div class="user-right">
							<h3>收藏夹</h3>
							<if condition="$favcount eq 0">
	                            <div class="fav-p"><h3>当前收藏夹没有商品</h3></div>
							<else/>
							<ul class="fav-list pro-list row">
								<volist name="favlist" id="vo">
								<li class="col-md-4 col-xs-6">
									<a href="<{:U('Product/proinfo',array('id'=>$vo[id]))}>">
										<div class="pro-img"><img src="__PUBLIC__/Uploads/Product/<{$vo.prophoto}>"/></div>
										<h5><{$vo.proname}></h5>
										<h6><{$vo.prointo}></h6>
										<a href="<{:U("Member/favdelete",array("id"=>$vo['id']))}>"><span class="dele">删除</span></a>
									</a>
								</li>
								</volist>
							</ul>
							<div class="pager">
								<{$page}>
							</div>
							</if>
						</div>
					</div>

数据表：

CREATE TABLE IF NOT EXISTS `tp_favorites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(4) DEFAULT NULL COMMENT '会员id',
  `pro_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商品id',
  `ProductName` varchar(120) NOT NULL DEFAULT '' COMMENT '商品名称',
  `addtime` varchar(30) DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='收藏夹' AUTO_INCREMENT=2 ;