Edit mutliple mysql tables with 1 php page

[alex89]

July 22nd, 2008, 10:31 pm

I would like to have a list of table names (along the left hand side) and when the user clicks on them, the table will show (on the right). I'd like the right hand table to be editable in page (a table of inputboxes with a save submit button), and this to be possible without page refreshes.

Anyone know of any existing functions or scripts that do this? It seems stupid to write from scratch if it exists.
I'm not terribly experienced with javascript, so can anyone point me in the right direction?

[George L.]

July 23rd, 2008, 3:04 am

Hey man, have you tried looking at Joomla?

[alex89]

July 23rd, 2008, 3:46 am

Whoops, I forgot to mention - I've got about 90% of the site complete, all built from scratch Uses php & MySQL.

I'd like a list of the tables in the database & inputboxes along right to modify existing database entries. The tables I want to modify only contain one row of data (a simple list of names).

Apart from a complete rework (into Joomla or similar), are there any simple php scripts/functions?

[spork]

July 23rd, 2008, 7:36 am

Sounds like you're looking for something similar to phpMyAdmin, but with AJAX, yes?

[alex89]

July 23rd, 2008, 9:30 am

Exactly, thanks for putting it so eloquently

[alex89]

July 24th, 2008, 8:39 am

So noone knows of a system?

[George L.]

July 24th, 2008, 9:06 am

Would you like to make it editable for some chosen staff? as well?

[alex89]

July 24th, 2008, 10:03 am

I can do that - I'd just like to know your thoughts on the best way to achieve the following:

Retrieve & edit multiple mysql database tables with php/javascript (without page refresh - if possible).

[George L.]

July 24th, 2008, 10:19 am

ha.. that's the tricky one.

[Bogey]

July 24th, 2008, 12:04 pm

You don't have much to worry about if you know which database to read for the information and how to handle all that.

If you got phpMyAdmin, you can read the information_schema database for specific information about databases and it's tables and apply Javascript to it. I doubt I have the time or ability to do this but if you know Javascript and PHP well enough, you could probably do something with this

[alex89]

July 30th, 2008, 2:59 am

Alright, even with a page refresh - without having to make mutliple php pages for each table - any ideas?

[spork]

July 30th, 2008, 8:02 am

I don't know of any web software that does that, although I can't imagine it would be too difficult to write yourself?

[SpooF]

July 30th, 2008, 8:56 am

alex89 wrote:

Alright, even with a page refresh - without having to make mutliple php pages for each table - any ideas?

I want to try and see if we can get everything clarified here. You want the same abilities as phpMyAdmin? You can write your own version of it if you want. The basic underlying functionality of it uses a mysql keyword DESCRIBE.

http://dev.mysql.com/doc/refman/5.0/en/describe.html

I don't see any reason you would need more than one php file for multiple tables.

[alex89]

July 30th, 2008, 9:02 am

I'll explain a little more.

The page required will edit several mysql tables of data (used in other parts of the site), in a graphical table, which displays data, and if you double click/click the edit button, you can edit the data. You can also add new rows, delete rows & sort.

It just seems like a bit of a pain to recode this, I'm sure it does exist, but I haven't come across it. Anyone seen anything like this, or written it in the past?

[SpooF]

July 30th, 2008, 9:49 am

http://www.phpscaffold.com/

Its more than one page but you could easily combine them all.