Overview
DbFacePHP integrate a productive database tables navigation and pagination tool, that help you talking with your MySQL database tables on the fly.
Expand the database menu, all tables will be shown on the left menu. Plus, table rows shown after the table name(You can turn off the feature for performance reason, See configurations documents). Click eash table name, will open the table navigation tool.
Datatable navigation
When table opened, you can navigate all records by clicking the page number. If total page exceeds 15, a combo box will be shown to help you select page number quickly.
Data Filtering
DbFacePHP contains a powerful filtering setting tool. Click the “Filter” button on the top-right of the table, the inner dialog will be show like below:
- Apply: apply current filter settings
- Close: close the filter dialog
- Bookmarks: select saved filter settings
- Clear all filters: Reset current filter settings
: add new filter condition
: delete selected filter condition
: popup a dialog that show all records of the conditional column
DbFacePHP support 13 kinds conditions. If you select “include”, “not include”, “contains”, “not contains”, “between”, “not between”, all filter data should be sperated by “,”, You can use the “pick data” button to help you obtain data from database.
Single data editing
Double click the record, single data editing will be activated. DbFacePHP activate corresponding editbox(Single Line TextField, Multi Line TextField, Number TextField, Calendar Box) on the basis of column types.
Row editing
Click the change button of each row, a row editing dialog will be shown like below:
Click the “Change” button of the popup dialog, the selected columns’ changes will be applied.
Row Inserting
Click the “New Record” button, on the page banner, Row Inserting dialog will be shown, you can input datas of inserting row, and click the “Insert” button to add new record.
Colum ordering
You can click the column header to sort the recordset.
Exporting
DbFacePHP supports XML, EXCEL, CSV, HTML exporting. Please note, All filters will be applied to the exporting data.