/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return TbaParam the loaded model * @throws CHttpException */ public function loadModel($id) { $model = TbaParam::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
<?php $marquee = TbaParam::model()->findByAttributes(array('param' => 'marquee_size')); $size = $marquee->pvalue; //取的變數內容; echo "<span style=font-size:" . $size . "px>"; echo CHtml::link($quote->title, array('tbaBoard/empread?id=' . $quote->id), array('target' => '_self')); echo "</span>";
?> /css/example.css" /> <div class="announe"> <!--tableBlue --> <?php echo CHtml::beginForm(); ?> <table > <tr> <td> <table > <?php $row_num = TbaParam::model()->findByAttributes(array('param' => 'board_num')); //取sql值時,先取得變數代碼等於 'select * from tba_param where param = board_num' $row = $row_num->pvalue; //取的變數內容; //直接從Contraller的actionAnnounce移過來 $today = date('Y-m-d'); //今天日期 //使用sql寫法 $sql = "SELECT a.id, a.title, a.content, a.dates, b.read FROM\n (SELECT * FROM `tba_board` WHERE datee >='{$today}' ) a LEFT JOIN `tba_board_emp_log` b\n ON a.id = b.board_id order by datee desc limit {$row}"; $result = Yii::app()->db->createCommand($sql)->queryAll(); for ($i = 0; $i < count($result); $i++) { echo "<tr>"; echo "<td>"; echo "<b>#-</b> " . CHtml::link($result[$i]['read'] ? $result[$i]['title'] : "<b>" . $result[$i]['title'] . "</b>", array('tbaBoard/empread?id=' . $result[$i]['id']), array('target' => '_self')); echo "</td>"; echo "</tr>";