Table of Contents for CHAPTER 38: Importing and Exporting Data

always_populate_raw_post_data directive

amortizationTable function, 2nd

ampersand (&) character

displaying special HTML characters

htmlentities function translating

AND (&&) operator

AND (&) bitwise operator

AND (&) logical operator

ANY record type, DNS, 2nd

Apache

disabling broadcast of server signature

downloading-2nd

downloading Apache manual

hiding configuration details

htaccess file

httpd.conf file

installing on Linux-2nd

installing on Windows-2nd

reasons for installing, 2nd

ServerSignature directive

ServerTokens directive

viewing documentation

web site

XAMPP as test environment

application directory

ARCHIVE storage engine, MySQL

application logic

index.tpl template

architecture

stored routines

Archive_Tar package, PEAR

arg_separator.input directive, PHP

arg_separator.output directive, PHP

argc

register_argc_argv directive

arguments

B

%b type specifier

B, metacharacters, Perl regular expressions

b file access mode

b option, mysql client

b type code, data types

back_log parameter, MySQL

backgrounds

highlight.bg directive, PHP

backslash () character

escape sequences, PHP

inserting backslash delimiter before special characters

MySQL using

backtick operator

backticks

executing shell command with

Bakken, Stig

bandwidth

calculating network bandwidth

testing user bandwidth-2nd

base directory

open_basedir directive, PHP

base exception class see exception class

baseclass

class inheritance, OOP

basename function

bd/bi/bu prefixes

trigger naming, MySQL

before triggers, MySQL

after triggers compared

naming conventions

BEGIN command

conforming to SQL-99 syntax

BEGIN/END block, MySQL

LEAVE command

stored routines, 2nd, 3rd

beginTransaction method, PDO

BIGINT datatype, MySQL

bin directory

sqlite_escape_string function

bin2hex function

binary data, SQLite-2nd

NULL character

sqlite_udf_decode_binary function

sqlite_udf_encode_binary function

BINARY datatype attribute, MySQL

CHAR/VARCHAR datatypes

binary distribution

installing MySQL on Linux-2nd

binary output, returning

bind_param method, mysqli, 2nd, 3rd

bind_result method, mysqli, 2nd

bindColumn method, PDO

binding

bindParam method, PDO, 808, 809, 810

bindtextdomain function, 2nd, 3rd

Bison

installing Apache and PHP on Linux

bitwise operators

BLACKHOLE storage engine, MySQL

BLOB datatype, MySQL

blocks

embedding multiple code blocks

BOOL (BOOLEAN) datatype, MySQL

Boole, George

Boolean datatype

type juggling

Boolean full-text searches, MySQL

bound columns

setting, PDO-2nd

bound parameters/results

prepared statements, mysqli

boxing client

SOAP client and server interaction

boxing server

SOAP client and server interaction

brackets ([])

[] metacharacter, Perl regular expressions

converting string characters into bracketed expressions

POSIX regular expressions

predefined character ranges (character classes)

break (<br>) tag

converting newline characters into

break statement, PHP

switch statement

B-tree indexes

buffering

output_buffering directive, PHP

sqlite_unbuffered_query function

build method, PHP

separating presentational logic from

business logic

C

%c type specifier

C option, mysql client

C option, mysqlxyz clients

CA (Certificate Authority) certificate

REQUIRE X509 option

ssl-ca option, mysql client

ssl-capath option, mysql client

CA issuers

modifying directory locations

cache directory

installing Smarty

cache_dir class member

cache_expire directive, session handling

cache_id parameter, display method, Smarty

cache_lifetime attribute, Smarty

cache_limiter directive, session handling

caching

setting for session-enabled pages-2nd

Smarty templating engine-2nd

creating multiple caches per template

is_cached method

caching attribute, Smarty

caching templates, Smarty

Cake Software Foundation

CakeForge

CakePHP framework

calculate_bonus stored function, MySQL

Calendar package, PEAR-2nd

creating monthly calendar-2nd

date and time classes

validating dates and times

validation classes

CALL statement, MySQL

callback rule, HTML_QuickForm

Canonical Name Record, DNS

capability, stored routines

capitalize function, Smarty

carriage return

escape sequences, PHP

CASCADE keyword, MySQL

CASCADED CHECK OPTION option, MySQL

WITH CHECK OPTION clause

case

manipulating case of characters in strings-2nd

case sensitivity

comparing two strings case-insensitively

comparing two strings case-sensitively

performing case-insensitive search-2nd

performing case-sensitive search-2nd

replacing text in case-insensitive manner

replacing text in case-sensitive manner-2nd

splitting string based on case-insensitive pattern, 2nd

splitting string based on case-sensitive pattern

SQLite

CASE statement

Perl regular expression modifier

case statement, PHP

case-insensitive search

casting, PHP-2nd

catching multiple exceptions-2nd

ceil function, MySQL

certificates

REQUIRE SUBJECT option

ssl-cert option, mysql client

CHAR datatype, MySQL

character classes

POSIX regular expressions-2nd

character entity references

character sequences

range function, arrays

CHARACTER SET option

default_charset directive, PHP

character sets

supported by htmlentities function

CHARACTER_SETS table

characteristics

converting strings into bracketed expressions

characters

counting number in string

customized character conversion

htmlentities function

ignoring newline characters

localized formats

reading single character

reading specific number of

regular expressions-2nd

charset parameter, htmlentities function

CHARSET placeholder

check option, myisamchk client

checkboxes

working with multivalued form components

checkdate function, PHP

checkdnsrr function-2nd

child class, OOP

children method, SimpleXML

chroot option, mysqld daemon

ciphers

REQUIRE CIPHER option

ssl-cipher option, mysql client

class attribute

dns_get_record returning

class constants

class definition

class inheritance, OOP-2nd

child class (subclass)

constructors and inheritance-2nd

extends keyword

parent class (baseclass)

class libraries

class management

class_exists function

classes

disable_classes directive, 2nd

classes, OOP

D

%d type specifier

D, d metacharacters, Perl regular expressions

D option, mysql client

D, d parameters, date function

