Muutke küpsiste eelistusi

Effortless E-Commerce with PHP and MySQL 2nd edition [Pehme köide]

  • Formaat: Paperback / softback, 552 pages, kõrgus x laius x paksus: 230x190x30 mm, kaal: 1087 g
  • Ilmumisaeg: 18-Dec-2013
  • Kirjastus: New Riders Publishing
  • ISBN-10: 0321949366
  • ISBN-13: 9780321949363
  • Pehme köide
  • Hind: 55,21 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Paperback / softback, 552 pages, kõrgus x laius x paksus: 230x190x30 mm, kaal: 1087 g
  • Ilmumisaeg: 18-Dec-2013
  • Kirjastus: New Riders Publishing
  • ISBN-10: 0321949366
  • ISBN-13: 9780321949363
Provides information on creating e-commerce sites using PHP and MySQL, covering such topics as generating an online catalog, presenting content, handling orders, and processing payments.

In this comprehensive guide to creating e-commerce website using PHP and MySQL, renowned author Larry Ullman walks you through every step—designing the visual interface, creating the database, presenting content, generating an online catalog, managing the shopping cart, handling the order and the payment process, and fulfilling the order—always with security and best practices emphasized along the way. Even if you’re an experienced web developer, you’re guaranteed to learn something new. The book uses two complete e-commerce site examples, with various features and goals, to present the widest possible range of e-commerce scenarios. This fully updated and expanded second edition includes an additional and new payment processing example, and also reflects the latest changes in PayPal’s options and methodologies. There are new chapters on marketing-related tools to improve the site and sales, on adding functionality via Ajax, and on implementing e-commerce functionality using OOP instead of procedural code. Effortless E-Commerce with PHP and MySQL, Second Edition teaches you how to:

  • Think of the customer first, in order to maximize sales and customer satisfaction
  • Create a safe server environment and database
  • Use secure transactions and prevent common vulnerabilities
  • Incorporate different payment gateways
  • Design scalable sites that are easy to maintain
  • Build administrative interfaces
  • Extend both examples to match the needs of your own sites
