Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The Yii way would be to define a Relation between the two model classes (and enforce it with a Foreign Key). Then Yii would know how the two classes are related and you would have an easier time loading the related data.</p> <p>In the <code>TaxiOrders</code> model class, a relation would look like this:</p> <pre><code>/** * @property TaxiDrivers $Driver */ class TaxiOrders extends CActiveRecord { // ... public function relations() { return array( 'Driver' =&gt; array(self::BELONGS_TO, 'TaxiDrivers', 'driver_id'), ); } // ... } </code></pre> <p>In the controller, when you load the order data, you can prefetch the associated driver data like this:</p> <pre><code>public function actionOrderInfo($orderID) { $order = TaxiOrders::model()-&gt;with('Driver')-&gt;findByPk($orderID); // render it } </code></pre> <p><code>with('Driver')</code> will make sure that each returned order has its driver info already loaded, no matter if you need to find one record or a lot of records. It is a lot more efficient than trying to load that related data yourself.</p> <p>In the view, you can output the driver info like this:</p> <pre><code>echo CHtml::encode($order-&gt;Driver-&gt;Name); </code></pre> <p>Unless you have a foreign key to ensure data integrity, it is possible that the Driver has been deleted without clearing his existing orders... In that case <code>$order-&gt;Driver</code> will be <code>NULL</code> and the line above will cause an error. Figuring out how to avoid it should be obvious.</p>
    singulars
    1. This table or related slice is empty.
    1. POChange yii crud generated page
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDCoder
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POChange yii crud generated page
      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. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks dude! but one more query I have and hope you can clearify: I have a standart generated admin.php view page with following code:<?php $this->widget('zii.widgets.grid.CGridView', array( 'id'=>'taxi-orders-grid', 'dataProvider'=>$model->search(), 'filter'=>$model, 'columns'=>array( 'id', 'uid', 'did', 'type', 'notes', //'or_lat', //'or_lng', //'des_lat', //'des_lng', 'cost', 'rating', 'date', 'time', 'status', array( 'class'=>'CButtonColumn', ), ), )); ?> and below code is for controller:
      singulars
      1. PO
      1. USZheka
 

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