Skip to main content

MySQL / PHP Database Applications, 2nd Edition

MySQL / PHP Database Applications, 2nd Edition

Brad Bulger, Jay Greenspan, David Wall

ISBN: 978-0-764-54963-2

Oct 2003

816 pages

Select type: Paperback

Product not available for purchase

Description

  • 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
Preface.

Acknowledgments.

Introduction.

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.

Index.

End-User License Agreement.

ChapterPageDetailsDatePrint Run
CDInstalling 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

method="get">

to


12/1/03

CDInstalling 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.
12/1/03

Companion Site

View the Companion Site.