Generated Application Features in:
PHP/MySQL Web Database Application Code Generator Version 10

The first page of the web application you will encounter is the login page. Attempting to go directly to another page of the application without logging in first will redirect the user back to the login page.

Once successfully logged in, you will see the main homepage.

The topbar shows the title of the application, the Ajax activity indicator, a “bread crumb” trail showing the current page, and the menu which takes you to the tables in your application.

After selecting one of the tables, you will be presented with the top control bar.

It contains a button to create a new record, and a filter selection box with a list of fields that the current table can be filtered by.

Selecting a filter will prompt you for the operator (e.g. Equals, Not Equals, Sounds Like, etc) and the value.

The editor used for the filter value will be the same as the one chosen for the data entry forms.

The user can select as few or as many filters as they require. For example, if you wanted to see items with a price between $10 and $15 you would select the price field twice and enter the appropriate criteria.

Filters can be removed by clicking the button. After selecting the criteria click the button.

The columns can be sorted by clicking on them. First click means ascending, next click means descending, next click means unsorted. Multiple columns can be selected, simply select them in the order you wish the data to be grouped by.

A default sort order for a table can be selected before you generate the application. To do so, click on the relevant table in the treeview, go to properties and select "Default Sort Order".

At the bottom of each page is a page navigator allowing the user to tab through pages of results.

To delete a record, click on the checkbox(es) of the records you wish to delete,

To select all records on the page, click the checkbox at the top of the grid.

and click the button on the page navigator at the bottom of the screen.

Records with a padlock cannot be deleted as they are the detail records in a master-detail relationship. To delete them you would need to go to the master table, filter the records on the field linked to this table, delete them and then delete the records in the detail table.

To view a record in more detail simply click on the row. To edit the record double-click on it instead.