Sams Teach Yourself PHP in 10 Minutes

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [Z]

data files

    comma-separated values (CSV)         reading     retrieving via fgetcsv function 2nd     writing to via fputcsv functionData Manipulation Language (DML)

     DELETE statement 2nd

     INSERT statement 2nd

     UPDATE statement 2nddata rules

    forms         validation requirements 2nddata source names (DSN)

     components 2nd

     full syntax definition

    MySQL databases

         connecting 2nddata types

     Boolean 2nd 3rd

     double 2nd 3rd     gettype function     integer 2nd 3rd

     juggling 2nd     NULL values 2nd     numeric 2nd

     querying

     settype function

     string 2nd 3rd

         converting to integer

database abstraction [See also databases]

    PEAR DB class

         installing 2nd

         supported extensions

databases [See also database abstraction]

    data source names (DSN)

         components 2nd

         connecting 2nd

         full syntax definition

    DB class (PEAR)         portability modes 2nd 3rd 4th    MySQL

         changing 2nd

         closing connections         connecting 2nd 3rd

         connection errors 2nd

         full rows of data, fetching 2nd         hostnames

         link identifiers         mysql extension versus mysqli extension

         queried data, fetching 2nd 3rd 4th         selecting         SQL statement execution 2nd 3rd 4th 5th 6th 7th 8th 9th 10th    queries         limiting (DB class) 2nd

    security

         escapeshellcmd function 2nd

         SQL injections 2nd 3rd 4th    sequences

         creating (DB class) 2nd         dropping (DB class)    SQL errors

         debugging 2nd 3rd

date command

date formats

     converting to timestamps 2nd     listing of

     storage overview 2nd

    Unix timestamp         best uses         drawbacks

         ease of use         maximum value         starting value

date function 2nd 3rd

     format codes 2nd

DB class (PEAR)

     connect method 2nd 3rd 4th 5th

     createSequence method

     data source names (DSN) 2nd

         components 2nd

         full syntax definition

     dropSequence method

     fetch modes

     getMessage method 2nd

     installing 2nd

     isError method 2nd

     limitQuery method 2nd     online documentation     portability modes 2nd 3rd 4th

    queries

         limiting 2nd    quotation marks

         use on string values 2nd

    selected data         retrieving 2nd

     sequences         creating

         dropping    SQL queries         executing 2nd         shortcut methods     supported database extensions

     using in scripts

DB_PORTABILITY_ALL constant

DB_PORTABILITY_DELETE_COUNT constant DB_PORTABILITY_ERRORS constant

DB_PORTABILITY_LOWERCASE constant DB_PORTABILITY_NONE constant DB_PORTABILITY_NULL_TO_EMPTY constant

DB_PORTABILITY_NUMROWS constant

DB_PORTABILITY_RTRIM constant

DB_Result object

     fetchRow method 2nd     getAll method

     getOne method

     getRow method     numCols method 2nd     numRows method 2nd

debugging     SQL errors in databases 2nd 3rddecimal numbers

     strings

declaring

     arrays 2nd 3rd

     custom error handlers 2nd 3rd 4th

     variables

decrement (--) operator 2nd

decrement operator (--) 2nd

default argument values

     functions 2nd 3rd

default input values

    forms

         setting (dynamic HTML) 2nd

defining

     functions         simple example 2nd 3rd DELETE statement (DML) 2nd

desktop applications

     creating (PHP-GTK extension)detecting

     host platforms 2nd

digit class     characters in regular expressions

directories    files

         changing         viewing contents disable_classes directive disable_functions directivedisabling

     classes

     functions

display_errors directivedisplaying

     HTTP headers 2nd     validation warnings for forms 2nd 3rd 4th Displaying the System Date and Time (Listing 1.1) 2nd

dissecting

    strings

         sublen function

         subpos function 2nd 3rd         substr function 2nd

division (/) operator

do loops 2nddollar sign prefix ($)     variables

double data types 2nd 3rddouble quotes     strings 2nd

double-quoted strings

     variables 2nd

downloading

     Apache source code

    PHP

         latest version 2nd

dynamic HTML

    forms

         check boxes, checking 2nd

         default input values, setting 2nd

         menus, creating 2nd

         menus, default selections 2nd

         menus, selecting multiple items 2nd 3rd 4th

         radio buttons, creating 2nd 3rd         radio buttons, selecting 2nddynamic shared objects (DSOs)

     Apache web server support 2nd 3rd