YII 架構問題
有人用過YII 架構沒?裡面的之間的通訊聯絡我不是清楚!求高人指點下
------解決方案--------------------
class Academic_list extends CActiveRecord
{
public static function model($className=__CLASS__)
{
return parent::model($className);
}
public function relations()
{
return array(
'sorts'=>array(
self::BELONGS_TO, 'Academic_sort', 'sortid'
)
);
}
}
class Academic_sort extends CActiveRecord
{
public $subs = null;
public static function model($className=__CLASS__)
{
return parent::model($className);
}
public function relations()
{
return array(
'lists'=>array(
self::HAS_MANY, 'Academic_list', 'id'
)
);
}
}
$row = Academic_list::model()->with('sorts')->findByPk($id);
$row->sorts->name;
------解決方案--------------------
以上 Academic_list 表和 Academic_sort 表是一對多的關係.
希望對你有協助.
祝你好運.
------解決方案--------------------
PHP code
class Tlist extends CActiveRecord{ public function relations() { return array( 'sorts'=>array( self::BELONGS_TO, 'Tsort', 'sortid', ) ); }}class Tsort extends CActiveRecord{ public function relations() { return array( 'lists'=>array( self::HAS_MANY, 'Tlist', 'id', ) ); }}$dataProvider = new CActiveDataProvider('Tlist', array( 'criteria'=>array(// 'condition'=>'status=1 AND tags LIKE :tags',// 'params'=>array(':tags'=>$_GET['tags']), 'with'=>array('sorts'), ), 'pagination'=>array( 'pageSize'=>5, 'currentPage'=>2, ),));$rows = $dataProvider->getData();foreach($rows as $row){ echo $row->id; echo '
';}
------解決方案--------------------
Tlist 表結構:
id INT 主鍵 遞增
sortid INT 外鍵
title VARCHAR
Tsort 表結構:
id INT 主鍵 遞增
name VARCHAR
PHP code
$dataProvider = new CActiveDataProvider('Tlist', array( 'criteria'=>array(// 'condition'=>'status=1 AND tags LIKE :tags',// 'params'=>array(':tags'=>$_GET['tags']), 'with'=>array('sorts'), ), 'pagination'=>array( 'pageSize'=>5, 'currentPage'=>1, ),));$rows = $dataProvider->getData();foreach($rows as $row){ echo $row->id; echo '---'; echo $row->sorts->name; echo '---'; echo $row->title; echo '
';}