You can also create views are based on PHP code. For instance, you can display a list of files from the file system. Handy, if you need to implement a file manager for instance. PHPRunner will build the sample code for you and you can extend it any way you need it.
To create a Code View create a SQL View first and then click Switch to PHP mode button. You can switch back to SQL mode if you need to.
Here is an example of just supplying some data as an array:
You will also need to define two fields, id (integer) and name (varchar). This is it, you can build your app and all functions like search, filters, pagination will work out of the box. If you ever needed to build pages that are not tied to any database table - your prayers were answered. You can use Code Views, for instance, to build a feedback form where data entered by the user is sent to your email.