Sams Teach Yourself PHP, MySQL and Apache All in One (3rd Edition)

Index

[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]

%T format string option (DATE FORMAT() function)

%T formatting directive

table type variable

tables

     auth users

     cache parameters

     calendar example

     columns priv

    creating

         CREATE TABLE command

         CROSS JOIN command

         DELETE command

         INSERT command

         JOIN command

         LEFT JOIN command

         LIMIT command

         NATURAL JOIN command

         primary/unique keys

         REPLACE command

         RIGHT JOIN command

         SELECT command 2nd

         STRAIGHT JOIN command

         UPDATE command

         WHERE clause

    custom logs

         code snippet

         sample reports

     db

     flat

     host

     OPTIMIZE TABLE command

    relationships

         many-to-many

         one-to-many

         one-to-one

    shopping cart database table example

         cart, adding items to

         cart, removing items from

         cart, viewing

         checkout actions, performing

         checkout form, creating

         field lengths

         field names

         integrating with storefront

     SHOW COLUMNS

     SHOW CREATE TABLE

     SHOW CREATE TABLE command

     SHOW INDEX

     SHOW OPEN TABLES command

     SHOW STATUS

     SHOW TABLE STATUS

     SHOW VARIABLES

    storefront database table example

         add to cart button

         cat id field

         categories of items, displaying

         planning process

         store categories field

         store item color field 2nd

         store item size field

         store items field

     tables priv

     telephone, online address books

     user

tags

     ASP

     end tags

     Script

     short

     short open tag switch

     standard

     start tags

     start/end

     strip tags() function

     XML

tagWrap() function

tail command-line utility, monitoring error logs (Unix)

tar command 2nd

tarball, uncompressing Apache source code

targets, configure script

telephone tables, online address books

ternary (?) operators

test() function

testing

     data types 2nd

     dates

    functions

         existence

         file validation

     PHP installs

text

     editors, modifying httpd.conf files

     wrapping

TEXT data type

Thawte, CA (certification authority)

third normal forms

time

     calendar

         event additions

         HTML form

         library, creating

         table, creating

         user input

     CURRENT TIME() function

     CURRENT TIMESTAMP() function

     current, retrieving

     CURTIME() function

     formatting

     functions, web resources

     HH-MM-SS format

     HOUR() function

     information, retrieving

     MINUTE() function

     NOW() function

     SEC TO TIME() function

     SECOND() function

     TIME data type

     TIME FORMAT() function

     TIME TO SEC() function

     time() function 2nd

     TIMESTAMP data type

     UNIX TIMESTAMP() function

time stamps

TimeOut directive, Apache performance

TINYBLOB data type

TINYINT data type

TINYTEXT data type

TITLE element

TLS (Transport Layer Security)

/tmp directory

tokenizing strings

topic lists/posts, dispaling in discussion forums

touch() function, file creation

tracking

     client requests, access logs

     clients, troubleshooting

transactions

     COMMIT command

     examples of

     ROLLBACK command

     syntax of

TransferLog directive

transmitted data, reducing (Apache performance)

transparent images

TRIM() function 2nd

trimming functions

Triple-Des, symmetric cryptography

troubleshooting

     Apache startups

     clients, tracking

     installs

     MySQL installs

     servers, starting (SSL configurations)

$txt variable

TYPE argument

type specifiers

Typical installation option (MySQL Setup Wizard)