# [web] Database-Editor in PHP?

This topic is 3589 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

## Recommended Posts

Hi, On a large PHP legacy-system I'm working on, we're using a very nice system that has been coded to be a general and user-friendly database editing tool, and I'm looking for a similar, but a little more clean tool. Let me explain. In our database, we have two tables: (Both tables have loads of more fields, but this gives the essence of their functionality) admin_tables: - id - table - name - sortby - whereclause - parent_id admin_tablefields: - id - table_id - field - name - input_type - default_value - ranking So, when I want to give users easily edit a table, I can simply create a couple of rows in this database, and a fully functional editor will be done like this:
<?
include("layout/layout.php");
top();

\$table_id = 2;

bottom();
?>


Needless to say, this lifts alot of burdens of my whole team, since they most of the time can simple code front-ends for the systems on our external web, and make these kind of editors as the internal tools. At the moment we're looking to migrate the whole system to a new server, and this means that we have to deal with 8 years of hardcoding paths e.g.. Converting the DBAdmin system will no doubt be a big burden, since it has been expanding on the server setup for a few years. So I'm on the hunt for a system that can do essentially the same thing, maybe without the need to have a database-backend. I've been searching around and have found lots of PHP classes that can abstract me away from the SQL queries, but they all still need me to write a form that POSTs and fill in the data into the class, before it can do any work for me. Any suggestions?

##### Share on other sites
phpMyAdmin? Or do I understand you wrong?

##### Share on other sites
A little :-)

I'm looking for some kind of class or the likes, that I can use to simply allow users to edit tables in a database. I wouldn't give my users access to phpMyAdmin, if my life depended on it...

Further searching after posting dug up the term "MySQL Table Editors" and I found a good solutions for what I want to do: http://www.phpguru.org/static/TableEditor.html

Here is also a comparasion of different systems that does the thing I want: http://www.phpguru.org/static/TableEditorComparison.html

I'm not entirely happy with the thing I got now, so suggestions are still much appreciated...

Regard,
Kasper

##### Share on other sites
Quote:
 Original post by CowardI'm looking for some kind of class or the likes, that I can use to simply allow users to edit tables in a database. I wouldn't give my users access to phpMyAdmin, if my life depended on it...
Why not? I still don't see what you need to do that phpMyAdmin wouldn't support, including of course restricting what your users can do to merely editing a table in the database without touching anything else!

##### Share on other sites
User-friendliness.

phpMyAdmin supports every operation I'd ever want my users to do, and I can restrict their access from droping tables and the likes - but then I'd have to explaint to the users why they'd have to "Just find the ID-number in that column in that table, and put it into that column in that table" - There I'd like some software that helps them a little on their way, instead :-)

1. 1
Rutin
19
2. 2
3. 3
JoeJ
16
4. 4
5. 5

• 27
• 20
• 13
• 13
• 17
• ### Forum Statistics

• Total Topics
631700
• Total Posts
3001791
×