Sams Teach Yourself PHP, MySQL and Apache All in One (4th 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]

s format code (date() function)

S format code (date() function) s type specifierSatisy all directive    access methods         combining

Satisy any directive

    access methods

         combiningSatisy directive

    access methods         combiningsaving

     function state between calls 2nd 3rd

    state

         hidden fields 2nd 3rd

scalability 2nd 3rd 4thscalabiltiy

     operating system limits

         external process control 2nd 3rd         file descriptors         server processes 2nd

    performance-related settings         file system access 2nd 3rd         network and status settings 2nd

     settings 2nd 3rd

ScanErrLog

    programs

         monitoring error logs

schemas

     directives

scope

     function variables 2nd 3rd

scoreboard file

scoreboard files

    file system access

         scalability

ScoreBoardFile directive

screen savers Script tags ScriptAlias directive (mass virtual hosting)

scripts

     apachectl    config

         OpenSSL library;installing

     configure 2nd         PHP installatoin

    configure scripts         makefiles

         targets     file upload 2nd 3rd 4th 5th 6th     PHP 2nd 3rd    split-file Perl         logs;splitting

scripts and input forms

     discussion forums 2nd 3rd 4th 5th 6th 7th

SEC TO TIME() functionsecond normal forms

     rules for 2nd 3rd SECOND() function 2nd 3rd 4thseconds key

     getdate() function

sections. [See also containers]

secure HTTP

secure servers    certificates

         managing 2nd 3rd 4th

    SSL         configuring     SSL protocols 2nd 3rd 4th 5th 6th

Secure Sockets Layer. [See SSL]security     access control

    authentication

         digital certificates 2nd 3rd 4th 5th 6th

         discussed

         need for

     basic authentication

     cerficates

         key pairs 2nd 3rd

         self-signed 2nd

         signing requests 2nd 3rd

    communciations

         integrity

     confidentiality

         public key cryptography 2nd

         SSL protocols         symmetric cryptography 2nd     digest authentication

     encryption

         decryption    integrity

         digest algorithms

         message digests     lock screen mechanism

    MySQL         connections, securing 2nd 3rd

         server startup procedures 2nd 3rd 4th     need for     reverse DNS lookups     SSH    SSL

         configuration 2nd

         mod ssl Apache Module

         OpenSSL 2nd 3rd 4th    SSL (Secure Sockets Layer)

         protocols (secure servers) 2nd     symbolic links (symlinks)     TLS (Transport Layer Security) 2nd

security issues

     software upgrades

SELECT command 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th

SELECT statement 2ndselecting

     variable names 2nd

self-signed certificates (managing certificates) 2ndsemi-colons ()     do\#201while statements

semicolon (     ) 2nd 3rdsemicolons (

     )

sending

     mail 2nd 3rd 4th 5th 6th 7th

    signals

         kill command

sending mail

    form submission

         form creation 2nd 3rd

         HTML formatted mail 2nd

         mail() function 2nd 3rd 4th

         sctipt creation 2nd 3rd 4th 5th

    on form submission

         creating script to send 2nd 3rd 4th 5th

         form creation 2nd 3rd         formatting with HTML 2nd 3rd         mail() function 2nd 3rd 4th

serialize() function

server binary     commands 2nd 3rd 4th

server environment

    commands         running with exec() function 2nd 3rd 4th

         running with passthru() function         running with system() function 2nd 3rd 4th 5th

    pipes         opening to and from processes 2nd 3rd 4th 5th 6th 7th 8thserver headers     froms ServerAlias directive (syntax)

ServerName directive

     configuration files

ServerName directives     documentation

ServerRoot directive     Apache configurationservers

    loads

         distributing (performance)

    MySQL

         shutting down    virtual servers

         specifying (<VirtualHost> directive container)

    Web servers         Apache installations (Windows)servers (existing)

     troubleshooting Service iconservices

    Apache

         installing

session IDs

     passing in query strings 2nd

session set save handler() function

session start() function

session variables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

     multiple, registering

session_destroy() function 2nd 3rd 4th 5th

session_id() function

session_save_path() function

session_start() function 2nd 3rd

sessions

     destroying 2nd 3rd 4th 5th     overview     session set save handler() function

     starting 2nd 3rd 4th

     storing arrays in     user preferences 2nd

    variables

         removing     with registered users 2nd

set time limit() function Set-Cookie header

