yii framework tutorial - database MVC

MVC = Model View Controller
Model = berisi data, fungsi dan perhitungan = object + method2nya
View = template, theme
Controller = lem perekat View + Model

1. create table
CREATE TABLE IF NOT EXISTS `departemen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nama` (`nama`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `karyawan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_id` int(11) NOT NULL,
  `nama` varchar(40) NOT NULL,
  `lahir` date NOT NULL,
  `email` varchar(40) DEFAULT NULL,
  `ext` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `dept_id` (`dept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

2. generate model dan class
Masuk ke
http://localhost/datarumah/index.php/gii

isi password gii anda

Pilih: Model Generator

isi table Name : departemen (isi * = semua table)
Tekan : Preview/Generate

Pilih Crud Generator

isi Model Class : Departemen
Tekan : Preview/Generate

Coba : http://localhost/datarumah/index.php/departemen

Model di turunkan dari Active Record
rules( ) adalah method terpenting utk validasi -> returnnya array

3.buka model /protected/models/Karyawan.php
tambahkan : array('email','email'),
utk validasi email

lihat detail di : http://www.yiiframework.com/doc/api/1.1/CModel

bila lahir mau diisi null, tambahkan:

/**
* @return null if value is empty string
*/
public function empty2null($value)
{
return $value===” ? null : $value;
}

array(‘lahir’, ‘filter’, ‘filter’=>array($this, ‘empty2null’)),

4.Buka View