Also for the company’s website, the demand was to have a simple list of bugs, with a search and filter option. I’ve tried some things with Excel as an export in HTML, but the bad point was, that it’s not possible to edit it online. That’s why I started to search in the World Wide Web.
The perfect solution for me, is the tool phpMyEdit, a MySQL table and PHP. First, it’s not easy to do it. First create a new table in your MySQL database. Create therein the fields you need for your table. Because you wouldn’t like to edit it with SQL commands, use the great app http://www.phpmyedit.org/.
phpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. All you need to do is to write a simple calling program (a utility to do this is included). It includes a huge set of table manipulation functions (record addition, change, view, copy, and removal), table sorting, filtering, table lookups, and more.
In my case, I’ve created a php file with just read permission for the normal users and a php file with admin permission for me. Absolutely cool!