setcookie() function 2nd 3rd 4th setDate array() function 2nd 3rd setDate global() function 2ndsettings    network settings

         performance

     network settings (scalability)

     scalability 2nd 3rd     status settings (scalability)

settype() function 2nd 3rd 4th 5th setup.exe application setup.exe file

setYearEnd() function

setYearStart() function

SHA

     digest algorithmsshading effects

     pie charts

shapes     drawing 2nd 3rd 4th 5th 6thshopping cart database table example

     cart, adding items to 2nd 3rd 4th     cart, removing items from 2nd 3rd     cart, viewing 2nd 3rd 4th 5th 6th

     checkout actions, performing 2nd 3rd 4th

     checkout form, creating 2nd 3rd

     field lengths

     field names 2nd 3rd 4th 5th 6th

     integrating with storefront 2nd 3rd 4th 5th 6th 7th

short open tag switch

short tags 2nd

shortcuts

    commands

         apache.exe

SHOW COLUMNS command

SHOW command

SHOW CREATE TABLE command 2nd

SHOW DATABASES command SHOW GRANTS command 2nd SHOW INDEX command 2nd

SHOW OPEN TABLES command

SHOW STATUS command 2nd 3rd SHOW TABLE STATUS command 2nd 3rd 4th

SHOW TABLES command

SHOW VARIABLES command 2nd 3rdshuffle() function

     arraysshut down

     MySQL server SHUTDOWN commandsignals    sending         kill command

signatures

     certificates

signed data types signing requests, certificates 2nd 3rd

