|
|
This chapter was provided to introduce you to the MySQL relational database and how to issue SQL statements at the mysql client. After you learned the basic queries at the command line, the Perl DBI module was introduced so that you could perform the same mysql functions from your Perl scripts. We discussed the most commonly used DBI methods and how to use them for connecting to a database, selecting and retrieving data, updating and removing records, etc. Finally, we went to the next step and created a CGI/Perl program and used the DBI module to produce a dynamic Web page to interact with a user request from a fill-out form and respond with data retrieved from a database.
Although we have covered the DBI essentials, there is more to be learned. To find detailed documentaion of DBI, including methods, variables, constants, functions, etc., the best resource is found at the CPAN repository shown in Figure 17.24, written by Tim Bunce.
|
|