PHP, MySQL and the PEAR Database (Page 1 of 4 )
In this conclusion to a three-part series, you will add PEAR into the mix of what you have already learned. This article is excerpted from chapter 9 of
Learning PHP and MySQL, written by Michele Davis and Jon Phillips (O'Reilly, 2006; ISBN: 0596101104). Copyright © 2006 O'Reilly Media, Inc. All rights reserved. Used with permission from the publisher. Available from booksellers or direct from O'Reilly Media.
Hosted ISP
Most ISPs have PEAR DB installed. Ask your ISP to install it if they haven't already. You can tell if PEAR DB has been installed by trying the PHP code in Example 9-7 to see whether the require_once ('DB.php'); line causes an error when the script is executed.
Adding Additional Packages
Once that's complete, you can access the PEAR Package Manger by entering pear at the command prompt. Adding new modules is as easy as executing pear packagename . You won't need to do anything, since the DB package was installed along with the install by default.
However, if you're running Windows XP Home, you'll need to take these steps to install the PEAR DB:
C:\>cd c:\php
C:\>pear install DB
C:\>pear list
To find out what versions of PEAR packages are installed, execute pear list. That returns a listing such as the one shown in Figure 9-6.
Figure 9-6. A listing of installed PEAR packages and versions
Once you've got PEAR installed, you're ready to try it out.