single quotation marks (\#212) single-byte character sets single-line comments

size attribute

size of files, determining 2nd

sizeof() function

     arrays skipping iterations (loops) 2nd 3rd

slash (/)

     division operator (/) slow queries status variable SMALLINT data type

software     configuring (Apache installations) 2nd 3rd 4th 5th software load balancer (performance)

software upgrades

     Apache 2nd 3rd

         modifying without upgrading 2nd

     Apache News and Announcements list

     changlogs

     maintenance releases

     MySQL 2nd

     MySQL Announcements list

     PHP 2nd

         when to upgrade

     PHP Announcements list

     security issues

     staying current 2nd

     when to upgrade 2nd 3rd 4thSolaris    file descriptors

         operating systems (scalability)

    server processes         operating systems (scalability)

source code

     Apache installation 2nd     downloading (Apache installations)

     uncompressing (Apache installations) 2ndspaces (HTML documents)

     viewing specifiers (strings) 2nd 3rd 4thspecifying     virtual servers (<VirtualHost> directive container)split-file Perl script

    logs

         splitting

spliting     logs

splitting     logs (merging) sprintf() function 2nd

SQLite database engine (new feature)

SSH

SSL

     configuring (secure servers)     digital certificates 2nd 3rd 4th

     installing

         mod ssl module 2nd         OpenSSL library     mod ssl module

    OpenSSL         installing         installing;Linux/Unix

         installing;Windows 2nd

    protocols

         authentication 2nd 3rd

         authentication (connections) 2nd

         confidentiality 2nd 3rd

         confidentiality (public key cryptography) 2nd

     protocols (secure servers) 2nd 3rd 4th 5th 6th

    protocos

         encryption

SSL (Secure Sockets Layer) 2nd 3rd

SSL protocols

    confidentiality

         symmetric cryptography 2nd

SSLCertificateFile directive    SSL configuations         certificates and keys

SSLeay library

stacking images 2nd 3rd standard tags

staring

    Apache         configuration file checks 2nd 3rd

Start Apache linkStart menu commands

     Control Apache start tags 2nd 3rd 4th 5thstarting     Apache 2nd         on Linux/Unix

         on Windows

     Apache (manually)

     block of statements 2nd     MySQL 2nd 3rd 4th

     sessions 2nd 3rd 4thstartup     MySQL

         key buffer size parameter 2nd 3rd

         table cache parameter 2nd 3rd

state

    functions         saving between calls 2nd 3rd

    saving

         hidden fields 2nd 3rdstatement     exit

statements [See also loops]     block of, starting/ending 2nd    break

         code ends

         loops 2nd 3rd 4th 5th

     continue 2nd 3rd

    control

         code block brackets

     defined

     DELETE

     do\#201while 2nd 3rd

     echo

     echo()

     for 2nd 3rd 4th

     foreach

     function 2nd

     function state, saving 2nd 3rd    global         remembering function variable values between calls 2nd 3rd

         variable access 2nd 3rd 4th 5th

     if 2nd 3rd 4th 5th         else clause with 2nd 3rd 4th

         elseif clause with 2nd 3rd 4th 5th

         example of     if\#201else

     INSERT 2nd    return

         argument swapping         function values 2nd 3rd     SELECT 2nd    static         remembering function variable values between calls 2nd

     switch 2nd 3rd 4th 5th

         example

     UPDATE     while 2nd 3rd 4th 5th

statements. [See also commands] [See commands]static statement     function state, saving 2nd 3rd

     remembering function variable values between calls 2nd

status

    files

         checking    schemas

         directives

status code     conditional logging status of files, checking 2nd

status settings     scalabilitystopping

     Apache

     MySQL server

storage

    backend storage

         database file-based access control authentication

         file-based authentication

         functions (authentication modules)

store categories field, storefront database table example 2nd 3rd

store item color field, storefront database table example 2nd 3rd 4th

store item size field, storefront database table example 2nd 3rd

store items field, storefront database table example 2nd 3rd 4th 5th

storefront database table example

     add to cart button 2nd 3rd 4th 5th 6th 7th 8th

     categories of items, displaying 2nd 3rd 4th 5th 6th     planning process 2nd     store categories field 2nd 3rd

     store item color field 2nd 3rd 4th

     store item size field 2nd 3rd     store items field 2nd 3rd 4th 5th

storing

     certificate signing requests     formatted strings 2nd

     password files (file-based authentication)    passwords

         user management;client authentication    usernames         user mangement;client authenticationstr replace() function     replacing strings 2nd 3rd

STRAIGHT JOIN command

string data type 2nd

string data types 2nd 3rdstrings

     breaking into arrays     case, converting 2nd     cleaning up 2nd 3rd 4th

     defined

    formatted

         storing 2nd

     formatting         argument swapping 2nd 3rd

         conversion specification 2nd 3rd 4th

         example 2nd         field width specifications 2nd 3rd         format control string

         padding specifiers 2nd 3rd 4th         precision specifications 2nd         printf() function 2nd 3rd

         specifiers 2nd 3rd 4th

         type specifiers 2nd 3rd 4th

     indexing 2nd

    length

         finding 2nd

     log formats

     modification functions 2nd 3rd

     portions, extracting 2nd 3rd

     portions, replacing 2nd

    query

         session IDs, passing 2nd

     replacing 2nd 3rd

    substrings

         finding 2nd         position, finding 2nd     tokenizing 2nd 3rd 4th 5th

     wrapping text 2nd 3rd 4th

strip tags() function stripslashes() function 2nd 3rd 4th

strlen() function 2nd

strpos() function 2nd strstr() function 2nd

strtok() function 2nd 3rd 4th 5th strtolower() function

strtoupper() functionsubdirectories     support-filessubdirectories. [See directories]subentries

     adding to records 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th

subexpressions

subject information (certificates)subqueries (MySQL)

     overview 2nd     time tracking example of 2nd 3rd 4th 5th 6th 7thsubscription project

     mail, sending 2nd 3rd 4th 5th 6th 7th

     subscribe and unsubscribe requests 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th

    subscribers table

         creating 2nd 3rd 4th subscription project development

substr() function 2nd 3rd

substr_replace() function     string portions, replacing 2nd SUBSTRING() function 2nd

substrings     finding 2nd     position, finding 2nd

subtraction operator (-)

superglobals 2nd 3rd

     $ FILES

     $SESSION 2nd 3rd

support contracts

     MySQL

support-files subdirectories

swapping arguments

     formatting strings 2nd 3rd

switch statements 2nd 3rd 4th 5th

     example

switches

     -DMyModule

    rand         key pairs;creating (certificates)symbolic links (symlink)

     file system access (scalability)

symlink (system links)     file system access (scalability)

SymLinksIfOwnerMatch parameter

     Options directivesymmetric cryptography

     confidentiality (SSL protocols) 2nd     limitations

syntax     <IfDefine> conditional container     <IfModule> conditional container     container directives 2nd     error log

    per-directory configuration files

         disabling

    request headers         name-based virtual hosting 2nd

    schemas         directives     ServerAlias directive

syslog daemon

    errors

         logging (Unix)

syslog daemon argument    errors

         logging (Unix)

system() function     running commands with 2nd 3rd 4th 5th