public static function get_list()
{
//Collegeテーブルの呼び出し
$college = Model_College::query()->where('df', '=', '0')->get();
//テーブルを配列で回す
foreach ($college as $row) {
//$dataに、配列'college'を作成
//$変数=['配列名->テーブルのテーブルID']=配列名->テーブルの名前←ここがViewで表示される場所
$data[$row->Cid] = $row->Cname;
//全てのデータを取り出したら回すのをやめる
}
return $data;
}
public function action_Edit($Cid = 0)
{
$Cid and $this->data['coll'] = Model_College::query()->where('Cid', '=', $Cid)->get();
if (Input::post()) {
$val = Model_College::validate();
if ($val->run()) {
$query = DB::update('College')->set(array('Cname' => Input::post('Cname'), 'Ckana' => Input::post('Ckana'), 'luID' => Auth::get_screen_name()))->where('Cid', '=', $Cid)->execute();
Response::redirect('college');
} else {
$this->message = $val->error();
$view = View::forge('collegemanagement/CollEdit', $this->data);
$view->set_global('message', $this->message, false);
}
} else {
$view = View::forge('collegemanagement/CollEdit', $this->data);
$view->set_global('message', $this->message, false);
}
return $view;
}
