How to use CSqlDataProvider on Yii?
CSqlDataProvider implements a data provider based on a plain SQL statement. CSqlDataProvider provides data in terms of arrays, each representing a row of query result. Like other data providers, CSqlDataProvider also supports sorting and pagination. It does so by modifying the given sql statement with “ORDER BY” and “LIMIT” clauses. You may configure the sort … [Read more…]