linking to mysql database

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

I have created a simple database using MySQL in linux and wanted to know if i can use CGI scripts to access it from my web page and what commands i should use to do so, or if i need to look at DBI or PHP (of which i have no experience). Thanks.

Comment on linking to mysql database

Replies are listed 'Best First'.
Re: linking to mysql database by DamnDirtyApe (Curate) on Jul 17, 2002 at 15:21 UTC
The way to do this is to use the DBI module in Perl. Take a look at the tutorial, "Reading from a database," here in the monastery. _______________ D a m n D i r t y A p e Home Node \| Email	[reply]
Re: linking to mysql database by broquaint (Abbot) on Jul 17, 2002 at 15:20 UTC
If you're going to access MySQL from within perl you'll need either `DBD::MySQL` or `Net::MySQL`. While the former has a lot of support and a mature codebase the latter doesn't require `DBI` or `XS`. HTH `_________ broquaint`	[reply]
Re: linking to mysql database by fuzzyping (Chaplain) on Jul 17, 2002 at 17:09 UTC
There are numerous excellent resources for this type of instruction. Beyond what's already available on PerlMonks, I can highly suggest the following books: Programming the Perl DBI, O'Reilly CGI Programming with Perl, O'Reilly Writing CGI Applications with Perl", Addison Wesley (an absolutely incredible book!!!) In addition, a few googled links... http://www.danchan.com/feature/2000/10/16/mysql/mysql3.htm http://dbi.perl.org/doc/index.html http://www.mysql.com/doc/P/e/Perl_DBI_Class.html Hope this helps! -fp	[reply]