D parameter, numeric datatypes

digits following decimal point

d type code, data types

daemons

starting and stopping MySQL

data

delimiting data

exporting data-2nd

hiding sensitive data-2nd

importing data-2nd

outputting data to web browser-2nd

poorly protected data

sales table

sanitizing user input-2nd

PEAR: Validate package-2nd

data delimitation

data encryption see encryption

data handling

deleting LDAP data-2nd

inserting LDAP data-2nd

ldap_add function

ldap_delete function

ldap_mod_add function

ldap_mod_del function

ldap_modify function

ldap_rename function

updating LDAP data

data handling category

database abstraction layers

data management, MySQL

data mining, MySQL

data retrieval, PDO-2nd

data sets, PHP

Data Source Name see DSN

data types

PHP arrays

precision directive, PHP

type codes

data validation

PEAR: HTML_QuickForm-2nd

PDO (PHP Data Objects)-817

database abstraction solutions

general PHP language features

database based authentication, PHP-2nd

authenticating user against MySQL database

authenticating using login pair and IP address

database configuration

database option, mysql client

database connections see connections

database security see security

database support

general PHP language features

PDO (PHP Data Objects)

database transactions see transactions

database versions offered by web host

databases

applications accessing

changing table structure

copying tables

creating

creating SQLite database

creating tables

creating tables conditionally

creating temporary tables

deleting

deleting tables

designating as default

indexes-2nd

migrating between

MySQL access privilege system

MySQL storage engines-2nd

selecting database, mysqli extension

transactions-2nd

using multiple storage engines

viewing

viewing tables, 2nd

datadir option, MySQL

datadir parameter, MySQL

datatype attributes, MySQL-2nd

date and time datatypes

DATE

DATETIME

invalid value inserted into

nonalphanumeric delimiters

TIME

TIMESTAMP

YEAR

numeric datatypes-2nd

BIGINT

BOOL (BOOLEAN)

constraining maximum display size

DECIMAL

digits following decimal point

adapting datatypes-2nd

array

Boolean

compound datatypes-2nd

converting between datatypes-2nd

float

functions for determining variable type

functions for verifying and converting

type identifier functions

type juggling-2nd

type related functions

date and time datatypes, MySQL

invalid value inserted into

nonalphanumeric delimiters

date and time functions, PHP

calculating dates

checkdate function

date function-2nd

determining days in current month

displaying localized date and time-2nd

displaying web page modification date

getdate function-2nd

getlastmod function

gettimeofday function

mktime function-2nd

setlocale function-2nd

strftime function-2nd

strtotime function

time function

date classes

determining days in current month

DATE datatype, MySQL

date function-2nd

format parameters

inserting punctuation

outputting am or pm

outputting current time

outputting standard date

outputting verbose date

outputting weekday

t parameter

Date method, DateTime class

date_default_timezone_set function

date_format function, Smarty

dates

calculating dates

Calendar package, PEAR-2nd

dates prior to Unix epoch

determining days in current month

displaying localized date and time-2nd

displaying web page modification date

formatting dates and times-2nd

formatting dates, Smarty

localized formats

localizing-2nd

object-oriented enhancements-2nd

standardized format for

US and European formats

DATETIME datatype, MySQL

Db column

db table

access control/authorization

columns, table listing of

MySQL access privilege system, 2nd

User/Db match

User/Host/Db triplet

DB_Table

dblogin array

Auth_HTTP class, PEAR

DDL statements

MySQL rollbacks

deb packages

installing MySQL on Linux

debug option, mysqlimport utility

debugging, mysqli

DECIMAL datatype, MySQL

Decision Support (DSS)

sqlite_fetch_array function

DECLARE statement, MySQL

cursors, 2nd

stored routines

declaring variables, PHP

decode_binary parameter

sqlite_column function

decoding

session_decode function

sqlite_udf_decode_binary function

decorator classes

default argument values-2nd

decrement (--) operator

dedicated server hosting

DEFAULT datatype attribute, MySQL

default directory

default_charset directive, PHP

default function, Smarty

default_mimetype directive, PHP

default_socket_timeout directive, PHP

default-character-set option, mysql client

defaults

highlight.default directive, PHP

defaults-extra-file option, mysqlxyz clients, 2nd

defaults-file option, mysqlxyz clients

default-storage-engine parameter, MySQL

default-table-type parameter, MySQL

define function

define_syslog_variables function

DEFINER clause/setting, MySQL

CREATE TRIGGER statement

modifying stored routines

SQL SECURITY characteristic

stored routines

views

DELETE command, mysqli extension

delete option, mysqlimport utility

Delete_priv column

delimiter parameter, preg_quote function

DELIMITER statement, MySQL

delimiter syntax

asp_tags directive, PHP

delimiters

changing Smarty default delimiters

choosing in Excel

creating design template

templating engines, 2nd

delimiting data

importing and exporting data

delimiting PHP code-2nd

ASP-style syntax

default delimiter syntax

embedding multiple code blocks

script tag

short tags

deref parameter, ldap_search function

DESCRIBE statement, MySQL

using mysql in interactive mode

viewing view definition

Detailed Configuration

MySQL Configuration Wizard, 2nd

DETERMINISTIC characteristic, MySQL

dictionaries

CrackLib extension using

digit character class

digital signatures

encrypting data with md5 function

directives, PHP see PHP configuration directives

directories

E

E, e options, mysql client

E_ALL error level

E_STRICT error level

each function, arrays

echo statement, PHP

Eclipse framework

editors

choosing code editor-2nd

ELSE statement, MySQL

else statement, PHP

else/elseif clauses, Smarty

ELSEIF statement, MySQL

elseif statement, PHP

e-mail

F

%f type specifier

f flag, install command

F parameter, date function

f option, mysql client

facility parameter, openlog function

FastCGI

configuring FastCGI to manage PHP processes

confirming FastCGI Handler Mapping is installed

installing IIS and PHP on Windows, 2nd

testing PHP installation

fclose function

features of PHP language-2nd

FEDERATED storage engine, MySQL

Fedora runlevels

