PHP - Where can I find a simple database tool that is easy for non-technical users to use?

Question

I'm looking for a simple database admin tool that will allow non-technical users to perform data-entry into a database (imagine a striped down version of phpMyAdmin). It would preferably allow the developer to set restrictions on which tables and fields can be modified.

Edit: Most of the tools posted, so far, are developer oriented. I'm looking for something that provides bare-bone functionality but is highly refined (clean interface, organized layout, etc.).

Edit2: Found this linked in the phpmyadmin alternatives thread.

http://www.sqlbuddy.com

Answer 1

HeidiSQL

http://www.heidisql.com/

Answer 2

Check out http://stackoverflow.com/questions/449570/webbased-mysql-interface-better-that-phpmyadmin for a list of clients that might suit you.

In particular, I've worked with SQLYog before and found it to be a decent tool. Unfortunately, you're going to hit a limit with how "easy" these things are for non-technical users. Short of building an interface yourself, much of what you'll find out there is geared toward developers.

Answer 3

Try Navicat

Navicat

We use this at work even tho we know how to code it manually.

I can give you a form for all of the data columns or you can view a whole table at once.

You can build queries using query the builder too.

Answer 4

In 15 minutes you can have a CakePHP site scaffolded, baked, and customized for a very clean, simple, web interface. It's not the right tool for every job, but when you need customizability, you might just need to roll your own solution.