continuepathinfo

787IndexNumbersandsymbols.
NETFrameworkSDK,512command,psql,613@@operatorusingfull-textindexes,PostgreSQL,757401(Unauthorizedaccess)message.
hardcodedauthentication,329HTTPauthentication,325sendingtouser,327404(Filenotfound)message,321AA(IPv4AddressRecord)recordtype,DNS,360A6(IPv6addresses)recordtype,DNS,360AAAA(IPv6AddressRecord)recordtype,DNS,360abstractclasses,OOP,168–169abstractclassesorinterfaces,169description,157inheritance,168instantiation,168abstractkeyword,169abstractmethods,146accentedlanguageslocalizedformats,280AcceptPathInfodirectiveconfiguringApachelookbackfeature,316accessprivilegesystem,PostgreSQL,651–662accessibility,475accessors,140getter(_get)method,142AccountDomain/NameparametersinstallingPostgreSQL,586ACIDtests,transactions,765actorparameterSoapClientconstructor,503SoapServerconstructor,508addDaysmethod,294addFunctionmethodcreatingSOAPserver,509addingdataldap_mod_addfunction,416addingentriesldap_addfunction,416addition(+)operator,71addl_headersparametermailfunction,368addl_headersparameter,mail()sendinge-mailwithadditionalheaders,369addl_paramsparametermailfunction,368addMonthsmethod,295AddressesoptioninstallingPostgreSQL,587addslashesfunction,34AddTypedirectiveinstallingPHPonLinux/Unix,13installingPHPonWindows,15addWeeksmethod,296addYearsmethod,297adlattribute,messages,379administrationPostgreSQL,593–610AdministratorAccountoptioninstallingPostgreSQL,587affectedRowsfunction,PostgreSQL,691788INDEXAfiliasIncPostgreSQLusers,576AFTERtrigger,PostgreSQL,740,741aggregatefunctions,PostgreSQL,724aggregatefunctions,SQLitecreating,551–553sqlite_create_aggregatefunction,552aggregators,RSSMagpieRSS,483popularaggregators,476ALIAStypePL/pgSQLfunctions,731,735aliases,LDAP,419alignmentspecifierprintfstatement,49allow_call_time_pass_referenceparameter,25allow_url_fopenparameter,38,88:alnum:characterclass,194:alpha:characterclass,194ALTERDATABASEcommand,627ALTERDOMAINcommand,646ALTERGROUPcommand,659ALTERSCHEMAcommand,628ALTERSEQUENCEcommand,633ALTERTABLEcommand,632ALTERTABLESPACEcommand,602ALTERTRIGGERcommand,740ALTERTYPEcommand,645ALTERUSERcommand,658always_populate_raw_post_dataparameter,36amortizationTablefunction,97ampersand(&)convertingspecialcharactersintoHTML,212ANALYZEcommand,PostgreSQL,603autovacuumparameter,604runningwithVACUUM,603AND(&&)operator,73answeredattribute,messages,379,383ANYrecordtype,DNS,360Apachedownloading,9–10Apachemanual,18binarydistribution,10selectingApacheversion,10sourcedistribution,10hidingconfigurationdetails,520–521installingonLinux/Unix,11–13onWindows,13–16problems,18scopeofdiscussion,11lookbackfeature,314configuring,315–316rewritefeature,315SSLsupport,10testinginstallation,16–17APPDATAstoringconfigurationinformationinstartupfile,616Archive_Tarpackage,PEAR,260arg_separator.
inputparameter,33arg_separator.
outputparameter,32argumentsseealsoparametersdefaultargumentvalues,94escapeshellargfunction,526optionalarguments,94passingargumentsbyreference,93passingargumentsbyvalue,92PL/pgSQLfunctions,731register_argc_argvdirective,34arithmeticoperators,70arraydatatypes,PHP,52789INDEXarrayfunctionsarray,107array_chunk,130array_combine,124array_count_values,117array_diff,128array_diff_assoc,128array_flip,116,213array_intersect,127array_intersect_assoc,127array_key_exists,112array_keys,111array_merge,125array_merge_recursive,125array_multisort,121array_pad,110array_pop,110array_push,109array_rand,129array_reverse,116array_search,112array_shift,110array_slice,125,484array_splice,126array_sum,130array_unique,118array_unshift,110array_values,112array_walk,114arsort,122asort,120count,116current,113each,113end,114in_array,111is_array,108key,113krsort,123ksort,122list,107natcasesort,120natsort,119next,114prev,114print_r,105range,108reset,113rsort,120shuffle,129sizeof,117sort,118usort,123arraysaddingandremoving,109–111addingelements,109atendofarray,109atfrontofarray,110increasingarraylengthtospecifiedsize,110arraypointers,105associativekeys,104breakingarrayintosmallerarrays,130countingnumberofvaluesin,116countingoccurrencesofvaluesin,117creating,106–108fromstructureddata,107rangeofnumericalvalues,108described,104keys,104locatingarrayelements,111–112manipulating,124–129appendingarraystogether,125combiningarrayofkeystoarrayofvalues,124removingandreturningsectionofarray,126returningcommonkey/valuepairsinarrays,127790INDEXreturningkey/valuepairsnotcommontoarrays,128returningsectionofarray,125returningvaluescommontoarrays,127returningvaluesnotcommontoarrays,128multidimensionalarrays,104numericalkeys,104NuSOAP,returninganarray,498outputting,105–106passingelementstouser-definedfunction,114pg_fetch_arrayfunction,678printing,105register_long_arraysdirective,34removingduplicatevalues,118returningarrayofkeys,111arrayofvalues,112firstelementofarray,110keyelementatcurrentpointer,113key/valuepairatcurrentpointer,113lastelementofarray,110lastelementofarray,pointertoend,114nextarrayvaluebeyondcurrentpointer,114randomvalues,129toclient,498valueatcurrentpointer,113valuebeforecurrentpointer,114reversingkey/valueroles,116reversingorderofelements,116searching,111–112allelements,201forspecifickey,returningtrue/false,112forspecificvalue,returningkey,112forspecificvalue,returningtrue/false,111settingarraypointertoendofarray,114settingarraypointertostartofarray,113single-dimensionalarrays,104sizing,116–117sorting,118–124byASCIIvalue,118bykeysNOTvalues,122byuser-definedfunction,123caseinsensitive,120inanotherlanguage,118key/valueassociationsmaintained,120key/valueassociationsnotmaintained,119multidimensionalarrays,121naturalnumberordermaintained,119numerically,118orderingelementsfromlowesttohighestvalue,118reverse(descending)order,120reverseorder,bykeysNOTvalues,123reverseorder,key/valueassociationsmaintained,122sqlite_array_queryfunction,543sqlite_fetch_arrayfunction,541startingpositionzero,104testingifvariableisanarray,108–109traversing,112–116uniqueness,118workingwithmultivaluedformcomponents,307arsortarrayfunction,122ASONevent_typeCREATERULEcommand,709asortarrayfunction,120ASPstyletagsdelimitingPHPcode,45asp_tagsparameter,22assignparameterinserttag,Smarty,463assignmentoperators,71assoc_casedirective,sqlite,538791INDEXassociativearrayscreating,106pg_fetch_assocfunction,680PGSQL_ASSOCvalue,678PGSQL_BOTHvalue,679associativekeys,arrays,104associativity,operators,69,70asXMLmethod,SimpleXML,489atomicityACIDtestsfortransactions,765attachmentssendinge-mailattachments,371–372attribute,messages,379,380,381attributesldap_first_attributefunction,407ldap_get_attributesfunction,408ldap_next_attributefunction,408attributesmethod,SimpleXML,488attributesparameter,ldap_search(),404attributes_onlyparameter,ldap_search(),404auditing,7Authpackage,PEAR,261authenticatingagainstSambaserver,266Auth_HTTPclass,PEARauthenticatingagainstPostgreSQLdatabase,335–337authenticationmethodologies,PHP,334–337installing,334–335validatingusercredentialswithAuth_HTTP,335authenticationAuth_HTTPclass,PEAR,334–337databasebasedauthentication,331–332filebasedauthentication,329–331hardcodedauthentication,328–329HTTPauthentication,325–326imap_openfunction,374IPaddressbasedauthentication,333–334PEARpackage,261PHPauthentication,326–337PHPauthenticationandIIS,327PostgreSQL,575PostgreSQLaccessprivilegesystem,652authenticationvariables,PHP,327–328determiningifproperlyset,328PHP_AUTH_PW,327PHP_AUTH_USER,327authentication,PHPheaderfunction,327issetfunction,328authentication,PostgreSQLmethodsof,pg_hba.
conffile,655pg_hba.
conffile,654authenticationFile.
txtfilebasedauthentication,329locationforsecurity,329PHPscriptforparsing,330authorizationPostgreSQLaccessprivilegesystem,652pg_classtable,656autologinexamplesessionhandling,437–439auto_append_fileparameter,35auto_detect_line_endingsparameter,39auto_prependparameter,100auto_prepend_fileparameter,35auto_startparameter,429autoloadingobjects,OOP,155–156_autoloadfunction,155require_oncestatement,155autovacuumparameter,PostgreSQL,604avgfunction,PostgreSQL,725Bbacktickoperatorsystemlevelprogramexecution,257backupandrecovery,PostgreSQL,605–609Bakken,Stig,259792INDEXbandwidthtesting,397–398baseexceptionclassseeexceptionclassbase_convertfunction,240baseclassclassinheritance,OOP,162basenamefunction,230bccaddressattribute,messages,379BEFOREtrigger,PostgreSQL,740,741,742BEGINcommandexamplePL/pgSQLfunction,736beginTransactionmethod,PDO,571begintransactionmethod,PHP,772BETWEENoperator,PostgreSQL,720BIGINTdatatype,PostgreSQL,637BIGSERIALdatatype,PostgreSQL,639bindirectoryinstallingPostgreSQLonLinux,585bin2hexfunction,530binarydataNULLcharacter,550sqlite_udf_decode_binaryfunction,551sqlite_udf_encode_binaryfunction,551binarydata,SQLite,549–550binarydistribution,Apachedownloading,10BINARYkeyword,COPYcommandcopyingdatato/fromtables,779bindColumnmethod,PDO,570bindingldap_bindfunction,402ldap_unbindfunction,403bindiroptioninstallingPostgreSQLfromsource,583bindParammethod,PDO,564,565BisonpackageinstallingPHPonLinux/Unix,11BisonparsergeneratorinstallingPHPonLinux/Unix,12bitmapindexscanning,PostgreSQL,753bitmapindexing,PostgreSQL,753bitwiseoperators,74blockfiletype,232body(ofmessage),385,386Booleandatatype,PHP,50BOOLEANdatatype,PostgreSQL,640boundcolumnssetting,PDO,570–571boxingclient/serverSOAPclientandserverinteraction,511brackets([]),regularexpressions,193breadcrumbtrailscreatingfromdatabasetabledata,319–321creatingfromstaticdata,318–319navigationalcues,317–321navigationaltrailillustrated,317breakstatement,PHP,85BSDlicenselicensingPostgreSQL,579bufferingsqlite_unbuffered_queryfunction,541buffersoutput_bufferingdirective,23shared_bufferssetting,PostgreSQL,596businesslogicseparatingpresentationallogicfrom,448byteatype,PostgreSQL,635bytesattribute,messages,382Cccommand,psql,614coption,psql,612cpsqlcommand,626C#C#SOAPclient,513usingC#clientwithPHPWebService,512–514cachedirectoryinstallingSmarty,451793INDEXCACHEoptioncreatingsequences,633cache_expiredirective,431$cache_lifetimeattribute,Smarty,468–471cache_limiterdirective,431cachingcache_expiredirective,431cache_limiterdirective,431compilationcompared,468determininghowsessionpagesarecached,431effective_cache_sizesetting,PostgreSQL,598feeds,MagpieRSS,485pagecaching,468Smartytemplatingengine,450$cache_lifetimeattribute,468–471creatingmultiplecachespertemplate,470is_cachedmethod,469Calendarpackage,PEAR,285–288classes,286creatingmonthlycalendar,286–288dateandtimeclasses,286decoratorclasses,286installing,285isValidmethod,288tabulardateclasses,286validatingdatesandtimes,288validationclasses,286callbacksserialize_handlerdirective,430unserialize_callback_funcdirective,24capitalizefunction,Smarty,454CASCADEkeyworddeletingsequences,635deletingtables,632DROPCASCADEcommand,647droppingschemas,628CASCADEoptionremovingtriggers,PostgreSQL,741casemanipulatingstringcase,208–209CASEfunction,PostgreSQL,725casesensitive/insensitivefunctionsseeunderstringfunctionactionscase-insensitivesearchPerlregularexpressionmodifier,199casingPDO_ATTR_CASEattribute,560casting,54ccaddressattribute,messages,379c-clientlibrary,373CHARdatatype,PostgreSQL,639charfiletype,232charactercasingPDO_ATTR_CASEattribute,560characterclassespredefinedcharacterranges,194characterencodingldap_8859_to_t61function,420ldap_t61_to_8859function,421characterentityreferences,210charactersets,211default_charsetdirective,36characterscountsnumberofcharactersinstring,224htmlentitiesfunction,527localizedformats,280CHECKattributePostgreSQLdatatypes,640checkconstraint,columns,640checkboxesworkingwithmultivaluedformcomponents,307checkdatefunction,PHP,272checkdnsrrfunction,360–361checkpoint_segmentssetting,PostgreSQL,599794INDEXcheckpoint_timeoutsetting,PostgreSQL,599checkpoint_warningsetting,PostgreSQL,599chgrpfunction,240childclassclassinheritance,OOP,162childrenmethod,SimpleXML,489chownfunction,239CIDR-ADDRESSfield,pg_hba.
conffile,654classconstants,143classinheritance,OOP,162childclass(subclass),162constructorsandinheritance,164–165extendskeyword,162parentclass(baseclass),162classinstantiation,136classlibrarieshelperfunctions,153–155classmanagement_autoloadfunction,155autoloadingobjects,OOP,155class_existshelperfunction,153classesseealsoPostgreSQLdatabaseclassdisable_classesdirective,27,519ReflectionClassclass,170classes,OOP,135seealsoobjects,OOPassigningdatatoclassfield,140characteristicsandbehaviors,136checkingifclassexists,153classconstants,143generalizedclasscreationsyntax,136gettingfieldsofclass,154gettinglistofdefinedclasses,154gettingmethodsofclass,154gettingnameofclass,153gettingparentclass,154objectsandclasses,136retrievingaclassvariable,142staticclassmembers,152–153clientauthentication,PostgreSQLpg_hba.
conffile,654Clienterrorfaultstringattribute,NuSOAP,500clientsPDO_ATTR_CLIENT_VERSIONattribute,560PostgreSQL,611–623clonekeyword,OOP,158clonemethod,OOP,160cloningOOPobjectcloning,158–161closedirfunction,251closelogfunction,182clustersdatabasesand,625CNAMErecordtype,DNS,360:cntrl:characterclass,194COALESCEfunction,PostgreSQL,726codecodereuse,259getCodemethod,exceptionclass,186codingconsistencyPDOfeatures,557columnCountmethod,PDO,567columnscheckconstraint,640copyingspecificcolumns,780defaultvalues,641primarykeyvalues,642settingboundcolumns,PDO,570–571sqlite_columnfunction,543sqlite_fetch_column_typesfunction,548sqlite_fetch_singlefunction,544COM/DCOMsupport,3commaseparatedvaluesseeCSVcommandlineoptionsPEARpackageforreading,260795INDEXcommandnotfoundmessageinstallingPostgreSQLfromsource,582command-lineinterface,PostgreSQL,611commandsescapeshellcmdfunction,527PGSQL_COMMAND_OKvalue,674commands,PostgreSQL,667–671commands,psql,613–614controllingcommandhistory,619commentsphp.
inifile,20Smartytemplatingengine,454comments,PHP,46–47COMMITcommand,771commitmethod,PDO,571PDO_ATTR_AUTOCOMMITattribute,560commitmethod,PHP,772committingtransactions,765comparingvaluesldap_comparefunction,411comparisonoperators,74comparisonoperators,PostgreSQL,720compatibilityzend.
ze1_compatibility_modedirective,22CompatibleRegularExpressions(PCRE)library,3compilationcachingcompared,468composingmessagesimap_mail_composefunction,386compositedatatypes,PostgreSQL,644–645briefdescription,635creating,644dropping,645modifying,645compressionzlib.
output_compressiondirective,24compressionparameterSoapClientconstructor,503concatenation(.
)operator,71concatenationoperator,PostgreSQL,721concurrencyMultiversionConcurrencyControl,602conditionalexpressions,PostgreSQL,725–726CASEfunction,725COALESCEfunction,726NULLIFfunction,726conditionalstatements,PHP,79–81alternativesyntax,80elsestatement,80ifstatement,79ifelsestatement,80switchstatement,81config_loadfunctioncreatingSmartyconfigurationfiles,465configsdirectoryinstallingSmarty,451configurationdirectives,PHPseePHPconfigurationdirectivesseealsoPHPconfigurationdirectives,listofconfigurationfile,Apacheinstallationproblems,18configurationfilesinstallingSmarty,451referencingconfigurationvariables,466Smartytemplatingengine,465–466configurationoptions,LDAP,418ldap_get_optionfunction,420ldap_set_optionfunction,420configurationoptions,PostgreSQLinstallingPostgreSQLfromsource,583configurationsconfiguringPHPsecurely,516–520changingdocumentextension,522configurationparameters,518–520expose_phpdirective,521hidingconfigurationdetails,520–522safemode,516–518stoppingphpinfoCalls,522796INDEXPDO(PHPDataObjects),558phpinfofunction,522configurecommandcustomizingPHPinstallationonUnix,17installingPostgreSQLfromsource,582configureWSDLmethod,499connectcommand,psql,614connectfunction,PostgreSQL,690connect_timeoutparameterpg_connectfunction,668connectionauthenticationPostgreSQLaccessprivilegesystem,652connectionsseealsolinksclosing,SQLite,539establishingsocketconnections,365–367imap_closefunction,375imap_openfunction,374ldap_connectfunction,401ldap_start_tlsfunction,402openingconnectionbutnotmailbox,374opening,SQLite,538–539PDO_ATTR_CONNECTION_STATUSattribute,560PostgreSQLdatabaseclass,693securingPostgreSQL,661sqlite_closefunction,540sqlite_openfunction,538connections,PostgreSQLestablishingandclosingconnections,667–671persistentornon-persistentconnections,669pg_closefunction,671pg_connectfunction,668pg_connection_busyfunction,672pg_connection_statusfunction,673pg_hba.
conffile,654pg_pconnectfunction,669pgsql.
auto_reset_persistentdirective,666pgsql.
max_persistentdirective,666storingconnectioninformationinseparatefile,669–670consistencyACIDtestsfortransactions,765Console_Getoptpackage,PEAR,260runninginfocommandfor,265constants,OOP,143constants,PHP,68CONSTRAINTkeyword,641constraintscheckconstraint,640defining,641domains,645,646foreignkeys,643PRIMARYKEYattribute,642constructorsdeclarationsyntax,148defaultexceptionconstructor,185invokingparentconstructors,150invokingunrelatedconstructors,150overloadedconstructors,185overloading,151PHP4,148constructors,OOP,148–151inheritanceandconstructors,164–165containerscontainernotmailbox,376contextsstreamwrappers,391continuestatement,PHP,86ContribModulesinstallingPostgreSQL,588controlstructures,78–89conditionalstatements,79–81executioncontrolstatements,78–79fileinclusionstatements,86–89797INDEXloopingstatements,81–86PL/pgSQLfunctions,732–733Smartytemplatingengine,457–462convertingdatapg_convertfunction,683$_COOKIEsuperglobalvariable,66cookie_domaindirective,429cookie_lifetimedirective,429cookie_pathdirective,429cookiesallowing/restrictingURLrewriting,428changingcookiename,429cross-sitescripting,525namedirective,429retrievingsessionname,427sessionhandling,426storingsessioninformation,428use_cookiesdirective,428use_only_cookiesdirective,428CoordinatedUniversalTime,271COPYcommand,PostgreSQL,777–783BINARYkeyword,779callingfromPHPscript,782–783COPYFROMcommand,778delimitedfields,779COPYTOcommand,778copyingdatato/fromtables,778–782changingdefaultdelimiter,780copyingdatafromatable,778copyingdatafromatextfile,779copyingdatafromtabletotextfile,782copyingspecificcolumns,780dealingwithNULLvalues,781exportingtableOIDs,780workingwithCSVfiles,781CSVclause,781DELIMITERclause,780ESCAPEclause,782FORCEclause,782HEADERclause,781NULLclause,781QUOTEclause,782copyingcopyingdatato/fromtables,778–782copyingmessages,389copyingtables,630pg_copy_fromfunction,684pg_copy_tofunction,683PGSQL_COPY_INvalue,674PGSQL_COPY_OUTvalue,674countarrayfunction,116countfunction,PostgreSQL,725count_charsfunction,224count_wordsfunction,Smarty,455CrackLibextension,PHPavoidingeasilyguessablepasswords,340installation,340minimumpasswordrequirements,340PECLwebsite,340using,340–341usingdictionaries,341cracklib_dict.
pwddictionary,341CREATEDATABASEcommand,626CREATEDOMAINcommand,646CREATEFUNCTIONcommand,727CREATEGROUPcommand,659CREATEINDEXcommand,753CREATERULEcommand,709CREATESCHEMAcommand,627CREATESEQUENCEcommand,633CREATETABLEstatement,629,630CREATETABLESPACEcommand,601CREATETRIGGERcommand,739CREATETYPEcommand,644CREATEUSERcommand,658CREATEVIEWcommand,707,708create_crumbsfunction798INDEXcreatingbreadcrumbsfromdatabasetabledata,320creatingbreadcrumbsfromstaticdata,318,319create_dropdownfunctionautoselectingformsdata,310generatingformswithPHP,308createdbcommand-linetool,626credentialsldap_bindfunction,402,403cross-sitescripting,524cryptTypeelementAuth_HTTPclass,PEAR,337CSS(CascadingStyleSheets)literaltag,Smarty,464Smartyconfigurationfilesand,465usingwithSmartytemplatingengine,467–468CSV(comma-separatedvalue)files,246copyingdatafromtabletotextfile,782copyingdatato/fromtables,781curlybracketsyntaxchangeinPHP5,192currencylocalizedformats,280currentarrayfunction,113current_datefunction,PostgreSQL,724current_timefunction,PostgreSQL,724current_timestampfunction,PostgreSQL,724currvalsequencefunction,634cursor_offsetparameterfetchmethod,PDO,568cursor_orientationparameterfetchmethod,PDO,568customerrorhandlersnavigationalcues,321–323CYCLEoptioncreatingsequences,633Cygwin,430Ddcommandviewingtablestructure,631doption,psql,612DaemonAccountparameterinstallingPostgreSQL,586datacopyingdatafromtabletotextfile,782copyingdatato/fromtables,778–782hidingsensitivedata,522–523importingandexportingdata,777–785phpPgAdmin,783–785retrievinganddisplayingdata,PostgreSQL,678–681rowsselectedandrowsmodified,681sanitizinguserdata,524–528dataencryption,528–532Auth_HTTPclass,PEAR,337MCrypt,531mcrypt_decryptfunction,532mcrypt_encryptfunction,531md5function,529mhashfunction,529,530PHP4features,3PHP'sencryptionfunctions,528datahandlingdeletingLDAPdata,417insertingLDAPdata,415ldap_addfunction,416ldap_deletefunction,418ldap_mod_addfunction,416ldap_mod_delfunction,418ldap_modifyfunction,417ldap_renamefunction,417PHPconfigurationdirectives,32streams,390–393updatingLDAPdata,417dataintegrity,PostgreSQL,574dataretrieval,PDO,567–570799INDEXDataSourceNameseeDSNdatatypes,PHP,50–57array,52Boolean,50compounddatatypes,52floatingpointnumbers,51integer,51null,54object,53resource,53string,51typecasting,54typeidentifierfunctions,57is_namefunction,57typejuggling,55typerelatedfunctions,56gettypefunction,57settypefunction,56datauniquenessindexes,PostgreSQL,749databaseabstractionlayersdescribed,555listof,556PHPDataObjects,556–572databasebasedauthentication,PHP,331–332authenticatinguseragainstPostgreSQLtable,332authenticatingusingloginpairandIPaddress,333databaseclassseePostgreSQLdatabaseclassDatabaseClusteroptioninstallingPostgreSQL,587DatabaseDriversoptionscategoryinstallingPostgreSQL,586DATABASEfield,pg_hba.
conffile,654databaseoperationstransactions,765–775DatabaseServeroptionscategoryinstallingPostgreSQL,585databasesupport,PDO,558databasesapplicationsaccessing,555checkconstraint,640clusterof,625connectingto,626creating,626defaultdatabases,625defaultvalues,641deleting,626domains,645–647foreignkeys,643indexes,PostgreSQL,749–759migratingbetween,260modifying,627primarykeys,642referentialintegrity,643renaming,627searching,PostgreSQL,759–764templatedatabases,625datadiroptioninstallingPostgreSQLfromsource,583datatypes,PostgreSQL,635–640attributesof,635,640–644CHECK,640DEFAULT,641NOTNULL,642NULL,642PRIMARYKEY,642REFERENCES,643UNIQUE,644BOOLEAN,640bytea,635compositetypes,635,644–645dateandtimedatatypes,636–637DATE,636INTERVAL,637800INDEXTIME,636TIMESTAMP,637domains,635inettype,635numericdatatypes,637–639BIGINT,637BIGSERIAL,639DECIMAL,638DOUBLEPRECISION,638FLOAT,638INTEGER,637NUMERIC,638REAL,638SERIAL,639SMALLINT,637stringdatatypes,639–640CHAR,639TEXT,640VARCHAR,640Date(DateandTimeLibrary),PHP5.
1,288–301accessors(getters),290cautionusing,289Dateconstructor,289datemanipulationcapabilities,294methodsaddDays,294addMonths,295addWeeks,296addYears,297date,290getArray,291getDay,291getDayOfYear,298getISOWeekOfYear,299getJuliaan,292getMonth,292getWeekday,298getWeekOfYear,299getYear,293isLeap,293isValid,294setDay,291setDMY,290setFirstDow,300setJulian,292setLastDow,301setMonth,292setToLastMonthDay,300setToWeekday,298setYear,293subDays,294subMonths,295subWeeks,296subYears,297mutators(setters),290usinginconjunctionwithearlierversions,289validators,293dateandtimedatatypes,PostgreSQL,636–637DATE,636INTERVAL,637TIME,636TIMESTAMP,637dateandtimefunctions,PHP,272–278calculatingdates,284determiningdaysincurrentmonth,283displayinglocalizeddateandtime,279–282displayingwebpagemodificationdate,283functionscheckdate,272date,272–275getdate,275getlastmod,283gettimeofday,276mktime,277801INDEXsetlocale,279strftime,281–282strtotime,284time,278dateandtimefunctions,PostgreSQL,723,724dateattribute,messages,380,383dateclassesCalendarpackage,PEAR,286DATEdatatype,PostgreSQL,636datefunction,PHP,272–275determiningdaysincurrentmonth,283formatparameters,273datemethod,290date_formatfunction,Smarty,455date_partfunction,PostgreSQL,724datesCalendarpackage,PEAR,285–288localizedformats,280priortoUnixepoch,272standardizingformatfor,271DBdatabaseabstractionlayer,556DBpackage,PEAR,260$dbloginarrayAuth_HTTPclass,PEAR,336dbnameparameterpg_connectfunction,668DebianoperatingsystemdownloadingPostgreSQL,580startingandstoppingPostgreSQLserver,596debug_flagproperty,NuSOAP,501debug_strproperty,NuSOAP,502debugginggetLastRequestmethod,SOAP,505getLastResponsemethod,SOAP,505NuSOAP,501DECIMALdatatype,PostgreSQL,638declarestatement,PHP,78declaringvariables,PHP,58–60decodingsession_decodefunction,436sqlite_udf_decode_binaryfunction,551decoratorclassesCalendarpackage,PEAR,286decrement(--)operator,72decryptionseedataencryptiondefaultargumentvalues,94DEFAULTattributePostgreSQLdatatypes,641defaultexceptionconstructorbaseexceptionclass,185defaultfunction,Smarty,456defaultvaluescolumns,641domains,646default_charsetparameter,36default_mimetypeparameter,35default_socket_timeoutparameter,39definefunction,68define_syslog_variablesfunction,181define_syslog_variablesparameter,39deleterules,PostgreSQL,711DELETEstatementmakingviewsinteractive,711deletedattribute,messages,380,383deletingdata,PostgreSQL,685deletingentries/values,ldap,418delimparameter,683,684DELIMITERclause.
COPYcommandchangingdefaultdelimiter,780delimiterstemplatingengines,448delimitingPHPcode,43–46ASPstyletags45defaultsyntax()operator,74PostgreSQL,720groupIDssafe_mode_giddirective,517groupschanginggroupmembershipoffile,240retrievinggroupIDoffileowner,240groups,PostgreSQLaddinggroups,659amendingusersingroups,659deletinggroups,660managingprivilegesfor,659GUI-basedclients,PostgreSQL,620–623Navicat,622–623pgAdminIII,620–621phpPgAdmin,621,622gzipfilesinstallingPostgreSQLfromsource,582Hhoption,psql,612,617handlemethodcreatingSOAPserver,509handlesresourcedatatype,PHP,53handlingerrorsseeerrorhandlinghardcodedauthentication,PHP,328–329hashmarkreferencingconfigurationvariables,Smarty,466hash_bits_per_characterdirective,432hash_functiondirective,431hashingmhashfunction,529HEADERclause,COPYcommandcopyingdatato/fromtables,781headerfunctionauthentication,PHP,327headersseealsomessageheadersauto_prepend_filedirective,35headlinefunctionusingfull-textindexes,PostgreSQL,758headlineslimitingnumberdisplayed,MagpieRSS,484helpoption,psql,612helpoption,SQLite,536helperfunctions,153–155class_exists,153get_class,153get_class_methods,154get_class_vars,154get_declared_classes,154get_object_vars,154get_parent_class,154interface_exists,154is_a,155is_subclass_of,155method_exists,155heredocsyntaxstringinterpolation,77hexadecimalcharacterspredefinedcharacterranges,195812INDEXHeyes,Richard,371highlight.
bgparameter,28highlight.
commentparameter,27highlight.
defaultparameter,28highlight.
htmlparameter,28highlight.
keywordparameter,28highlight.
stringparameter,27highlight_filefunction,27HISTCONTROLvariable,psql,619HISTFILEvariable,psql,619historycontrollingpsqlcommandhistory,619historyofPHP,1–4HISTSIZEvariable,psql,619HMAC(HashedMessageAuthenticationCode),531hostattribute,messages,379hostconnectiontypesecuringPostgreSQLconnections,662hostparameterpg_connectfunction,668hostaddrparameterpg_connectfunction,668HOSTNAME,$_ENVsuperglobal,67hostnossl/hostsslconnectiontypessecuringPostgreSQLconnections,662.
htaccessfilemanagingconfigurationdirectives,21HTMLconvertingintoplaintext,214convertingplaintextinto,210–213sendingHTMLformattede-mail,370–371HTMLformscreating/rendering/validating,261HTMLMimeMail5sendinge-mailattachments,371HTMLtagsstrip_tagsfunction,528html_errorsparameter,31HTML_QuickFormpackage,PEAR,261HTMLDOC,254htmlentitiesfunction,210sanitizinguserdata,527htmlgoodieswebsiteformstutorialsonline,304htmlspecialcharsfunction,211HTTPfileuploads,345–346HTTP404Filenotfoundmessage,321HTTPauthentication,325–326safe_moderestrictions,517HTTPproxy,NuSOAP,493HTTPsessionhandling,425–446PHP4features,3HTTP_AUTHORIZATIONvariablePHPauthenticationandIIS,327HTTP_REFERER,$_SERVERsuperglobal,65http_response_codeparameter,headerfunctionauthentication,PHP,327HTTP_Uploadclass,PEARfileuploads,355–357installing,355languages(foreign)supported,357movinguploadedfiletofinaldestination,356–357retrievinginformationaboutuploadedfiles,355–356retrievingvalueofsingleproperty,356uploadingmultiplefiles,357HTTP_USER_AGENT,$_SERVERsuperglobal,65httpd.
conffileinstallingPHPonLinux/Unix,13installingPHPonWindows,14,16managingconfigurationdirectives,21httpd.
conffile,Apachedenyingaccesstosomeextensions,523Hutteman,Luke,477813INDEXIicommand,psql,614IBMDB2,558idattribute,messages,382identauthenticationmethodpg_hba.
conffile,PostgreSQL,655identifiers,PHP,57–58IEEE754specialvaluesnumericdatatypes,638IFblockELSEIF/ELSIFoptions,732PL/pgSQLfunctions,732ifstatement,PHP,79ifstatement,Smarty,457ifelsestatement,PHP,80I/Ofsyncsetting,PostgreSQL,598ifidattribute,messages,382ignore_repeated_errorsparameter,31,180ignore_repeated_sourceparameter,31,180ignore_user_abortparameter,27IISPHPauthenticationandIIS,327IMAP(InternetMessageAccessProtocol),372–389composingmessages,386establishingandclosingconnections,375mailboxadministration,388–389mailboxesandmessages,375–378messageadministration,389NNTPprotocol,372openingandclosingconnections,374openingconnectionstoIMAPmailboxes,374POP3protocol,372purposeandadvantages,372requirements,373–374retrievingmessages,378–386sendingmessages,387imap_closefunction,375imap_createmailboxfunction,388imap_deletemailboxfunction,388imap_expungefunction,389imap_fetchbodyfunction,385imap_fetchoverviewfunction,383imap_fetchstructurefunction,382imap_getmailboxesfunction,375imap_headerinfofunction,379–382imap_headersfunction,378imap_mailfunction,387imap_mail_composefunction,386imap_mail_copyfunction,389imap_mail_movefunction,389imap_num_msgfunction,376imap_openfunction,374openingconnectionstomailboxes,374performingnon-SSLconnection,375imap_renamemailboxfunction,389imap_statusfunction,377IMMUTABLEfunctionsuserdefinedfunctions,PostgreSQL,728implementskeywordinterfaces,OOP,166implicit_flushparameter,24implodefunction,217importingdata,777–785phpPgAdmin,783–785in_arrayarrayfunction,111in_reply_toattribute,messages,380includedirectoryc-clientlibraryconfusion,373includestatementfunctionlibraries,100PHP,87Smartytemplatingengine,462include_oncefunction,PHP,88include_pathparameter,36installingSmarty,451include_phpfunction,Smarty,464814INDEXincrement(++)operator,72INCREMENTBYkeywords,633index.
phpfileinstallationproblems,18indexedarraysPGSQL_BOTHvalue,679PGSQL_NUMvalue,678indexes,PostgreSQL,749–759advantages,749bitmapindexscanning,753bitmapindexing,753datauniqueness,749description,749EXPLAINANALYZEstatement,759EXPLAINstatement,759full-textindexes,755–759functionalindexes,754JOINclause,759normalindexes,751–754ORDERBYclause,759partialindexes,753primarykeyindexes,750queryoptimization,749searchingmultiplecolumnindex,759stopwords,758textsearching,749tipsforusing,759tsearch2module,755–759uniqueindexes,750WHEREclause,759inettype,PostgreSQL,635Infinityspecialvaluenumericdatatypes,638infocommand,PEAR,265informationmodel,LDAP,400informationschema,PostgreSQL,687–688inheritance,OOP,134,161–165abstractclasses,168classinheritance,162constructorsandinheritance,164–165description,157multipleinheritance,158ini_setfunctionmanagingconfigurationdirectives,21initdbcommandinstallingPostgreSQLonLinux,584InitializeDatabaseClusteroptioninstallingPostgreSQL,587inputsystemlevelprogramexecution,254input/outputfunctionssafe_moderestrictions,516INSERTINTOcommandswapmeetproject,768insertrules,PostgreSQL,710INSERTstatementmakingviewsinteractive,711massinserts,683inserttag,Smarty,463insertingdata,PostgreSQL,682–684massinserts,683–684pg_copy_fromfunction,684pg_copy_tofunction,683pg_insertfunction,682InstallasaServiceparameterinstallingPostgreSQL,586installcommand,PEAR,266installationsApache/PHP,18MagpieRSS,479NuSOAP,493PDO(PHPDataObjects),558PEAR,262–264PEARpackages,266PL/pgSQLfunctions,730PostgreSQL,581–589onLinuxandUnix,582–585onWindows2000/XP/2003,585–589onWindows95/98/ME,589815INDEXSmartytemplatingengine,450–452SQLite,536instanceofkeyword,OOP,153instantiationabstractclasses,OOP,168classinstantiation,136constructors,148INSTEADformofarule,715integerdatatype,PHP,51INTEGERdatatype,PostgreSQL,637InterbasePDOsupporteddatabases,558interface_existshelperfunction,154interfaces,OOP,165–168abstractclassesorinterfaces,169caution:classmembersnotdefinedwithininterfaces,165checkingifinterfaceexists,154description,157generalsyntaxforimplementing,166implementingasingleinterface,167implementingmultipleinterfaces,168implementskeyword,166namingconventions,166internalfunctions,PostgreSQL,723–727aggregatefunctions,724conditionalexpressions,725–726dateandtimefunctions,723furtherinformationon,727stringfunctions,724internetservices,364–365defaultportsforinternetservices,364getservbynamefunction,364getservbyportfunction,364interoperability,474INTERVALdatatype,PostgreSQL,637INTOdesignationvariableassignment,PL/pgSQLfunctions,732introspection,170IPaddressbasedauthentication,PHP,333–334authenticatingusingloginpairandIPaddress,333IPspoofing,334IPaddressesdomainnamesand,360IPspoofing,334IP-ADDRESSfield,pg_hba.
conffile,654IP-MASKfield,pg_hba.
conffile,654isequalto(==)operator,73isidenticalto(===)operator,73isnotequalto(!
=)operator,73is_ahelperfunction,155is_arrayarrayfunction,108is_cachedmethod,Smarty,469is_namefunction,57is_subclass_ofhelperfunction,155is_uploaded_filefunction,PHP,349ISAPIsupport,PHP4,3isexecutablefunction,241isLeapmethod,293ISO8601specification,299isolationACIDtestsfortransactions,766transactionisolation,766isreadablefunction,241issetfunctionauthentication,PHP,328isValidmethodCalendarpackage,PEAR,288DateandTimeLibrary,294HTTP_Uploadclass,PEAR,357iswriteablefunction,241itemattributeforeachstatement,Smarty,458816INDEXJJavasupport,PHP4,3java.
class.
pathdirective,40java.
homedirective,41java.
librarydirective,41java.
library.
pathdirective,41JavaScriptpassingPHPvariableintoJavaScriptfunction,311–313JDBC(JavaDatabaseConnectivity),556JOINclauseindexes,PostgreSQL,759joinfunction,217Joye,Pierre-Alain,289Juliandates,292Kkeyarrayfunction,113keyattributeforeachstatement,Smarty,458,459keysarrays,104killcommandpg_ctlprogram,594krb_server_keyfile,postgresql.
conffilesecuringPostgreSQL,651krb5authenticationmethodpg_hba.
conffile,PostgreSQL,655krsortarrayfunction,123ksortarrayfunction,122LLoption,psql,612loption,psql,612languagefeatures,4–7languageoptionsPHPconfigurationdirectives,22languages(foreign)HTTP_Uploadclass,PEAR,357installingPostgreSQL,585lastvalsequencefunction,634layersdatabaseabstractionlayers,555LDAP(LightweightDirectoryAccessProtocol)additionalresources,400bindingtoLDAPserver,402–403characterencoding,420–421closingLDAPserverconnection,403configurationfunctions,418–420connectingtoLDAPserver,401–402countingretrievedentries,407deallocatingmemory,415deletingLDAPdata,417–418errorhandling,422–423insertingLDAPdata,415–417introduction,400–401models,400retrievingattributes,407–410retrievingLDAPdata,404–405searchingforLDAPdata,404–405sortingandcomparingLDAPentries,410–412updatingLDAPdata,417usingfromPHP,401–423workingwithDistinguishedName,421–422workingwithentries,412–415workingwithentryvalues,405–406ldap_8859_to_t61function,420ldap_addfunction,416ldap_bindfunction,402ldap_closefunction,403ldap_comparefunction,411ldap_connectfunction,401ldap_count_entriesfunction,407ldap_deletefunction,418ldap_dn2ufnfunction,421ldap_err2strfunction,422ldap_errnofunction,422ldap_errorfunction,423817INDEXldap_explode_dnfunction,421ldap_first_attributefunction,407ldap_first_entryfunction,412ldap_free_resultfunction,415ldap_get_attributesfunction,408ldap_get_dnfunction,410ldap_get_entriesfunction,414ldap_get_optionfunction,420ldap_get_valuesfunction,406ldap_get_values_lenfunction,406ldap_listfunction,405ldap_mod_addfunction,416ldap_mod_delfunction,418ldap_mod_replacefunction,417ldap_modifyfunction,417ldap_next_attributefunction,408ldap_next_entryfunction,413LDAP_OPT_XYZoptions,419ldap_readfunction,405ldap_renamefunction,417ldap_searchfunction,404ldap_set_optionfunction,420ldap_sortfunction,411ldap_start_tlsfunction,402ldap_t61_to_8859function,421ldap_unbindfunction,403left_delimiterattributeusingCSSinconjunctionwithSmarty,467leftmostprefixing,752Lerdorf,Rasmus,1lessthan(PathInfodirective,316configuring,315–316Filesdirective,315ForceTypedirective,315userfriendlyURLs,314loopattributesectionfunction,Smarty,460loopingstatements,PHP,81–86alternativesyntax,80breakstatement,85continuestatement,86do.
.
.
whilestatement,82forstatement,83foreachstatement,84whilestatement,81loosetyping,5lostpassword.
phpresettinguser'spassword,344:lower:characterclass,195lowerfunction,PostgreSQL,724lstatfunction,233ltrimfunction,222Mm4macroprocessorinstallingPHPonLinux/Unix,12magic_quotes_gpcparameter,35magic_quotes_runtimeparameter,35magic_quotes_sybaseparameter,35MagpieRSS,479–486aggregatingfeeds,483–484cachingfeeds,485disablingcaching,485features,479installing,479limitingnumberofdisplayedheadlines,484parsingfeeds,479–481renderingretrievedfeed,481–482mailsendmail_fromdirective,40sendmail_pathdirective,40Mailpackage,PEAR,260819INDEXMailTransferAgent(MTA),367,368mailfunction,368seealsoe-mailaddl_headersparameter,368addl_paramsparameter,368configurationdirectives,367–368examplesusing,369–372force_extra_parametersdirective,368MailTransferAgent,368passingPHPvariableintoJavaScriptfunction,311PHPconfigurationdirectives,40sendmail_fromdirective,368sendmail_pathdirective,368SMTPdirective,367smtp_portdirective,368mailboxattribute,messages,379mailboxescontainernotmailbox,376creating,388deleting,388expungingthemailbox,374,375imap_createmailboxfunction,388imap_deletemailboxfunction,388imap_getmailboxesfunction,375imap_num_msgfunction,376imap_openfunction,374imap_renamemailboxfunction,389imap_statusfunction,377mailboxadministration,388–389movingmessagesbetween,389numberofmessagesin,376openingwithread-onlyprivileges,374renaming,389retrievinginformationabout,375retrievingstatusinformationabout,377withoutchildren,376maintenance_work_memsetting,PostgreSQL,597make(GNUmake)installingPostgreSQLfromsource,582Masinter,Larry,345masksumaskfunction,241mathematicaloperators,PostgreSQL,721maxattributesectionfunction,Smarty,460maxfunction,PostgreSQL,725max_execution_timeparameter,29,346,519MAX_FILE_SIZEdirective,350max_fsm_pagessetting,PostgreSQL,597max_fsm_relationssetting,PostgreSQL,597max_input_timeparameter,29max_prepared_transactionssetting,PostgreSQL,597MAXVALUEkeywordcreatingsequences,633MCrypt,531mcrypt_decryptfunction,532mcrypt_encryptfunction,531md5authenticationmethodpg_hba.
conffile,PostgreSQL,655md5functionfilebasedauthentication,330PHPencryptionfunction,529memorydeallocatingmemory,LDAP,415ldap_free_resultfunction,415maintenance_work_memsetting,PostgreSQL,597max_fsm_pagessetting,PostgreSQL,597max_fsm_relationssetting,PostgreSQL,597PostgreSQL,678report_memleaksdirective,31shared_bufferssetting,PostgreSQL,596work_memsetting,PostgreSQL,596memory_limitparameter,29,347,519messagebodyimap_fetchbodyfunction,385820INDEXmessageheadersaddl_headersparameter,mail(),368imap_fetchoverviewfunction,383imap_headerinfofunction,379–382imap_headersfunction,378sendinge-mailwithadditionalheaders,369settingFromfieldof,368message_idattribute,messages,380,383messagescomposingmessages,386copying,389expunging,389getMessagemethod,exceptionclass,186headerattributes,379imap_expungefunction,389imap_fetchbodyfunction,385imap_fetchoverviewfunction,383imap_fetchstructurefunction,382imap_headerinfofunction,379–382imap_headersfunction,378imap_mailfunction,387imap_mail_composefunction,386imap_mail_copyfunction,389imap_mail_movefunction,389imap_num_msgfunction,376messageadministration,389moving,389numberofmessagesinmailbox,376retrievingmessagebody,385retrievingmessageheaderinformation,379retrievingmessageheadersintoarray,378retrievingmessageoverview,383retrievingmessagestructure,382retrievingmessages,378–386sendingmessages,387metacharactersPerlregularexpressionsyntax,199–200METHODfield,pg_hba.
conffile,655methodoverloading,OOP,158methodparametersReflectionParameterclass,174method_existshelperfunction,155methodsexceptionclass,186ReflectionMethodclass,172methods,OOP,143–147abstractmethods,146checkingifmethodavailabletoobject,155declaring,144finalmethods,147functionsandmethodscompared,143gettingmethodsofclass,154invoking,144methodscopes,144–147privatemethods,145protectedmethods,146publicmethods,145staticscope,152mhashfunction,529,530MicrosoftSQLServer,558MimeMail5sendinge-mailattachments,371MIMEtypesdefault_mimetypedirective,35minfunction,PostgreSQL,725MINVALUEkeyword,633mktimefunction,PHP,277determiningdaysincurrentmonth,284mm(sharedmemory)optionstoringsessioninformation,427modeparametersetFetchModemethod,PDO,570modessettingfileI/Oaccesslevel,243modifiersPerlregularexpressionsyntax,199modifyingdataseeupdatingdata821INDEXmodulesettingsPHPconfigurationdirectives,39modulus(%)operator,71monetaryrepresentationslocalizedformats,280MoreoverTechnologiesRealSimpleSyndication(RSS),476mortgage.
php,98move_uploaded_filefunction,PHP,350moveTomethodHTTP_Uploadclass,PEAR,357movingmessagesimap_mail_movefunction,389msgnoattribute,messages,383MTA(MailTransferAgent)mailfunction,368settingformailfunction,367Muffett,Alec,340multidimensionalarrays,104sorting,121multiple-columnnormalindexes,PostgreSQL,752multipleinheritance,PHPand,158multipleselectboxes,307multiplication(*)operator,71multiprocessingmodulesinstallingApacheonLinux/Unix,12MultiversionConcurrencyControlseeMVCCMustUnderstanderrorfaultstringattribute,NuSOAP,500mutators,140setter(_set)method,142MVCC(MultiversionConcurrencyControl),574PostgreSQL,602PostgreSQLtransactions,766MX(MailExchangeRecord)records,DNS,360getmxrrfunction,363–364MyExceptionclassextendingexceptionclass,187MySQLPDOsupporteddatabases,558safe_moderestrictions,517Nnameattributeforeachstatement,Smarty,458sectionfunction,Smarty,460namedirective,429nameparameterinserttag,Smarty,463namevariable$_FILESarray,348namedparameterspreparedstatements,PDO,564,565namespaces,PHPand,158namingconventionsdirectoriesandPEARpackages,268interfaces,OOP,166POSTvariables,304PostgreSQLtables,630namingmodel,LDAP,400NaNspecialvalue,638NAPTR(NamingAuthorityPointer)recordtype,DNS,360natcasesortarrayfunction,120NationalWeatherServicePostgreSQLusers,577natsortarrayfunction,119Navicat,622–623navigationalcues,websites,313–323breadcrumbtrails,317–321customerrorhandlers,321–323userfriendlyURLs,313–317navigationaltrailsseebreadcrumbtrails822INDEXnesting,5nestingfunctions,96PL/pgSQLfunctions,736Net_SMTPpackage,PEAR,260Net_Socketpackage,PEAR,260Netcraft,2networking,393–398creatingportscannerwithNMap,395pingingserver,394–395subnetconverter,395–397testinguserbandwidth,397–398NEWconstructtriggerfunctions,PostgreSQL,740,741,742,743,745newkeyword,OOP,136NEWvariabletriggerfunctions,PostgreSQL,745newlinecharacter,242newsgroupsattribute,messages,380newsrcconfigurationfileimap_openfunction,374nextarrayfunction,114nextvalsequencefunction,634nl2brfunctionNuSOAPdebugging,502stringconversion,210Nmap(networkmapper)toolcreatingportscannerwith,395NNTPprotocolIMAPprotocol,372openingconnectionstoNNTPmailboxes,374NOCYCLEoptioncreatingsequences,633nonrepeatablereadstransactionisolation,766normalindexes,PostgreSQL,751–754leftmostprefixing,752multiple-columnnormalindex,752single-columnnormalindex,751NOT(!
)logicaloperator,73representing,178NOTNULLattribute,PostgreSQL,642NOTHINGkeyworddeleterules,711noticepg_last_noticefunction,674pgsql.
ignore_noticedirective,667pgsql.
log_noticedirective,667nowfunction,PostgreSQL,724NS(NameServerRecord)recordtype,DNS,360NULLattribute,PostgreSQL,642NULLcharacter,binarydata,550nulldatatype,PHP,54NULLstate,BOOLEANdatatype,640NULLvaluescomparisonoperators,PostgreSQL,720copyingdatato/fromtables,781indexingbestpractices,759logicaloperators,PostgreSQL,720PDO_ATTR_ORACLE_NULLSattribute,560NULLIFfunction,PostgreSQL,726numberFieldsfunction,PostgreSQL,695numbersconvertingnumeralformats,261localizedformats,280Numbers_Romanpackage,PEAR,261numericdatatypes,PostgreSQL,637–639BIGINTdatatype,637BIGSERIALdatatype,639DECIMALdatatype,638DOUBLEPRECISIONdatatype,638FLOATdatatype,638IEEE754specialvalues,638INTEGERdatatype,637NUMERICdatatype,638REALdatatype,638SERIALdatatype,639SMALLINTdatatype,637823INDEXnumericalarrays,106numericalkeys,104numQueriesfunction,PostgreSQL,692,694numRowsfunction,PostgreSQL,691NuSOAP,492–502caution:namingconflict,493consumingaWebService,494–495creatingamethodproxy,495–496debuggingtools,501designatingHTTPproxy,501errorhandling,500–501features,492generatingWSDLdocument,499–500installing,493publishingaWebService,496–498returninganarray,498–499secureconnections,WebServices,502usingProxyclass,495Oooption,psql,614,618ob_gzhandlerfunction,24objectcloning,OOP,158–161clonekeyword,158clonemethod,160description,157example,158objectdatatype,PHP,53objectorientation,6NuSOAPfeatures,492PDOfeatures,557PHP4features,2PHP5features,4PostgreSQLdatabaseclass,692,693SQLite,539objectorientedprogrammingabstractclasses,157,168–169autoloadingobjects,155–156benefitsofOOP,134–135classes,135constants,143constructors,148–151destructors,151–152encapsulation,134featuresnotsupportedbyPHP,157–158fields,137–140helperfunctions,153–155inheritance,134,157,161–165instanceofkeyword,153interfaces,157,165–168keyOOPconcepts,135–147methodoverloading,158methods,143–147multipleinheritance,158namespaces,158objectcloning,157,158–161objects,136operatoroverloading,158polymorphism,135properties,140–143reflection,157,169–176staticclassmembers,152–153typehinting,147objectspg_fetch_objectfunction,680objects,OOP,136seealsoclasses,OOPcheckingifmethodavailabletoobject,155checkingifobjectbelongstoclass,155checkingifobjectbelongstoinheritedclass,155constructors,148–151destructors,151–152gettingfieldsavailabletoobject,154instanceofkeyword,153newkeyword,136objectsandclasses,136typehinting,147824INDEXODBC(OpenDatabaseConnectivity),556PDOsupporteddatabases,558OFFSETclausepagingdatabaseclassoutput,701,702OIDs(objectidentifiers)exportingtableOIDs,780OLDconstructtriggerfunctions,PostgreSQL,740,741,743,745OLDvariabletriggerfunctions,PostgreSQL,745onetimeURLsonetimeURLgenerator,343recovering/resettingpasswords,344open_basedirparameter,26,519opendirfunction,251openingconnectionsimap_openfunction,374openingdirectorystream,251openingfiles,243openlogfunction,181OpenSSLlibrarysecuringPostgreSQLconnections,661operandsexpressions,PHP,69operatingsystemsstartingandstoppingPostgreSQLserver,595systemlevelprogramexecution,256operatoroverloading,PHPand,158operatorprecedence,PostgreSQL,722operatorsarithmeticoperators,70assignmentoperators,71associativity,69,70bitwiseoperators,74comparisonoperators,74decrement(--)operator,72equalityoperators,73expressions,PHP,69–75increment(++)operator,72logicaloperators,72precedence,69,70stringoperators,71typecasting,PHP,54operators,PostgreSQL,719–723comparisonoperators,720listshowingprecedence,722logicaloperators,719mathematicaloperators,721operatorprecedence,722stringoperators,721optionsparameterpg_connectfunction,668pg_deletecommand,685pg_updatecommand,684SoapClientconstructor,503SoapServerconstructor,508options,psql,612OR(||)operator,73CREATERULEcommand,709OraclePDOsupporteddatabases,559ORDERBYclauseindexes,PostgreSQL,759orderingseesortingordinaryindexes,PostgreSQLseenormalindexes,PostgreSQLOrte,Monte,449output,PHP,47–50echostatement,48printstatement,47printfstatement,49sprintfstatement,50output_bufferingdirective,23output_handlerdirective,23outputsoutputtingdatatofile,250825INDEXtabularoutput,PostgreSQL,689,695–697paging,701–704sorting,699–701overloadedconstructorbaseexceptionclass,185,186overloadingconstructors,151methods,158operators,158overridingfinalscope,140ownershipoffileschanging,239effectofenablingsafemode,516Ppoption,psql,612p+/p*/p/p{}/p$quantifiers,193packagesPEARpackages,259–262paddingspecifierprintfstatement,49pagecaching,468pageLinksfunction,PostgreSQL,704,705PAGERvariable,psql,615pagingtabularoutput,PostgreSQL,701–704pamauthenticationmethodpg_hba.
conffile,PostgreSQL,655parametersseealsoargumentsaddl_paramsparameter,mail(),368passingadditionalparameterstosendmailbinary,368pg_send_query_paramsfunction,686ReflectionParameterclass,174parentclassclassinheritance,OOP,162parentkeywordinvokingparentconstructors,150parse_strfunction,215parsingSQLitequeryresults,541–544variables_orderdirective,33XMLfiles,261partialindexes,PostgreSQL,753participanttable,swapmeetproject,767partitionidentifyingfreespaceon,236identifyingtotalspaceon,236passthrufunction,257passwdcolumnpg_shadowtable,PostgreSQL,653passwordauthenticationmethodpg_hba.
conffile,PostgreSQL,655passwordparameterpg_connectfunction,668SoapClientconstructor,503passwords,6assigningduringuserregistration,337–339avoidingeasilyguessable,339–342CrackLibextensionrequirements,340fromdirective,38hardcodedauthentication,328missioncriticalapplications,339PHP_AUTH_PWauthenticationvariable,327recovering/resettinguser'spassword,342–344patchessecuringPostgreSQL,650PATH_INFOvariableuserfriendlyURLs,314,316pathinfofunction,231pathshidingsensitivedata,523include_pathdirective,36installingPostgreSQLonLinux,585PHPconfigurationdirectives,36retrievingabsolutepath,231826INDEXretrievingdirectorycomponentofpath,230retrievingfilenamecomponent,230retrievingtargetofsymboliclink,235safe_mode_include_dirdirective,517schemasearchpath,628session.
cookie_pathdirective,429session.
save_pathdirective,428settingpathtosendmailbinary,368PDO(PHPDataObjects),556–572configuring,558connectingtodatabaseserver,559–561connectionrelatedoptions,560constructorsembeddingparametersinto,559referringtophp.
inifile,559databaseabstractionlayersand,556databasesupport,558determiningavailabledrivers,559driver_optsarray,559errorhandling,561–562features,557gettingandsettingattributes,561installing,558methodsbeginTransaction,571bindColumn,570bindParam,564,565columnCount,567commit,571errorCode,562errorInfo,562exec,563execute,564,565fetch,567fetchAll,568fetchColumn,569getAttribute,561prepare,564query,563rollback,571rowCount,563setAttribute,561setFetchMode,570namedparameters,564,565preparedstatements,562,564–566queryexecution,562–563questionmarkparameters,564retrievingdata,567–570selectingdatabase,559–561settingboundcolumns,570–571transactions,571using,557–571PDO_ATTR_XYZattributes,560PDO_CASE_XYZvalues,560PDO_ERRMODE_XYZmodes,560,561PDO_FETCH_XYZvalues,567PDO_PARAM_XYZvalues,565PDOStatementclass,567PEAR(PHPExtensionandApplicationRepository),259–270directoriesandPEARpackagenames,268installing,262–264hostingcompanypermission,263UNIX,262Windows,263PEARPackageManager,264–269updating,264PEARpackages,259–262automaticallyinstallingdependencies,267downgrading,269faileddependencies,266installing,266Calendarpackage,285fromPEARwebsite,267learningaboutinstalledpackages,265reflectionAPI,176uninstalling,269827INDEXupgrading,268,269using,267viewing,264PEARpackages,listofArchive_Tar,260Auth,261Calendar,285–288Console_Getopt,260DB,260File_SMBPasswd,266HTML_QuickForm,261Log,261Mail,260Net_SMTP,260Net_Socket,260Numbers_Roman,261PEAR,260PEARValidate_US,226–227PHPUnit,260XML_Parser,261XML_RPC,261PEAR_ENV.
regfile,263PEAR:Auth_HTTPclass,334–337PEAR:HTTP_Uploadclass,355–357PECL(PHPExtensionCommunityLibrary),340performanceindexingtips,759PDOfeatures,557templatecaching,471performancetuning,PostgreSQL,596–600managingdiskactivity,598–599managingplannerresources,598managingresources,596–598managingrun-timeinformation,600partialindexes,PostgreSQL,754settingscheckpoint_segments,599checkpoint_timeout,599checkpoint_warning,599effective_cache_size,598fsync,598log_duration,599log_min_duration_statement,600maintenance_work_mem,597max_fsm_pages,597max_fsm_relations,597max_prepared_transactions,597random_page_cost,598shared_buffers,596sort_mem,596stats_command_string,600stats_row_level,600stats_start_collector,600vacuum_mem,597work_mem,596usinglogging,599–600PerlDBI(PerlDatabaseInterface),556perloptioninstallingPostgreSQLfromsource,583Perlregularexpressionsyntax,198–205functions,200–205preg_grep,201preg_match,201preg_match_all,201preg_quote,202preg_replace,203preg_replace_callback,203preg_split,204metacharacters,199–200modifiers,199PerlversionsinstallingApacheonLinux/Unix,11permissionserrorlogging,180retrievingpermissionsforfiles,240,241828INDEXpersistencePDO_ATTR_PERSISTENTattribute,560persistentornon-persistentconnections,669pgsql.
allow_persistentdirective,666pgsql.
auto_reset_persistentdirective,666pgsql.
max_persistentdirective,666personalattribute,messages,379pfsockopenfunction,367pg_affected_rowsfunction,681,773pg_classtable,656pg_closefunction,671pg_connectfunction,668pg_connection_busyfunction,672pg_connection_statusfunction,673pg_convertfunction,683pg_copy_fromfunction,684,782pg_copy_tofunction,683,782–783pg_ctlcommand/programcommandtypes,594immediatestop,595options,594startingandstoppingdatabaseserver,594startingPostgreSQLforfirsttime,590pg_deletefunction,682,685pg_dumpcommand,605upgradingPostgreSQL,610pg_dumpallcommand,607pg_executefunction,686pg_fetch_arrayfunction,678pg_fetch_assocfunction,680pg_fetch_objectfunction,680pg_fetch_rowfunction,680pg_free_resultfunction,678pg_hba.
conffile,652,654pg_insertfunction,682pg_last_errorfunction,675pg_last_noticefunction,674pg_num_rowsfunction,681pg_pconnectfunction,669pg_preparefunction,685pg_queryfunction,672,772pg_restorecommand,608upgradingPostgreSQL,610pg_result_errorfunction,675pg_result_error_fieldfunction,676pg_result_statusfunction,674pg_send_executefunction,686pg_send_queryfunction,672pg_send_query_paramsfunction,686pg_set_error_verbosityfunction,677pg_shadowtable,652,653pg_updatefunction,682,684pg_userview,653pgAdminIII,620–621PGDATAenvironmentvariable,590PGDATABASEvariable,psql,615PGHOSTvariable,psql,615PGHOSTADDRvariable,psql,615PGPASSWORDvariable,psql,615pgportoptioninstallingPostgreSQLfromsource,583PGPORTvariable,psql,615pgsqlclassseePostgreSQLdatabaseclasspgSQLfunctionsseePL/pgSQLfunctionspgsql.
allow_persistentdirective,666pgsql.
auto_reset_persistentdirective,666pgsql.
ignore_noticedirective,667pgsql.
log_noticedirective,667pgsql.
max_linksdirective,667pgsql.
max_persistentdirectives,666PGSQL_ASSOCvalue,678PGSQL_BAD_RESPONSEvalue,674PGSQL_BOTHvalue,679PGSQL_COMMAND_OKvalue,674PGSQL_COPY_INvalue,674829INDEXPGSQL_COPY_OUTvalue,674PGSQL_DIAG_XYZvalues,676,677PGSQL_DML_NO_CONVvalue,682PGSQL_DML_STRINGvalue,682PGSQL_EMPTY_QUERYvalue,674PGSQL_ERRORS_DEFAULTvalue,678PGSQL_ERRORS_TERSEvalue,678PGSQL_ERRORS_VERBOSEvalue,678PGSQL_FATAL_ERRORvalue,675PGSQL_NONFATAL_ERRORvalue,675PGSQL_NUMvalue,678PGSQL_STATUS_LONGvalue,674PGSQL_STATUS_STRINGvalue,674PGSQL_TUPLES_OKvalue,675PGUSERvariable,psql,615phantomreads,766phoneNumbermethodValidate_USpackage,PEAR,227PHP(PersonalHomePage)autoselectingformsdata,310–311changeofPHPabbreviation,2codereuse,259comments,46–47configuringPHPsecurely,516–520hidingconfigurationdetails,521–522constants,68controlstructures,78–89datatypes,50–57dateandtimefunctions,272–278delimitingcodeasPHP,43–46downloading,10–11sourcedistribution,11Windowsinstallerinterface,11Windowszippackage,11downloadingPHPmanual,19embeddingPHPcodeinHTML,43–46errorreportinglevels,30escapesequences,76expressions,68–75fileuploads,346–355generalfeatures,4–7generatingformswith,308–310history,1–4identifiers,57–58installationproblems,18installingcustomizingUnixbuild,17customizingWindowsbuild,17–18onLinux/Unix,11–13onWindows,13–16usingPostgreSQLlibrary,11output,47–50passingPHPvariableintoJavaScriptfunction,311–313stringinterpolation,75–77superglobalvariables,63testinginstallation,16–17transactionmethods,772transactions,771–775usingCrackLibextension,340–341variables,58–67webforms,303–313workingwithmultivaluedformcomponents,307–308PHP4,2–3PHP5,3–4SOAPextension,502–512GNOMEXMLlibrary,503PHP5.
1Date(DateandTimeLibrary),288–301PHPauthentication,326–337authenticationmethodologies,328–337authenticationvariables,327–328PHPbaseexceptionclass,185PHPconfigurationdirectivescreatingSOAPserver,507–508datahandling,32dynamicextensions,39830INDEXenablingPostgreSQLextension,665errorandexceptionhandling,177–180errorhandlingandlogging,29fileupload/resourcedirectives,346–347fileuploads,37fopenwrappers,38languageoptions,22mailfunction,40,367–368managingconfigurationdirectives.
htaccessfile,19–21httpd.
conffile,21ini_setfunction,21php.
inifile,19–20modifyingwithinscopeofdirective,21modulesettings,39pathsanddirectories,36PostgreSQLextension,666–667resourcelimits,28safemode,25sessionhandling,427–432syntaxhighlighting,27syslog,39PHPconfigurationdirectives,listofallow_call_time_pass_reference,25allow_url_fopen,38always_populate_raw_post_data,36arg_separator.
input,33arg_separator.
output,32asp_tags,22auto_append_file,35auto_detect_line_endings,39auto_prepend_file,35auto_start,429cache_expire,431cache_limiter,431cookie_domain,429cookie_lifetime,429cookie_path,429default_charset,36default_mimetype,35default_socket_timeout,39define_syslog_variables,39disable_classes,27disable_functions,26display_errors,30,179display_startup_errors,30,179doc_root,37docref_ext,32docref_root,31enable_dl,37engine,22entropy_file,430entropy_length,431error_append_string,32error_log,32,180error_prepend_string,32error_reporting,29,178expose_php,28extension,39extension_dir,37file_uploads,38,346force_extra_parameters,368from,38gc_divisor,430gc_maxlifetime,432gc_probability,430hash_bits_per_character,432hash_function,431highlight.
bg,28highlight.
comment,27highlight.
default,28highlight.
html,28highlight.
keyword,28highlight.
string,27html_errors,31ignore_repeated_errors,31,180ignore_repeated_source,31,180ignore_user_abort,27831INDEXimplicit_flush,24include_path,36java.
class.
path,40java.
home,41java.
library,41java.
library.
path,41log_errors,30,179log_errors_max_len,31,180magic_quotes_gpc,35magic_quotes_runtime,35magic_quotes_sybase,35max_execution_time,29,346max_input_time,29memory_limit,29,347name,429open_basedir,26output_buffering,23output_handler,23pgsql(with-pgsql),665pgsql.
allow_persistent,666pgsql.
auto_reset_persistent,666pgsql.
ignore_notice,667pgsql.
log_notice,667pgsql.
max_links,667pgsql.
max_persistent,666post_max_size,34,347precision,23referer_check,430register_argc_argv,34register_globals,33register_long_arrays,34report_memleaks,31safe_mode,25safe_mode_allowed_env_vars,26safe_mode_exec_dir,25safe_mode_gid,25safe_mode_include_dir,25safe_mode_protected_env_vars,26save_handler,427save_path,428sendmail_from,40,368sendmail_path,40,368serialize_handler,430serialize_precision,24short_open_tag,22SMTP,40,367smtp_port,40,368track_errors,31,180unserialize_callback_func,24upload_max_filesize,38,347upload_tmp_dir,38,347url_rewriter.
tags,432use_cookies,428use_only_cookies,428use_trans_sid,431user_agent,38user_dir,37variables_order,33y2k_compliance,23zend.
ze1_compatibility_mode,22zlib.
output_compression,24zlib.
output_handler,24PHPDataObjectsseePDOPHPExtensionCommunityLibrary(PECL),340phpfunctions,91–101arrayfunctions,105–131dateandtimefunctions,PHP,272–278helperfunctions,153–155regularexpressionfunctions,195–205Smartytemplatingengine,464stringmanipulationfunctions,205–226PHPreflectionAPIseereflectionAPIPHPscriptsreferencingPOSTdata,304832INDEXphp.
inifilecomments,20configurationtemplates,19customizingPHPinstallationonWindows,17installingPHPonLinux/Unix,12installingPHPonWindows,15managingconfigurationdirectives,19–20PDOconstructors,559settingparameters,20php.
ini-distfileinstallingPHPonLinux/Unix,12installingPHPonWindows,15php.
ini-recommendedfileinstallingPHPonLinux/Unix,13installingPHPonWindows,15php.
iniconfigurationtemplates,19php_admin_flagkeywordmanagingconfigurationdirectives,21php_admin_valuekeywordmanagingconfigurationdirectives,21PHP_AUTH_PWauthenticationvariables,PHP,327hardcodedauthentication,329PHP_AUTH_USERauthenticationvariables,PHP,327hardcodedauthentication,329php_flagkeyword,21PHP_INI_XYZscopes,21php_valuekeyword,21phpinfofunctionhidingconfigurationdetails,522testingPHPinstallation,16,17phpPgAdmin,621–622exportinterface,784importinterface,784importingandexportingdatawith,783–785PHPUnitpackage,PEAR,260pingingserver,394–395pipe(|)operatorregularexpressions,193PL(procedurallanguages),736PL/pgSQLfunctionsALIAStype,731arguments,731controlstructures,732–733errorhandling,733–735notifyingerrors,734trappingerrors,733examplefunction,735EXCEPTIONclause,733FORloops,733IFblock,732installing,730INTOdesignation,732nesting,736RAISEcommand,734syntax,731–736userdefinedfunctions,PostgreSQL,730–736variableassignment,732variabledeclaration,731WHILEloops,732PL/PHPfunction,737platformsupport,PostgreSQL,574pointersmovingfilepointer,249,250retrievingfilepointerposition,250polymorphism,135POP3protocolIMAPprotocol,372openingconnectionstoPOP3mailboxes,374PortNumberoptioninstallingPostgreSQL,587portparameterpg_connectfunction,668portsettings,postgresql.
conffilesecuringPostgreSQL,651833INDEXportsseealsosocketconnectionsc-clientlibraryconfusion,373creatingportscannerwithfsockopen(),366creatingportscannerwithNMap,395defaultportsforinternetservices,364establishingport80connection,365settingporttoconnecttoserver,368positionfunction,PostgreSQL,724POSIXregularexpressionfunctions,195–198POSIXregularexpressionsyntax,193–195$_POSTsuperglobalvariable,65POSTmethod,304POSTvariables,304post_max_sizeparameter,34fileupload/resourcedirectives,347workingwithmultiplefileuploads,355postalCodemethodValidate_USpackage,PEAR,227postgressuperuserpassword,650postgresuserinstallingPostgreSQLonLinux,584PostgreSQL,573–577administration,593–610ANALYZEcommand,603authenticatinguseragainstPostgreSQLtable,332authentication,575autovacuumparameter,604backupandrecovery,605–609pg_dumpcommand,605pg_dumpallcommand,607pg_restorecommand,608clients,611–623command-lineinterface,611commands,667–671configurationdirectives,666–667connectingtonewdatabase,psql,614COPYcommand,777–783customPostgreSQL-basedsessionhandlers,442–445dataintegrity,574databaseclassseePostgreSQLdatabaseclassdeletingdata,685displayingdata,678–681downloading,579–581documentation,581Unixversion,580Windowsversion,580–581editingfilewithoutleavingpsql,614enablingPostgreSQLextension,665errorinformation,673–678executingcommandslocatedinspecificfile,614executingqueriesviapsql,618extensibility,574features,574–576GlobalDevelopmentGroup,575GUI-basedclients,620–623indexes,749–759informationschema,687–688insertingdata,682–684inserting/modifying/deletingdata,682–685installing,581–589onLinuxandUnix,582–585onWindows2000/XP/2003,585–589onWindows95/98/ME,589installingonLinuxandUnixinstallingfromRPMs,582installingfromsource,582–583internalfunctions,723–727licensing,575,579loggingon/offserverviapsql,613memoryrecuperation,678modifyingdata,684MultiversionConcurrencyControl,574,602Navicat,622–623834INDEXoperators,719–723originsof,573PDOsupporteddatabases,559pgAdminIIIutility,620–621PHP'sPostgreSQLextension,665–688phpPgAdmin,621–622platformsupport,574preparedstatements,685–686privileges,575procedurallanguages,736–737psql,611–619queries,671–673retrievingdata,678–681rules,708–711ruletypes,710–711scalability,574searching,759–764security,575,649–663addinggroups,659addingusers,658amendingusersingroups,659applyingpatches,650auditinganddisablinguseraccounts,650deletinggroups,660disablingunusedsystemservices,650GRANTcommand,660grantingauserpermissionsonalltables,661initialtasks,649–651modifyinguserattributes,658PostgreSQLaccessprivilegesystem,651–662postgresql.
conffile,651removingusers,658REVOKEcommand,661roles,660securingconnections,661settingsuperuserpassword,650sortingoutput,700utilizingfirewalls,650sendingqueryoutputtoexternalfile,614startingandstoppingdatabaseserver,593–596operatingsystemcommands,595pg_ctlprogram,594startingforfirsttime,589statusinformation,673–678storingconfigurationinformationinstartupfile,616support,576systemmaintenancetasks,602–605tablespaces,601–602transactionisolationlevels,766transactions,766–771triggers,739–747tuninginstallation,596–600logging,599managingdiskactivity,598managingplannerresources,598managingresources,596managingrun-timeinformation,600upgradingbetweenversions,609userdefinedfunctions,727–737usersAfiliasInc,576NationalWeatherService,577WhitePages.
com,577VACUUMcommand,602–603verifyingPHP'sPostgreSQLsupport,666viapsql,618views,707–708makingviewsinteractive,711–716workingwithviewsfromPHP,716–717PostgreSQLaccessprivilegesystemauthentication,652authorization,652connectionauthentication,652informationstorage,652pg_classtable,652,656pg_hba.
conffile,652,654835INDEXpg_shadowtable,652requestverification,652PostgreSQLdatabaseclassactionableoptionsintableoutput,697advantagesofusing,692–693affectedRowsfunction,691connectfunction,690connectingtodatabase,693constructor,690countingqueriesexecuted,694creatingpagedoutput,689creatingpgsqlclass,690–692diestatement,691,692executingquery,693fetchArrayfunction,691fetchObjectfunction,691fetchRowfunction,691fieldNamefunction,696getResultAsTablemethod,696,698,699introduction,689linkingtodetailedview,697–699listingpagenumbers,704–706numberFieldsfunction,695numQueriesfunction,692,694numRowsfunction,691objectorientation,692,693pageLinksfunction,704,705pagingoutput,701–704producttable,689queryfunction,691retrievingrows,694sortingoutput,689,699–701tabularoutput,689,695–697PostgreSQLdatabaseclusterinstallingPostgreSQLonLinux,584PostgreSQLlibraryinstallingPHP,11postgresql.
conffilekrb_server_keyfile,651listen_address,651ports,651securingPostgreSQL,651SSLconnections,651postmasterexecutablefilestartingandstoppingdatabaseserver,593PracticalQueryAnalysis(PQA)tool,600precedence,operators,69,70PostgreSQL,722precisionserialize_precisiondirective,24precisionparameter,23precisionspecifierprintfstatement,49predefinedcharacterrangesregularexpressions,194prefetchingPDO_ATTR_PREFETCHattribute,560prefixoptioninstallingPostgreSQLfromsource,583prefixingleftmostprefixing,752preg_grepfunction,201preg_matchfunction,201preg_match_allfunction,201preg_quotefunction,202preg_replacefunction,203preg_replace_callbackfunction,203preg_splitfunction,204preparemethod,PDO,564preparedstatementsPDO,562,564–566pg_executefunction,686pg_preparefunction,685pg_send_executefunction,686pg_send_query_paramsfunction,686PostgreSQL,685–686presentationallogicseparatingbusinesslogicfrom,448Smartytemplatingengine,450,454–464templatingenginesand,448836INDEXprevarrayfunction,114PRIMARYKEYattributePostgreSQLdatatypes,642primarykeyindexes,PostgreSQL,750primarykeyvalues,642printstatement,PHP,47print_rarrayfunction,105printfstatement,PHP,49privatedesignationcachingsessionpages,431privatefields,139privatemethods,145privileges,PostgreSQL,575GRANTcommand,660REVOKEcommand,661procedurallanguagesinstallingPostgreSQL,588PL/pgSQLfunctions,730–736PostgreSQL,736–737samplePL/PHPfunction,737producttable,689creating,557PostgreSQLextension,PHP,667promptscommonpromptsubstitutionsequences,619modifyingpsqlprompt,618properties,OOP,140–143creatingcustomgettersandsetters,142getter(_get)method,142PHPlimitations,140ReflectionPropertyclass,175setter(_set)method,140protectedfields,139protectedmethods,146proxiesgeneratingC#proxyforWebService,513NuSOAPdesignatingHTTPproxy,501NuSOAPproxyclasses,493NuSOAP,creatingamethodproxy,495usingNuSOAP'sProxyclass,495proxy_host/proxy_login/proxy_password/proxy_portparametersSoapClientconstructor,503psql,611–619options,613–614controllingcommandhistory,619listingpsqlcommands,613viewingallavailablecommands,617commonpromptsubstitutionsequences,619commonlyusedpsqlvariables,615psqltasks,613–619connectingtonewdatabase,614controllingcommandhistory,619editingfilewithoutleavingpsql,614executingcommandslocatedinspecificfile,614executingqueries,618loggingon/offserver,613modifyingpsqlprompt,618sendingqueryoutputtoexternalfile,614storingconfigurationinformationinstartupfile,616storingpsqlvariablesandoptions,615–616viewingallavailablecommands,617viewinglistofsetvariables,615tab-completionfeature,614PSQL_EDITORvariable,615PTR(PointerRecord)recordtype,DNS,360publicdesignationcachingsessionpages,431publicfields,138publicmethods,145:punct:characterclass,195purchase.
phpswapmeetproject,774837INDEXputenvfunctionsafe_mode_protected_env_varsdirective,518pythonoptioninstallingPostgreSQLfromsource,583Qqoption,psql,613quantifiersPerlstyle,198regularexpressions,193,194queries,PDO,562–563queries,PostgreSQL,671–673databaseclassseePostgreSQLdatabaseclasspg_queryfunction,672pg_send_queryfunction,672PGSQL_EMPTY_QUERYvalue,674queryingaviewwithPHP,716workingwithviews,707queries,SQLite,540–541sqlite_array_queryfunction,543sqlite_queryfunction,540sqlite_unbuffered_queryfunction,541queryfunctionPostgreSQLdatabaseclass,691querymethod,PDO,563queryoptimizationindexes,PostgreSQL,749questionmarkparameterspreparedstatements,PDO,564QUOTEclause,COPYcommandcopyingdatato/fromtables,782quotesmagic_quotes_gpcdirective,35magic_quotes_runtimedirective,35magic_quotes_sybasedirective,35useofsingleanddoublequotes,34RRAISEcommandPL/pgSQLfunctions,734randomvalues,129random_page_costsetting,PostgreSQL,598rangearrayfunction,108rankfunctionusingfull-textindexes,PostgreSQL,758ReadCommittedtransactionisolationlevels,766ReadUncommittedtransactionisolationlevels,766readablefilescheckingiffilereadable,241readdirfunction,251readfilefunction,248readingldap_readfunction,405readingdirectory'scontents,251–252readingfiles,244–249readline-develpackageinstallingPostgreSQLfromsource,583readlinkfunction,235REALdatatype,PostgreSQL,638specialvalues,638RealSimpleSyndication(RSS),476–486introduction,473MagpieRSS,479–486MoreoverTechnologies,476RSSaggregators,476RSSfeeds,476,477RSSsyntax,478SharpReaderinterface,477realpathfunction,231recentattribute,messages,380,383recentlyvieweddocumentindexexamplesessionhandling,439,440RECORDtypevariabledeclarationPL/pgSQLfunctions,731838INDEXrecovery,PostgreSQL,605–609recursivefunctions,63,97RedHatoperatingsystemstartingandstoppingPostgreSQLserver,596referenceassignmentvariabledeclaration,PHP,59REFERENCESattributePostgreSQLdatatypes,643referencesattribute,messages,384referentialintegrity,tables,643referer_checkdirective,430reflectionAPIclassescomprising,170othertasksusing,176PEARpackagesdependingon,176ReflectionClassclass,170ReflectionMethodclass,172ReflectionParameterclass,174ReflectionPropertyclass,175reflection,OOP,169–176description,157introspection,170ReflectionClassclass,170ReflectionMethodclass,172ReflectionParameterclass,174ReflectionPropertyclass,175regionmethodValidate_USpackage,PEAR,227registercommand,pg_ctlprogram,594register_argc_argvparameter,34register_globalsparameter,33register_long_arraysparameter,34register_tick_functionfunction,PHP,78registration.
phpfilepassworddesignation,338registrycaution:PEAR_ENV.
regfile,263regularexpressionoperators,PostgreSQL,721regularexpressions,192–205alternativestoregularexpressionfunctions,214–222Perlregularexpressionsyntax,198–205functions,200–205metacharacters,199–200modifiers,199PHPregularexpressionfunctions,POSIX,195–198pipe(|)operator,193POSIXregularexpressionsyntax,193–195predefinedcharacterranges,194rejectauthenticationmethodpg_hba.
conffile,PostgreSQL,655relaclcolumnpg_classtable,PostgreSQL,656reloadcommand,pg_ctlprogram,594REMOTE_ADDR,$_SERVERsuperglobal,65renamefunction,253RENAMEkeyword,627alteringtables,632renamingentriesldap_renamefunction,417RepeatableReadtransactionisolationlevels,766replacefunction,PostgreSQL,724replaceparameter,headerfunctionauthentication,PHP,327reply_toattribute,messages,380reply_toaddressattribute,messages,380report_memleaksparameter,31reportingsensitivitylevelerror_reportingdirective,178$_REQUESTsuperglobalvariable,67requestattributeNuSOAPdebugging,502requestverificationPostgreSQLaccessprivilegesystem,652REQUEST_URI,$_SERVERsuperglobal,65839INDEXrequirestatementfunctionlibraries,100PHP,88Smartytemplatingengine,452require_oncefunction,PHP,89require_oncestatement,OOP,155resetarrayfunction,113resourcedatatype,PHP,53resourcehandling,PHP4,2resourcelimitsPHPconfigurationdirectives,28resourcesfileI/O,242managing,PostgreSQL,596responseattribute,NuSOAPdebugging,502restartcommandpg_ctlprogram,594RESTRICTkeyworddeletingsequences,635droppingschemas,628droppingviews,708RESTRICToptionremovingtriggers,PostgreSQL,741restrictedmodeseesafemoderesultsets,SQLitemanipulatingresultsetpointer,546–548parsing,541–544retrievingdetails,544–546sqlite_currentfunction,546sqlite_has_morefunction,546sqlite_nextfunction,547sqlite_rewindfunction,547sqlite_seekfunction,547resultspg_free_resultfunction,678pg_result_errorfunction,675pg_result_error_fieldfunction,676pg_result_statusfunction,674retrieveBiofunction,NuSOAPreturninganarraytotheclient,498retrievingdata,PostgreSQL,678–681rowsselectedandrowsmodified,681retrievingLDAPdata,404returnkeyword/statementreturningmultiplevalues,96returningvaluesfromfunctions,95returnstatement,PHP,78return_pathattribute,messages,380reusingsoftwarereasonsforwebservices,475REVOKEcommandsecuringPostgreSQL,661REVOKEDELETEcommandmakingviewsinteractive,715rewindfunction,250rewritefeature,Apache,315right_delimiterattributeusingCSSinconjunctionwithSmarty,467rmdirfunction,252rolessecuringPostgreSQL,660rollbackrollingbacktransactions,765transactionsexample,770ROLLBACKcommandtransactionsexample,770,771rollbackmethod,PDO,571rollbackmethod,PHP,772rollbacktosavepointmethod,PHP,772Romannumeralsconvertingnumeralformats,261rootdoc_rootdirective,519DocumentRootdirective,Apache,523hidingsensitivedata,523rowCountmethod,PDO,563840INDEXrowspg_affected_rowsfunction,681pg_fetch_rowfunction,680pg_num_rowsfunction,681PostgreSQLdatabaseclassretrieving,694sqlite_changesfunction,546sqlite_last_insert_rowidfunction,541sqlite_num_rowsfunction,546RPCimplementationofXML-RPCprotocol,261RPMsdownloadingPostgreSQL,580installingPostgreSQLfrom,582rsortarrayfunction,120rtrimfunction,223rules,PostgreSQL,708–711creatingrules,709deleterules,711DOALSOformofarule,716insertrules,710INSTEADformofarule,715makingviewsinteractive,711–716removingrules,709ruletypes,710–711rulesandtriggers,747selectrules,710updaterules,710runtime,PostgreSQLmanagingrun-timeinformation,600SsafemodeconfiguringPHPsecurely,516–518effectofenabling,516PHPconfigurationdirectives,25sql.
safe_modedirective,520safe_modeparameter,25,516–517,520safe_mode_allowed_env_varsparameter,26,518safe_mode_exec_dirparameter,25,518safe_mode_gidparameter,25,517safe_mode_include_dirparameter,25,517safe_mode_protected_env_varsparameter,26,518save_handlerdirective,427save_pathdirective,428savepoints,transactions,769scalabilitydatabasebasedauthentication,331PHP4features,2PostgreSQL,574scandirfunction,252schemacommand,SQLite,537schemasearchpath,628schemascreating,627dropping,628informationschema,687–688renaming,628schemasearchpath,628tableschemas,SQLite,548schemaTargetNamespacemethod,499scopemodifyingconfigurationdirectiveswithin,21nestingfunctions,97passingargumentsbyreference,93passingargumentsbyvalue,92scopeattributeconfig_loadfunction,Smarty,466scope,PHPvariables,60–63functionparameters,61globalvariables,61localvariables,60staticvariables,62scriptparameterinserttag,Smarty,463scripttagdelimitingPHPcode,45841INDEXscriptingcross-sitescripting,524scriptsdoc_rootdirective,37searches,PostgreSQLfull-textsearch,763textsearching,749searchingldap_listfunction,405ldap_readfunction,405ldap_searchfunction,404PostgreSQL,759–764schemasearchpath,628sectionattributeconfig_loadfunction,Smarty,466sectionfunction,Smarty,459sectionelsefunction,Smarty,461securityconfiguringPHPsecurely,516–520changingdocumentextension,522configurationparameters,518–520expose_phpdirective,521hidingconfigurationdetails,520–522safemode,516–518stoppingphpinfoCalls,522cross-sitescripting,524dataencryption,528–532filedeletion,524hidingsensitivedata,522–523LDAPmodels,400NuSOAPconnections,502programmingsecurelyinPHP,515–532PostgreSQL,575,649–663userdefinedfunctions,728sanitizinguserdata,524–528escapeshellargfunction,526escapeshellcmdfunction,527functionsfor,526htmlentitiesfunction,527strip_tagsfunction,528Smartytemplatingengine,450SQLite,535variablefunctions,100SEEK_CUR/SEEK_END/SEEK_SETmovingfilepointer,249seenattribute,messages,384selectingdata,PostgreSQLnumberofrowsselected,681selectrules,710selfkeywordstaticclassmembers,153senderattribute,messages,381senderaddressattribute,messages,380sendingmessagesimap_mailfunction,387sendmail_fromdirective,40,368sendmail_pathdirective,40,368separatorsarg_separator.
inputdirective,33arg_separator.
outputdirective,32sequencescreating,633deleting,635functions,634modifying,633SERIALdatatype,PostgreSQL,639Serializabletransactionisolationlevels,766serializemethod,NuSOAP,501serialize_handlerdirective,430serialize_precisiondirective,24$_SERVERsuperglobalvariable,65Servererrorfaultstringattribute,NuSOAP,500serversignatureexpose_phpdirective,521serversPDO_ATTR_SERVER_XYZattributes,560startingandstoppingdatabaseserver,593–596ServerSignaturedirective,Apache,520842INDEXServerTokensdirective,Apache,521serviceconfigurationinstallingPostgreSQL,586ServiceNameparameterinstallingPostgreSQL,586serviceparameterpg_connectfunction,668servicesinternetservices,364–365securingPostgreSQL,650$_SESSIONsuperglobalvariable,67sessionhandling,425–446seealsocookiesautologinexample,437–439configurationdirectives,427–432creating/deletingsessionvariables,434customPostgreSQL-basedsessionhandlers,442–445definingcallbackhandlers,430destroyingasession,433determininghowsessionpagesarecached,431directivesauto_start,429,433cache_expire,431cache_limiter,431cookie_domain,429cookie_lifetime,429,437cookie_path,429entropy_file,430entropy_length,431gc_divisor,430gc_maxlifetime,432gc_probability,430hash_bits_per_character,432hash_function,431name,429referer_check,430save_handler,427save_path,428serialize_handler,430url_rewriter.
tags,432use_cookies,428use_only_cookies,428use_trans_sid,431encoding/decodingsessiondata,435functionssession_close,441session_decode,436session_destroy,433,441session_encode,435session_garbage_collect,441session_id,434session_open,441session_read,441session_register,434session_set_save_handler,441session_start,433session_unregister,434session_unset,433,434session_write,441managingobjectswithinsessions,429recentlyvieweddocumentindexexample,439–440retrievingandsettingSID,434session-handlingsupport,PHP4,3startingasession,432storingsessioninformation,427userdefinedsessionhandlers,441–445verifyinglogininformationusingsessions,438sessioninfotablecustomPostgreSQL-basedsessionhandlers,442setcommand,psql,615setAttributemethod,PDO,561setCancelTextmethodAuth_HTTPclass,PEAR,336setClassmethodcreatingSOAPserver,510843INDEXsetcookiefunction$_COOKIEsuperglobal,66setDaymethod,291setDMYmethod,290setFetchModemethod,PDO,570setFirstDowmethod,300setHTTPProxymethod,NuSOAP,501setJulianmethod,292setLastDowmethod,301setlocalefunction,279setMonthmethod,292setPersistencemethodcreatingSOAPserver,510setsavepointmethod,772setter(_set)methodcreatingcustomgettersandsetters,142properties,140setToLastMonthDaymethod,300setToWeekdaymethod,298settypefunction,56setvalsequencefunction,634setYearmethod,293shared_bufferssetting,PostgreSQL,596SharpReaderinterface,477shellcommands,252–253systemlevelprogramexecution,254–258shellsyntaxcomments,PHP,46SHELL,$_ENVsuperglobal,67shell_execfunction,258shorttagscaution:XMLclash,45delimitingPHPcode,44short_open_tagparameter,22,44showattributesectionfunction,Smarty,460show_sourcefunctionsyntaxhighlighting,27shufflearrayfunction,129shufflingaddingvaluesinarrays,130shufflingvaluesinarrays,129SIDcookiesstoring,426generationprocedure,430hash_bits_per_characterdirective,432hash_functiondirective,431persistenceusingURLrewriting,426retrievingandsetting,434sessionhandlingusingSID,425session_idfunction,434use_trans_siddirective,431SimpleXML,486–491functions,486–488simplexml_import_dom,488simplexml_load_file,487simplexml_load_string,488methods,488–491asXML,489attributes,488children,489xpath,490SimpleXMLextension,474simplicity,5singlequotesstringinterpolation,76single-columnnormalindexes,PostgreSQL,751single-dimensionalarrays,104sizeattribute,messages,384sizevariable$_FILESarray,348size_limitparameter,ldap_search(),404sizeofarrayfunction,117SMALLINTdatatype,PostgreSQL,637Smartytemplatingengine,449–471$cache_lifetimeattribute,468caching,450,468–471multiplecachespertemplate,470844INDEXcomments,454configurationfiles,465–466controlstructures,457–462creatingsimpledesigntemplate,452features,449functionscapitalize,454config_load,465count_words,455date_format,455default,456display,453get_config_vars,466include_php,464is_cached,469php,464section,459sectionelse,461strip_tags,456truncate,456inserttag,463insertingbannerintotemplate,463installing,450–452instantiatingSmartyclass,452literaltag,464makingavailabletoexecutingscript,452presentationallogic,450,454–464referencingconfigurationvariables,466security,450statementselse,458fetch,462foreach,458foreachelse,459if,457include,462require,452syntaxoftypicalSmartytemplate,449syntaxoftypicaltemplate,448templatecompilation,450using,452–454usingCSSinconjunctionwith,467variablemodifiers,454–457$smarty.
configvariable,466SMARTY_DIRconstant,451SMTPdirective,40,367SMTPprotocol,implementationof,260smtp_portdirective,40,368SOA(StartofAuthorityRecord)recordtype,361SOAP,491–512boxingclient/server,511C#SOAPclient,513client/serverinteraction,511–512configurationdirectives,507–508creatingSOAPclient,503–506creatingSOAPserver,506–511definition,491introduction,474methods/functionsaddFunction,509addingclassmethods,510exportingallfunctions,509getFunctions,504getLastRequest,505getLastResponse,505getQuote,509handle,509setClass,510setPersistence,510NuSOAP,492–502PHP5'sSOAPextension,502–512SoapClientconstructor,503–504SoapServerconstructor,508soap.
wsdl_cache_dirdirective,508soap.
wsdl_cache_enableddirective,508845INDEXsoap.
wsdl_cache_ttldirective,508soap_faultclassNuSOAPerrorhandling,500,501SOAP_PERSISTENCE_REQUESTmode,511SOAP_PERSISTENCE_SESSIONmode,511soap_versionparameterSoapClientconstructor,504SoapServerconstructor,508SoapClientconstructor,503–504actorparameter,503compressionparameter,503creatingSoapClientobject,504exceptionsparameter,503loginparameter,503optionsparameter,503passwordparameter,503proxy_hostparameter,503proxy_loginparameter,503proxy_passwordparameter,503proxy_portparameter,503soap_versionparameter,504traceparameter,504wsdlparameter,503SoapServerconstructor,508actorparameter,508optionsparameter,508soap_versionparameter,508wsdlparameter,508SOAPx4seeNuSOAPsocialsecuritynumbersusingValidate_USpackage,PEAR,227socketconnectionsseealsoportsestablishing,365–367fsockopenfunction,365–367pfsockopenfunction,367socketfiletype,232softwareasaservice,475sortarrayfunction,118sortflagsarray_multisortflags,121sort_flagsparameter,118sort_memsetting,PostgreSQL,596sortingtabularoutput,PostgreSQL,699–701sortingvaluesldap_sortfunction,411sourcedistribution,Apache,10sourcedistribution,PHP,11sourcedistribution,PostgreSQL,580,582–583:space:characterclass,195specialcharactersconvertingintoHTML,211insertingbackslashdelimiterbefore,202spellcheckerGoogleWebService,494splitfunctionfilebasedauthentication,330regularexpressions,197split_partfunction,PostgreSQL,724makingviewsinteractive,713splitifunction,198sprintfstatement,PHP,50SQL(StructuredQueryLanguage)transactionisolationlevels,766userdefinedfunctions,PostgreSQL,728SQLServerPDOsupporteddatabases,558sql.
safe_modedirective,520sql_regcasefunction,198SQLite,535–553binarydata,549–550characteristics,535closingconnections,539command-lineinterface,536–537creatingtableinmemory,539directives,537–538functions846INDEXcreatingaggregatefunctions,551–553creatingandoverriding,550–551sqlite_array_query,543sqlite_changes,546sqlite_close,540sqlite_column,543sqlite_create_aggregate,552sqlite_create_function,550sqlite_current,546sqlite_escape_string,549sqlite_fetch_array,541,542sqlite_fetch_column_types,548sqlite_fetch_single,544sqlite_fetch_string,544sqlite_field_name,545sqlite_has_more,546sqlite_last_insert_rowid,541sqlite_next,547sqlite_num_fields,545sqlite_num_rows,546sqlite_open,538,539sqlite_popen,539sqlite_query,539,540sqlite_rewind,547sqlite_seek,547sqlite_udf_decode_binary,551sqlite_udf_encode_binary,551sqlite_unbuffered_query,541helpoption,536installing,536licensing,535manipulatingresultsetpointer,546–548objectorientation,539openingconnections,538–539parsingresultsets,541–544PDOsupporteddatabases,559PHP'sSQLitelibrary,537–553queryingdatabase,540–541retrievingresultsetdetails,544–546security,535storingsessioninformation,427tableschemas,548transactions,535sqliteoption,427SQLitesupport,PHP5,4sqlite.
assoc_casedirective,538SQLITE_ASSOCoption,542SQLITE_BOTHoption,542SQLITE_NUMoption,542SQLSTATEcodes,562squarebracketoffsetsyntax,PHP5,192SquirrelMail,373SRV(ServicesRecord)recordtype,DNS,361SSL(SecureSocketsLayer)NuSOAPfeatures,493secureconnections,NuSOAP,502SSLconnectionsc-clientlibraryconfusion,373postgresql.
conffilesecuringPostgreSQL,651securingPostgreSQLconnections,661–662configurationoptions,662FrequentlyAskedQuestions,662installingOpenSSLlibrary,661performance,662portnumber,662trafficencryption,662usingHTTPStoencrypttraffic,662SSLsupportApache,10sslmodeparameterpg_connectfunction,668ssnmethodValidate_USpackage,PEAR,227STABLEfunctions,PostgreSQL,728startattributesectionfunction,Smarty,460847INDEXstartcommand,pg_ctlprogram,594STARTTRANSACTIONcommand,768STARTWITHkeywords,633statfunction,234stateseesessionhandlingstateabbreviationsusingValidate_USpackage,PEAR,227statelessnesssessionhandlingandcookies,425statementspreparedstatements,PDO,564–566Smartytemplatingengine,462–464staticclassmembersOOP,152–153selfkeyword,153staticvariablesvariablescope,PHP,62statistics,PostgreSQLANALYZEcommand,603stats_command_stringsetting,600stats_row_levelsetting,600stats_start_collectorsetting,600statuscommandpg_ctlprogram,594statusinformation,PostgreSQL,673–678PGSQL_STATUS_LONGvalue,674PGSQL_STATUS_STRINGvalue,674stepattributesectionfunction,Smarty,460stopatfirstmatchPerlregularexpressionmodifier,199stopcommand,pg_ctlprogram,594stopwordsfull-textindexes,PostgreSQL,758str_ireplacefunction,219str_padfunction,223str_replacefunction,219str_word_countfunction,225strcasecmpfunction,207strcmpfunction,206strcspnfunction,207streams,390–393contexts,391functionsstream_context_create,391stream_filter_append,393stream_filter_prepend,393stream_get_filters,392streamfilters,391–393streamwrappers,390strftimefunction,PHP,281–282formatparameters,281–282stringcomparisonfunctions,206–208stringconversionfunctionsconvertingHTMLtoplaintext,214convertingplaintexttoHTML,210–213manipulatingstringcase,208–209orderoffunctionexecution,212stringdatatype,PHP,51stringdatatypes,PostgreSQL,639–640CHAR,639TEXT,640VARCHAR,640stringfunctionactionscapitalizingfirstletter,209ofeachword,209comparisonofstringscaseinsensitive,207casesensitive,206concatenatingarrayelements,217convertingcharactersintobracketedexpressions,198intoreplacementvalue,213newlinecharactersintoHTML,210specialcharactersintoHTML,211tolowercase,208touppercase,208unusualcharactersintoHTML,210848INDEXcountingoccurrencesofsubstring,221numberofcharacters,224numberofwords,225delegatingstringreplacementprocedure,203determiningstringlength,205dividingstring,204basedondelimiters,215caseinsensitive,198casesensitive,197intoarrayofsubstrings,216findingpositionofparameterinstringcaseinsensitive,218casesensitive,217lastoccurrenceofparameter,218insertingbackslashdelimiterbeforespecialcharacters,202lengthoffirstsegmentalso/notinstr2,207paddingstringtonumberofcharacters,223parsingintovariousvariables,215removingcharactersfrombeginning,222fromend,223HTMLandPHPtags,214replacingpatternalloccurrencesof,203caseinsensitive,197casesensitive,196replacingstringscaseinsensitive,219casesensitive,219forpartofstring,222returningremainderofstringafterparameteroccurs,219betweenparameters,220searchingforpatterninarray,201searchingforpatterninstringalloccurrences,201caseinsensitive,196casesensitive,195existenceofpattern,201translatingHTMLintotext,213translatingtextintoHTML,212stringfunctionscount_chars,224ereg,195ereg_replace,196eregi,196eregi_replace,197explode,216get_html_translation_table,212htmlentities,210htmlspecialchars,211implode,217join,217ltrim,222nl2br,210parse_str,215preg_grep,201preg_match,201preg_match_all,201preg_quote,202preg_replace,203preg_replace_callback,203preg_split,204rtrim,223split,197spliti,198sql_regcase,198str_ireplace,219str_pad,223str_replace,219str_word_count,225strcasecmp,207strcmp,206strcspn,207strip_tags,214,456,528stripos,218849INDEXstrlen,205strpos,217strrpos,218strspn,207strstr,219strtok,215strtolower,208strtotime,284strtoupper,208strtr,213substr,220,240substr_count,221substr_replace,222trim,223ucfirst,209ucwords,209stringfunctions,PostgreSQL,724stringhandling,PHP5,4stringinterpolation,75–77doublequotes,75heredocsyntax,77singlequotes,76stringmanipulation,205–226Perlregularexpressionmetacharacters,199Perlregularexpressionmodifiers,199stringoffsetsyntax,PHP5,191–192stringoperators,71stringoperators,PostgreSQL,721stringparsing,6stringslocalizedformats,280strip_tagsfunctionsanitizinguserdata,528Smartytemplatingengine,456stringmanipulation,214striposfunction,218stripslashesfunction,34strlenfunction,205strposfunction,217strrposfunction,218strspnfunction,207strstrfunction,219strtokfunction,215strtolowerfunction,208strtotimefunction,284strtoupperfunction,208strtrfunction,213subclass,OOP,162subDaysmethod,294subjectattribute,messages,380,384subMonthsmethod,295subnetconverter,395–397substrfunction,220exampleusing,240substr_countfunction,221substr_replacefunction,222substringfunction,PostgreSQL,724subtraction(-)operator,71subWeeksmethod,296subYearsmethod,297sumfunction,PostgreSQL,725superglobalvariables,PHP,63,67$_COOKIE,66$_ENV,67$_FILES,66$_GET,65$_GLOBALS,67$_POST,65$_REQUEST,67$_SERVER,65$_SESSION,67superuserpassword,PostgreSQL,650superusers,PostgreSQLdeterminingifuseris,653installingPostgreSQLfromsource,582support,PostgreSQL,576surrogatekeys,750850INDEXswapmeetproject,767exampleillustrating,768–771insertingdataintotables,768participanttable,767purchase.
php,774trunktable,767usingPHP,773switchstatement,PHP,81SybasePDOsupporteddatabases,559symboliclinkscreating,235retrievinginformationabout,233retrievingtargetof,235symlinkfunction,235syntaxhighlightingPHPconfigurationdirectives,27syslogdefine_syslog_variablesdirective,40errormessagesin,181PHPconfigurationdirectives,39syslogfunction,182syslogprioritylevels,182systemcommands,252–253systemfunction,256systemlevelprogramexecution,254–258backtickoperator,257delimitingarguments,255escapingshellmetacharacters,255executingoperatingsystemlevelapplication,256returningbinaryoutput,257executingshellcommands,257,258outputtingexecutedcommand'sresults.
,256sanitizinginput,254systemprogramssafe_mode_exec_dirdirective,518Ttab-completionfeature,psql,614tableschemas,SQLite,548tables,PostgreSQLalteringtablestructure,632copying,630copyingdatafromtabletotextfile,782copyingdatato/fromtables,778–782copyingdatafromatable,778exportingtableOIDs,780creating,629creatingtable-formattedresults,697creatingtemporarytables,630deleting,632foreignkeys,643getResultAsTablemethod,696namingconventions,630referentialintegrity,643viewinglistoftables,631viewingtablestructure,631tablespaces,PostgreSQL,601–602altering,602creating,601dropping,602owner,601tabulardateclassesCalendarpackage,PEAR,286tabularoutputPostgreSQLdatabaseclass,689,695–697paging,689,701–704sorting,689,699–701tagsstrip_tagsfunction,Smarty,456tarfilesinstallingPostgreSQLfromsource,582managementof,260tasks,psql,613–619tcloptioninstallingPostgreSQLfromsource,583851INDEXTCPsockets,260templatecompilation,Smarty,450template0/template1databases,625templatesdirectory,Smarty,451,452templates_cdirectory,Smarty,451templatingengines,447–449benefitsof,448delimiters,448separatingpresentationalfrombusinesslogic,448Smartytemplatingengine,449–471syntaxoftypicalSmartytemplate,449syntaxoftypicaltemplate,448TEMPORARYkeywordcreatingsequences,633creatingtemporarytables,630temporarytables,630ternary(==)operator,74testingfacilitatingunittests,260userbandwidth,397–398TEXTdatatype,PostgreSQL,640textfilescopyingdatafromatextfile,779copyingdatafromtabletotextfile,782errormessagesin,181textsearchingindexes,PostgreSQL,749TG_XYZvariablestriggerfunctions,PostgreSQL,745thiskeywordaccessingprivatefields,139referringtofields,OOP,137staticfields,153throwinganexception,183ticks,78register_tick_functionfunction,78unregister_tick_functionfunction,78tiers,555timeCalendarpackage,PEAR,285–288CoordinatedUniversalTime,271localizedformats,280max_execution_timedirective,519standardizingformatfor,271TIMEdatatype,PostgreSQL,636WITHTIMEZONE,636timefunctions,PHPseedateandtimefunctions,PHPtimefunctions,PostgreSQL,723,724time_limitparameter,ldap_search(),404timeofdayfunction,PostgreSQL,724timeoutsPDO_ATTR_TIMEOUTattribute,560TIMESTAMPdatatype,PostgreSQL,637WITHTIMEZONE,637timestampsretrievingfile'slastaccesstime,238retrievingfile'slastchangedtime,238retrievingfile'slastmodificationtime,239settingfilemodification/accesstimes,253Unixtimestamp,271Windowslimitation,276TLS(TransportLayerSecurity),402tmp_namevariable$_FILESarray,348TO_CHARfunction,PL/pgSQL,736toaddressattribute,messages,381totalspaceidentifyingondiskpartition,236touchfunction,253traceparameterSoapClientconstructor,504traces,exceptionclassmethodsgetTrace,186getTraceAsString,186track_errorsparameter,31,180transactionisolation,766852INDEXtransactions,765–775ACIDtests,765atomicity,765begintransactionmethod,PHP,772commitmethod,PHP,772committing,765consistency,765definition,765–766durability,766exampleillustrating,768–771isolation,766max_prepared_transactionssetting,PostgreSQL,597nestingtransactions,771PHP,771–775PHPDataObjects,571PostgreSQL,766–771rollbackmethod,PHP,772rollbacktosavepointmethod,PHP,772rollingback,765,771savepoints,769setsavepointmethod,PHP,772SQLite,535TransportLayerSecurity(TLS)protocolldap_start_tlsfunction,402triggersvariablefunctions,99triggers,PostgreSQL,739–747adding,739AFTERtrigger,740,741ALTERTRIGGERcommand,740BEFOREtrigger,740,741CREATETRIGGERcommand,739dataaccess,740definingproceduretoexecute,740DROPTRIGGERcommand,741functionarguments,741functionreturntype,741functionscompared,741languagessupporting,740modifying,740NEW/OLDconstructs,740,741,742,743,745orderofoperationofdifferenttriggers,741removing,741CASCADEoption,741RESTRICToption,741rulesandtriggers,747specialvariablesfortriggerfunctions,745TG_XYZvariables,745viewingexistingtriggers,746writingtriggerfunctions,741–747trimfunction,223TRUEstateBOOLEANdatatype,640truncatefunction,Smarty,456trunktable,swapmeetproject,767trustauthenticationmethodpg_hba.
conffile,PostgreSQL,655try.
.
.
catchblockcatchingmultipleexceptions,188exceptionhandling,184PHP5features,4tsearch2module,749ERROR:Can'tfindtsearchconfigbylocale,757full-textindexes,PostgreSQL,755–759getting/installingtsearch2,755stopwords,758usingfull-textindexes,757workingwithtsearch2,756tuningseeperformancetuning,PostgreSQLtuplesPGSQL_TUPLES_OKvalue,675typeattribute,messages,383typecasting,PHPdatatypes,54operators,54853INDEXtypeconversion,PHPoperatorsand,69TYPEfield,pg_hba.
conffile,654typehinting,147typeidentifierfunctions,57typejuggling,55typerelatedfunctions,56typespecifiersprintfstatement,49typevariable$_FILESarray,348types,PHPisidenticalto(===)operator,73typing,5UUoption,psql,612ucfirstfunction,209ucwordsfunction,209udateattribute,messages,381UID(userID)retrievinguserIDoffileowner,240uidattribute,messages,384umaskfunction,241UNIQUEattributePostgreSQLdatatypes,644uniqueindexes,PostgreSQL,750uniqueness,PostgreSQLindexes,749primarykeyindexes,750unittests,260UnixcustomizingPHPinstallation,17downloadingApache,9downloadingPHP,11downloadingPostgreSQL,580installingApache/PHP,11–13installingPEAR,262installingPostgreSQL,582–585Unixepoch,272Unixtimestamp,271unknownfiletype,232unregistercommand,pg_ctlprogram,594unregister_tick_functionfunction,78unseenattribute,messages,381unserialize_callback_funcdirective,24unsetfunction,434updatingdataldap_modifyfunction,417makingviewsinteractive,711pg_updatefunction,684PostgreSQL,681,684updaterules,710sqlite_changesfunction,546upgrading,PostgreSQL,609UPLOAD_ERR_FORM_SIZE,350UPLOAD_ERR_INI_SIZE,350UPLOAD_ERR_NO_FILE,351UPLOAD_ERR_OK,350UPLOAD_ERR_PARTIAL,351upload_max_filesizeparameter,38,347,355upload_tmp_dirparameter,38,347uploadsfileuploads,HTTP,346–355fileuploads,PHP,345–346file_uploadsdirective,38HTTP_Uploadclass,PEAR,355–357:upper:characterclass,195upperfunction,PostgreSQL,724URLrewritingallowing/restrictingwhenusingcookies,428referer_checkdirective,430retrievingsessionname,426session.
referer_checkdirective,430SIDpersistenceusing,426url_rewriter.
tagsdirective,432use_trans_siddirective,431URLsonetimeURLs,342userfriendlyURLs,313–317854INDEXusability,websitesnavigationalcues,313–323use_cookiesdirective,428use_only_cookiesdirective,428use_trans_siddirective,431usecatupd/useconfig/usecreatedb/usenamecolumnspg_shadowtable,PostgreSQL,653useraccountssecuringPostgreSQL,650userauthenticationtabledatabasebasedauthentication,331IPaddressbasedauthentication,333userauthtable,332userbandwidthtesting,397–398userdefinedfunctions,PostgreSQL,727–737creating,727PL/pgSQLfunctions,730–736security,728SQLfunctions,728typesoffunction,728USERfield,pg_hba.
conffile,654userfriendlyURLsApachelookbackfeature,314,315–316navigationalcues,313–317PHPcode,316UserInterfacesoptionscategoryinstallingPostgreSQL,586userloginadministration,337–344passworddesignation,337–339passwordguessability,339–342recovering/resettingpasswords,342–344userparameterpg_connectfunction,668userregistrationpassworddesignation,337–339user_agentparameter,38user_dirparameter,37,520userauthtableseeuserauthenticationtableusersautologin,sessionhandling,437ignore_user_abortdirective,27PHP_AUTH_USERauthenticationvariable,327retrievinguserIDoffileowner,240sanitizinguserdata,524–528users,PostgreSQLaddingusers,658grantingpermissionsonalltables,661managingprivilegesfor,657modifyinguserattributes,658pg_shadowtable,652removingusers,658usesupercolumnpg_shadowtable,PostgreSQL,653usesysidcolumnpg_shadowtable,PostgreSQL,653usortarrayfunction,123UTC(CoordinatedUniversalTime),271VVACUUMcommand,PostgreSQL,602–603autovacuumparameter,604caution:manualvacuuming,603VACUUMFREEZEcommand,603VACUUMFULLcommand,603VACUUMVERBOSEcommand,598,603Validate_USpackage,PEAR,226–227installing,226phoneNumbermethod,227postalCodemethod,227regionmethod,227ssnmethod,227using,227validationclassesCalendarpackage,PEAR,286855INDEXvalueassignmentvariabledeclaration,PHP,59valuesldap_comparefunction,411ldap_get_valuesfunction,406ldap_get_values_lenfunction,406ldap_mod_delfunction,418ldap_sortfunction,411valuntilcolumnpg_shadowtable,PostgreSQL,653varparameterinserttag,Smarty,463VARCHARdatatype,PostgreSQL,640variabledeclarationPL/pgSQLfunctions,731RECORDtype,731variablefunctions,99securityrisk,100variablemodifiers,Smarty,454–457variables,PHP,58–67authenticationvariables,327–328superglobalvariables,63–67variabledeclaration,58–60explicitdeclaration,59referenceassignment,59valueassignment,59variablescope,60–63functionparameters,61globalvariables,61localvariables,60staticvariables,62variablevariables,67variables_orderparameter,33VersionMismatcherrorfaultstringattribute,NuSOAP,500versionsPDO_ATTR_CLIENT_VERSIONattribute,560PDO_ATTR_SERVER_VERSIONattribute,560views,PostgreSQL,707–708creatingviews,707droppingviews,708makingviewsinteractive,711–716queryingaViewwithPHP,716workingwithviewsfromPHP,716–717VOLATILEfunctionsuserdefinedfunctions,PostgreSQL,728Ww3schoolswebsite,304webforms/pagesautoselectingformsdata,310–311displayingmodificationdate,283example,304–305formstutorialsonline,304generatingformswithPHP,308–310passingdatabetweenscripts,304passingformdatatofunction,306passingPHPvariableintoJavaScriptfunction,311–313PHPandwebforms,303–313workingwithmultivaluedformcomponents,307–308WebServices,473–514highprofiledeployments,475MagpieRSS,479–486NuSOAP,492–502consumingaWebService,494–495creatingamethodproxy,495–496debuggingtools,501designatingHTTPproxy,501errorhandling,500–501generatingWSDLdocument,499–500publishingaWebService,496–498returninganarray,498–499secureconnections,502RealSimpleSyndication(RSS),473,476–486reasonsfor,474856INDEXSimpleXML,474,486–491SOAP,474,491–512PHP5'sSOAPextension,502–512support,PHP5,4usingC#clientwithPHPWebService,512–514websiteusabilitynavigationalcues,313–323WHEREclause,PostgreSQLindexes,759partialindexes,753,754WHILEloops,PL/pgSQL,732whilestatement,PHP,81WhitePages.
comPostgreSQLusers,577whitespacecharactersPerlregularexpressionmodifier,199predefinedcharacterranges,195widthspecifierprintfstatement,49WindowscustomizingPHPinstallation,17downloadingApache,10downloadingPHP,11downloadingPostgreSQL,580–581installingApache/PHP,13–16installingPEAR,263installingPostgreSQLon2000/XP/2003,585–589on95/98/ME,589startingandstoppingPostgreSQLserver,596usingC#clientwithPHPWebService,512–514with-docdir/without-docdiroptionsinstallingPostgreSQLfromsource,583with-perl/with-pgportoptionsinstallingPostgreSQLfromsource,583with-pgsqloptionenablingPostgreSQLextension,665with-python/with-tcloptioninstallingPostgreSQLfromsource,583wordscountsnumberofwordsinstring,225work_memsetting,PostgreSQL,596wrappersfopenwrappers,38streamwrappers,390writeablefilescheckingiffilewriteable,241write-aheadlogging,PostgreSQLcheckpoint_segmentssetting,599checkpoint_timeoutsetting,599WSDL(WebServicesDefinitionLanguage)creatingSOAPserver,506configurationdirectives,507NuSOAPfeatures,493generatingWSDLdocument,499–500obtaining,494wsdlparameterSoapClientconstructor,503SoapServerconstructor,508wsdl_cache_dirconfigurationdirectivecreatingSOAPserver,508wsdl_cache_enabledconfigurationdirective,508wsdl_cache_ttlconfigurationdirective,508XXoption,psql,612:xdigit:characterclass,195XMLGNOMEXMLlibrary,503SimpleXML,486–491asXMLmethod,489SOAPdefinition,491support,PHP5,4857INDEXXML_Parserpackage,PEAR,261XML_RPCpackage,PEAR,261XML-RPCprotocol,261XORoperator,73xpathmethod,SimpleXML,490Yy2k_complianceparameter,23ZZendscriptingengine,2zend.
ze1_compatibility_modedirective,22ZIPcodeusingValidate_USpackage,PEAR,227zipfiles,260zlib.
output_compressionparameter,24zlib.
output_handlerparameter,24zlib-develpackageinstallingPostgreSQLfromsource,583Zmievski,Andrei,449