Introduction xiv
What Is E-Commerce? xiv
About This Book xv
Technologies Used xvi
What's New in This Edition xvi
Getting Help xvii
What You'll Need xvii
Some Fundamental Skills xvii
A Web Server xviii
And a Bit More xviii
PART ONE FUNDAMENTALS
1(48)
Chapter 1 Getting Started
2(26)
Identifying Your Business Goals
3(1)
Researching Legal Issues
4(3)
National and International Laws
4(2)
PCI Compliance
6(1)
Choosing Web Technologies
7(1)
Selecting a Web Host
8(5)
Hosting Options
8(3)
My Hosting Recommendation
11(1)
Finding a Good Host
12(1)
Using a Payment System
13(5)
Payment Processors
14(1)
Payment Gateways
15(1)
The Middle Way
16(1)
Which Should You Use?
17(1)
The Development Process
18(10)
Site Planning
19(1)
HTML Design
19(1)
Database Design
20(1)
Programming
21(2)
Testing
23(2)
Going Live
25(1)
Maintaining
25(1)
Improving
26(2)
Chapter 2 Security Fundamentals
28(21)
Security Theory
28(5)
No Website Is Secure
29(1)
Maximum Security Isn't the Goal
30(1)
Security for Customers
31(2)
PCI Requirements
33(2)
Server Security
35(5)
Hosting Implications
35(1)
PHP and Web Security
36(2)
Database Security
38(2)
Secure Transactions
40(2)
Common Vulnerabilities
42(7)
Protecting Information
42(1)
Protecting the User
43(1)
Protecting the Site
44(5)
PART TWO SELLING VIRTUAL PRODUCTS
49(132)
Chapter 3 First Site: Structure and Design
50(32)
Database Design
51(4)
Server Organization
55(3)
Connecting to the Database
58(2)
The Config File
60(4)
The HTML Template
64(9)
Creating the Header
66(1)
Adding Dynamic Functionality to the Header
66(5)
Creating the Footer
71(1)
Creating the Home Page
72(1)
Defining Helper Functions
73(9)
Redirecting the Browser
74(2)
Creating Form Inputs
76(6)
Chapter 4 User Accounts
82(32)
Protecting Passwords
83(2)
Registration
85(11)
Creating the Basic Shell
86(1)
Creating the Form
87(1)
Processing the Form
88(8)
Logging In
96(6)
Processing the Form
96(4)
Creating the Form
100(2)
Logging Out
102(1)
Managing Passwords
103(8)
Recovering Passwords
103(4)
Changing Passwords
107(4)
Improving the Security
111(3)
Chapter 5 Managing Site Content
114(34)
Creating an Administrator
114(2)
Adding Pages
116(8)
Creating the Basic Script
116(5)
Adding a WYSIWYG Editor
121(3)
Displaying Page Content
124(8)
Creating category.php
125(4)
Creating page.php
129(3)
Adding PDFs
132(10)
Setting Up the Server
133(1)
Creating the PHP Script
134(8)
Displaying PDF Content
142(6)
Creating pdfs.php
142(2)
Creating view_pdf.php
144(4)
Chapter 6 Using PayPal
148(33)
About PayPal
148(5)
Payment Solutions
150(2)
Payment Buttons
152(1)
Testing PayPal
153(6)
Registering at PayPal
154(2)
Creating Test Customer Accounts
156(1)
Creating a Button
157(2)
Integrating PayPal
159(5)
Updating the Registration Page
160(1)
Creating thanks.php
161(2)
Creating cancel.php
163(1)
Testing the Site
164(2)
Using IPN
166(11)
Enabling IPN
167(1)
Updating the Registration Script
167(2)
Creating the IPN Script
169(7)
Updating the Thanks Script
176(1)
Renewing Accounts
177(2)
Going Live
179(2)
PART THREE SELLING PHYSICAL PRODUCTS
181(200)
Chapter 7 Second Site: Structure and Design
182(36)
About the Site
183(3)
What's Being Sold
183(1)
No Customer Registration
184(1)
Implementing MVC
184(2)
Heightened Security
186(1)
Database Design
186(7)
Product Tables
186(1)
Customer Tables
187(2)
The SQL
189(4)
Server Setup
193(10)
Server Organization
193(1)
Customizing the Server Behavior
194(9)
Helper Files
203(3)
Connecting to the Database
203(1)
The Configuration File
204(2)
The HTML Template
206(5)
The HTML Header
207(2)
The HTML Footer
209(1)
Adjusting Your References
209(1)
Creating Constants for HTML
210(1)
Making the Most of MySQL
211(7)
Prepared Statements
211(3)
Stored Procedures
214(4)
Chapter 8 Creating a Catalog
218(38)
Preparing the Database
219(12)
Populating the Tables Using SQL
219(3)
Looking at the Stored Procedure Queries
222(6)
Creating Stored Procedures
228(3)
Shopping by Category
231(5)
Creating the PHP Script
232(2)
Creating the View Files
234(2)
Listing Products
236(7)
Creating the PHP Script
237(2)
Creating the View Files
239(4)
Creating the "No Products" View
243(1)
Indicating Availability
243(2)
Showing Sale Prices
245(6)
Updating the Stored Procedure
246(2)
Updating product_functions.inc.php
248(2)
Updating list_goodies.html
250(1)
Updating list_coffees.html
250(1)
Highlighting Sales
251(5)
Creating the Home Page
252(2)
Creating the Sales Page
254(2)
Chapter 9 Building a Shopping Cart
256(22)
Defining the Procedures
256(5)
Adding Products
257(1)
Removing Products
258(1)
Updating the Cart
258(1)
Fetching the Cart's Contents
259(2)
Defining the Helper Functions
261(1)
Making a Shopping Cart
262(9)
Creating the PHP Script
263(4)
Creating the Views
267(4)
Making a Wish List
271(4)
Creating the PHP Script
271(2)
Creating the Views
273(2)
Calculating Shipping
275(3)
Chapter 10 Checking Out
278(60)
About Authorize.net
278(2)
Creating a Test Account
280(1)
Preparing the Site
281(15)
The New HTML Template
281(2)
The Helper Function
283(5)
Creating the Procedures
288(8)
Taking the Shipping Information
296(16)
Creating the PHP Script
296(8)
Creating the View Files
304(8)
Taking the Billing Information
312(12)
Creating the Basic PHP Script
312(2)
Creating the View File
314(4)
Validating the Form Data
318(6)
Processing Credit Cards
324(9)
Installing the SDK
324(1)
Using the SDK
325(2)
Examining the Server Response
327(2)
Updating billing.php
329(4)
Completing the Order
333(3)
Creating the PHP Script
334(1)
Creating the View File
335(1)
Testing the Site
336(1)
Going Live
337(1)
Chapter 11 Site Administration
338(43)
Setting Up the Server
339(5)
Requiring Authentication
339(1)
Creating a Template
339(4)
Updating create_form_input()
343(1)
Adding Products
344(15)
Adding Non-Coffee Products
344(9)
Adding Coffee Products
353(6)
Adding Inventory
359(5)
Creating Sales
364(4)
Viewing Orders
368(9)
Listing Every Order
369(2)
Viewing One Order
371(6)
Processing Payment
377(4)
PART FOUR EXTRA TOUCHES
381(141)
Chapter 12 Extending the First Site
382(38)
New Public Features
383(10)
Logging History
383(2)
Recording Favorites
385(2)
Rating Content
387(1)
Making Notes
388(5)
Security Improvements
393(12)
Using Prepared Statements
393(3)
Resetting Passwords More Securely
396(9)
Administrative Changes
405(6)
Making Recommendations
405(1)
Placing HTML Content in Multiple Categories
406(2)
Allowing for Content Drafts
408(1)
Supporting Multiple Types of Administrators
409(2)
Implementing PayPal PDT
411(9)
Enabling PDT
412(1)
Using PDT
413(7)
Chapter 13 Extending the Second Site
420(36)
Public Suggestions
421(25)
Creating a Receipt Page
421(6)
Emailing Receipts
427(8)
Paginating the Catalog
435(1)
Highlighting New Products
436(1)
Making Recommendations
437(1)
Adding Customer Reviews
437(8)
Creating "Add to Wish List" Links
445(1)
Improving the Cart's Display
445(1)
Checking Order Status Online
446(1)
Administrative Suggestions
446(3)
Home Page Additions
446(1)
Shipping Alternatives
447(1)
Viewing Customers
448(1)
Shipping Partial Orders
448(1)
Viewing Incomplete Orders
449(1)
Structural Alterations
449(7)
Using Prepared Statements
450(3)
Tweaking the Database
453(3)
Chapter 14 Adding JavaScript and Ajax
456(32)
Adding jQuery
457(1)
Preventing Duplicate Orders
458(3)
Using Superfish
461(3)
Adding a Calendar
464(3)
Pagination and Table Sorting
467(1)
Applying Ajax
468(2)
Working with Favorites
470(8)
Creating the Server-Side Resource
471(2)
Creating the Client Side
473(5)
Recording Notes
478(5)
Creating notes.php
479(1)
Creating the Client-Side Materials
480(3)
Better Cart Management
483(1)
Taking Customer Feedback
484(4)
Submitting Reviews
484(1)
Marking Reviews as Helpful
485(3)
Chapter 15 Using Stripe Payments
488(34)
About Stripe
488(4)
Why Stripe?
491(1)
Why Not Stripe?
492(1)
Creating an Account
492(3)
Performing Single Charges
495(19)
Creating the Form
496(2)
Adding the JavaScript
498(1)
Writing billing.js
499(7)
Database Changes
506(1)
Writing the PHP Code
507(7)
Testing Stripe
514(2)
Going Live
516(2)
Capturing Charges
518(1)
Performing Recurring Charges
519(3)
Index 522
Larry Ullman is a writer, Web and software developer, trainer, instructor, speaker, and consultant. He has written numerous highly acclaimed books, which have sold over 300,000 copies worldwide in more than 20 languages. As his readers, students, and co-workers attest, Larrys strength is converting the technical and arcane into something comprehensible and useful.