Book Home

Book TitleSearch this book

Symbols & Numbers | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Index: P

PACK_KEYS option: 15.2. SQL Commands
param( ): 9.2.1. Introduction to Perl CGI
parameterized SQL: 10.1.3. Parameterized SQL
paramstyle attribute (MySQLdb module): 20.1.1. Module Attributes
parentheses ( )
in Boolean mode searches: 3.9.1.3. Boolean mode
overriding precedence rules: 3.8.1. Logical Operators
Parise, Jon: 11.8. Where to Find Out More
parsing queries: 5.2.2.2. EXPLAIN SELECT
PASSWORD( ) function: 17.2.2. General Functions
authentication tokens and: 6.3.1.1. User management
scrambling passwords in user table: 6.1.2.2. The security tables
PASSWORD option: 15.2. SQL Commands
password property
GNU JDBC driver: 13.1.2.2. Driver manager connectivity
twz JDBC driver: 13.1.2.2. Driver manager connectivity
--password=my_password option: 4.1.2. File Content
passwords
assigning: 6.1.1. User Management
authentication tokens and: 6.3.1.1. User management
avoiding storage in memory: 6.3.1.2. Resource protection
encrypting with crypt( ): 11.7. Using the HTML <form> Environment
GRANT statement and: 6.1.2.1. GRANT and REVOKE
handling, using character arrays: 6.3.1.2. Resource protection
mysql_change_user( ) and: 18.2. Functions
19.2. Functions
protecting, in client applications: 6.3.2. Client Applications
in security tables: 6.1.2.2. The security tables
pattern matching in queries: 3.8.4. Pattern Matching
9.2.3. A Sample CGI/DBI Program
percent (%)
modulo of two values: 17.1.2. Arithmetic Operators
pattern matching character: 3.8.4. Pattern Matching
9.1.4. Introducing Bind Variables and Optimizations
performance
MySQL vs. other database engines: 1.4. MySQL Features
retrieving all rows from statement handle: 9.1.4. Introducing Bind Variables and Optimizations
transaction isolation levels and: 8.2.2.1. Transaction isolation levels
performance tuning: 5. Performance Tuning
database servers: 5.3. Database Server Tuning
EXPLAIN SELECT command and: 5.2.2.2. EXPLAIN SELECT
hardware: 5.4. Operating System/Hardware Tuning
host applications: 5.2.1. Host Application Tuning
operating systems: 5.4. Operating System/Hardware Tuning
SQL queries: 5.2.2. SQL Query Tuning
period (.), extended regular expression: 3.8.4. Pattern Matching
PERIOD_ADD( ) function: 17.2.2. General Functions
PERIOD_DIFF( ) function: 17.2.2. General Functions
Perl: 9. Perl
AppConfig module: 9.2.3. A Sample CGI/DBI Program
CGI module: 9.2. DBI and CGI
MVC methodology: 9.2.2. The Model/View/Controller Methodology
sample program: 9.2.3. A Sample CGI/DBI Program
DBI module: 9.1. Introduction to DBI
basic example: 9.1.1. Basic Perl Example
error handling and attributes: 9.1.3. Error Handling and Attributes
Model layer
creating: 9.3.1. A Model for Relational Data
example of use: 9.3.3. Example of the Model's Use
implementing: 9.3.2. Implementing the Model
Template Toolkit module: 9.2.3. A Sample CGI/DBI Program
permissions
granting and revoking: 6.1.2.1. GRANT and REVOKE
managing users with multiple roles: 6.1.1. User Management
setting on data directories: 6.2.1. Operating System Security
storing in separate table: 6.3.1.1. User management
persistent connections, as performance tuning tool: 5.2.1. Host Application Tuning
phantom reads: 8.2.2.1. Transaction isolation levels
PHP: 11. PHP
accessing MySQL DBMS with: 11.3. Accessing the MySQL DBMS with PHP
arrays in: 11.1.1. A Short Language Primer
begin/end tags: 11.1. Introducing PHP
11.1.1. A Short Language Primer
comments in scripts: 11.1.1. A Short Language Primer
conditionals in: 11.1.1. A Short Language Primer
DSOs (dynamic shared objects) and: 11.2.1.1. Installation problems
equality testing in: 11.1.1. A Short Language Primer
include files: 11.3.6. Include Files
installation problems: 11.2.1.1. Installation problems
installing: 11.2. Installing PHP
on Microsoft Windows systems: 11.2.2. Getting Started Under Microsoft Windows
on Unix systems: 11.2.1. Getting Started Under Unix
introduction to: 11.1. Introducing PHP
MySQL API reference: 18. MySQL PHP API Reference
MySQL library functions: 11.3.4. Frequently Used MySQL Library Functions
opening/using database connections: 11.3.2. Opening and Using a Database Connection
resources for: 11.8. Where to Find Out More
sessions library: 11.5. Managing Sessions
syntax of: 11.1.1. A Short Language Primer
user data
decoding: 11.1. Introducing PHP
securing: 11.4. Securing User Data
variables in: 11.1.1. A Short Language Primer
writing data with: 11.6. Writing Data with PHP
.php file extension: 11.1. Introducing PHP
installation problems and: 11.2.1.1. Installation problems
PHP-GTK extension, developing window-based applications: 11.2. Installing PHP
php.ini configuration file: 11.4. Securing User Data
11.5. Managing Sessions
physical database design: 7.4. Physical Database Design
PI( ) function: 17.2.2. General Functions
plus sign (+)
addition operator: 3.8. SQL Operators
17.1.2. Arithmetic Operators
in Boolean mode searches: 3.9.1.3. Boolean mode
populate_publisher( ) (Publisher class): 9.3.2. Implementing the Model
9.3.2.6. Constructors
port property (twz JDBC driver): 13.1.2.2. Driver manager connectivity
portability, maintaining with properties files: 13.1.3. Maintaining Portability Using Properties Files
POSITION( ) function: 17.2.2. General Functions
possible_keys column (EXPLAIN SELECT command): 5.2.2.2. EXPLAIN SELECT
POST method and $HTTP_POST_VARS array: 11.4. Securing User Data
PostgresSQL vs. MySQL: 1.4. MySQL Features
pound sign (#)
comments in configuration files: 4.1.2. File Content
one-line comments in C: 15.1.3. Comments
one-line comments in PHP scripts: 11.1.1. A Short Language Primer
POW( ) function: 17.2.2. General Functions
POWER( ) function: 17.2.2. General Functions
precedence rules for MySQL operators: 3.8. SQL Operators
17.1.1. Rules of Precedence
prepare( ): 9.1.1. Basic Perl Example
bind variables and: 9.1.4. Introducing Bind Variables and Optimizations
presents.php script: 11.3.2. Opening and Using a Database Connection
previous( ): 13.2.1. Queries and Result Sets
PRIMARY KEY attribute: 15.2. SQL Commands
15.2. SQL Commands
EXPLAIN SELECT command and: 5.2.2.2. EXPLAIN SELECT
Primary Key utility: 9.3.1. A Model for Relational Data
primary keys: 3.5. Indexing
auto-incrementing: 3.6.2. Sequence Generation
creating physical databases: 7.4. Physical Database Design
getByPrimaryKey( ) (Publisher class): 9.3.2. Implementing the Model
9.3.2.5. Primary key select method
9.3.3. Example of the Model's Use
increasing application performance: 8.2.2.2. Using READ UNCOMMITTED
IS_PRI_KEY( ) macro: 19.1. Data Types
security tables and: 6.1.2.2. The security tables
print statement (PHP): 11.1.1. A Short Language Primer
PrintError attribute: 9.1.3. Error Handling and Attributes
printf( ): 10.1.3. Parameterized SQL
11.1.1. A Short Language Primer
privileges
GRANT statement and: 6.1.2.1. GRANT and REVOKE
9.1.2. Setting Up the Database and Program
REVOKE statement and: 6.1.2.1. GRANT and REVOKE
security issues for managing: 6.1.2. Privilege Management
tables for storing information: 6.1.2.2. The security tables
PROCEDURE clause: 15.2. SQL Commands
PROCESS privilege: 6.1.2.1. GRANT and REVOKE
production environment: 6.1.1. User Management
<Emphasis>A Programmer's Introduction to PHP 4.0<Default Para Font>: 11.8. Where to Find Out More
properties files
maintaining portability using: 13.1.3.1. Properties files
putting configuration information in: 13.1.2.2. Driver manager connectivity
Publisher class
implementing: 9.3.2. Implementing the Model
initializing: 9.3.2.1. The Publisher class
methods for building/executing SQL: 9.3.2.2. Methods that build and execute SQL
methods for handling WHERE clause: 9.3.2.3. Methods that handle WHERE clauses
Publisher.pm module: 9.3.2. Implementing the Model
Python: 10. Python
DB-API: 10.1. DB-API
20.1. Module: MySQLdb
connecting to databases: 10.1.1. The Database Connection
cursors in: 10.1.2. Cursors
database applications using: 10.3. Applied DB-API
encapsulating SQL data types: 10.1.4. Other Objects
parameterized SQL and: 10.1.3. Parameterized SQL
proprietary operations and: 10.2. Proprietary Operations


Symbols & Numbers | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
Library Navigation Links

Copyright © 2003 O'Reilly & Associates, Inc. All Rights Reserved.