Database Information Manager script i wrote
| From: | scott [gts] | Date: | Tue, 22 May 2001 20:45:07 +0000 |
| Subject: | Database Information Manager script i wrote | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-53925@lists.php.net to get a copy of this message | ||
I've been working on this thing for the past few days
and thought i'd share it all with you.
i've posted a demo up: you cannot delete rows,
but you can add and edit them
http://furt.com/php/dbedit/
to get the code: http://furt.com/php/dbedit_b1.zip
(please read specs.php for lots of information on how
the thing is layed out and how it all fits together)
------
The key thing that separates my script from the other
database manager scripts is that mine supports a sort
of "foreign key" referencing between tables.
for example:
if you have two tables, main_table and tid_table
assume main_table looks like this:
id tid description
-- --- -----------------
1 2,3 "This is something"
and tid_table looks like this:
id Foo
-- ---
1 "Bar"
2 "Baz"
3 "Bone"
after putting a few options into the specs file,
when you view the main_table, in place of the tid "2,3"
the script will look up the "real" value of "2,3" and
replace it with "Baz, Bone".
Basically, i needed something like this becuase the
company i work for wants to store porfolio information
in a large database... a single entry can have multiple
authours, multiple clients, etc. etc... and so i
figured instead of having to keep typing in "Scott"
for all the things that i authour, why not have the
script put a drop-down combo box with a list of all
authours, when i add a record to main_table??
enough of me babbling.