blocks|key|2703777|text|您需要取消注释|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2703778|2703779|+extension=php_mysql.dll|blockquote|2703780|2703781|2703782|和|2703783|2703784|+extension=php_mysqli.dll|2703785|2703786|2703787|在您的php.ini中，让我知道是否有效|2703788|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|U|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|K|3|L|5|E|7|Z|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|R|$]]

You need to uncomment 

<blockquote>
 extension=php_mysql.dll 
</blockquote>

and 

<blockquote>
 extension=php_mysqli.dll 
</blockquote>

in your php.ini, let me know if works

blocks|key|2916292|text|您需要安装PHP+intl扩展。我遇到了相同的错误|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2916293|下面是我在控制器中的工作代码|2916294|$count++++++=+++Yii::$app->db->createCommand('
++++++++++++++++++++SELECT+COUNT(*)+FROM+screen_ticket_booking_history+WHERE+status=:status
++++++++++++++++++++',+[':status'+=>+0])->queryScalar();

++++++++++++++++++++$sql+=++"SELECT+A1.booking_id+As+Booking_id,
++++++++++++++++++++++++++++++++A1.booking_date+As+Booking_date,
++++++++++++++++++++++++++++++++A2.movie_name+As+Movie,
++++++++++++++++++++++++++++++++A3.theatre_name+As+Theatre,
++++++++++++++++++++++++++++++++A1.amount+As+Amount

++++++++++++++++++++++++++++++++FROM+
++++++++++++++++++++++++++++++++screen_ticket_booking_history+A1

++++++++++++++++++++++++++++++++LEFT+OUTER+JOIN+movies+A2+ON+A1.movie_id=A2.id
++++++++++++++++++++++++++++++++LEFT+OUTER+JOIN+theatres+A3+ON+A1.theatre_id=A3.id
++++++++++++++++++++++++++++++++LEFT+OUTER+JOIN+users_backend+A4+ON+A3.users_backend_id=A4.id

++++++++++++++++++++++++++++++++WHERE+A1.booking_date+=+'{$day}'
++++++++++++++++++++++++++++++++AND+++A1.movie_id='{$movies->id}'";


++++++++++++++++++++//~+$models+=+$dataProvider->getModels();+//print_r($models);die();
++++++++++++++++++++if(+$userid+!=+'1')
++++++++++++++++++++{+
++++++++++++++++++++++++$sql+.=+"+AND+A3.users_backend_id+=+'{$userid}'+";
++++++++++++++++++++}

++++++++++++++++++++$dataProvider+=+new+SqlDataProvider([
++++++++++++++++++++'sql'+=>+$sql,
++++++++++++++++++++'totalCount'+=>+$count,
++++++++++++++++++++]);
++++++++++++++++++++return+$this->render('index',
++++++++++++++++++++[+++'model'+++++++++++++=>+$model,
++++++++++++++++++++++++'dataProvider'++++++=>+$dataProvider,
++++++++++++++++++++]);
++++++++++++++++}|code-block|syntax|javascript|2916295|下面是我的观点|2916296|<?=+GridView::widget([
+++++++'dataProvider'+=>+$dataProvider,
+++++++'columns'+=>+[
+++++++++++['class'+=>+'yii\grid\SerialColumn'],

+++++++++++'Booking_id',
+++++++++++'Booking_date',
+++++++++++'Movie',
+++++++++++'Theatre',
+++++++++++'Amount',
+++++++++++//~+['class'+=>+'yii\grid\ActionColumn'],
+++++++],
+++]);+?>|2916297|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You need to install PHP intl extension.i had the same error 

given below is my working code 
in controller

<pre><code>$count = Yii::$app-&gt;db-&gt;createCommand('
 SELECT COUNT(*) FROM screen_ticket_booking_history WHERE status=:status
 ', [':status' =&gt; 0])-&gt;queryScalar();

 $sql = "SELECT A1.booking_id As Booking_id,
 A1.booking_date As Booking_date,
 A2.movie_name As Movie,
 A3.theatre_name As Theatre,
 A1.amount As Amount

 FROM 
 screen_ticket_booking_history A1

 LEFT OUTER JOIN movies A2 ON A1.movie_id=A2.id
 LEFT OUTER JOIN theatres A3 ON A1.theatre_id=A3.id
 LEFT OUTER JOIN users_backend A4 ON A3.users_backend_id=A4.id

 WHERE A1.booking_date = '{$day}'
 AND A1.movie_id='{$movies-&gt;id}'";


 //~ $models = $dataProvider-&gt;getModels(); //print_r($models);die();
 if( $userid != '1')
 { 
 $sql .= " AND A3.users_backend_id = '{$userid}' ";
 }

 $dataProvider = new SqlDataProvider([
 'sql' =&gt; $sql,
 'totalCount' =&gt; $count,
 ]);
 return $this-&gt;render('index',
 [ 'model' =&gt; $model,
 'dataProvider' =&gt; $dataProvider,
 ]);
 }
