Any dynamic database frontend tool from which you can update directly?

Answer 1

I dont know the nature of the app nor do i know of any JS libraries with this type of functionality. I think i would look at PHP libraries/components as opposed to JS. For example Symfony could lend you this functionality through the use of its admin generator features. While converting something youre well along on to Symfony for the sake of admin generation probably isnt the best idea, i think youre bound to find alo tmore resources on the server side than the client side. :-)

Answer 2

"...from any query's resultset..." I suspect there is no tool that can do that. Imagine a resultset of data from a table with one (or more) columns which has a foreign key to another table(s). A tool would need to find the relationship between the tables, update the "lookup table", and then update the dependent table. Now imagine a more complicated resultset from a variety of tables - maybe some of those tables are views. Tall order...

I use phpMyAdmin to update tables in my schema, but I perform these updates as an admin rather than a user.