|
Choosing
datasource tables and views to build PHP code
After you successfully connected to database, check off 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 button on the left.
 
If you'd like to keep default settings for the rest of tables jump to Output
directory tab and build PHP code.
Using Add new table window
you can add a 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.
 NOTE:
Don't change table settings after you've built the project and added
data records. All data will be lost after table modification.
To edit or delete tables right click on 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.
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.
 |