</code></pre>

and below is my view

<pre><code>&lt;?= GridView::widget([
 'dataProvider' =&gt; $dataProvider,
 'columns' =&gt; [
 ['class' =&gt; 'yii\grid\SerialColumn'],

 'Booking_id',
 'Booking_date',
 'Movie',
 'Theatre',
 'Amount',
 //~ ['class' =&gt; 'yii\grid\ActionColumn'],
 ],
 ]); ?&gt;
</code></pre>

blocks|key|135658|text|我遇到了同样的问题，很容易solve.You需要如下所示的指定DB：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|135659|public+function+actionIndex()
{

++++$totalCount+=+Yii::$app->db->createCommand('SELECT+COUNT(*)+FROM+v_risorse')->queryScalar();

++++$dataProvider+=+new+SqlDataProvider([
++++++++**'db'+=>+Yii::$app->db,**
++++++++'sql'+=>+'SELECT+*+FROM+v_risorse',
++++++++'totalCount'+=>+$totalCount,
++++++++'sort'+=>false,
++++++++'pagination'+=>+[
++++++++++++'pageSize'+=>+10,
++++++++],
++++]);

++++return+$this->render('index',+[
++++++++'dataProvider'+=>+$dataProvider,
++++]);
}|code-block|syntax|javascript|135660|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I met the same problem，It is easy to solve.You need assign the DB as bellow:

<pre><code>public function actionIndex()
{

 $totalCount = Yii::$app-&gt;db-&gt;createCommand('SELECT COUNT(*) FROM v_risorse')-&gt;queryScalar();

 $dataProvider = new SqlDataProvider([
 **'db' =&gt; Yii::$app-&gt;db,**
 'sql' =&gt; 'SELECT * FROM v_risorse',
 'totalCount' =&gt; $totalCount,
 'sort' =&gt;false,
 'pagination' =&gt; [
 'pageSize' =&gt; 10,
 ],
 ]);

 return $this-&gt;render('index', [
 'dataProvider' =&gt; $dataProvider,
 ]);
}
</code></pre>

