Ваш браузер не поддерживает плавающие фреймы!
Index
Preface
What This Book Is About
What You Need to Know
How This Book Is Organized
How to Use This Book
Conventions Used in This Book
Using Code Examples
How to Contact Us
Web Site and Code Examples
Acknowledgments
Chapter 1. Database Applications and the Web
Section 1.1. The Web
Section 1.2. Three-Tier Architectures
Chapter 2. The PHP Scripting Language
Section 2.1. Introducing PHP
Section 2.2. Conditions and Branches
Section 2.3. Loops
Section 2.4. Functions
Section 2.5. Working with Types
Section 2.6. User-Defined Functions
Section 2.7. A Working Example
Chapter 3. Arrays, Strings, and Advanced Data Manipulation in PHP
Section 3.1. Arrays
Section 3.2. Strings
Section 3.3. Regular Expressions
Section 3.4. Dates and Times
Section 3.5. Integers and Floats
Chapter 4. Introduction to Object-Oriented Programming with PHP 5
Section 4.1. Classes and Objects
Section 4.2. Inheritance
Section 4.3. Throwing and Catching Exceptions
Chapter 5. SQL and MySQL
Section 5.1. Database Basics
Section 5.2. MySQL Command Interpreter
Section 5.3. Managing Databases and Tables
Section 5.4. Inserting, Updating, and Deleting Data
Section 5.5. Querying with SQL SELECT
Section 5.6. Join Queries
Section 5.7. Case Study: Adding a New Wine
Chapter 6. Querying Web Databases
Section 6.1. Querying a MySQL Database Using PHP
Section 6.2. Processing User Input
Section 6.3. MySQL Function Reference
Chapter 7. PEAR
Section 7.1. Overview
Section 7.2. Core Components
Section 7.3. Packages
Chapter 8. Writing to Web Databases
Section 8.1. Database Inserts, Updates, and Deletes
Section 8.2. Issues in Writing Data to Databases
Chapter 9. Validation with PHP and JavaScript
Section 9.1. Validation and Error Reporting Principles
Section 9.2. Server-Side Validation with PHP
Section 9.3. JavaScript and Client-Side Validation
Chapter 10. Sessions
Section 10.1. Introducing Session Management
Section 10.2. PHP Session Management
Section 10.3. Case Study: Using Sessions in Validation
Section 10.4. When to Use Sessions
Section 10.5. PHP Session API and Configuration
Chapter 11. Authentication and Security
Section 11.1. HTTP Authentication
Section 11.2. HTTP Authentication with PHP
Section 11.3. Form-Based Authentication
Section 11.4. Protecting Data on the Web
Chapter 12. Errors, Debugging, and Deployment
Section 12.1. Errors
Section 12.2. Common Programming Errors
Section 12.3. Custom Error Handlers
Chapter 13. Reporting
Section 13.1. Creating a Report
Section 13.2. Producing PDF
Section 13.3. PDF-PHP Reference
Chapter 14. Advanced Features of Object-Oriented Programming in PHP 5
Section 14.1. Working with Class Hierarchies
Section 14.2. Class Type Hints
Section 14.3. Abstract Classes and Interfaces
Section 14.4. Freight Calculator Example
Chapter 15. Advanced SQL
Section 15.1. Exploring with SHOW
Section 15.2. Advanced Querying
Section 15.3. Manipulating Data and Databases
Section 15.4. Functions
Section 15.5. Automating Querying
Section 15.6. Table Types
Section 15.7. Backup and Recovery
Section 15.8. Managing Users and Privileges
Section 15.9. Tuning MySQL
Chapter 16. Hugh and Dave's Online Wines:A Case Study
Section 16.1. Functional and System Requirements
Section 16.2. Application Overview
Section 16.3. Common Components
Chapter 17. Managing Customers
Section 17.1. Code Overview
Section 17.2. Customer Validation
Section 17.3. The Customer Form
Chapter 18. The Shopping Cart
Section 18.1. Code Overview
Section 18.2. The Winestore Home Page
Section 18.3. The Shopping Cart Implementation
Chapter 19. Ordering and Shipping at the Online Winestore
Section 19.1. Code Overview
Section 19.2. Credit Card and Shipping Instructions
Section 19.3. Finalizing Orders
Section 19.4. HTML and Email Receipts
Chapter 20. Searching and Authentication in the Online Winestore
Section 20.1. Code Overview
Section 20.2. Searching and Browsing
Section 20.3. Authentication
Appendix A. Linux Installation Guide
Section A.1. Finding Out What's Installed
Section A.2. Installation Overview
Section A.3. Installing MySQL
Section A.4. Installing Apache
Section A.5. Installing PHP
Section A.6. What's Needed for This Book
Appendix B. Microsoft Windows Installation Guide
Section B.1. Installation Overview
Section B.2. Installing with EasyPHP
Section B.3. What's Needed for This Book
Appendix C. Mac OS X Installation Guide
Section C.1. Getting Started
Section C.2. Installing MySQL
Section C.3. Setting Up Apache and PHP
Section C.4. What's Needed for This Book
Appendix D. Web Protocols
Section D.1. Network Basics
Section D.2. Hypertext Transfer Protocol
Appendix E. Modeling and Designing Relational Databases
Section E.1. The Relational Model
Section E.2. Entity-Relationship Modeling
Appendix F. Managing Sessions in theDatabase Tier
Section F.1. Using a Database to Keep State
Section F.2. PHP Session Management
Section F.3. MySQL Session Store
Appendix G. Resources
Section G.1. Client Tier Resources
Section G.2. Middle-Tier Resources
Section G.3. Database Tier Resources
Section G.4. Security and Cryptography Resources
Appendix H. The Improved MySQL Library
Section H.1. New Features
Section H.2. Getting Started
Section H.3. Using the New Features
Colophon
Copyright
< Day Day Up >
[
SYMBOL
] [
A
] [
B
] [
C
] [
D
] [
E
] [
F
] [
G
] [
H
] [
I
] [
J
] [
K
] [
L
] [
M
] [
N
] [
O
] [
P
] [
Q
] [
R
] [
S
] [
T
] [
U
] [
V
] [
W
] [
X
] [
Z
]
salt
scalar types
scripting languages
JavaScript
PHP
[See PHP]
search.tpl (winestore database)
2nd
search/search.php (winestore database)
2nd
3rd
4th
search/searchform.php (winestore database)
2nd
3rd
4th
5th
Secure Sockets Layer protocol
[See SSL]
security
attacks and special characters
authentication
[See authentication]
queries from user input
sessions and
users and privileges, managing
validation and
SELECT ... INTO OUTFILE statement
<select multiple> tag
SELECT statement
arithmetic and comparison operators
clauses, combining
CREATE TABLE, using with
DISTINCT clause
HAVING clause
INSERT, using with
LIMIT operators
ORDER BY clause
sorting and grouping output
WHERE clause
selectDistinct( ) function (MySQL)
selectFont( ) method (pdf-php)
Sequel
server variables
$_SESSION array
session_destroy( ) function (PHP)
2nd
session_destroy( ) handler function
session_id( ) function (PHP)
session_is_registered( ) function (PHP)
session_readonly( ) function (PHP)
session_register( ) function (PHP)
session_set_save_handler( ) function (PHP)
2nd
session_start( ) function (PHP)
2nd
session_unregister( ) function (PHP)
session_unset( ) function (PHP)
sessionAuthenticate( ) function (PHP)
2nd
3rd
sessionClose( ) handler function
sessionGC( ) garbage collection handler
sessionOpen( ) handler function
sessionRead( ) handler function
sessions
2nd
advantages
authentication and
bookmarks and
cookies
definition
disadvantages
ending
hijacking, prevention
management
2nd
[See also PHP, session management]
configuration
garbage collection
without cookies
performance
PHP accessing functions
with register_globals enabled
PHP API and configuration
security aspects
session hijacking
session identifiers
session identifiers (IDs)
session variables
2nd
3rd
serialization
2nd
storage, database tier
types
unsetting
session-based applications, designing
tracking anonymous users
tracking authenticated users
starting
state information storage
timeouts
validation using
when to use
sessionWrite( ) handler function
set_error_handler( ) function (PHP)
setupQuery( ) function (winestore database)
shapeInfo( ) function (PHP)
shell_exec( ) function (PHP), security risks
shellclean( ) function
2nd
short-circuit evaluation property
SHOW command (MySQL)
showcart.php (winestore database)
2nd
3rd
4th
showcart.tpl (winestore database)
2nd
showCountry( ) function (winestore database)
showerror( ) function (PHP)
showPricing( ) function (winestore database)
showTitle( ) function (winestore database)
showVarieties( ) function (winestore database)
showWine( ) function (winestore database)
sin( ) function (MySQL)
Smarty PHP template engine
SMTP (Simple Mail Transfer Protocol)
sort( ) function (PHP)
sorting arrays
[See arrays, sorting]
special characters
escaping in regular expressions
use in attacks
sprintf( ) function (PHP)
supported conversion types
SQL
2nd
[See also databases]
3rd
4th
[See also MySQL]
5th
advanced querying
arithmetic and comparison operators
data types for attributes
table creation based on ER modeling
user variables
sqrt( ) function (MySQL)
srand( ) function (PHP)
SSL (Secure Sockets Layer) protocol
start anchors (^) (regular expressions)
starvation
stateful versus stateless applications
static member functions
static member variables
static variables
storage engines
[See table types]
stored procedures
str_pad( ) function (PHP)
str_replace( ) function (PHP)
strcasecmp( ) function (PHP)
strcmp( ) function (PHP)
strftime( ) function (PHP)
string expressions
string functions (MySQL)
string literals
strings
2nd
arrays, splitting into
case, changing
characters
replacing in
translating
trimming from
comparing
formatting
length
padding
regular expressions, matching with
[See regular expressions]
sprintf( ) and printf( ) functions (PHP)
supported conversion types
substrings
extraction from strings
replacing
translating
substrings, replacing
timestamps, generating from date strings
trimming whitespace
validation of
email addresses
legal character tests
URLs
Zip and postcodes
wildcard matching
strlen( ) function (PHP)
strncasecmp( ) function (PHP)
strncmp( ) function (PHP)
strtolower( ) function (PHP)
strtotime( ) function (PHP)
2nd
strtoupper( ) function (PHP)
2nd
strtr( ) function (PHP)
strval( ) function (PHP)
substr( ) function (PHP)
substr_replace( ) function (PHP)
substring( ) function (MySQL)
substrings
[See strings, substrings]
SUM( ) function (MySQL)
superglobals
switch statement
system( ) function (PHP)
security risks of
< Day Day Up >
online games
Copyright ©
2010
|
D
omen maybe sale
-
bye this domen
