Need to display SQL query in GridView?

Question

Yii

Hello. It is necessary to display data in the GridView format based on an SQL query, since it is necessary that when the database is changed, changes also occur in the table on the site. Tell me how to do it

Answer 1

you can also wrap the GridView in pjax

Answer 2

It is necessary to display data in GridView format based on SQL query

that's how it usually is
this is how it usually is.
Perhaps you need to refresh the page with gridView from time to time - but this is no longer about yii and mysql at all. It's just js.