Controlphpinfo

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(phpinfofunctionhidingconfigurationdetails,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