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 pane on the left.
Using Create 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.
Synchronize database
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, right-click tables tree or blank area
near tables tree and select Sync
database.
Note: As from PHPRunner 5.1 database
synchronization should be implemented manually. In PHPRunner 5.0
and earlier database synchronization was implemented
automatically.
|
