Yii框架GridView 使用三板斧

##action 代码:

1. 数据准备

```php
// 准备查询
$sql = "select $select_str from member $where_str";

// 准备查询对应统计
$count = yii::$app->db->createCommand("select count(*) from member m $where_str")
		->bindValues($bind)->queryScalar();
```
2.实例化 SqlDataProvider

```php
$dataProvider = new SqlDataProvider([
    'sql' => $sql,
    'params' => $bind,
    'totalCount' => $count,
    'pagination' => [
        'pagesize' => '20',
    ]
]);

return $this->render('list',['dataProvider'=>$dataProvider,'params'=>$params]);
```

页面代码:
3. 页面绑定

```php
<?php
use yii\helpers\Url;
use yii\grid\GridView;
use yii\grid\DataColumn;

echo GridView::widget([
	'id' => 'pages-grid',
	'dataProvider' => $dataProvider,
	//              'filterModel' => $models,
	'columns' => [
		// ['class' => 'yii\grid\SerialColumn'],	//头列数字序号,如果不想要可以注释掉
		'col1',
		'col2',
		//...
		[
			'class' => DataColumn::className(), // 如果需要为列名指定别名或翻译
			'attribute' => 'description1',
			'format' => 'text',
			'label' => '中文名1',
		],
		[
			'class' => DataColumn::className(), // this line is optional
			'attribute' => 'description1',
			'format' => 'text',
			'label' => '中文名2',
		],
		//...
		//一般最后列做各种操作
		[
			'class' => 'yii\grid\ActionColumn',
			'header' => '操作',
			'template' => '{delete} {update}',
			'buttons' => [
				'delete' => function ($url, $model) {
				return Html::a(
					Html::img(Url::home().'someUrl'.'delete.gif'),
					$url.'&mid='.$model['mid'],
					['alt'=>'删除','title'=>'删除']);
				},
				'update' => function ($url, $model) {
					return
					Html::a(Html::img(Url::home().'someUrl'.'update.png'),
					$url.'&mid='.$model['mid'],
					['alt'=>'更新','title'=>'更新']);
				},
			],
		],
	],
]);
```