Hi

I have a MySQL database table containing a set of parameters used by our build deployment system. From time to time it becomes necessary to add, delete or ammend rows in the parameter table

We would like to create a web page to administer this functionality. I could easily create such a webpage based around iteration over DBI query to display parameters etc etc. However I got thinking and figured this must be a fairly common requirement to want to provide this sort of 'front-end' to a table. All of the searches however that I tried against CPAN etc came back with too many results to be useful.

As you have probably guessed my question is, what is the best way to do this given the points below. I can't believe no one has encountered this problem before, I just can't find any evidence!

• There are a number of tables I would like to expose in this way (i.e. ad hoc solution not ideal)
• Ideally the table view would be read only until a given row was selected for editing, i.e. I don't want to just display a massive grid of input boxes
• Slightly further down the line there will be a requirement to bind column values into a combo box. Any module possesing suitable abilities would be preferable should there be a choice
• As always we are very limited in time, so a simple/lightweight framework is preferable to a full scale M-V-C one for simplicity

Thanks in anticipation

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.