feeds, RSS see RSS feeds

feof function

fetch method, mysqli

fetch method, PDO

choosing fetch or fetchAll function

cursor_offset parameter

cursor_orientation parameter

PDO_FETCH_XYZ values

fetch statement, Smarty

FETCH statement, MySQL

using cursors, 2nd

fetch_array method, mysqli

fetch_object method, mysqli

fetch_row method, mysqli

fetch_style parameter

PDO_FETCH_XYZ values

fetchAll method, PDO

choosing fetch or fetchAll function

fetchColumn method, PDO

fetching

PDO_ATTR_PREFETCH option

PDO_DEFAULT_FETCH_MODE option

fgetc function

fgetcsv function

loading table data with PHP

fgets function

fgetss function

fields

retrieving field names

sqlite_field_name function

sqlite_num_fields function

FIELDS TERMINATED BY option

getting fields available to object

fields, OOP-2nd

class characteristics

declaring

field scopes-2nd

final fields

restricting access to

static fields

static scope

fields-xyz options, mysqlimport utility

file based authentication, PHP-2nd

authenticationFile.txt

file extensions

file handling

identifying if EOF reached

ignoring newline characters

moving file pointer to beginning of file

moving file pointer to offset

opening files

outputting data to file

PHP 4 features

reading CSV file into array

reading entire file

reading file in predefined format

reading file into array

reading file into string

reading single character

reading specific number of characters

recognizing end of file character

recognizing newline characters

resource handling

retrieving current pointer offset

setting access level

stripping HTML and PHP tags from input

writing string to file

file I/O see file handling

file inclusion statements, PHP-2nd

include statement-2nd

include_once function

require statement

require_once function

file ownership

safe_mode restrictions

file pointers

moving to beginning of file

moving to offset

retrieving current pointer offset

FILE privilege

file upload directives, PHP-2nd

G

g modifier, Perl regular expressions

G option, mysql client

displaying results vertically

SHOW STATUS statement

G, g parameters, date function

garbage collection

gc_maxlifetime directive

session_garbage_collect function

gc_maxlifetime directive

gcc tool

installing MySQL on Linux, 2nd

$_GET superglobal variable

get function

GET method

arg_separator.input directive, PHP

passing data between scripts

get_class function

get_class_methods function

get_class_vars function

get_config_vars method

referencing configuration variables, Smarty

get_declared_classes function

get_html_translation_table function

get_object_vars function

get_parent_class function

getAttribute method, PDO

retrieving attribute values

setting error mode

getCode method, exception class

getdate function-2nd

getFiles method, HTTP_Upload

uploading files with PEAR: HTTP_Upload

uploading multiple files

getFunctions method, SOAP

getlastmod function

getLine method, exception class

getMessage method, exception class

getmxrr function

getProp method, HTTP_Upload

using HTTP_Upload to retrieve file properties

getQuote function, SOAP, 2nd

boxing server

executing boxing client

getservbyname function

getservbyport function

getSubmitValues method, HTML_QuickForm class

getter methods

creating custom getters and setters

Gettext

translating web sites with Gettext-2nd

creating localization repository

creating translation files-2nd

generating binary files

setting desired language in scripts-2nd

translating text-2nd

updating web site scripts-2nd

xgettext command

gettext function

recognizing strings for translation

support multiple languages with

gettext utility

downloading and installing

gettimeofday function

getTrace method, exception class

getTraceAsString method, exception class

gettype function

GID (group ID)

safe_mode_gid directive, PHP

GLOBAL keyword

global scope, functions

return statement

global scope, variables

register_globals directive

global search

Perl regular expression modifier

global variables

configuration files, Smarty

variable scope, PHP

GLOBAL_STATUS table

GLOBAL_VARIABLES table

globalization see internationalization

globals

register_globals directive, PHP

$_GLOBALS superglobal array, 2nd

GNOME XML library

PHP 5’s SOAP extension

goto statement, PHP

GPL (General Public License)

using with MySQL

GRANT command, MySQL

access privileges managed by, 2nd

adding privileges to user

creating new user

granting column-level privileges, 2nd

granting multiple table-level privileges

granting table-level privileges, 2nd

importance of IDENTIFIED BY clause

privilege types supported

syntax

tips when working with

user and privilege management-2nd

wildcards

GRANT OPTION privilege

grant options

determining user’s SSL requirements

REQUIRE CIPHER option

Boolean full-text searches

REQUIRE SSL option

REQUIRE SUBJECT option

Grant_priv column

Grantor column

granularity

graph character class

greater than (>) character

displaying special HTML characters

htmlentities function translating

greater than (>, >=) operators

group IDs

safe_mode_gid directive

GUI client programs, MySQL-2nd

GUI Tools, MySQL

H, h parameters, date function

gunzip tool

installing MySQL on Linux, 2nd, 3rd

Gutmans, Andi

H

H, h options, mysql client, 2nd, 3rd

handle method, SOAP

handlers

hard coded authentication, PHP

handles see file handling

handling errors see error handling

hash mark

referencing configuration variables, Smarty

hashed indexes

hashing

encrypting data with md5 function

mhash function

mhash library

header function

authentication, PHP

header.phtml file

i modifier, Perl regular expressions

headers

I

i option, myisamchk client

I, i parameters, date function

i type code, data types

i18n

IBM DB2

PDO supported databases

ICU (International Components for Unicode)

installing Apache and PHP on Linux

ident parameter, openlog function

IDENTIFIED BY clause, GRANT command

identifiers, PHP

IF EXISTS keywords, MySQL

if function, Smarty

else/elseif statements

IF NOT EXISTS clause

CREATE TABLE statement, MySQL

if statement, PHP

else statement

elseif statement

IF-ELSEIF-ELSE statement

IGNORE LINES option

IGNORE option

ignore options, mysqlimport utility

ignore_repeated_errors directive

ignore_repeated_source directive

ignore_user_abort directive, PHP

ignore-lines options, mysqlimport utility

IIS

enabling on Vista

installing on Windows-2nd

PHP authentication and

reasons for installing

unsuitable versions of Windows for

