echo Yii::app()->createUrl('weiyu'); ?> ">我的微语</a> </li> <li><a href=""><span><?php echo $sl = Album::model()->countByAttributes(array('user_id' => Yii::app()->user->id)); ?> </span></a><a href="<?php echo Yii::app()->createUrl('album/myalbum'); ?> ">我的相册</a></li> <li><a href="./index.php?r=user/fav"> <span> <?php $c1 = Picshoucang::model()->countByAttributes(array('pic_uid' => Yii::app()->user->id)); $c2 = Shoucang::model()->countByAttributes(array('uid' => Yii::app()->user->id)); $num = $c1 + $c2; echo $num; ?> </span></a> <a href="./index.php?r=user/fav">我的收藏</a> </li> <!-- <li><a href=""><span>0</span></a><a href="">小集体</a></li> --> <li><a href="" target="_blank"><span>1</span></a><a href="./index.php?r=quiet/index" target="_blank">找自己</a></li> <!-- <li><a href=""><span>0</span></a><a href="">电影</a></li> <li><a href=""><span>0</span></a><a href="">音乐</a></li> <li><a href=""><span>0</span></a><a href="">读书</a></li> --> </ul> </div> </div>
?> 次 </li> <?php if (!Yii::app()->user->getIsGuest()) { ?> <li class="img"> <?php //收藏与已经收藏判断,不能放在控制器中 $userid = Yii::app()->user->id; $sxid = $model->id; // 联合查询同时满足同一主键的数据,如果返回为NULL就是未收藏,否则一经收藏 $sql = "select * from {{shoucang}} where uid={$userid} and sixiangid={$sxid}"; $sc_sixiang = Shoucang::model()->findAllBySql($sql); if ($sc_sixiang == NULL) { ?> <a href="<?php echo Yii::app()->createUrl('article/shoucang', array('id' => $model->id)); ?> "><div>收藏</div><img src="<?php echo $model->img; ?> "></a> <?php } else { ?> <a><div>已收藏 ^_^</div><img src="<?php echo $model->img; ?>
/** * This is invoked after the record is deleted.删除文章之后删除相应的内容 */ protected function afterDelete() { parent::afterDelete(); Comment::model()->deleteAll('article_id=' . $this->id); Shoucang::model()->deleteAll('sixiangid=' . $this->id); //Tag::model()->updateFrequency($this->tags, ''); }
public function actionQuxiao($id) { $model = Shoucang::model()->findByPk($id); if ($model->delete()) { //添加成功时候的提示信息设置 /** *setFlash getFlash hasFlash 几个方法 */ Yii::app()->user->setFlash('quxiao', '取消收藏成功 -_-!'); } $this->redirect('./index.php?r=user/fav'); }
?> </td> <td><?php echo $_v->click; ?> </td> <td><?php //统计评论数量 $pl = $_v->id; echo $count = Comment::model()->countByAttributes(array('article_id' => $_v->id)); ?> </td> <td><?php //统计被收藏的数量 $sx = $_v->id; echo $count = Shoucang::model()->countByAttributes(array('sixiangid' => $_v->id)); ?> </td> <td><?php date_default_timezone_set('PRC'); //设置默认时区 echo date('Y-m-d H:i:s', $_v->create_time); //时间戳转化date() ?> </td> <td class="fun_con mfun"> <a class="f_edit mtop" href="<?php echo Yii::app()->createUrl('backend/article/update', array('id' => $_v->id)); ?> " target="_blank">编辑</a> <a class="f_delete mtop" onclick="return confirm('你确定要删除《<?php