{"version":"1.0","type":"rich","title":"Gist 3898724","description":"This example demonstrates how to filter database entries by category using the Yii framework’s CDbCriteria API. It shows a query that selects entry names, addresses, and slugs alongside category names and slugs, joining the categories_entries and categories tables to match entries to their categories. The code compares the category name against a GET parameter, performing a case-insensitive match with downcase() or a partial name match via compare(). The visualization would display the resulting filtered dataset, though no rendering library is used in this PHP snippet.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-3898724?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}