blocks|key|2916299|text|这里有文档：https://www.yiiframework.com/doc/guide/2.0/en/output-data-providers#sql-data-provider|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2916300|示例：|2916301|创建控制器(+$dataProvider+)：|style|BOLD|2916302|public+function+actionIndex($src,+$disposition,+$start,+$finish)
++++{
++++++++++++++++$count+=+$connection->createCommand("
++++++++++++++++select+COUNT(*)
++++++++++++++++from+cdr+
++++++++++++++++where+(Length(dst)+>+6)+
++++++++++++++++and+(start+between+:start+and+:finish)++
++++++++++++++++and+(lastapp=\"Dial\")+
++++++++++++++++and+src+in+(:src)
++++++++++++++++and+disposition+in+('ANSWERED',+'FAILED',+'BUSY',+'NO+ANSWER')")
++++++++++++++++->bindValue(':src',+$params['src'])
++++++++++++++++->bindValue(':start',+$params['start'])
++++++++++++++++->bindValue(':finish',+$params['finish'])->queryScalar();

++++++++++++++++$sql+=+"select+src,+dst,
++++++++++++++++Case+Disposition
++++++++++++++++when+'ANSWERED'+then+'Отвечено'
++++++++++++++++when+'FAILED'+then+'Ошибка'
++++++++++++++++when+'BUSY'+then+'Занято'
++++++++++++++++when+'NO+ANSWER'+then+'Не+дозвонились'++++
++++++++++++++++else+'ИТОГ'++++
++++++++++++++++End+as+status,
++++++++++++++++Start,
++++++++++++++++Round(billsec/60,+2)+as+Billing,
++++++++++++++++uniqueid
++++++++++++++++from+cdr+
++++++++++++++++where+(Length(dst)+>+6)+
++++++++++++++++and+(start+between+:start+and+:finish)++
++++++++++++++++and+(lastapp=\"Dial\")+
++++++++++++++++and+src+in+(:src)
++++++++++++++++and+disposition+in+('ANSWERED',+'FAILED',+'BUSY',+'NO+ANSWER')";

++++++++++++++++$boundParams+=+[
+++++++++++++++++++':src'+=>+$params['src'],
+++++++++++++++++++':start'+=>+$params['start'],
+++++++++++++++++++':finish'+=>+$params['finish'],
++++++++++++++++];

++++++++//+++Provider
++++++++$dataProvider+=+new+SqlDataProvider([
++++++++++++'sql'+=>+$sql,
++++++++++++'params'+=>+$boundParams,
++++++++++++'totalCount'+=>+$count,
++++++++++++'pagination'+=>+[
++++++++++++++++'pageSize'+=>+150,
++++++++++++],
++++++++++++'sort'+=>+[
++++++++++++++++'attributes'+=>+[
++++++++++++++++++++'src',
++++++++++++++++++++'dst',
++++++++++++++++++++'Start',
++++++++++++++++++++'Billing',
++++++++++++++++++++'uniqueid',
++++++++++++++++],
++++++++++++],
++++++++]);
++++++++return+$this->render('index',+[
++++++++++++'params'+=>+$params,
++++++++++++'dataProvider'+=>+$dataProvider,
++++++++++++'count'+=>+$count,
++++++++]);
++++}
}|code-block|syntax|javascript|2916303|创建视图(+GridView+)：|2916304|echo+GridView::widget([
++++'dataProvider'+=>+$dataProvider,
++++'columns'+=>+[
++++++++['class'+=>+'yii\grid\SerialColumn'],
++++++++[
++++++++++++'label'+=>+'От+кого',
++++++++++++'attribute'+=>+'src',
//++++++++++++'format'+=>+['decimal',+2],
++++++++],
++++++++[
++++++++++++'label'+=>+'Кому',
++++++++++++'attribute'+=>+'dst',
//++++++++++++'format'+=>+['decimal',+2],
++++++++],
++++++++[
++++++++++++'label'+=>+'Начало',
++++++++++++'attribute'+=>+'Start',
//++++++++++++'format'+=>+['decimal',+2],
++++++++],
++++++++[
++++++++++++'label'+=>+'Длительность+(сек)',
++++++++++++'attribute'+=>+'Billing',
//++++++++++++'format'+=>+['decimal',+2],
++++++++],
++++++++[
++++++++++++'label'+=>+'UUID',
++++++++++++'attribute'+=>+'uniqueid',
//++++++++++++'format'+=>+['decimal',+2],
++++++++],
++++++++//~+['class'+=>+'yii\grid\ActionColumn'],
++++],
]);|2916305|entityMap|0|LINK|mutability|MUTABLE|url|https://www.yiiframework.com/doc/guide/2.0/en/output-data-providers#sql-data-provider^0|6|2D|0|0|0|0|N|0|0|0|H|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|15|8|@$A|16|B|17|H|I]]|9|@]|C|$]]|$1|J|3|K|5|L|7|18|8|@]|9|@]|C|$M|N]]|$1|O|3|P|5|6|7|19|8|@$A|1A|B|1B|H|I]]|9|@]|C|$]]|$1|Q|3|R|5|L|7|1C|8|@]|9|@]|C|$M|N]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]]]

There documentation: <a href="https://www.yiiframework.com/doc/guide/2.0/en/output-data-providers#sql-data-provider" rel="nofollow noreferrer">https://www.yiiframework.com/doc/guide/2.0/en/output-data-providers#sql-data-provider</a>

Example:

Create $dataProvider (controller):

<pre><code>public function actionIndex($src, $disposition, $start, $finish)
 {
 $count = $connection-&gt;createCommand("
 select COUNT(*)
 from cdr 
 where (Length(dst) &gt; 6) 
 and (start between :start and :finish) 
 and (lastapp=\"Dial\") 
 and src in (:src)
 and disposition in ('ANSWERED', 'FAILED', 'BUSY', 'NO ANSWER')")
 -&gt;bindValue(':src', $params['src'])
 -&gt;bindValue(':start', $params['start'])
 -&gt;bindValue(':finish', $params['finish'])-&gt;queryScalar();

 $sql = "select src, dst,
 Case Disposition
 when 'ANSWERED' then 'Отвечено'
 when 'FAILED' then 'Ошибка'
 when 'BUSY' then 'Занято'
 when 'NO ANSWER' then 'Не дозвонились' 
 else 'ИТОГ' 
 End as status,
 Start,
 Round(billsec/60, 2) as Billing,
 uniqueid
 from cdr 
 where (Length(dst) &gt; 6) 
 and (start between :start and :finish) 
 and (lastapp=\"Dial\") 
 and src in (:src)
 and disposition in ('ANSWERED', 'FAILED', 'BUSY', 'NO ANSWER')";

 $boundParams = [
 ':src' =&gt; $params['src'],
 ':start' =&gt; $params['start'],
 ':finish' =&gt; $params['finish'],
 ];

 // Provider
 $dataProvider = new SqlDataProvider([
 'sql' =&gt; $sql,
 'params' =&gt; $boundParams,
 'totalCount' =&gt; $count,
 'pagination' =&gt; [
 'pageSize' =&gt; 150,
 ],
 'sort' =&gt; [
 'attributes' =&gt; [
 'src',
 'dst',
 'Start',
 'Billing',
 'uniqueid',
 ],
 ],
 ]);
 return $this-&gt;render('index', [
 'params' =&gt; $params,
 'dataProvider' =&gt; $dataProvider,
 'count' =&gt; $count,
 ]);
 }
}
</code></pre>

Create GridView (view):

<pre><code>echo GridView::widget([
 'dataProvider' =&gt; $dataProvider,
 'columns' =&gt; [
 ['class' =&gt; 'yii\grid\SerialColumn'],
 [
 'label' =&gt; 'От кого',
 'attribute' =&gt; 'src',
// 'format' =&gt; ['decimal', 2],
 ],
 [
 'label' =&gt; 'Кому',
 'attribute' =&gt; 'dst',
// 'format' =&gt; ['decimal', 2],
 ],
 [
 'label' =&gt; 'Начало',
 'attribute' =&gt; 'Start',
// 'format' =&gt; ['decimal', 2],
 ],
 [
 'label' =&gt; 'Длительность (сек)',
 'attribute' =&gt; 'Billing',
// 'format' =&gt; ['decimal', 2],
 ],
 [
 'label' =&gt; 'UUID',
 'attribute' =&gt; 'uniqueid',
// 'format' =&gt; ['decimal', 2],
 ],
 //~ ['class' =&gt; 'yii\grid\ActionColumn'],
 ],
]);
</code></pre>

blocks|key|134636|text|基本问题的最简单解决方案是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|134637|++++$dataProvider+=+new+SqlDataProvider([
++++++++++++'sql'+=>+'<your+query/>',
++++]);
++++echo+GridView::widget([
++++++++++++'dataProvider'+=>+$dataProvider,
++++]);|code-block|syntax|javascript|134638|根据您的喜好，使用SqlDataProvider和GridView参数来充实它的复杂性。|134639|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

The simplest solution to the basic question is:
<pre><code> $dataProvider = new SqlDataProvider([
 'sql' =&gt; '&lt;your query/&gt;',
 ]);
 echo GridView::widget([
 'dataProvider' =&gt; $dataProvider,
 ]);
</code></pre>
Flesh it out as complex as you like using SqlDataProvider and GridView params.

I'm quite new to Yii2.
I'm using advanced structure 

I need to show a custom sql result in a view without using a model because I would like to display a sql view.

index.php

<pre><code>&lt;?= GridView::widget([
 'dataProvider' =&gt; $dataProvider,
 'columns' =&gt; [
 ['class' =&gt; 'yii\grid\SerialColumn'],
 'COD_RISORSA',
 [
 'label' =&gt;"Nome",
 'attribute' =&gt; 'NOME',
 'value'=&gt;function($data){
 return $data["NOME"];
 }
 ],
 'COGNOME',
 ['class' =&gt; 'yii\grid\ActionColumn'],
 ],
 ]); ?&gt;
</code></pre>

VRisorseController.php

<pre><code>public function actionIndex()
{

 $totalCount = Yii::$app-&gt;db-&gt;createCommand('SELECT COUNT(*) FROM v_risorse')-&gt;queryScalar();

 $dataProvider = new SqlDataProvider([
 'sql' =&gt; 'SELECT * FROM v_risorse',
 'totalCount' =&gt; $totalCount,
 'sort' =&gt;false,
 'pagination' =&gt; [
 'pageSize' =&gt; 10,
 ],
 ]);

 return $this-&gt;render('index', [
 'dataProvider' =&gt; $dataProvider,
 ]);
}
</code></pre>

At the following Url:
<a href="http://localhost/advanced/frontend/web/index.php?r=vrisorse%2Findex" rel="noreferrer">http://localhost/advanced/frontend/web/index.php?r=vrisorse%2Findex</a>

I have the error:

<blockquote>
 Not Supported – yii\base\NotSupportedException Message format 'number'
 is only supported for integer values. You have to install PHP intl
 extension to use this feature.
 1. in C:\xampp\htdocs\advanced\vendor\yiisoft\yii2\i18n\MessageFormatter.php
</blockquote>

I tried to comment all the columns in gridview, and the error seems to be related to <code>$dataProvider</code> variable

<code>'COD_RISORSA','NOME', 'COGNOME'</code> are columns of the select.

Yii2 custom sql query in gridview

我对Yii2还很陌生。我使用的是高级结构我需要在不使用模型的情况下在视图中显示自定义sql结果，因为我希望显示sql视图。index.php<?= GridView::widget([ 'dataProvider' => $dataProvider, 'columns' => [ ...

问网格视图中的Yii2自定义sql查询
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问网格视图中的Yii2自定义sql查询EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问网格视图中的Yii2自定义sql查询
EN