IMAP extension, PHP

enabling

IMAP server

authenticating against

implements keyword, OOP

implicit_flush directive, PHP

implode function

importing data-2nd

LOAD DATA INFILE statement-2nd

choosing target database

data import example

security

loading table data with PHP

mysqlimport utility-2nd

IN clause, MySQL

determining existence with subqueries

IN parameters

include statement, PHP-2nd

in_array function

include function

making unnecessary

setting base path for

include statement, Smarty

include_once function, 2nd

include_path directive

fopen function, 2nd

including PEAR packages within scripts

installing Smarty, 2nd

installing Zend Framework

readfile function

include_php function, Smarty

increment (++) operator

INDEX datatype attribute, MySQL

INDEX privilege

index.php file

index.phtml file

index.tpl template application logic

searching web with Zend_Service_Yahoo, 619

Index_priv column

creating Zend Framework controllers

IndexController.php

indexed arrays

creating arrays with array function

indexes, MySQL-2nd

advantages

Boolean full-text searches

EXPLAIN statement

full text indexes-2nd

log_long_format parameter

normal indexes-2nd

NOT NULL attribute

ORDER BY clause

primary key indexes-2nd

query optimization

reasons for MySQL popularity

rebuilding

searching an index prefix

INFILE keyword

LOAD DATA INFILE statement-2nd

info command, PEAR

information option, myisamchk client

INFORMATION_SCHEMA, MySQL, 2nd-3rd

triggers

viewing view definition

inheritance, OOP, 2nd-3rd

abstract classes

class inheritance-2nd

ini_set function

modifying PHP configuration directives

init_file parameter, MySQL

Innobase Oy

InnoDB storage engine, MySQL

InnoDB tables, MySQL

backing up/restoring

MySQL 4

MySQL system requirements

MySQL transactions, 2nd

sample project-2nd

adding data

executing transaction

participants table

trunks table

verifying InnoDB table availability

with-innodb option

innodb_data_home_dir parameter, MySQL

INOUT parameters

escaping shell metacharacters

input

delimiting input

sanitizing user input

input parameters

setting parameters, MySQL-2nd

input/output functions

safe_mode restrictions

insensitive cursors, MySQL

INSERT command, mysqli extension

INSERT privilege

insert tag, Smarty

insert_banner function, PHP

insert_name function, PHP

Insert_priv column

inserting data, MyISAM tables

install command

downloading Apache manual

PEAR

installations

Apache and PHP

downloading Apache-2nd

downloading PHP-2nd

downloading PHP manual

installing Apache and PHP on Linux-2nd

installing Apache and PHP on Windows-2nd

testing PHP installation-2nd

IIS and PHP on Windows-22, 25

PDO (PHP Data Objects)

Smarty templating engine

SQLite

web host support for third-party software

INSTALL-DIR constant

installing MySQL

instanceof keyword, OOP

instantiation

abstract classes, OOP

integers

Interbase 6

PDO supported databases

interface_exists function

interfaces, OOP-2nd

abstract classes or interfaces

caution using class members

checking if interface exists

general syntax for implementing

encapsulation

implementing multiple interfaces

implementing single interface

implements keyword

naming conventions

internationalization

common country/language code combinations

translating web sites with Gettext-2nd

internet services-2nd

default ports for

getservbyname function

getservbyport function

retrieving port number’s service name

retrieving service’s port number

interoperability, web services

Invalid_Email_Exception class, 2nd

INVOKER setting, MySQL

modifying stored routines

SQL SECURITY characteristic

invoking functions-2nd

ionCube PHP Encoder

IP address based authentication, PHP-2nd

authenticating using login pair and IP address

IP spoofing

IP addresses, domain names and

IP spoofing

IPv4/IPv6Address Record, DNS

is equal to (==) operator

is identical to (===) operator

is not equal to (!=) operator

is_a function

is_array function

is_cached method, Smarty

is_name function

is_subclass_of function

is_uploaded_file function

is_xyz functions, PHP

ISAM storage engine

converting ISAM tables to MyISAM tables

ISAPI support, PHP

isolation

isset function

issuers

iterative statements, MySQL-2nd

isValid method, PEAR

Calendar package

isValidXyz methods

HTTP_Upload class, 2nd

item parameter

foreach function, Smarty

ITERATE statement, MySQL

iv parameter, mcrypt_encrypt function

J

j parameter, date function

Java support, PHP

JavaScript

embedding into Smarty template

JDBC

K

key function, arrays

key parameter

foreach function, Smarty, 2nd

mcrypt_encrypt function

mhash function

KEY_COLUMN_USAGE table

keys

arrays

ssl-key option, mysql client

keywords

highlight.keyword directive, PHP

keywords, OOP

kill command, mysqladmin client

krsort function, arrays

ksort function, arrays

L

L, l parameters, date function

l10n

labels

goto statement

language options category

LANGUAGE SQL characteristic

features of PHP language-2nd

languages

PHP 6 features

languages (foreign) supported

HTTP_Upload class, PEAR

translating web sites with Gettext-2nd

last access time

retrieving file’s last access time

last changed time

retrieving file’s last changed time

last modified time

retrieving file’s last modification time

last-in-first-out (LIFO)

order of element removal

layers

database abstraction layers

LC_MESSAGES directory

localization

LC_XYZ localization categories

LDAP (Lightweight Directory Access Protocol)

access to LDAP server

beginning LDAP

binding to LDAP server-2nd

closing LDAP server connection-2nd

connecting to LDAP server-2nd

counting retrieved entries

deleting LDAP data-2nd

error handling-2nd

converting LDAP error numbers to messages

retrieving most recent error message

retrieving most recent error number

inserting LDAP data-2nd

online resources

retrieving LDAP data-2nd

putting result set into array-2nd

retrieving specific entry-2nd

searching for one or more records-2nd

searching for LDAP data

Secure LDAP (LDAPS)

sorting LDAP records-2nd

updating LDAP data

using LDAP from PHP-2nd

working with Distinguished Name-2nd

converting DN to readable format

loading DN into array-2nd

ldap_add function

