Installing the Winestore Examples
by David Lane, Hugh E. Williams
Web Database Applications with PHP, and MySQL
- Web Database Applications with PHP & MySQL
- Preface
- 1. Database Applications and the Web
- 2. PHP
- Introducing PHP
- Conditions and Branches
- Loops
- A Working Example
- Arrays
- Strings
- Regular Expressions
- Date and Time Functions
- Integer and Float Functions
- User-Defined Functions
- Objects
- Common Mistakes
- 3. MySQL and SQL
- 4. Querying Web Databases
- 5. User-Driven Querying
- 6. Writing to Web Databases
- 7. Validation on the Server and Client
- 8. Sessions
- 9. Authentication and Security
- 10. Winestore Customer Management
- 11. The Winestore Shopping Cart
- 12. Ordering and Shipping at the Winestore
- 13. Related Topics
- A. Installation Guide
- B. Internet and Web Protocols
- C. Modeling and Designing Relational Databases
- D. Managing Sessions in the Database Tier
- E. Resources
- Index
- Colophon
The winestore example PHP scripts are available from the author’s web site, http://www.webdatabasebook.com. To install the example scripts that are presented in Chapter 4 to Chapter 10, perform the following steps.
Download the file http://www.webdatabasebook.com/wda.tar.gz into the
/tmpdirectoryLog in as the
rootuser, make a directory for the file below the document root of the Apache installation, and copy the file to that location:% mkdir /usr/local/apache/htdocs/wda % cp /tmp/wda.tar.gz /usr/local/apache/htdocs/wda
Change directory to the new location and install the files:
% cd /usr/local/apache/htdocs/wda % gzip -d wda.tar.gz % tar xvf wda.tar
Edit the file
db.incand modify the first two lines so that the password and username match those selected in the previous section Section A.1.2. Save the file and exit the editor.Load the book homepage by requesting the URL: http://localhost/wda/.
Many of the examples run only if the winestore database has been loaded into the MySQL DBMS by following the instructions in Section 3.2 in Chapter 3.
-
No Comment