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]
[Y]
[Z]
p( ) (Perl)
p1|p2|p3 (matching any of listed patterns)
page-generating packages
paged displays
links to each page of a query result
paging styles
presenting output in linked pages
previous and next page links
PAGER
paging output
param( ) (Perl)
parameter binding operations and reserved characters
parameters
command-line and option file, mixing
connection, specifying
parent-child relationship of keys and foreign keys
parentheses ( )
parentheses, for sorting SELECT results in UNIONs
passwords
securing
2nd
PATH environment variable
setting
pattern matching
[See also SQL pattern matching]2nd
alternations
case sensitivity, controlling
case sensitivity, managing in
column names, escaping SQL pattern characters in
dates
email addresses
ENUM column input data, validation via
vs. FULLTEXT searches
literal metacharacters
non-string values
patterns
for numeric values
regular expressions, using
SET column input data, validation via
times
URLs
pattern metacharacters, matching literally
PEAR (PHP Extension and Add-on Repository)
archive
per-group descriptive statistics, calculating
Perl
@ARGV array
@INC array
array-based metadata attribute names
attribute names for access of array-based metadata
attributes, enabling or disabling
calculating month lengths accounting for leap years
CGI.pm module
2nd
input parameters
override argument to form initialization
checkboxes, creating
connect script
connection parameters, obtaining
from option files
connection, database selection, disconnection
error handling
data exchange between MySQL and Excel, using for
datafiles
columns, extraction and rearranging of
formats, converting
date conversion
and validity checking
SQL script, using
U.S. to ISO format
delimiters, selection using
do( )
duplicates, finding programmatically
encoding special characters using
error checking
MySQL numeric error codes, enabling
trace( )
finding all paydays for a given year
form creating methods
hash lookups, case sensitivity
hit counter
input extraction conventions
library files
LOAD DATA statement, diagnostic utility for
metadata, organization in arrays
modules
MySQL and
MySQL, dependencies
NULL values, representation
NULLs, representing in transferred data, script for
placeholders, implementation
quotes and
queries
error checking
result sets, processing
reusable, writing
query results, exporting
query results, web scripting
definition lists
email addresses, outputting as
hyperlinks, outputting as
make_table_from_query( )
nested lists
ordered lists, outputting as
paragraph text, displaying as
tables, displaying
unordered lists
records changed by a query, counting
reference tables, using to create
references
resources
result set metadata, obtaining
database handles, using
statement handles, using
scrolling lists, creating
multiple-pick
sequence values, accessing with
servers, querying for supported table types
session management with MySQL
database connection parameters
session expiration
session records table, creating
SET column values, converting to arrays
single-pick list elements
functions and arguments
value lists and label hashes
Spreadsheet::ParseExcel::Simple module
Spreadsheet::WriteExcel::FromDB module
Spreadsheet::WriteExcel::Simple module
Text::CSV_XS module, documentation, accessing
uploading files from forms
validation using a lookup table
-w option
web scripts
Apache servers
web sites
XML, modules for exporting query results to
XML::XPath module
Perl DBI
metadata, organization in arrays
retrieval methods
RaiseError and
PERL5LIB environment variable
PERLSESSID cookie
perror (print error) utility
PHP
$php_errormsg global variable
checkboxes or scrolling lists, presentation
class constructor functions
classes
connection parameters, obtaining
from option files
connection, database selection, disconnection
dependencies for MySQL
encoding special characters using
error checking
error messages
displaying special characters
suppressing
error_reporting( )
hit counter
include files and
input extraction conventions
input parameters
vs. Java servlets
library files
magic_quotes_gpc
metadata attributes
multi-pick list elements, creating
MySQL and
2nd
MySQL interface, non-portability of
mysql_connect( )
mysql_errno( )
mysql_error( )
mysql_pconnect( )
mysql_select_db( )
NULL values, representation
object-oriented MySQL interfaces
2nd
[See also MySQL_Access class]
vs. function-based scripts
placeholder support, lack of
adding
pop-up menus, creating
port number option
queries
column counts, getting
query results, web scripting
definition lists
downloading
email addresses, outputting as
ordered lists, outputting as
paragraph text, displaying as
quoting
radio buttons, creating
ranking, programmatic assignment
records changed by a query, counting
references
register_globals, security issues
resources
result set metadata, obtaining
result sets
NULL values, determining
scripts
scrolling lists, creating
sequence values, accessing with
servers, querying for supported table types
session management
closing a session
destroying a session
garbage collection
handler routines
MySQL, for backing store
opening a session
overriding default interface
reading session data
session table, creating
storage management routines, writing
storage method, globally changing
writing session data
single-pick list elements, scripting for
socket pathname option
uploading files from forms
save locations, setting
Version 4 session management interface
functions
version constraints
versions
error checking, problems with pre-4.0.6
web script pathname acquisition
web scripting in
web scripts
Apache servers
web site
<?php and ?> tags
.php extension
PHP Extension and Add-on Repository (PEAR)
.php filename extension
php.ini
phrase searches using FULLTEXT indexes
pipes
2nd
placeholders
2nd
generating a list
including special characters or NULLS in queries, using for
PHP, supporting under
positions, numbering of
.pm file extension
PNP
parameter binding
pop-up menus
POSIX character classes
POST
POST requests
post_image.pl
postal (Zip) codes, pattern for matching
prepare( ) (Perl)
prepare_query( ) (PHP MySQL_Access class)
previous-page, next-page links, generating for web output
PRIMARY KEY
PRIMARY KEY indexes
PRIMARY KEYs
AUTO_INCREMENT columns and
declaring
NULL values and
NULLs and
PrintError
selective enabling
PrintError (Perl DBI)
profile table
resetting
programmatic deletion of multiple tables
large tables, handling
programs, executing in shells
prompts in MySQL, meaning of
Python
% (format specifier)
cgi and urllib modules
connection parameters, obtaining
from option files
connection, database selection, disconnection
DB-API interface
DictCursor
encoding special characters using
error handling
event counts, retrieval using
input extraction conventions
joins on tables sharing column names
library files
multi-pick list elements, creating
MySQL and
NULL values, representing in
placeholders, implementation
pop-up menus, creating
queries
cursor object, using
reusable, writing
query output, numbering of rows
query results, web scripting
email addresses, outputting as
hyperlinks, outputting as
ordered lists, outputting as
paragraph text, displaying as
records changed by a query, counting
references
reports, generating
resources
result set metadata, obtaining
sequence values, accessing with
single-pick list elements, scripting for
subselects, simulating using
summary calculations using for
sys.path variable
uploading files from forms
web scripts
Apache servers
pathname acquisition
web sites about
PYTHONPATH environment variable
|
Main Menu
|
