Database

Version 3.26.0


Tables

psa_demo
psa_users


Please refer to this blog post for updated information.

Framework/Libraries used:

Functionalities:

Version 1.1 supports the adding, updating and deleting of table data as well as the creating and dropping of tables. Only adding of column is allowed for altering table schema. What table is displayed for use depends on which user is logged in.

Usage:

Logging into demo table,

  1. Click ‘Login’ link.
  2. Enter username/password as demo/demo.
  3. psa_demo table will be displayed.
  4. Click on ‘Add’ button to add a new row.
  5. Double-click on a field to edit.
  6. Select a row and click ‘Delete’ button to remove the row.

Logging in as administrator,

  1. Click ‘Login’ link.
  2. Enter username/password as admin/admin. (This account is disabled in my online version. Fork the enabled version here.)
  3. Admin panel will be displayed.
  4. Click on table name in admin panel to edit/drop table.
  5. Click on add_new_table in admin panel to create a table.
  6. Click on psa_users in tables panel to add/remove a user or edit username, password and the table a user can access.