CGI Programming 101: Chapter 18: Database Programming

Name	Description
dbicat.txt	Kite Catalog using DBI (source code)
dbicat.cgi	Kite Catalog using DBI (example)
count.txt	SQL Page Counter using DBI (source code) Example: You are visitor number 96854.

Errata

  while (($stocknum,$name,$price) = $sth->fetchrow) {
      print "<input type=\"text\" name=\"$stocknum\" size=5> $name - \$price<p>\n";
  }
  

Additional Resources

MySQL, by Paul DuBois and Michael Widenius.

An in-depth look at MySQL, from syntax, table creation, database design and administration, to using the Perl DBI module and PHP. This book is the perfect companion to CGI Programming 101.


• A Short Guide to DBI, by Mark-Jason Dominus

• MySQL, related software and documentation is available at http://www.mysql.com/.

• The MySQL manual is available at http://www.mysql.com/Manual_chapter/manual_toc.html

• The DBI Module (external docu), and the DBI perldoc.

• Intro to DBI

• SQL Tutorial

• SQL Reference Page