ldap_bind function

ldap_close function

ldap_connect function

ldap_count_entries function

ldap_delete function

ldap_dn2ufn function

ldap_err2str function

ldap_errno function

ldap_error function

ldap_explode_dn function

ldap_get_entries function-2nd

ldap_mod_add function

ldap_mod_del function

ldap_mod_replace function

ldap_modify function

ldap_read function

ldap_rename function

ldap_search function-2nd

ldap_set_option function

ldap_sort function

ldap_start_tls function

ldap_unbind function

LDAP_XYZ error codes

LDAPS (Secure LDAP)

LEAVE command

changing Smarty default delimiters

left_delimiter attribute

leftmost prefixing

length parameter, fwrite function

Lerdorf, Rasmus

general language features

history of PHP

less than (<) character

displaying special HTML characters

htmlentities function translating

less than (<, <=) operators

letters

capitalizing first letters, Smarty

lettersonly rule

PEAR: HTML_QuickForm

libraries

class library helper functions

function libraries-2nd

general language features, 2nd

library directory

installing Zend Framework

licensing

MySQL-2nd

SQLite

licensing restrictions

Lightweight Directory Access Protocol see LDAP

LIKE clause

viewing MySQL configuration parameters

LIKE keyword, mysql client

LIMIT clause

creating paged query output

lines

getLine method, exception class

LINES options

LINES TERMINATED BY option

lines-terminated-by option, mysqlimport utility

link tag

using CSS in conjunction with Smarty

Linux

configuring PHP at build time on

Fedora runlevels

installing Apache and PHP on-2nd

installing MySQL on-2nd

installing PEAR on

reconfiguring PHP after MySQL install

Red Hat runlevels

starting MySQL on

automatically on boot-2nd

stopping MySQL on

automatically on shutdown or reboot

list array function

returning multiple values

list command, PEAR

list construct

returning multiple values

list function, array

list function, PHP

literal statement, Smarty

using CSS in conjunction with Smarty

LOAD DATA INFILE statement

M

m modifier, Perl regular expressions

M, m parameters, date function

M parameter, numeric datatypes

Macromedia Dreamweaver MX

choosing code editor

magic_quotes_gpc directive, PHP, 2nd

magic_quotes_runtime directive, PHP, 2nd, 3rd

magic_quotes_sybase directive, PHP

parameters

magic quotes, enabling

MagpieRSS-2nd

aggregating feeds-2nd

limiting number of displayed headlines

parsing feeds-2nd

rendering retrieved feed-2nd

Mail Exchange Record, DNS

Mail package, PEAR

sending e-mail attachments

sending e-mail with multiple recipients

sending HTML formatted e-mail

Mail Transfer Agent see MTA

mail function, 2nd

N

n escape sequence

n parameter, date function

name atribute, $_FILES superglobal

name directive

name parameter, Smarty

foreach function

insert tag

section function

Name Server Record, DNS

name variable, $_FILES array

named parameters

prepared statements, PDO, 2nd

named pipes protocol, mysql client

Naming Authority Pointer, DNS

naming conventions

before and after triggers

interfaces, OOP

mysqli extension

POST variables

NAPTR (Naming Authority Pointer), DNS

natcasesort function, arrays

NATIONAL attribute, MySQL

CHAR/VARCHAR datatypes

natsort function, arrays

Nebel, Ernesto

nesting functions

Net_SMTP package, PEAR

Net_Socket package, PEAR

Netcraft

networking-2nd

creating port scanner with NMap

creating subnet converter-2nd

pinging server-2nd

skip-networking parameter, MySQL, 2nd

testing user bandwidth-2nd

network-specific functionality-2nd

calculating network bandwidth

creating port scanner with NMap

creating subnet converter-2nd

DNS (Domain Name System)

e-mail

establishing socket connections-2nd

internet services-2nd

pinging server-2nd

testing user bandwidth-2nd

new keyword

class instantiation

objects, OOP

newline characters

converting into HTML break tag

escape sequences, PHP

ignoring

recognizing

NewsController.php

searching web with Zend_Service_Yahoo, 618

next function, arrays

NitroSecurity

nl2br function

Nmap (network mapper) tool

NO SQL characteristic

no-auto-rehash option, mysql client

no-beep option, mysql client

nocache value

session.cache_limiter directive, 2nd

no-column-names option, mysql client

no-defaults option, mysqlxyz clients

none value

session.cache_limiter directive

nonzero rule, HTML_QuickForm

nopunctuation rule, HTML_QuickForm

normal indexes, MySQL-2nd

leftmost prefixing

multiple-column normal indexes

single-column normal indexes

NOT (!) operator

NOT (~) bitwise operator

NOT (~) logical operator

NOT DETERMINISTIC characteristic, MySQL

NOT FOUND condition, MySQL

NOT NULL attribute, MySQL, 2nd

notee option, mysql client, 2nd

Notepad++

choosing code editor

NS (Name Server Record) record type, DNS, 2nd

NULL attribute

ENUM datatype, MySQL

NULL character

binary data, SQLite

NULL datatype attribute, MySQL

NULL values

primary key indexes, MySQL

nulls

PDO_ATTR_ORACLE_NULLS option

num_args parameter, sqlite_create_aggregate function

num_rows method, mysqli, 2nd

number_format function

number_rows component, LIMIT clause

numbers

localized formats

localizing-2nd

Numbers_Roman package, PEAR

numeric datatypes, MySQL-2nd

constraining maximum display size

digits following decimal point

numeric rule, HTML_QuickForm

numerical arrays

numerical keys

O

%o type specifier

o option, mysqlcheck client

O parameter, date function

ob_gzhandler function

object cloning, OOP, 2nd-3rd

object-oriented programming-192, 193-211

abstract classes, 2nd-3rd

abstract keyword

autoloading objects-2nd

benefits of OOP-2nd

class definition and instantiation

features not supported by PHP

fields-2nd

general language features

helper functions-2nd

implements keyword

inheritance, 193, 198-203

object cloning, 2nd-3rd

static class members-2nd

type hinting

objects, OOP

P

P command, mysql client

P, p options, mysql client

P, p options, mysqlxyz clients, 2nd

packages, PEAR-2nd

page caching

paged output, MySQL

creating-2nd

determining current page number

determining total number of pages

determining total number of rows

entries per page

introduction

LIMIT clause

listing page numbers-2nd

offset for recordstart point

previous and next links

row offset

sample output

total rows in result set

pageLinks method, MySQL

pager option, mysql client

pagesize variable, MySQL

paging output, mysql client

parameter variable, MySQL

parameters

Q

quantifiers

Perl regular expressions

POSIX regular expressions-2nd

queries, MySQL

R

escape sequence

r, r+ file access modes

r option

myisamchk client

mysqlcheck client

r parameter, date function

random values

returning random keys from arrays

range function, arrays

rangelength rule, HTML_QuickForm

readdir function

readfile function

reading

reading directory contents, 2nd

reading files-2nd

ignoring newline characters

reading CSV file into array

reading entire file

reading file in predefined format

reading file into array

reading file into string

reading single character

reading specific number of characters

stripping HTML and PHP tags from input

read-only cursors, MySQL

READS SQL DATA characteristic

real numbers see float datatype

Real Simple Syndication see RSS

realpath function

recover option, myisamchk client

recovery, InnoDB tables

recursive functions, 2nd-3rd

Red Hat

runlevels

reference

allow_call_time_pass_reference directive

passing arguments by

reference assignment

variable declaration, PHP

REFERENCES privilege

References_priv column

reasons for using triggers

referential integrity

REFERENTIAL_CONSTRAINTS table

referer_check directive

referers

validating sessions using

refresh command, mysqladmin client

regedit script

regex rule, HTML_QuickForm

region method, Validate_US package

register_argc_argv directive

register_globals directive, 2nd

register_long_arrays directive

registry

executing PEAR_ENV.reg file

regular expressions-2nd

alternatives to regular expression functions-2nd

converting string characters into bracketed expressions

performing search, case-insensitive-2nd

performing search, case-sensitive-2nd

Perl Compatible Regular Expressions library

PHP functions-2nd

pipe (|) operator

replacing text, case-insensitive

replacing text, case-sensitive

splitting string into elements, case-insensitive

splitting string into elements, case-sensitive

regular expressions, Perl-2nd

compatible PHP regular expression functions-2nd

preg_match_all function

preg_quote function

preg_replace function

preg_replace_callback function

preg_split function

quantifiers

regular expressions, POSIX-2nd

brackets ([])

characters based on frequency or position

PHP regular expression functions-2nd

predefined character ranges (character classes)-235

quantifiers-2nd

reload command, mysqladmin client

RELOAD privilege

Reload_priv column, user table, 2nd

REMOTE_ADDR, $_SERVER superglobal, 2nd

rename function

RENAME USER command, MySQL

render method

rendering retrieved feed, MagpieRSS

REPAIR TABLE command, MySQL

REPEAT statement, MySQL

Repl_client_priv column, user table, 2nd

Repl_slave_priv column, user table, 2nd

REPLACE option

replace option, mysqlimport utility

replace parameter, header function

replication

backing up InnoDB tables

mysqli

reasons for MySQL popularity

REPLICATION CLIENT privilege

REPLICATION SLAVE privilege

reporting sensitivity level, errors

$_REQUEST superglobal

retrieving cookie information

request authorization see authorization

request verification see authorization

REQUEST_URI, $_SERVER superglobal

REQUIRE CIPHER option

require function

making unnecessary

setting base path for

require statement, Smarty

REQUIRE SSL option

REQUIRE SUBJECT option

REQUIRE X509 option

require statement, PHP

require_once function, PHP, 2nd

require_once statement

required rule, HTML_QuickForm, 2nd, 3rd

reset function, arrays

resource directives, PHP-2nd

resource handling see file handling

resource limits category

limiting user resources-2nd

resources

RESTRICT keyword, MySQL

result sets

iterating with cursors-2nd

manipulating result set pointer, SQLite-2nd

determining if end of result set is reached

moving pointer forward

moving pointer to first row

moving pointer to specific row

retrieving row at current pointer

MySQL triggers and

parsing, SQLite-2nd

retrieving first column in result set

retrieving result set details, SQLite-2nd

field names

number of affected rows

number of columns in result set

number of rows in result set

retrieving select result set columns

returning result set as associative array-2nd

sqlite_current function

sqlite_has_more function

sqlite_next function

sqlite_query function

sqlite_rewind function

sqlite_seek function

starting index offset for

result_type parameter

sqlite_fetch_array function

sqlite_query function

sqlite_unbuffered_query function

resultmode parameter, query method

results

binding, mysqli

bound results, mysqli

customizing view results, MySQL

paged results, MySQL

return keyword/statement

returning values from functions-2nd

returning multiple values-2nd

return parameters, MySQL-2nd

reusing software, web services

REVOKE command, MySQL

access privileges managed by, 2nd

deleting users

revoking column-level privileges

revoking previously assigned privileges

revoking table-level permissions

syntax

tips when working with

user and privilege management-2nd

rewind function

right_delimiter attribute

changing Smarty default delimiters

rmdir function

rollback

database transactions

InnoDB tables example, 2nd

MySQL transactions tips

rollback method

mysqli

PDO

Roman numerals

converting numeral formats

root

chroot option, mysqld daemon

doc_root directive, 2nd

DocumentRoot directive, Apache

hiding sensitive data

root user password, MySQL

Routine_name column, procs_priv table

Routine_type column, procs_priv table

ROUTINES table

routines, MySQL see stored routines, MySQL

rowCount method, PDO

rows

creating more readable row output with HTML_Table

retrieving number of affected rows

retrieving number of rows in result set

retrieving row at current pointer position

sqlite_changes function

sqlite_last_insert_rowid function

sqlite_num_rows function

rows, MySQL

inserting rows via views

retrieving multiple rows

rows, mysqli extension

determining rows selected/affected

RPM

installing MySQL on Linux-2nd

learning more about

uninstalling MySQL on Linux

