对不起,我是一个初学者与yii web框架
我想知道如何在两个表之间建立联系。
,
假设我有2个表
第一个表= Member(id, username, password)
第二个表= Product(id, member_id, product_name, product_detail)
我有post product表单当我已经发布表单时我想显示member_id
登录。
这里这个简单的代码是me
在模型/Member.php<?php
class Member extends CActiveRecord {
public static function model($c = __CLASS__) {
return parent::model($c);
}
public function tableName(){
return "members";
}
}
?>
在模型/Product.php<?php
class Product extends CActiveRecord {
public static function model($c = __CLASS__) {
return parent::model($c);
}
public function tableName() {
return "products";
}
public function relations() {
return array(
"members" => array(self::BELONGS_TO, "Member", "members_id")
);
}
}
?>
如何在控制器中编写代码,script.js和显示视图上的值?
<?php
//Get product by primary key.
$product_id = 20;
$data = Product::model()->findByPk($product_id);//SELECT * FROM product WHERE id = 20;
//get username and password from table member.
$username = $data->members->username;
$password = $data->members->password;
//"members" is the alias from function relations() in your model Product
//I mean this "members" => array(self::BELONGS_TO, "Member", "members_id")
//and like this select fields from "producto"
$product_name = $data->product_name;
$product_detail = $data->product_detail;