public function actionSearch($uid) { $sql = "select * from {{weiyu}} where create_user_id={$uid} order by create_time desc"; $showweiyu = Weiyu::model()->findAllBySql($sql); $data = array('showweiyu' => $showweiyu); $this->render('search', $data); }
public function actionDelete($id) { //$this->loadModel($id)->delete(); $model = Weiyu::model()->findByPk($id); if ($model->delete()) { //添加成功时候的提示信息设置 /** *setFlash getFlash hasFlash 几个方法 */ Yii::app()->user->setFlash('shanchu', '删除成功!'); } $this->redirect('./index.php?r=backend/weiyu/index'); }
function actionIndex() { //首页幻灯片展示,读取最新4条 $ppt = Article::model()->findAll(array('order' => 'create_time desc', 'limit' => 4)); //首页最新微语展示 $wei = Weiyu::model()->findAll(array('order' => 'create_time desc')); // 首页点击率思想展示 $sixiang = Article::model()->findAll(array('order' => 'click desc', 'limit' => 8)); // 首页得瑟会员、小丫丫展示 $jiaoya = User::model()->findAll(array('order' => 'regtime desc', 'limit' => 5)); //首页展示标签 $pictag = Albumcate::model()->findAll(); $articletag = Type::model()->findAll(); //首页展示新的图 $likepic = Album::model()->findAll(array('order' => 'create_time desc', 'limit' => 9)); $data = array('quote' => $this->getRandomQuote(), 'ppt' => $ppt, 'wei' => $wei, 'sixiang' => $sixiang, 'jiaoya' => $jiaoya, 'pictag' => $pictag, 'likepic' => $likepic, 'articletag' => $articletag); $this->render('index', $data); }
echo date('Y-m-d H:i:s', $_u->regtime); //时间戳转化date() ?> </td> <td><?php date_default_timezone_set('PRC'); //设置默认时区 echo date('Y-m-d H:i:s', $_u->update_time); //时间戳转化date() ?> </td> <td><div align="center"><?php echo $ct = Article::model()->countByAttributes(array('author_id' => $_u->id)); ?> /<?php echo $ct2 = Weiyu::model()->countByAttributes(array('create_user_id' => $_u->id)); ?> /<?php echo $ct3 = Album::model()->countByAttributes(array('user_id' => $_u->id)); ?> </div></td> <td><?php $shui = $_u->id; $gznu = "select * from {{follow}} where uid={$shui}"; $numGZ = count(Follow::model()->findAllBySql($gznu)); echo $numGZ; ?> </td> <td><?php $byshui = $_u->id; $fansnu = "select * from {{follow}} where touid={$byshui}";
<span> <?php echo $count = Article::model()->countByAttributes(array('author_id' => Yii::app()->user->id)); ?> </span> </a><a href="<?php echo Yii::app()->createUrl('article/myarticle', array('uid' => Yii::app()->user->id)); ?> ">我的感觉</a></li> <li><a href="<?php echo Yii::app()->createUrl('weiyu'); ?> "> <span> <?php echo $count = Weiyu::model()->countByAttributes(array('create_user_id' => Yii::app()->user->id)); ?> </span></a><a href="<?php 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>
//时间戳转化date() ?> </p> </li> <li class="list"><a href="<?php echo Yii::app()->createUrl('backend/article/index'); ?> ">感觉: <?php echo count(Article::model()->findAll()); ?> 篇</a></li> <li class="list"><a href="<?php echo Yii::app()->createUrl('backend/weiyu/index'); ?> ">微语: <?php echo count(Weiyu::model()->findAll()); ?> 句</a></li> <li class="list"><a href="<?php echo Yii::app()->createUrl('backend/user/index'); ?> ">注册会员: <?php echo count(User::model()->findAll()); ?> 名</a></li> <li class="list"><a href="">美图: <?php echo count(Album::model()->findAll()); ?> 张</a></li> <!-- <li class="list">余额:0.00元</li> <li class="list">短信:无</li> -->