GhazaliTajuddin.com

Another Kuantan Blogger

Framework

Yii CActiveDataProvider

by Leave a Comment

Yii Framework
Yii Framework

Sample using CActiveDataProvider
Sample 1:

[php]
$dataProvider=new CActiveDataProvider(‘User’,array(
‘criteria’=>array(
‘condition’=>’activationstatus = 1’),
));
[/php]

Sample 2:

[php]
$dataProvider=new CActiveDataProvider(‘Event’, array(
‘criteria’=>array(
‘condition’=>’date >= "’.date(‘Y-m-d’, strtotime(‘-2 years’)).’"’,
),
));
[/php]

Sample 3:

[php]
$dataProvider=new CActiveDataProvider(‘Post’, array(
‘pagination’=>array(
‘pageSize’=>5,
),
‘criteria’=>$criteria,
));
[/php]

Sample 4:

[php]
$dataProvider=new CActiveDataProvider(‘User’)
[/php]

Yii Lookup

by Leave a Comment

Yii Framework
Yii Framework

Some function is created to make code easy to read and manageable. The Lookup function is so powerfull to simplified data storage. Usually we store Approve, Not Approved, Qualified, Not Qualified in words for each records, but with Lookup class, we can make it short to an integer for each properties.

Table scheme “tbl_lookup”

[php]

CREATE TABLE tbl_lookup
(
id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(128) NOT NULL,
code INTEGER NOT NULL,
type VARCHAR(128) NOT NULL,
position INTEGER NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[/php]

Insert some records like this

[php]
INSERT INTO tbl_lookup (name, type, code, position) VALUES (‘Activated’, ‘ActivationStatus’, 1, 1);
INSERT INTO tbl_lookup (name, type, code, position) VALUES (‘Not Activated’, ‘ActivationStatus’, 2, 2);
INSERT INTO tbl_lookup (name, type, code, position) VALUES (‘Pending Approval’, ‘membership_status’, 1, 1);
INSERT INTO tbl_lookup (name, type, code, position) VALUES (‘Approved’, ‘membership_status’, 2, 2);
INSERT INTO tbl_lookup (name, type, code, position) VALUES (‘Not Approved’, ‘membership_status’, 3, 3);
[/php]

[Read more…] about Yii Lookup

Yii CGridView

by Leave a Comment

Yii Framework
Yii Framework
  • CGridView is one of Zii Components
  • There is other than CGridView, CDetailView, CListView. Look here.
  • CGridView use DataProvider which define in controller
  • CGridView display data in tables.
  • Supports paginating, sorting, searching.
  • Also support view, update, delete method
Define our data provider in controller like this
[php]

/**
* Lists all models.
*/
public function actionIndex()
{
$dataProvider=new CActiveDataProvider(‘User’,
array(
‘pagination’=>array(
‘pageSize’=>10,
),
‘sort’=>array(
‘defaultOrder’=> array(‘id’=>false),
)
));

$this->render(‘index’,array(
‘dataProvider’=>$dataProvider,
));
}
[/php]

[Read more…] about Yii CGridView

Understanding Yii CFORM

by 5 Comments

Yii Framework
Yii Framework

In this tutorial we discuss about the basic principal of MVC using Yii Framework. How to create Model extends from CFormModel which we collect data from it, to create related Controller and finishing at View.

1. Generate webapp from Command Prompt

yiic webapp myapps

2. Uncomment gii on myapps/protected/config/main.php. Set your prefered password. This allow us to use scaffolding modules provided by Yii Framework. Please remove this when you ready to deploy your application for security reason.

3. Access your gii module at your browser

http://localhost/myapps/index.php?r=gii.

4. Using gii module online forms, create a Controller, name it MyData, it should generate MyDataController.php. You can access it at root/myapps/controllers/MyDataController.php

5. Duplicate myapps/models/ContactForm.php, rename it as MyDataForm.php. This will act as your model. This model extends CFormModel class as we dont use Active Records.

6. Clean up MyDataForm.php like this

[php]
/**
* ContactForm class.
* ContactForm is the data structure for keeping
* contact form data. It is used by the ‘contact’ action of ‘SiteController’.
*/
class MyDataForm extends CFormModel
{
public $name;
public $email;
public $subject;

/**
* Declares the validation rules.
*/
public function rules()
{
return array(
// name, email, subject and body are required
array(‘name, email, subject’,’required’),
);
}

}[/php]

[Read more…] about Understanding Yii CFORM