The best way to learn is by doing.

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

I have been avoiding databases for a very long time now and I think this year it is time I learn how to write perl progs to interact with db's. I want to learn how write a simple cgi program with a mysql db for back end data. Does any one have any links or google key words for some simple cgi/mysql web app examples. Most my searches pull up php/myslq examples. I hate php by now. Thanks in advanced Parkprimus

Comment on The best way to learn is by doing.

Replies are listed 'Best First'.
Re: The best way to learn is by doing. by jettero (Monsignor) on Jan 02, 2007 at 20:21 UTC
http://www.perl.com/pub/a/1999/10/DBI.html answers that question rather well. If I were you, I'd try the super search here rather than google. Most people here know where all the good articles are located almost off the top of their head. -Paul	[reply]
Re: The best way to learn is by doing. by Arunbear (Prior) on Jan 02, 2007 at 21:27 UTC
Writing CGI Applications with Perl has many examples of CGI, DBI and of how to use them together.	[reply]
Re: The best way to learn is by doing. by GrandFather (Saint) on Jan 02, 2007 at 20:21 UTC
DB != cgi. I suggest the first place to look is in the Tutorials section here at Database Programming. Using DBI in a light weight way is pretty easy and there are plenty of monks who can help with that. In like fashion, cgi is a very frequent topic of discussion here. However, it is probably much easier to approach the two areas one at a time. Combining them later on will be a snap, but learning two quite different and essentially unrelated things at the same time is likely to be a little fraught! DWIM is Perl's answer to Gödel	[reply]
Re: The best way to learn is by doing. by shigetsu (Hermit) on Jan 02, 2007 at 20:27 UTC
Does any one have any links or google key words for some simple cgi/mysql web app examples. The DBI docs on CPAN provide some basic examples: Outline Usage Search on Google: DBI examples	[reply]
Re: The best way to learn is by doing. by GertMT (Hermit) on Jan 02, 2007 at 20:29 UTC
maybe you can have a look at www.hoboes.com/html/NetLife/Swine/ I just have not (yet) been able to get the SQLite linked.	[reply]