Verify if the relationship is established with the value attribute of CDataColumn

Question

Verify if the relationship is established with the value attribute of CDataColumn

Is it possible to use a conditional statement within the value attribute of CDataColumn to verify if a model has a value set before displaying it? For example, I have a model Source with an optional relation 'country' that is not always set for every instance. When attempting to display the country name in a Source CDataColumn, I encounter the PHP error:

Trying to get property of non-object

This error occurs when the country is not set for any of the Sources in the grid. Is there a way to check if the relation is set inside the 'value' attribute of the column?

php yii

Answer 1

Answer №1

Consider implementing the following solution (replace name as required) :

array(
  'name'=>'country',
  'value'=>'(isset($data->country)) ? $data->country->name : ""',
),

An alternative approach would be to create a getter in your Source model, like so :

public function getCountryName()
{
  // Assuming country_id is the foreign key
  if (isset($this->country_id) && isset($this->country))
    return $this->country->name;

  return '';
}

By using this getter method, you simply need to include the following code in your gridview columns :

 'countryName',

Answer 2

Consider implementing the following solution (replace name as required) :

array(
  'name'=>'country',
  'value'=>'(isset($data->country)) ? $data->country->name : ""',
),

An alternative approach would be to create a getter in your Source model, like so :

public function getCountryName()
{
  // Assuming country_id is the foreign key
  if (isset($this->country_id) && isset($this->country))
    return $this->country->name;

  return '';
}

By using this getter method, you simply need to include the following code in your gridview columns :

 'countryName',

Verify if the relationship is established with the value attribute of CDataColumn

Answer №1

Similar questions

Failing to send contact information using JSON in PHP

Fluctuating updated site (ajax)

Jquery Triggers Failing to Work Following Ajax Request

Accessing form data from Ajax/Jquery in php using $_POST variables

Add the AJAX response to the dropdown menu options

What is the process for sharing your website content on Google Blogger?

Transmit a data point from JavaScript to PHP

Indentation differences between PHP and JavaScript

Unexpected error 500 (Internal Server Error) occurred due to BadMethodCallException

Please include the document with a name that contains spaces

What is the best way to manage the back button using jQuery?

Eliminate duplicate time slots in Laravel and Vuejs

Storing data with Laravel 5.3 using Storage::put and XMLHttpRequest

Using jQuery to dynamically insert a table row with JSON data into dropdown menus

Executing JavaScript function by clicking on <img>

The JQUERY code for refreshing a div requires a timeout delay

Unraveling JSON data retrieved from a MySQL query

PHP seems to be resistant to receiving data from ajax requests

Sophisticated web applications with Ajax functionalities and intricate layouts powered by MVC frameworks

Adding parameters to a URL is a common practice