Viewing Database Tables You may view the record data contained within a particular table by clicking on the “View / Edit Records” link next to its name.
Download Select this link to download the database table as a CSV file.
Import You may view the record data contained within a particular table by clicking on the “View / Edit Records” link next to its name.
Empty This link will empty the database table of all record data contained within a particular table by clicking on the “Empty” link next to its name.
Modify This link allows modification of the database table. Use this feature to add additional fields to the table by clicking on the “Modify” link.
Find Record Enter terms to be searched in the provided field. Click the "within field" link to select specific fields to search for the entered terms. This allows the search to be drilled down to a specific area of the database table.
Add New Record This feature allows for new records to be added to the database table one at a time. Simply click the Add New Record button and the table fields will be presented for submission of information. It is not necessary to insert a Prikey as that will be assigned automatically upon saving the new record. Save when finished.
Show Collapsed Options Clicking this will show extra options such as hiding fields and collapsing data columns.
Run Custom Query If you are familiar with MySQL databases, you can pull up a custom query.
Format Timestamps This feature allows the timestamps to be formatted as human date strings. Select timestamp field(s) to format as dates. Note that this will not actually alter the data. This allows timestamp values to display as meaningful date/time strings which are more easily read.
Format Serialized Data This feature allows php programmers/developers to format serialized array data for display. - Select field(s) containing serialized array data. Note that this will not actually alter the data. It's just meant to display serialized array data in a more concised, readable format.
Decode Data This feature allows php programmers/developers to decode encoded data for display. - Select field(s) containing encoded data. Note that this will not actually alter the data. It's just meant to display the encoded data in a readable format.
- Note: Some field may store encoded data. This tool decodes those fields.
|