Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Variables that you have defined in your controller action are only available to immediate view files that are being used to render a view. They are not available to layouts. However, layouts will be able to use public methods and properties of the controller. So, if you want to pass a variable to your layout you need to declare it as a property of the controller. There are two ways of doing this.</p> <p>Firstly, you can just create a public variable.</p> <pre><code>Class YourController extends CController{ public $dataProvider2; public function actionIndex(){ // renders the view file 'protected/views/site/index.php' // using the default layout 'protected/views/layouts/main.php' //$this-&gt;render('index'); $dataProviderUser=new CActiveDataProvider('User',array( 'pagination'=&gt;array( 'pageSize'=&gt;20, ), )); $dataProviderDomain = new CActiveDataProvider('Domain'); //Added new line here $this-&gt;dataProvider2 = $dataProviderDomain; $this-&gt;render('index',array( 'dataProvider1'=&gt;$dataProviderUser, 'dataProvider2'=&gt;$dataProviderDomain )); } } </code></pre> <p>$this->dataProvider is now available in your view file, but don't foorget to check that it exists before using it.</p> <p>The other method is to use the magic getter method from Yii.</p> <p>In your model, describe a method like this;</p> <pre><code>public function getdataProvider2(){ return $this-&gt;_dataProvider2; } </code></pre> <p>and you'll need a property;</p> <pre><code>private $_dataProvider2; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POYii dataProvider theme main.php
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJoe Miller
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POYii dataProvider theme main.php
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHi, thanks for the solution. Now it works with $this->dataProvider2 in the main.php. But if I click on User Profil, it tells me that dataProvider2 is empty. I also had to add dataProvider2 to my UserController. So it seems like those controllers are all using the same variable but with different use. I dont realy get it.
      singulars
      1. PO
      1. USK213
    2. COIt's a matter of context. When you're in the layout, $this refers to the controller that is calling the layout. So if $this->dataProvider2 is not defined in that controller, then the layout won't be able to access it.
      singulars
      1. PO
      1. USJoe Miller
    3. COSo can I do something like DomainController.dataProvider2, so that it always takes the right Controller?
      singulars
      1. PO
      1. USK213
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload