Index: D

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: D

data

inserting: 3.5.1. Inserting Data

INSERT INTO ... SELECT statement and: 3.8.3. INSERTing with a SELECT Statement

outputting with echo/print statements: 2.1.1.3. Outputting data with echo and print

passing for queries: 5.1. User Input

tainted: 5.1.4. Security and User Data

web security for: 9.5. Protecting Data on the Web

working with: 3.5. Inserting, Updating, and Deleting Data

writing to databases: 1.5.2.3. Data entry and saving records to a database

6. Writing to Web Databases

data-access module: 1.4.1. Database Management Systems

Data Definition Language (DDL): 1.4.4.2. SQL components

data entry, script for: 10.2.2. The Customer <form>

Data Manipulation Language (DML): 1.4.4.2. SQL components

data versioning: 6.2.3.3. The table-level locking paradigm in MySQL

database deletes: 6.1. Database Inserts, Updates, and Deletes

6.1.3. Inserting, Updating, and Deleting Data
6.1.3.5. Deleting data

database-driven querying: 1.5.2.1. Database-driven querying

(see also querying, database-driven)

database inserts: 6.1. Database Inserts, Updates, and Deletes

6.1.3. Inserting, Updating, and Deleting Data
sample script for: 6.1.3.4. Case study: Inserts and updates in practice

database management system: 1.1. Three-Tier Architectures

(see also DBMS)

database recovery: 6.2.3.5. What isn't covered here

database tier: 1.1. Three-Tier Architectures

1.4. The Database Tier
managing sessions in: D. Managing Sessions in the Database Tier
resources for further reading: E.3. Database Tier Resources
storing session variables in: 8.5.2.1. Need for centralized session store

database updates: 6.1. Database Inserts, Updates, and Deletes

6.1.3. Inserting, Updating, and Deleting Data
6.1.3.3. Updating data
sample script for: 6.1.3.4. Case study: Inserts and updates in practice

database writes: 6. Writing to Web Databases

databases: 1.4.1. Database Management Systems

1.4.1. Database Management Systems
3.1.2. Terminology
creating: 3.4.1. Creating Databases
displaying structure of with SHOW command: 3.4.4. Displaying Database Structure with SHOW
inserting uploaded files into: 6.1.2. Uploading and Inserting Files into Databases
migrating data and: 3.5.1.2. Transferring data between databases and DBMSs
non-MySQL, accessing: 4.4. Interacting with Other DBMSs Using PHP
vs. spreadsheets: 1.4.2. Why Use a DBMS?
terminology for: 3.1. Database Basics
using for authentication: 9.3. Authentication Using a Database
writing to: 6. Writing to Web Databases

datatypes: 3.4.2. Creating Tables

date( ): 2.8.2. Formatting a Date

7.2.1.1. Validating dates

date and time: 2.8. Date and Time Functions

dates, validating: 7.2.1.1. Validating dates
SQL functions for: 3.9.1.3. Date and time functions

db.inc include file: 4.2.1. Using Include Files in Practice

10.4. The Winestore Include Files
clean( ) in: 5.1.4. Security and User Data

DBMS (database management system): 1.1. Three-Tier Architectures

1.1. Three-Tier Architectures
1.4.1. Database Management Systems
3. MySQL and SQL
components of: 1.4.1. Database Management Systems
migrating data and: 3.5.1.2. Transferring data between databases and DBMSs
modifying: 3.8. Modifying the Database
reasons for using: 1.4.2. Why Use a DBMS?

DDL (Data Definition Language): 1.4.4.2. SQL components

deadlock problem: 6.2.2.2. The LOCK TABLES and UNLOCK TABLES statements in MySQL

debugging

equality operator vs. assignment operator and: 2.2.3. Conditional Expressions
flush( ) and: 2.12.1. A Page That Produces Partial or No Output
PHP scripts: 2.12. Common Mistakes
print_r( )/var_dump( ) for: 2.1.7.1. Debugging with print_r( ) and var_dump( )

decode( ): 9.3.1.1. Encrypting other data in a database

DELETE statement

limitations of: 3.10.4. Limitations of MySQL
vs. DROP statement: 3.5.2. Deleting Data
WHERE clause and: 3.6.2. WHERE Clauses

deletes: 6.1. Database Inserts, Updates, and Deletes

(see also database deletes)

deleting

data: 3.5.2. Deleting Data
indexes: 3.4.3. Altering Tables and Indexes
users: 3.10.3. Adding and Deleting Users

DES encryption method: 9.3. Authentication Using a Database

die( ): 4.1.4. Error Handling of MySQL Database Functions

digital certificates: 9.5.1.4. Certificates and Certification Authorities

dirty read problem: 6.2.1. Transactions and Concurrency

12.1. Finalizing Orders

displayCart( ): 11.2.1. Viewing the Shopping Cart

displayWines( ): 4.2. Formatting Results

displayWinesList( ): 5.2. Querying with User Input

DISTINCT clause: 3.6.3.4. DISTINCT

3.7.2.3. Using DISTINCT in joins

DML (Data Manipulation Language): 1.4.4.2. SQL components

doublevalue( ): 2.10.2. Variable Scope

do...while loop: 2.3.2. do...while

downloads: A. Installation Guide

Apache server: 1.3.1.1. The Apache HTTP server, Version 1.3

A.1.3. Installing Apache

ApacheSSL: A.3. Installing Apache to Use SSL

mod_ssl: A.3. Installing Apache to Use SSL

MySQL: A.1.1. Installing MySQL

OpenSSL: A.3.1. Installing OpenSSL

PHP: A.1.4. Installing PHP

sample scripts for: A.2. Installing the Winestore Examples

DROP DATABASE statement: 3.5.1.2. Transferring data between databases and DBMSs

DROP INDEX statement: 3.4.3. Altering Tables and Indexes

DROP TABLE statement: 3.5.2. Deleting Data

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