448 Part IV . Development (Fedora web server) On the CD-ROM
448 Part IV . Development On the CD-ROM The programs contained in this section are available on the CD-ROM. Present and future expansion The ecommercesite has a start. It s nowhere near ready to go online and take orders. A shopping-cart CGI must be built, as well as more robust inventory capabilities. Using a combination of cookies, knowledge of Perl, and the ideas in this chapter, it shouldn t be too much of a stretch to take the ecommercesite to the next step. Summary The Perl DBI is a generic interface used by many types of RDBMS to enable Perl programs to work with databases. MySQL has a database driver (DBD) to work with the DBI and enable the programmer to write powerful MySQL-enabled Perl programs. . Both the DBI and the DBD for MySQL can be obtained at your nearest CPAN mirror or at http://www.cpan.org. . The DBI takes advantage of handles to enable the developer to communicate with a database server. There are driver handles such as MySQL, database handles for connecting to the database server, and statement handles for working with SQL statements. . The developer using the DBI communicates with the database using an object-oriented approach. Database handles are created manually by the user and can be destroyed by the user or automatically by Perl. . The DBI also includes configurable error checking. By default, error checking is automatic. The programmer can control whether error checking is manual, automatic, or a combination of both even within the same program. . The DBI includes many functions for working with databases, not just MySQL. These include functions to retrieve data such as fetchrow, fetchrow_array, and others. . The DBI enables the Perl programmer to combine the power of Perl with the features of MySQL to make applications that run from the command line or in a CGI for the Web. …
We highly recommend you visit web and email hosting services if you need stable and cheap web hosting platform for your web applications.