Log in as the root user.

If you're not already, connect to the Internet.

Type the following to install the optional package:

% pear install HTML_Template_IT

Type the following to check if upgrades of the core packages used in this book are available:

% pear upgrade PEAR

% pear upgrade Date

% pear upgrade DB

% pear upgrade Mail

Using a browser, download the file http://www.webdatabasebook.com/examples.zip into the /tmp directory.

To start, you need to configure your Apache web server so that it won't show users the content of the .inc include files if they're retrieved with a web browser. There are several ways to do this, but the simplest is to edit your httpd.conf configuration file. You'll find the file in /usr/local/apache2/conf/. To edit the file, you'll need to login as the root user.

Now, open the httpd.conf file in an editor, and add this to the end of the file:

<Files ~ "\.inc$">

    Order allow,deny

    Deny from all

    Satisfy All

</Files>

Save the file and exit the editor. You now need to restart your Apache server. You can do this by typing:

% /usr/local/apache2/bin/apachectl restart

Now, create a directory in your Apache document root to store the examples, and copy the downloaded file to that location:

% mkdir /usr/local/apache2/htdocs/wda

% cp /tmp/examples.zip /usr/local/apache2/htdocs/wda

Unzip the wda.zip examples in their new directory by doing this:

% cd /usr/local/apache2/htdocs/wda

% unzip examples.zip

Edit the file db.inc in the wda directory and modify the lines beginning with $username and $password so that fred and shhh are replaced with the username and password you chose for your user when installing MySQL:

<?php

   $hostName = "127.0.0.1";

   $databaseName = "winestore";

   $username = "fred";

   $password = "shhh";

Save the file and exit the editor.

You may also need to set the file permissions so that examples are accessible through your web browser. To do this, use:

% chmod a+rx /usr/local/apache/htdocs/wda

% chmod a+r /usr/local/apache/htdocs/wda/*

You should now be able to load the example list by requesting the following URL with a web browser running on the same machine as the web server: http://127.0.0.1/wda/. Test the examples from Chapter 2 through Chapter 4—they should work.

You'll find that some of the examples from Chapter 6 onward run only if the winestore database has been loaded into the MySQL DBMS by following the instructions in the next section. In addition, most examples from Chapter 7 onward work only if you've installed the PEAR package HTML_Template_IT.

Visit the web site http://ros.co.nz/pdf/.

From the Downloads section, choose the link to the Zip file that contains the class, sample, and the required font metric files. Save the file in /tmp.

Change directory to the temporary directory and unzip the download file. into an install directory.

If you're only planning to use the library with our examples, first install the code examples as described in the previous section, and then use:

% unzip pdfClassesAndFonts_009e.zip -d /usr/local/apache2/htdocs/wda

This installs the class files and fonts in the examples directory.

An alternative approach is to install the files into a shared file location such as /usr/local/src/pdf-php. Then, edit your php.ini file and include the directory at the end of the include_path directive. This allows you to include the path in a PHP script using only the class name and without specifying the directory.

Using a web browser, download the file http://www.webdatabasebook.com/database.zip into the /tmp directory.

Uncompress the winestore database in any directory by typing the following in a shell window:

% unzip database.zip

Run the MySQL command-line interpreter using the root username and the password you set, and load the winestore database:

% /usr/local/mysql/bin/mysql -uroot -p

password

 < /tmp/winestore.data

Be patient, this may take a while. Exit the command interpreter by typing quit.

After the loading is complete (it may take a while) the database can be tested by running a query. To do this, use the username and password you created when installing and configuring MySQL:

% /usr/local/mysql/bin/mysql -uusername -ppassword

Now type:

mysql> SELECT * FROM region;

This should produce the following list of wine regions as output:

+-----------+---------------------+

| region_id | region_name         |

+-----------+---------------------+

|         1 | All                 |

|         2 | Goulburn Valley     |

|         3 | Rutherglen          |

|         4 | Coonawarra          |

|         5 | Upper Hunter Valley |

|         6 | Lower Hunter Valley |

|         7 | Barossa Valley      |

|         8 | Riverland           |

|         9 | Margaret River      |

|        10 | Swan Valley         |

+-----------+---------------------+

Using a browser, download the file http://www.webdatabasebook.com/wda2-winestore.zip into the /tmp directory.

If you haven't configured your Apache web server so that it won't show users the content of the .inc include files, follow Step 2 in Section A.6.2.

Log in as the root user and move the application into your Apache document root:

% cp /tmp/wda2-winestore.zip /usr/local/apache2/htdocs/

Unzip the wda2-winestore.zip code in the document root directory. This will create the subdirectory wda2-winestore:

% cd /usr/local/apache2/htdocs/

% unzip wda2-winestore.zip

Edit the file wda2-winestore/includes/db.inc and modify the lines beginning with $username and $password so that fred and shhh are replaced with the username and password you selected when configuring MySQL:

<?php

   $hostname = "127.0.0.1";

   $databasename = "winestore";

   $username = "fred";

   $password = "shhh";

Save the file and exit the editor.

You may also need to set the file permissions so that examples are accessible through your web browser. To do this, use:

% chmod a+rx /usr/local/apache2/htdocs/wda2-winestore

% chmod a+r /usr/local/apache2/htdocs/wda2-winestore/*

You should now be able to load the application index by requesting the following URL with a web browser running on the same machine as the web server: http://127.0.0.1/wda2-winestore/. Click on the Use the Application link and you should be able to use the application.