David
Reputation: 325
CActiveDataProvider returns no data at all, only structure
So, I'm a bit new with yii, I'm very sorry if this sounds like a lame question but I have some weird behavior. I'm trying to load a blog post with the comments but the actionView returns only the blog post:
public function actionView($id)
{
$model = $this->loadModel($id);
$criteria = new CDbCriteria;
$criteria->condition = 'postId = ' . $id;
$criteria->order = 'commentTime desc';
$criteria->with = array('user');
$dataSet = new CActiveDataProvider('Comments', array(
'criteria' => $criteria,
)
);
echo "<pre>";
print_r($dataSet);
echo "</pre>";
$this->render('view',array(
'model'=>$model,
'dataSet'=>$dataSet,
));
}
Now the view file:
$this->renderPartial('_view',array('data'=>$model,));
$this->renderPartial('comments',array('data'=>$dataSet,));
The funny thing is that according to the logs, it's not even selecting from the comments table, but when I print_r, I get the whole structure of the table.
CActiveDataProvider Object
(
[modelClass] => Comments
[model] => Comments Object
(
[_md:CActiveRecord:private] => CActiveRecordMetaData Object
(
[tableSchema] => CMysqlTableSchema Object
(
[schemaName] =>
[name] => Comments
[rawName] => `Comments`
[primaryKey] => id
[sequenceName] =>
[foreignKeys] => Array
(
[postId] => Array
(
[0] => Posts
[1] => id
)
[userId] => Array
(
[0] => users
[1] => id
)
)
[columns] => Array
(
[id] => CMysqlColumnSchema Object
(
[name] => id
[rawName] => `id`
[allowNull] =>
[dbType] => int(11)
[type] => integer
[defaultValue] =>
[size] => 11
[precision] => 11
[scale] =>
[isPrimaryKey] => 1
[isForeignKey] =>
[autoIncrement] => 1
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[postId] => CMysqlColumnSchema Object
(
[name] => postId
[rawName] => `postId`
[allowNull] =>
[dbType] => int(11)
[type] => integer
[defaultValue] =>
[size] => 11
[precision] => 11
[scale] =>
[isPrimaryKey] =>
[isForeignKey] => 1
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[userId] => CMysqlColumnSchema Object
(
[name] => userId
[rawName] => `userId`
[allowNull] =>
[dbType] => int(11)
[type] => integer
[defaultValue] =>
[size] => 11
[precision] => 11
[scale] =>
[isPrimaryKey] =>
[isForeignKey] => 1
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[commentTime] => CMysqlColumnSchema Object
(
[name] => commentTime
[rawName] => `commentTime`
[allowNull] =>
[dbType] => timestamp
[type] => string
[defaultValue] =>
[size] =>
[precision] =>
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[commentText] => CMysqlColumnSchema Object
(
[name] => commentText
[rawName] => `commentText`
[allowNull] =>
[dbType] => mediumtext
[type] => string
[defaultValue] =>
[size] =>
[precision] =>
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[voteUp] => CMysqlColumnSchema Object
(
[name] => voteUp
[rawName] => `voteUp`
[allowNull] =>
[dbType] => mediumint(8) unsigned
[type] => integer
[defaultValue] => 0
[size] => 8
[precision] => 8
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[voteDown] => CMysqlColumnSchema Object
(
[name] => voteDown
[rawName] => `voteDown`
[allowNull] =>
[dbType] => mediumint(8) unsigned
[type] => integer
[defaultValue] => 0
[size] => 8
[precision] => 8
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[reports] => CMysqlColumnSchema Object
(
[name] => reports
[rawName] => `reports`
[allowNull] =>
[dbType] => smallint(5) unsigned
[type] => integer
[defaultValue] => 0
[size] => 5
[precision] => 5
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
)
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[columns] => Array
(
[id] => CMysqlColumnSchema Object
(
[name] => id
[rawName] => `id`
[allowNull] =>
[dbType] => int(11)
[type] => integer
[defaultValue] =>
[size] => 11
[precision] => 11
[scale] =>
[isPrimaryKey] => 1
[isForeignKey] =>
[autoIncrement] => 1
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[postId] => CMysqlColumnSchema Object
(
[name] => postId
[rawName] => `postId`
[allowNull] =>
[dbType] => int(11)
[type] => integer
[defaultValue] =>
[size] => 11
[precision] => 11
[scale] =>
[isPrimaryKey] =>
[isForeignKey] => 1
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[userId] => CMysqlColumnSchema Object
(
[name] => userId
[rawName] => `userId`
[allowNull] =>
[dbType] => int(11)
[type] => integer
[defaultValue] =>
[size] => 11
[precision] => 11
[scale] =>
[isPrimaryKey] =>
[isForeignKey] => 1
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[commentTime] => CMysqlColumnSchema Object
(
[name] => commentTime
[rawName] => `commentTime`
[allowNull] =>
[dbType] => timestamp
[type] => string
[defaultValue] =>
[size] =>
[precision] =>
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[commentText] => CMysqlColumnSchema Object
(
[name] => commentText
[rawName] => `commentText`
[allowNull] =>
[dbType] => mediumtext
[type] => string
[defaultValue] =>
[size] =>
[precision] =>
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[voteUp] => CMysqlColumnSchema Object
(
[name] => voteUp
[rawName] => `voteUp`
[allowNull] =>
[dbType] => mediumint(8) unsigned
[type] => integer
[defaultValue] => 0
[size] => 8
[precision] => 8
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[voteDown] => CMysqlColumnSchema Object
(
[name] => voteDown
[rawName] => `voteDown`
[allowNull] =>
[dbType] => mediumint(8) unsigned
[type] => integer
[defaultValue] => 0
[size] => 8
[precision] => 8
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[reports] => CMysqlColumnSchema Object
(
[name] => reports
[rawName] => `reports`
[allowNull] =>
[dbType] => smallint(5) unsigned
[type] => integer
[defaultValue] => 0
[size] => 5
[precision] => 5
[scale] =>
[isPrimaryKey] =>
[isForeignKey] =>
[autoIncrement] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
)
[relations] => Array
(
[user] => CBelongsToRelation Object
(
[joinType] => LEFT OUTER JOIN
[on] =>
[alias] =>
[with] => Array
(
)
[together] =>
[scopes] =>
[name] => user
[className] => User
[foreignKey] => userId
[select] => *
[condition] =>
[params] => Array
(
)
[group] =>
[join] =>
[having] =>
[order] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[post] => CBelongsToRelation Object
(
[joinType] => LEFT OUTER JOIN
[on] =>
[alias] =>
[with] => Array
(
)
[together] =>
[scopes] =>
[name] => post
[className] => Posts
[foreignKey] => postId
[select] => *
[condition] =>
[params] => Array
(
)
[group] =>
[join] =>
[having] =>
[order] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
)
[attributeDefaults] => Array
(
[voteUp] => 0
[voteDown] => 0
[reports] => 0
)
[_model:CActiveRecordMetaData:private] => Comments Object
*RECURSION*
)
[_new:CActiveRecord:private] =>
[_attributes:CActiveRecord:private] => Array
(
)
[_related:CActiveRecord:private] => Array
(
)
[_c:CActiveRecord:private] =>
[_pk:CActiveRecord:private] =>
[_alias:CActiveRecord:private] => t
[_errors:CModel:private] => Array
(
)
[_validators:CModel:private] =>
[_scenario:CModel:private] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[keyAttribute] =>
[_criteria:CActiveDataProvider:private] => CDbCriteria Object
(
[select] => *
[distinct] =>
[condition] => postId = 2
[params] => Array
(
)
[limit] => -1
[offset] => -1
[order] => commentTime desc
[group] =>
[join] =>
[having] =>
[with] => Array
(
[0] => user
)
[alias] =>
[together] =>
[index] =>
[scopes] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
[_id:CDataProvider:private] => Comments
[_data:CDataProvider:private] =>
[_keys:CDataProvider:private] =>
[_totalItemCount:CDataProvider:private] =>
[_sort:CDataProvider:private] =>
[_pagination:CDataProvider:private] =>
[_e:CComponent:private] =>
[_m:CComponent:private] =>
)
Upvotes: 1
Views: 1447
Answers (2)
acorncom
Reputation: 5955
You're setting yourself up for a SQL injection (or at least the possibility of one) building your criteria that way. If you do things like this do you get your results back?
public function actionView($id)
{
// the with will load your comments through your Blog relationship
// with the comments and then user your Comment -> User relationship as well
// doing it this way eliminates the need for creating your own criteria object
$model = Blog::model()->with('comments.user')->findByPk((int)$id);
// we then set a defaultOrder here
$dataSet = new CActiveDataProvider($model->comments, array(
'sort'=>array(
'defaultOrder'=>'commentTime desc',
),
)
);
echo "<pre>";
print_r($dataSet);
echo "</pre>";
....
}
Upvotes: 1
Onkar Janwa
Reputation: 3950
Try this model debugger then test your output and please make your question clear. http://www.kevinkorb.com/post/26
Upvotes: 1
Related Questions
- yii fetching data using CSqlDataProvider
- Get CActiveDataProvider data in the View
- CActiveDataProvider doesnt give selected columns
- Yii2-activedataprovider doesn't fetch data
- Yii: Relational CActiveDataProvider does not working, got error "Column not found: 1054 Unknown column"
- Undefined Variable $data in CActiveDataProvider - Yii Framework
- Yii CActiveDataProvider data is not loading from joined tables
- Get all data using CActiveDataProvider
- YII CActiveDataProvider with relational tables
- Getting data with CActiveDataProvider in yii