Choosing datasource tables and views to build PHP code

After you successfully connected to database, select all datasource tables you'd like to build PHP code for. After that highlight one of selected tables and step through other screens in PHPRunner adjusting settings for selected table. You can always see name of currently selected table in the middle of blue info pane.

To switch between selected tables use Table list pane on the left. Click Add Table to add new table to existing database.

For each field type name, type, size, scale (applies to DECIMAL datatype in SQL Server, Oracle and MySQL only). Set the Primary key field.

To edit or delete tables right-click the table name in the list.

Add table view

This feature creates an additional view of the same table. This feature is useful when you like to present several views of the same data. When you create new custom view, all current settings of the table, on the basis of which view is created, are copied into it except for visual templates and events. Note that you can create a copy of existing custom view (right-click the custom view and select Copy).

Example:

Table Cars shows all cars in the database. SQL query: Select * from Cars.

View Active listings displays active listings only. SQL Query: Select * from Cars where status='active'

View Closed listings displays closed listings only. SQL Query: Select * from Cars where status='closed'

SQL query can be modified later on SQL query tab in PHPRunner.

Note: when you create a custom view all table settings are copied to Custom view settings.

Every time you make changes to the database in PHPRunner (e.g. you create new table or view, you add or edit table fields etc.), these changes should be implemented in the database. In other words, the structures of the database and PHPRunner project should be synchronized.

To synchronize database manually, right-click tables tree or blank area near tables tree and select Sync database.

Also you can use the option to synchronize the database automatically on each project load (select Project -> Settings). Use this option for small or local databases. In the case of remote or large databases the automatic synchronization will take  some time when opening the project.