rsort function, arrays

RSS (Real Simple Syndication)-519

RSS feeds

aggregating feeds, MagpieRSS-2nd

parsing feeds, MagpieRSS-2nd

popular aggregators

publication of RSS feeds

rendering retrieved feed, MagpieRSS-2nd

rtrim function

Ruby on Rails

rules, HTML_QuickForm-2nd

enforcing filters and rules-2nd

runlevels

Red Hat/Fedora

S

%s type specifier

S, s metacharacters, Perl regular expressions

s modifier, Perl regular expressions

s option

mysql client

mysqlxyz clients, 2nd

S, s parameters, date function

s type code, data types

safe_mode directive, 2nd-3rd

configuring PHP securely-2nd

functions/variables/directives affected by

restrictions when enabled

sql.safe_mode directive

safe_mode_allowed_env_vars directive, 2nd

safe_mode_exec_dir directive, 2nd

safe_mode_gid directive, 2nd

safe_mode_include_dir directive, 2nd

safe_mode_protected_env_vars directive, 2nd

safe-updates option, mysql client, 2nd

safe-user-create option, mysqld daemon

sales table, creating, 2nd

Savant Template System

save_handler directive

save_path directive

scalability

database based authentication

PHP 4 features

scalar datatypes

scandir function

schema command, SQLite

schema, MySQL

INFORMATION_SCHEMA-728, 857

SCHEMA_PRIVILEGES table

scope

modifying PHP configuration directives

scope attribute

config_load function, Smarty

scope, functions

passing arguments by reference

passing arguments by value-2nd

return statement

scope, PHP variables-2nd

script parameter

script tag

embedding PHP code in web pages

scripting

cross-site scripting

scripts directory

Boolean full-text searches

searches, MySQL, 2nd-3rd

extending search capabilities

full-text search-2nd

simple search interface

text searching

searching

ldap_read function

ldap_search function-2nd

sec value, gettimeofday function

seconds since Unix epoch value

seconds value, getdate function

section attribute

config_load function, Smarty

section function, Smarty

sectionelse function, Smarty

sections

configuration files, Smarty

Secure LDAP (LDAPS)

Secure Sockets Layer (SSL)

HTTP authentication

security

T

escape sequence

t file access mode

T option, mysql client

T parameter, date function

t parameter, date function, 2nd

table attributes see datatype attributes, MySQL

table handlers, MySQL

table indexing see indexes, MySQL

TABLE_CONSTRAINTS table

Table_name column

columns_priv table

tables_priv table

Table_priv column, tables_priv table

TABLE_PRIVILEGES table

tables

changing table structure

copying

creating table from database data with HTML_Table

creating

creating tables conditionally

creating temporary tables

default-table-type parameter, MySQL

deleting

flush-tables command, mysqladmin client

granting multiple table-level privileges

granting table-level privileges

INFORMATION_SCHEMA

loading table data with PHP

MySQL storage engines-2nd

partitioning, MySQL 5.1

privilege verification process

proc table, MySQL stored routines

procs_priv table, MySQL stored routines

refresh command, mysqladmin client

retrieving table’s column types

revoking table-level privileges

sales table

sqlite_fetch_column_types function

TIMESTAMP definitions, 2nd

updating tables via views

viewing available tables

viewing table structure

virtual tables see views, MySQL

TABLES table

tables_priv table

access control/authorization

columns, table listing of

MySQL access privilege system, 2nd

User/Host/Db triplet in db table

tableset

tabular date classes

tabular output, MySQL, 2nd

tabular_output method, mysqli class

sorting query results

U

%u type specifier

U modifier, Perl regular expressions

U option, mysql client

u option, mysqlxyz clients

U parameter, date function

ucfirst function

ucwords function

UID/GID checks

safe_mode_include_dir directive, PHP

UNDEFINED algorithm, MySQL

Unicode

UNICODE attribute

CHAR datatype, MySQL

Unicode support

uninstall command, PEAR

uniqid function

UNIQUE datatype attribute, MySQL

unique indexes, MySQL-2nd

uniqueness, MySQL

indexes

PRIMARY KEY attribute

primary key indexes, 2nd

unit tests, facilitating

Unix epoch

Unix timestamp

unserialize_callback_func directive

unset function

UPDATE command, mysqli extension

Update_priv column

updates

sqlite_changes function

upgrade command, PEAR

upgrade-all command, PEAR

upgrading PEAR packages-2nd

upload error messages, PHP-2nd

UPLOAD_ERR_XYZ status code

error variable, $_FILES array, 2nd

retrieving files upload info. using POST

upload_max_filesize directive, PHP

upload_tmp_dir directive, PHP

uploading files-2nd

PEAR: HTTP_Upload class-2nd

uploading files via HTTP-2nd

uploading files with PHP-2nd

$_FILES superglobal array-2nd

determining if file was uploaded

file upload directives-2nd

file upload functions-2nd

is_uploaded_file function

move_uploaded_file function

permissions

specifying MIME type of file

specifying name/size of file

upload error messages-2nd

upper character class

uppercase

converting string to all uppercase

uri parameter, SoapClient constructor

URL rewriting

automating

choosing cookies or

referer_check directive

retrieving session name

SID persistence using

use_trans_sid directive

web host restrictions placed on .htaccess file

URLs

arg_separator.output directive, PHP

global scope of variables

one time URLs

one-time URL generator

recovering/resetting passwords-2nd

USAGE privilege

USE command

designating database, MySQL

mysql client connection options

setting target database

using mysql in interactive mode

use_cookies directive

use_include_path parameter

fopen function

readfile function

use_trans_sid directive

usec value, gettimeofday function

used space, disk partition

user accounts on server

MySQL security

user authentication

authenticating against MySQL database

database based authentication

HTTP authentication-2nd

IP address based authentication

PHP authentication-2nd

user login administration-2nd

user bandwidth, testing-2nd

User column

user defined session handlers-2nd

user identification

user@host combination

user input

converting into HTML entities

cross-site scripting

escaping shell arguments

file deletion risk

insecure user input

sanitizing user input-2nd

PEAR: Validate package-2nd

stripping tags from

user login administration-2nd

recovering/resetting passwords-2nd

testing password guessability-2nd

user option

mysqlimport utility

mysqlxyz clients

user parameter, MySQL

user privilege columns, user table

user privileges, MySQL

user profiles

ignore_user_abort directive, PHP

user table

authentication/authorization

Alter_priv column

Alter_routine_priv column

columns, table listing of

Create_priv column

Create_routine_priv column

Create_tmp_table_priv column

Create_user_priv column

Create_view_priv column

Lock_tables_priv column

max_connections column

max_questions column

max_updates column

max_user_connections column

MySQL access privilege system-2nd

Password column

Process_priv column

References_priv column

Reload_priv column

Repl_client_priv column

Repl_slave_priv column

Select_priv column

Show_db_priv column

Show_view_priv column

user privilege columns

user_agent directive

user_dir directive, 2nd

USER_PRIVILEGES table

userauth table see user authentication

User/Host/Db triplet, db table

userfile

users

auto login, session handling

CREATE USER command

DROP USER command

GRANT command

limiting user resources-2nd

MySQL access privilege system

MySQL user and privilege management-2nd

PHP_AUTH_USER authentication variable

resetting user password

REVOKE command deleting

safe-user-create option, mysqld daemon

simultaneous connections for users

usort function, arrays-2nd

UTC (Coordinated Universal Time)

V

V, v options, mysqlxyz clients

validate method, HTML_QuickForm class

Validate package, PEAR-2nd

validating e-mail addresses

validating strings

Validate_US package, PEAR-2nd

Validate package, PEAR-2nd

methods

using-2nd

validation

reasons for using triggers

validating dates

validating dates and time

validating e-mail addresses

validating form input-2nd

validating strings

validation classes

passing arguments by value-2nd

validation rules

HTML_QuickForm, PEAR

value

value assignment

variable declaration, PHP

values

assigning default value, Smarty

default argument values-2nd

returning values from functions-2nd

var keyword, OOP

var parameter

insert tag, Smarty

VARCHAR datatype, MySQL

BINARY attribute

NATIONAL attribute

variable modifiers, Smarty-2nd

variables

authentication variables, PHP

binding variables, mysqli

Boolean

configuration files, MySQL

declaring variables, MySQL

destroying variables

handling external variables

PHP-2nd

setting variables, MySQL-2nd

superglobal variables, PHP-2nd

testing if variable is an array

variable declaration, PHP

explicit declaration

reference assignment

value assignment

variable scope, PHP-2nd

variable variables, PHP

variables command, mysqladmin client

variables_order configuration directive

variables_order directive

vehicles table

verbose option

mysqlimport utility

mysqlxyz clients

version command, mysqladmin client

version option

vertical option, mysql client

view, MVC

views

creating Zend Framework web site

searching web with Zend_Service_Yahoo

creating views-2nd

views directory

incorporating into Web applications-2nd

VIEWS table

views, MySQL-2nd

advantages of using

ALGORITHM attribute-2nd

customizing view results

DEFINER clause

deleting views

encapsulating queries

executing-2nd

passing in parameters

inserting rows via views

modifying returned column names

modifying view definition

MySQL 5.0

SQL_SECURITY clause

triggers and

updating tables via views

using clauses with

using functions with

version support for

view columns containing expressions

viewing view definition

DESCRIBE statement

INFORMATION_SCHEMA database

SHOW CREATE VIEW command

WITH CHECK OPTION clause

virtual private server hosting

virtual tables, MySQL see views, MySQL

virtualization

Vista

enabling IIS on Vista

W

W, w metacharacters, Perl regular expressions

w, w+ file access modes

W option, mysqlxyz clients

W, w parameters, date function

w3schools web site

wday value, getdate function

web

incorporating views into-2nd

web applications

integrating stored routines-2nd

integrating triggers into-2nd

web browsers

outputting data to-2nd

web forms-2nd

forms tutorials online

passing data between scripts

passing form data to function-2nd

PEAR: HTML_QuickForm-2nd

validating form data in functions

working with multivalued form components-2nd

web frameworks

web hosting

web hosting providers

choosing-2nd

database versions offered by

dedicated server hosting

PHP file extensions supported by

PHP software offered by default by

PHP versions offered by

questions for prospective web host-2nd

restrictions placed on Apache .htaccess files by

restrictions placed on PHP-enabled scripts by

shared server hosting

specific web framework support offered

virtual private server hosting

web pages

displaying modification date

embedding PHP code in web pages-2nd

web servers

X

%X, %x type specifiers

x escape sequence

x modifier, Perl regular expressions

X option, mysql client, 2nd

X509

REQUIRE X509 option

x509_issuer column, user table

x509_subject column, user table

XAMPP

xdigit character class

xgettext command

XML

GNOME XML library

outputting mysql query results in

XML document

xml option, mysql client, 2nd

XML support, PHP

XML_Parser package, PEAR

XOR (^) bitwise operator

XOR operator

xpath method, SimpleXML

Y

Y parameter, date function

y2k_compliance directive, PHP

Yahoo

prominent MySQL users

yday value, getdate function

Yawp

YEAR datatype, MySQL

year value, getdate function

you.phtml view

creating Zend Framework web site

Z

Z, z parameters, date function

zcontext parameter, fopen function

Zend Framework-2nd

components

creating web site-2nd

creating controllers-2nd

creating directory structure-2nd

creating front-end controller-2nd

creating views-2nd

downloading and installing-2nd

securing connection information, mysqli

creating controller-2nd

creating views-2nd

Zend Guard

Zend scripting engine

Zend Studio

choosing code editor

zend.ze1_compatibility_mode directive

Zend_Amazon component

Zend_Cache component

Zend_Config component

Zend_Controller component

Zend_Db component

Zend_Feed component

Zend_Filter component

Zend_Filter_Input component

Zend_Gdata component

Zend_HTTP_Client component

Zend_Search_Lucene component

Zend_Service_Amazon component

Zend_Service_Flickr component

Zend_Service_Yahoo component