beginning_php_and_postgresql_e-commerce.pdf

THE EXPERT’S VOICE ® IN OPEN SOURCE

Beginning

PHP and PostgreSQL

E-Commerce

From Novice to Professional

Learn how to use PHP, PostgreSQL, and sound

development practices to build high quality,

extensible e-commerce web sites in no time!

Cristian Darie, Emilian Balanescu,

and Mihai Bucica

www.it-ebooks.info

Beginning PHP and

PostgreSQL

E-Commerce

From Novice to Professional

Cristian Darie, Emilian Balanescu,

Mihai Bucica

www.it-ebooks.info

Beginning PHP and PostgreSQL E-Commerce: From Novice to Professional

electronic or mechanical, including photocopying, recording, or by any information storage or retrieval

system, without the prior written permission of the copyright owner and the publisher.

ISBN-13 (pbk): 978-1-59059-648-7

ISBN-10 (pbk): 1-59059-648-X

Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1

Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence

of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark

owner, with no intention of infringement of the trademark.

Lead Editor: Jason Gilmore

Technical Reviewer: Greg Sabino Mullane

Editorial Board: Steve Anglin, Ewan Buckingham, Gary Cornell, Jason Gilmore, Jonathan Gennick,

Jonathan Hassell, James Huddleston, Chris Mills, Matthew Moodie, Dominic Shakeshaft, Jim Sumser,

Keir Thomas, Matt Wade

Project Manager: Kylie Johnston

Copy Edit Manager: Nicole Flores

Copy Editor: Julie McNamee

Assistant Production Director: Kari Brooks-Copony

Production Editor: Lori Bring

Compositor: Gina Rexrode

Proofreader: April Eddy

Indexer: John Collin

Artist: April Milne

Cover Designer: Kurt Krames

Manufacturing Director: Tom Debolski

Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor,

New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders-ny@springer-sbm.com , or

visit http://www.springeronline.com .

For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley,

CA 94710. Phone 510-549-5930, fax 510-549-5939, e-mail info@apress.com , or visit http://www.apress.com .

The information in this book is distributed on an “as is” basis, without warranty. Although every pre

caution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any lia-

bility to any person or entity with respect to any loss or damage caused or alleged to be caused directly or

indirectly by the information contained in this work.

The source code for this book is available to readers at http://www.apress.com in the Source Code/

Download section.

www.it-ebooks.info

Contents at a Glance

About the Authors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii

About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv

Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii

■ ■ ■ Phase 1 of Development

PART 1

■

CHAPTER 1

Starting an E-Commerce Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

■

CHAPTER 2

Laying Out the Foundations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

■

CHAPTER 3

Creating the Product Catalog: Part I . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57

■

CHAPTER 4

Creating the Product Catalog: Part II . . . . . . . . . . . . . . . . . . . . . . . . . . . 107

■

CHAPTER 5

Searching the Catalog . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169

■

CHAPTER 6

Receiving Payments Using PayPal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189

■

CHAPTER 7

Catalog Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199

■ ■ ■ Phase II of Development

PART 2

■

CHAPTER 8

The Shopping Cart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267

■

CHAPTER 9

Dealing with Customer Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 303

■

CHAPTER 10

Product Recommendations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 335

■ ■ ■ Phase III of Development

PART 3

■

CHAPTER 11

Managing Customer Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353

■

CHAPTER 12

Storing Customer Orders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 425

■

CHAPTER 13

Implementing the Order Pipeline: Part I . . . . . . . . . . . . . . . . . . . . . . . . 453

■

CHAPTER 14

Implementing the Order Pipeline: Part II . . . . . . . . . . . . . . . . . . . . . . . 477

■

CHAPTER 15

Credit Card Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 505

■

CHAPTER 16

Product Reviews . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 537

■

CHAPTER 17

Connecting to Web Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 547

■

APPENDIX A

Installing Apache, PHP, and PostgreSQL . . . . . . . . . . . . . . . . . . . . . . . . 571

■

APPENDIX B

Project Management Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . 583

■

INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 593

iii

www.it-ebooks.info

www.it-ebooks.info

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: