Yet another web interface class

If you need a php class to quickly create a web interface for your database, this is it.

TODO

TODO, not in order of importance
Some are just ideas, that might never be implemented

  • configfile checker
  • better message when lookup tabel not added with add_table
  • default function to determine van label text (DragonId -> Id)
  • default function to determine “foreign keys” that are based on a convention
  • better error in case of foreign key violation i.e. because of delete
  • localization
  • field desciption to help with what should be filled in in a form
  • lookup of foreign keys fails on empty lookup table
  • update lookup value selection list when lookup table has changed
  • table sorting, select ascending/descending
  • links to other tables/pages
  • multiple databases
  • option for persistent database connections
  • testing in Windows & on different browsers
  • lookup fields using left join if possible
  • search
  • other means of getting config data, i.e. database (with yawic front-end)
  • save config data in shared memory
  • config: restrictions on field
  • config: change data before showing the field
  • //TODO set tablename to default [lookup_tablename]
  • //parse sql
  • //TODO add some form of escape or check ( escape($sql) wont do – escapes to much ie concat(‘a’,'b’) )
  • global config: always show id fields as labels / hide config