**Course Title:** Mastering Yii Framework: Building Scalable Web Applications **Section Title:** Advanced Active Record and Querying **Topic:** Handling pagination and sorting in Yii applications **Overview** In this topic, we will explore how to handle pagination and sorting in Yii applications using Active Record. Pagination allows us to limit the number of records returned from a database query, while sorting enables us to arrange the records in a specific order. We will cover the following key concepts: * Pagination using `limit` and `offset` methods * Sorting using `orderBy` method * Using `find()` method with pagination and sorting * Using `findAll()` method with pagination and sorting * Using `find()` method with pagination, sorting, and filtering **Pagination using `limit` and `offset` methods** Pagination can be achieved using the `limit` and `offset` methods provided by Active Record. The `limit` method specifies the number of records to return, while the `offset` method specifies the starting point of the records to return. ```php // Get 10 records starting from the 20th record $models = MyModel::find()->limit(10)->offset(20)->all(); ``` **Sorting using `orderBy` method** Sorting can be achieved using the `orderBy` method provided by Active Record. The `orderBy` method takes a string argument that specifies the column to sort by and the direction of the sort. ```php // Get records sorted by name in ascending order $models = MyModel::find()->orderBy('name ASC')->all(); ``` **Using `find()` method with pagination and sorting** The `find()` method can be used with pagination and sorting by chaining the `limit`, `offset`, and `orderBy` methods. ```php // Get 10 records starting from the 20th record, sorted by name in ascending order $models = MyModel::find()->limit(10)->offset(20)->orderBy('name ASC')->all(); ``` **Using `findAll()` method with pagination and sorting** The `findAll()` method can be used with pagination and sorting by chaining the `limit`, `offset`, and `orderBy` methods. ```php // Get 10 records starting from the 20th record, sorted by name in ascending order $models = MyModel::findAll(['limit' => 10, 'offset' => 20, 'order' => 'name ASC']); ``` **Using `find()` method with pagination, sorting, and filtering** The `find()` method can be used with pagination, sorting, and filtering by chaining the `limit`, `offset`, `orderBy`, and `where` methods. ```php // Get 10 records starting from the 20th record, sorted by name in ascending order, and filtered by age > 18 $models = MyModel::find()->limit(10)->offset(20)->orderBy('name ASC')->where('age > 18')->all(); ``` **Conclusion** In this topic, we have covered how to handle pagination and sorting in Yii applications using Active Record. We have seen how to use the `limit`, `offset`, and `orderBy` methods to achieve pagination and sorting. We have also seen how to use the `find()` and `findAll()` methods with pagination and sorting. By following these examples, you should be able to implement pagination and sorting in your Yii applications. **Practice Exercise** Try implementing pagination and sorting in your own Yii application using the methods and examples provided in this topic. **Additional Resources** For more information on pagination and sorting in Yii, please refer to the official Yii documentation: * [Pagination](https://www.yiiframework.com/doc/guide/2.0/en/db-active-record-pagination) * [Sorting](https://www.yiiframework.com/doc/guide/2.0/en/db-active-record-sorting) If you have any questions or need further assistance, please leave a comment below.