CGI with SQL?

[duniyadnd]

Is it possible to make CGI Scripts interactive with SQL tables (at least adding/editing information and checking tables)? If anyone knows of any sites that deals with this, could they post it up? Appreciate it.

Thanks
Duniyadnd

[Mouldy_Goat]

Yes, this is a very big thing. There are some really top notch modules devoted to this. Take a look at some of these pages:

This is the actual DBI.pm module documentation, so very useful..
http://search.cpan.org/author/TIMB/DBI-1.30/DBI.pm

http://www.extropia.com/tutorials/sql/dbi.html
http://redes.ucpel.tche.br/extropia/temp/tutorials/sql/dbi_api.html

It's quite easy to use once you get the hang of it, and your code will be more portable than a very portable thing.

[Mouldy_Goat]

It's been used for quite major stuff in case your interested, like this (http://perl.oreilly.com/news/ixl_0800.html) perl success story.

[premshree]

I have used the ODBC.pm module for connecting to MS Access from Perl.

See this URL : http://www.roth.net/perl/odbc/docs/