Hello PHP dudes!
I have an interesting question. I have a database table with about 40 columns and 50 rows of data. It's mostly 'text' and 'bool' fields.
I want to build a page where a non-technical webuser can query the database with a relatively simple form based/GUI interface written in HTML and PHP. They can specify hopefully specify a text string they would want to search for, or a yes/no radiobox for the bool fields. Also would be the ability to select which columns they would want displayed in the results. It is not necessary to do a search for multiple strings in multiple columns, just one string in all the columns.
Think of my goal as a version of PHPMyAdmin 'search page' (click the search tab when viewing a table for a table), but SIMPLER - so easy that with a little skill your mom might be able to use it.
Most MySQL query builders I see such as PHPMyAdmin or Navicat are powerful and developer oriented, but not end-user oriented.
Any ideas!!? Know any libraries, scripts, programs or examples for use out there? 😃
THANKS! 🙂
