Quick way to set up a web frontend to a MySQL database?

Sylvar has asked for the wisdom of the Perl Monks concerning the following question:

I've been asked to get an Access database onto the web so that it can be searched. I already have a MySQL database and I know how to get the data onto it.

I know I can use DBI and LWP to roll my own web frontend, but surely I'm not the first to do so. I'd welcome suggestions on a recipe that could be given, say, (dbi:mysql:dbname, user, pass) and just brutally gang-search all the columns for a given term, then display (in some sort of HTML table) the records that match.

Heck, I've done it in PHP, I could always tweak it for this project, but it occurs to me there's probably a reasonably easy way to do it in Perl.

Comment on Quick way to set up a web frontend to a MySQL database?

Replies are listed 'Best First'.
Re: Quick way to set up a web frontend to a MySQL database? by olly (Scribe) on May 16, 2001 at 22:03 UTC
Try perldoc dbi and perldoc dbd::you_dbd they almost have the sample you are asking about in them Imagination is more important then knowledge -Einstein-	[reply]
Re: Quick way to set up a web frontend to a MySQL database? by rob_au (Abbot) on May 17, 2001 at 02:25 UTC
Depending on your resources and the need for expediency with your current project, you may want to also look at the O'Reilly "Programming the Perl DBI" book - http://www.oreilly.com/catalog/perldbi/ - The sample chapter at http://www.oreilly.com/catalog/perldbi/chapter/ch04.html would be worth your review as well. There is also an O'Reilly book specifically on MySQL (and MSQL) but I don't know how good it may or may not be. And of course, as always, review other people's code - There are heaps of examples on Perl DBI stuff around and you'll pick up a lot by looking at some of these examples.	[reply]
Re: Quick way to set up a web frontend to a MySQL database? by jepri (Parson) on May 17, 2001 at 10:27 UTC
You may find this module useful for creating HTML frontends to databases. I haven't used it yet though. ____________________ Jeremy I didn't believe in evil until I dated it.	[reply]
Re: Quick way to set up a web frontend to a MySQL database? by asiufy (Monk) on May 17, 2001 at 05:57 UTC
Do you really want to code your own front end? You mentioned PHP... Well, I have been using phpMyAdmin for a while now, and it's pretty good... Zero effort to get up and running... Now, that being said, I am looking for the Perl alternatives (for the boxes without PHP).	[reply]