- Demonstrates Web application development by presenting ten real, ready-to-use examples
- Samples start with a simple guess book and end with a fully-functional e-commerce site with a shopping cart
- New features include both MySQL 4.1 and PHP 4.2
- Latest edition contains new applications including log analysis and project tracking
- CD-ROM includes all the code and examples applications from the book in addition to MySQL, PHP, Apache, PHP classes, libraries, utilities, and other tools
Part I: Working with MySQL.
Chapter 1 Database Design with MySQL.
Chapter 2 The Structured Query Language for Creating and Altering Tables.
Chapter 3 The Structured Query Language for Inserting, Editing, and Selecting Data.
Part II: Working with PHP.
Chapter 4 Getting Started with PHP—Variables.
Chapter 5 Control Structures.
Chapter 6 PHP’s Built-in Functions.
Chapter 7 Writing Organized and Readable Code.
Part III: Simple Applications.
Chapter 8 Guestbook 2003, the (Semi-)Bulletproof Guestbook.
Chapter 9 Survey.
Part IV: Not So Simple Applications.
Chapter 10 Threaded Discussion.
Chapter 11 Content-Management System.
Chapter 12 Catalog.
Chapter 13 Problem-Tracking System.
Chapter 14 Shopping Cart.
Chapter 15 XML Parsing.
Chapter 16 SOAP.
Chapter 17 Project Management.
Part V: Appendixes.
Appendix A: What’s on the CD-ROM.
Appendix B: HTML Forms.
Appendix C: Brief Guide to MySQL/PHP Installation and Configuration.
Appendix D: MySQL Utilities.
Appendix E: MySQL User Administration.
Appendix F: PHP Function Reference.
Appendix G: Regular Expressions Overview.
Appendix H: Helpful User-Defined Functions.
Appendix I: PHP and MySQL Resources.
Appendix J: MySQL Function Reference.
End-User License Agreement.
|CD||Installing MYSQL PHP DATABASE APPLICATIONS databases from the CD|
Q: I am trying to install the MYSQL PHP DATABASE APPLICATIONS databases from the CD. The book instructs me to copy the 'book' folder into the Domain Root folder (Htdocs is specified). I installed MySQL, Apache and PHP using PHPDEV423 (http://www.firepages.com.au). When I copy the folder across it shows up in root and I can click through until I reach the database installation page. Whether I select 'install all' or an individual database, and click 'submit,' I get the following error message:- Forbidden. You don't have permission to access /book/install/method="get" on this server Apache/1.3.27 Server at localhost Port 80 The URL is: http://localhost/book/install/method="get"? install_all=yes&submit=Submit A: The problem is how $REQUEST_URI comes out on Windows. You need to edit the file 'index.php' in the directory 'install' and change
|CD||Installing PHP 5 bundled with the book|
Q: I am having a problem installing the software-php 5 bundled with the book. I am running Windows 2000, PHP v4.3.3 + php 5, mysql v4.0.15, apache v1.3.28 with mod_ssl. After installing apache, mysql and php, I chose the command window and typed in php -n index.php to load the files into the database. It requires the mysql root password. When I installed mysql, no password was needed for root. There was an indication that the file: install.class.php in /book/re-installer/class is not working. Even after inputting the root password the same error still comes up: ERROR: array ( 'error' => 2, 'msg' => 'call_user_func_array(): First argumented is expected to be a valid callback, \'mysql_connect\' was given', 'file' => 'F:\Program Files\Apache Group\Apache\htdocs\book\re-installer\classes\install.class.php', 'line' => 459, ) I cannot connect as 'root' - Error: "aborting..." A: The error indicates that you do not have the mysql extension enabled - php is not recognizing the function name 'mysql_connect' as a valid function, and that's all that could mean. You need to get a new version of PHP as the README file suggests. There have been *two* PHP 5 beta releases since the CD was burned. Also, use not-pre-bundled installations of PHP/MySQL/Apache on Windows, because you have to put files in the right places. The details on this issue are in the README files.
View the Companion Site.