Index: P

Book Home

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