conditionspathinfo

957IndexSymbolsandNumerics$metacharacter,Perlregularexpressions,241%wildcard,mysqlclient,673&character,htmlentities,555[],()metacharacters,Perlregularexpressions,241.
(period)metacharacter,Perlregularexpressions,241option,mysqlxyzclients,685\metacharacter,Perlregularexpressions,241escapesequences,96^metacharacter,Perlregularexpressions,241",'characters,htmlentities,555characters,htmlentities,555401(Unauthorizedaccess)message,366,368,370A\Ametacharacter,Perlregularexpressions,241A(IPv4AddressRecord)recordtype,DNS,403a,a+fileaccessmodes,288aoption,mysqlcheckclient,682Aparameter,datefunction,326aparameter,datefunction,326,329A6(IPv6addresses)recordtype,DNS,403AAAA(IPv6AddressRecord)recordtype,DNS,403aboutpage,ZendFramework,615about.
phtmlview,ZendFramework,616,617AboutController.
php,ZendFramework,613,614absolutepaths,identifying,280abstractclasses,OOP,193,207–208abstractkeyword,180,207abstractmethods,180accentedlanguages,335characterentityreferences,255,256accesscontrol,MySQLprivileges,735accessprivilegesystem,MySQL,734–750accessinformationstorage,738–750howitworks,735–737accessibility,505accessors,172ACIDacronym,926actorparameterSoapClientconstructor,529SoapServerconstructor,533addAttachmentmethodMail_Mimepackage,PEAR,418addElementmethod,HTML_QuickFormclass,356addFunctionmethod,SOAP,533addition(+)operator,90addition-assignmentoperator,90addl_headersparameter,mailfunction,412addl_paramsparameter,mailfunction,412addslashesfunction,43addtlparameter,checkdnsrrfunction,405AddTypedirectiveinstallingApacheandPHPonLinux,17installingApacheandPHPonWindows,19ad/ai/auprefixestriggernaming,MySQL,856administrator,MySQL,687,688settingadministratorpassword,645,646AdobeDreamweaverCS3,48958INDEXAdobeFlashgeneralPHPlanguagefeatures,8affected_rowsmethod,mysqli,782,789aftertriggers,MySQL,851beforetriggerscompared,852namingconventions,856AGAINSTfunction,MySQLfulltextindexes,914,915aggregatefunctions,SQLite,589–590aggregators,RSSMagpieRSS,516popularaggregators,507ALGORITHMAttributeviews,MySQL,869algorithmsMERGEalgorithm,869TEMPTABLEalgorithm,870UNDEFINEDalgorithm,870ALLPRIVILEGESprivilege,752allow_call_time_pass_referencedirective,34allow_url_fopendirective,47,110,111allowable_tagsparameter,fgetssfunction,294alnumcharacterclass,235alphacharacterclass,235alphanumericrulePEAR:HTML_QuickForm,359ALTERstatements,MySQL,752,841ALTERPROCEDURE,832ALTERROUTINE,752ALTERTABLE,724ALTERVIEW,874Alter_privcolumndbtable,746hosttable,747usertable,739,743Alter_routine_privcolumndbtable,746hosttable,747usertable,740,744always_populate_raw_post_datadirective,45amortizationTablefunction,121,122ampersand(&)characterdisplayingspecialHTMLcharacters,257htmlentitiesfunctiontranslating,555AND(&&)operator,92AND(&)bitwiseoperator,94AND(&)logicaloperator,215ANYrecordtype,DNS,403,405Apachedisablingbroadcastofserversignature,39downloading,12–13downloadingApachemanual,14hidingconfigurationdetails,546htaccessfile,29httpd.
conffile,29installingonLinux,15–17installingonWindows,17–20reasonsforinstalling,11,12ServerSignaturedirective,546ServerTokensdirective,547viewingdocumentation,14website,914XAMPPastestenvironment,12applicationdirectorycreatingZendFrameworkfront-endcontroller,612applicationlogicindex.
tpltemplate,478architecturestoredroutines,820ARCHIVEstorageengine,MySQL,703Archive_Tarpackage,PEAR,310arg_separator.
inputdirective,PHP,40arg_separator.
outputdirective,PHP,40argcregister_argc_argvdirective,42argumentsseealsoparametersdefaultargumentvalues,118–119escapeshellargfunction,304escapingshellarguments,554optionalarguments,118959INDEXpassingargumentsbyreference,117passingargumentsbyvalue,115–116argvregister_argc_argvdirective,42arithmeticoperators,90arraydatatype,67typecasting,69arrayfunction,130arrayfunctionsarray,130array_chunk,162array_combine,155array_count_values,144array_diff,159array_diff_assoc,159array_flip,146array_intersect,157array_intersect_assoc,158array_key_exists,136array_keys,137array_merge,153array_merge_recursive,154array_pop,136array_push,135array_rand,160array_reverse,146array_search,137array_shift,135array_slice,155array_splice,156array_sum,161array_unique,145array_unshift,135array_values,138array_walk,142–143arsort,149asort,148count,143current,139each,140end,141explode,132in_array,136is_array,134key,139krsort,151ksort,151list,131natcasesort,150natsort,150next,140prev,141print_r,133range,132reset,141rsort,149setlocalefunction,145shuffle,160sizeof,144sort,147usort,151–153arraypointers,129movingtofirstposition,141movingtolastposition,141movingtonextposition,140movingtopreviousposition,141array_chunkfunction,162array_combinefunction,155array_count_valuesfunction,144array_difffunction,159array_diff_assocfunction,159array_fliparrayfunction,258array_flipfunction,146array_intersectfunction,157array_intersect_assocfunction,158array_key_existsfunction,136array_keysfunction,137array_mergefunction,153array_merge_recursivefunction,154array_popfunction,136array_pushfunction,135array_randfunction,160960INDEXarray_reversefunction,146array_searchfunction,137array_shiftfunction,135array_slicefunction,155,518array_splicefunction,156array_sumfunction,161array_uniquefunction,145array_unshiftfunction,135array_valuesfunction,138array_walkfunction,142–143arrays,127–162$_FILESsuperglobalarray,390–391addingandremovingelements,134–136addingvaluesin,161arraypointers,129associativekeys,128convertingarrayintostring,262countingarrayvaluefrequencies,144creating,129–133creatingwithpredefinedvalue,132datatypes,128described,128–129determiningsize,143–145determininguniquearrayvalues,145dividingintosmallerarrays,162extractingwithlistfunction,131keys,128locatingelementsin,136–138manipulating,153–160mappingassociatively,128merging,153combiningarrayofkeystoarrayofvalues,155maintainingduplicatedvalues,154movingarraypointer,140–141multidimensionalarrays,129numericalkeys,128offsetfornumericallyindexedarrays,581outputting,133passingarrayvaluestofunction,142–143printingfortestingpurposes,133randomreorderingofelements,160readingCSVfileinto,292readingdirectoryinto,300readingfileinto,290register_long_arraysdirective,42removingandreturningsectionof,156removingduplicatevalues,145retrievingarraykeys,137retrievingarrayvalues,138retrievingcurrentarraykey,139retrievingcurrentarraykeyandvalue,140retrievingcurrentarrayvalue,139retrievinglastarrayvalue,141retrievingnextarrayvalue,140retrievingpreviousarrayvalue,141returningfirstelementof,135returningkey/valuepairatcurrentpointer,140returningkey/valuepairscommonto,158returningkey/valuepairsinfirstarrayonly,159returninglastelementof,136returningnumberofvaluesin,143returningrandomkeysfrom,160returningsectionof,155–157returningvaluescommonto,157returningvaluesinfirstarrayonly,159reversingkey/valueroles,146reversingorderofelements,146searching,136–138searchingassociativearraykeys,136searchingassociativearrayvalues,137searchingforallmatchingelements,242sorting,145–153bykeys,151caseinsensitivehumansortorder,150elementorderingoptions,147key/valuepairsnotmaintained,147maintainingkey/valuepairs,148naturalhumansortorder,150reverse(descending)order,149sortingbyASCIIvalue,147sortinginanotherlanguage,145961INDEXsortingnaturally,147sortingnumerically,147user-definedcriteria,151–153sqlite_array_queryfunction,578sqlite_fetch_arrayfunction,576–577testingifvariableisanarray,134traversing,138–143workingwithmultivaluedformcomponents,354zeroindexvalue,128arsortfunction,arrays,149ASkeyword,MySQL,869ASCIIattributeCHARdatatype,MySQL,712asensitivecursors,MySQL,903asortfunction,arrays,148asp_tagsdirective,PHP,31ASP-stylesyntaxembeddingPHPcodeinwebpages,58assignattributeincludestatement,Smarty,490assignparameterinserttag,Smarty,491assignmentofvariablesreferenceassignment,75valueassignment,75assignmentoperators,90assoc_casedirective,sqlite,571associativearrayscreating,130creatingarrayswitharrayfunction,131mappingarraysassociatively,128returningkey/valuepairscommontoarrays,158returningkey/valuepairsinfirstarrayonly,159returningrandomkeysfromarrays,160returningresultsetasassociativearray,576–577searchingassociativearraykeys,136searchingassociativearrayvalues,137associativekeys,arrays,128associativity,operators,88,89asXMLmethod,SimpleXML,524atimeparameter,touchfunction,302atomicity,databasetransactions,926attachmentssendinge-mailattachments,418attributesdatatypeattributes,MySQL,714–718gettingandsettingattributes,PDO,804storedprocedures,MySQL,826attributesmethod,SimpleXML,523attributesparameter,ldap_search,431attributes_onlyparameter,ldap_search,431audittrailsreasonsforusingtriggers,850auditinggenerallanguagefeatures,10Authpackage,PEAR,319Auth_HTTPclass,PEARauthenticatingagainstMySQLdatabase,378–380authenticationmethodologies,PHP,377–380installing,377–378validatingusercredentialswithAuth_HTTP,378authenticationseealsoprivilegesaccesscontrolstages,735Auth_HTTPclass,PEAR,377–380connectionauthentication,735databasebasedauthentication,373–375filebasedauthentication,371–373generalPHPlanguagefeatures,8hardcodedauthentication,370howprivilegesystemworks,735HTTPauthentication,366–367IPaddressbasedauthentication,375–377PHPauthentication,367–380headerfunction,368issetfunction,369tracingconnectionrequest,737userloginadministration,380–386962INDEXauthenticationvariables,PHP,367determiningifproperlyset,369authentication_dynamictable,MyISAM,696authentication_statictable,MyISAM,696authenticationFile.
txt,371,372authnsparameter,checkdnsrrfunction,405authorizationaccesscontrolstages,735howprivilegesystemworks,735requestauthorization,738tracingconnectionrequest,736usertableand,738autologinexample,sessionhandling,459–461auto_append_filedirective,PHP,44auto_detect_line_endingsdirective,PHP,47AUTO_INCREMENTdatatypeattribute,MySQL,714auto_prepend_filedirective,PHP,44functionlibraries,125auto_startdirectivesessionhandling,449,454autocommitmethod,mysqli,790AUTOCOMMITvariableMySQLtransactionstips,933autocommitsPDO_ATTR_AUTOCOMMIToption,800auto-completionmysqlclient,673PEAR:HTML_QuickForm,363autoloadfunction,192autoloadingobjects,OOP,191–192require_oncestatement,191auto-rehashoption,mysqlclient,673B%btypespecifier,64\B,\bmetacharacters,Perlregularexpressions,241bfileaccessmode,288boption,mysqlclient,674btypecode,datatypes,785back_logparameter,MySQL,655backgroundshighlight.
bgdirective,PHP,38backslash(\)characterescapesequences,PHP,96insertingbackslashdelimiterbeforespecialcharacters,244MySQLusing,943backtickoperator,307backticksexecutingshellcommandwith,307Bakken,Stig,309bandwidthcalculatingnetworkbandwidth,423testinguserbandwidth,422–424basedirectoryopen_basedirdirective,PHP,36baseexceptionclassseeexceptionclassbaseclassclassinheritance,OOP,199basenamefunction,278bd/bi/buprefixestriggernaming,MySQL,856beforetriggers,MySQL,850aftertriggerscompared,852namingconventions,856BEGINcommandconformingtoSQL-99syntax,930BEGIN/ENDblock,MySQLLEAVEcommand,836storedroutines,828,829,832beginTransactionmethod,PDO,817BIGINTdatatype,MySQL,710bindirectoryinstallingMySQLonWindows,645bin2hexfunction,562binarydata,SQLite,585–587NULLcharacter,586sqlite_escape_stringfunction,586sqlite_udf_decode_binaryfunction,588sqlite_udf_encode_binaryfunction,588BINARYdatatypeattribute,MySQL,714CHAR/VARCHARdatatypes,712963INDEXbinarydistributioninstallingMySQLonLinux,639–640binaryoutput,returning,307bind_parammethod,mysqli,784,785,787bind_resultmethod,mysqli,784,787bindColumnmethod,PDO,815bindingldap_bindfunction,429ldap_unbindfunction,430parameters,mysqli,785results,mysqli,787bindParammethod,PDO,807,808,809,810bindtextdomainfunction,593,595,597BisoninstallingApacheandPHPonLinux,15bitwiseoperators,94BLACKHOLEstorageengine,MySQL,704BLOBdatatype,MySQL,713blocksembeddingmultiplecodeblocks,59BOOL(BOOLEAN)datatype,MySQL,710Boole,George,65Booleandatatype,65typejuggling,71Booleanfull-textsearches,MySQL,917boundcolumnssetting,PDO,815–816boundparameters/resultspreparedstatements,mysqli,783boxingclientSOAPclientandserverinteraction,537boxingserverSOAPclientandserverinteraction,536brackets([])[]metacharacter,Perlregularexpressions,241convertingstringcharactersintobracketedexpressions,239POSIXregularexpressions,233predefinedcharacterranges(characterclasses),234break()tagconvertingnewlinecharactersinto,254breakstatement,PHP,107switchstatement,101B-treeindexes,700bufferingoutput_bufferingdirective,PHP,32sqlite_unbuffered_queryfunction,575buildmethod,PHPCalendarpackage,PEAR,344businesslogicseparatingpresentationallogicfrom,472C%ctypespecifier,64Coption,mysqlclient,673Coption,mysqlxyzclients,685CA(CertificateAuthority)certificateREQUIREX509option,761ssl-caoption,mysqlclient,763ssl-capathoption,mysqlclient,763CAissuersREQUIREISSUERoption,762cachedirectoryinstallingSmarty,476cache_dirclassmembermodifyingdirectorylocations,476cache_expiredirective,sessionhandling,453cache_idparameter,displaymethod,Smarty,479cache_lifetimeattribute,Smarty,498cache_limiterdirective,sessionhandling,452cachingcompilationcompared,497feeds,MagpieRSS,519pagecaching,497querycaching,624,628settingforsession-enabledpages,452–453Smartytemplatingengine,497–501creatingmultiplecachespertemplate,499is_cachedmethod,499964INDEXcachingattribute,Smarty,497cachingtemplates,Smarty,474CakeSoftwareFoundation,605CakeForge,605CakePHPframework,605calculate_bonusstoredfunction,MySQL,845Calendarpackage,PEAR,341–345creatingmonthlycalendar,343–344dateandtimeclasses,342decoratorclasses,342installing,341isValidmethod,345tabulardateclasses,342validatingdatesandtimes,344validationclasses,342CALLstatement,MySQL,830callbackrule,HTML_QuickForm,359CanonicalNameRecord,DNS,403capability,storedroutines,821capitalizefunction,Smarty,480carriagereturnescapesequences,PHP,96CASCADEkeyword,MySQL,875CASCADEDCHECKOPTIONoption,MySQLWITHCHECKOPTIONclause,871casemanipulatingcaseofcharactersinstrings,252–254casesensitivitycomparingtwostringscase-insensitively,250comparingtwostringscase-sensitively,249performingcase-insensitivesearch,236–237performingcase-sensitivesearch,235–236replacingtextincase-insensitivemanner,238replacingtextincase-sensitivemanner,237–238splittingstringbasedoncase-insensitivepattern,239,247splittingstringbasedoncase-sensitivepattern,238SQLite,571CASEstatementstoredroutines,MySQL,833casestatement,PHP,101case-insensitivesearchPerlregularexpressionmodifier,240casting,PHP,69–70catchingmultipleexceptions,226–229ceilfunction,MySQL,895certificatesREQUIRESUBJECToption,762ssl-certoption,mysqlclient,763CHARdatatype,MySQL,712characterclassesPOSIXregularexpressions,234–235characterentityreferences,255charactersequencesrangefunction,arrays,133CHARACTERSEToptionLOADDATAINFILEstatement,942charactersetsdefault_charsetdirective,PHP,44installingMySQLonWindows,645supportedbyhtmlentitiesfunction,256CHARACTER_SETStable,725characteristicsstoredprocedures,MySQL,826charactersconvertingstringsintobracketedexpressions,239countingnumberinstring,271customizedcharacterconversion,259htmlentitiesfunction,555ignoringnewlinecharacters,295localizedformats,335readingsinglecharacter,295readingspecificnumberof,293regularexpressions,232–248charsetparameter,htmlentitiesfunction,256CHARSETplaceholder,596checkoption,myisamchkclient,682965INDEXcheckboxesworkingwithmultivaluedformcomponents,354checkdatefunction,PHP,325checkdnsrrfunction,402–404childclass,OOP,199childrenmethod,SimpleXML,524chrootoption,mysqlddaemon,734ciphersREQUIRECIPHERoption,762ssl-cipheroption,mysqlclient,763classattributedns_get_recordreturning,405classconstants,176classdefinition,68classinheritance,OOP,199–201childclass(subclass),199constructorsandinheritance,201–203extendskeyword,199parentclass(baseclass),199classinstantiation,168newkeyword,68classlibrarieshelperfunctions,189classmanagementautoloadfunction,192autoloadingobjects,191class_existsfunction,189classesdisable_classesdirective,37,544classes,OOP,166seealsoobjects,OOPcharacteristicsandbehaviors,166checkingifclassexists,189classconstants,176codeconventionswhencreating,167generalizedclasscreationsyntax,166gettingfieldsofclass,190gettinglistofdefinedclasses,190gettingmethodsofclass,190gettingnameofclass,189gettingparentclass,190staticclassmembers,187–188clauses,MySQLusingwithviews,868client-sidecursors,MySQL,903clonekeyword,OOP,195clonemethod,OOP,196cloning,OOP,194–197closemethod,mysqli,771,785,787CLOSEstatement,MySQLcursors,903,906closedirfunction,299closelogfunction,218,219closingfiles,289CNAME(CanonicalNameRecord)recordtype,DNS,403cntrlcharacterclass,235codeseealsoPHPcodecodereuse,309getCodemethod,exceptionclass,224codeeditors,choosing,48–50codingconsistency,PDO,795COLLATION_CHARACTER_SET_APPLICABILITYtable,725COLLATIONStable,725Column_namecolumn,columns_privtable,749Column_privcolumncolumns_privtable,749tables_privtable,748COLUMN_PRIVILEGEStable,725columnCountmethod,PDO,811column-namesoption,mysql,673columnsgrantingcolumn-levelprivileges,756KEY_COLUMN_USAGEtable,726privilegeverificationprocess,738retrievingfirstcolumninresultset,579retrievingnumberofcolumnsinresultset,581retrievingcolumntypes,585966INDEXretrievingselectresultsetcolumns,578revokingcolumn-levelprivileges,757settingboundcolumns,PDO,815–816sqlite_columnfunction,578sqlite_fetch_column_typesfunction,585sqlite_fetch_singlefunction,579tableattributesmodifyingbehavior,693,714–718columnsoption,mysqlimportutility,946COLUMNStable,725columns_privtableaccesscontrol/authorization,736columns,tablelistingof,749MySQLaccessprivilegesystem,738,749columnsetuseoftermasplaceholder,748,749COM/DCOMsupport,PHP,4commaseparatedvalue(CSV)files,292commandline,SQLite,569–570commandsescapeshellcmdfunction,305,554executingshellcommands,301–302executingsystem-levelcommand,305retrievingsystemcommandresults,306COMMENTcharacteristicstoredprocedures,MySQL,827commentsconfigurationfiles,MySQL,660Smartytemplatingengine,480comments,PHP,59–60highlight.
commentdirective,38multiplelineCsyntax,60php.
inifile,28phpDocumentor,60shellsyntax,60singlelineC++syntax,59commitdatabasetransactions,925InnoDBtablesexample,931,932commitmethod,mysqli,790commitmethod,PDO,817comparerulePEAR:HTML_QuickForm,359comparisonoperators,93performingcomparisonswithsubqueries,899compatibilityzend.
ze1_compatibility_modedirective,PHP,31CompatibleRegularExpressions(PCRE)library,4compilationcachingcompared,497compile_dirclassmember,476compile_idparameter,displaymethod,Smarty,479CompleteinstallationinstallingMySQLonWindows,643compounddatatypes,67–68compressoptionmysqlimportutility,946mysqlclient,673,685compressedMyISAM,697compression,PHPzlib.
output_compressiondirective,33compressionhandlerfunction,33compressionparameter,SoapClient,529concatenate,91concatenationoperators,90,91CONCURRENToptionLOADDATAINFILEstatement,942conditionalstatements,MySQL,832–834conditionalstatements,PHP,98–101alternativesyntax,99elsestatement,99elseifstatement,100ifstatement,99switchstatement,101conditionsstoredroutines,MySQL,844config_dirclassmember,476config_loadfunction,Smarty,494967INDEXconfigurationdirectivesseePHPconfigurationdirectivesconfigurationdirectives,listofseePHPconfigurationdirectives,listofconfigurationparameterstrack_vars,82configuration,MySQL,652–660automaticallyexecutingSQLcommands,656configurationfilessummarized,660configurationtemplates,658configuringPHPforMySQL,661disablingDNSresolution,657limitingconnectionstolocalserver,657loggingpotentiallynonoptimalqueries,656loggingslowqueries,656managingconnectionloads,655my.
cnfconfigurationfile,657–660MySQLConfigurationWizard,643mysqld_safewrapper,652parameters,653–657reasonsforMySQLpopularity,625settingdatadirectorylocation,655settingdefaultstorageengine,655settingmaximumallowablesimultaneousconnections,656settingMySQLcommunicationport,657settingMySQLdaemonuser,657viewingMySQLconfigurationparameters,653configuration,PHP,540–545changingdocumentextension,548configurationparameters,543–545configuringPHPatbuildtimeonLinux,26configuringPHPforMySQL,661expose_phpdirective,547hidingApache,546hidingconfigurationdetails,546–549hidingPHP,547–549phpinfofunction,548removingphpinfocalls,548safemode,540–543configuration,Smarty,475,493–495config_loadfunction,494configsdirectory,476CSSand,494globalvariables,493referencingconfigurationvariables,494sections,493configurecommand,PHP,26connectmethod,mysqliclass,771connectionauthenticationseeauthenticationconnectionoptions,mysqlxyzclients,684–685connectionsback_logparameter,MySQL,655closing,SQLite,573ldap_connectfunction,427max_connectionscolumn,usertable,759max_connectionsparameter,MySQL,656max_user_connectionscolumn,usertable,760opening,SQLite,571–573PDO(PHPDataObjects),798–801embeddingparametersintoconstructor,799handlingconnectionerrors,801PDOconnection-relatedoptions,799placingparametersinfile,799referringtophp.
inifile,799pingingserver,418simultaneousconnectionsforusers,736socketconnections,establishing,408–411sqlite_closefunction,573sqlite_openfunction,571sqlite_popenfunction,572tracingconnectionrequests,736–737connections,MySQLmanagingconnectionloads,655secureMySQLconnections,760–765connections,mysqliextensionclosing,771handlingerrors,772securingconnectioninformation,775968INDEXsettingup,770storingconnectioninformation,774consistencydatabasetransactions,926storedroutines,820Console_Getoptpackage,PEAR,310runninginfocommandfor,317constants,OOP,176constants,PHP,86–87constraintsTABLE_CONSTRAINTStable,726constructfunction,183constructors,182–186declarationsyntax,183inheritanceand,201–203invokingparentconstructors,184invokingunrelatedconstructors,186overloading,186PHP4,183CONTAINSSQLcharacteristicstoredprocedures,MySQL,827continuestatement,PHP,108controlstructures,PHP,98–112conditionalstatements,98–101fileinclusionstatements,108–112loopingstatements,101–108controlstructures,Smarty,484–490controllersAboutController.
php,613,614creatingZendFrameworkfront-endcontroller,612creatingZendFrameworkwebsite,613–615IndexController.
php,613MVCfrontcontroller,604searchingwebwithZend_Service_Yahoo,618–619$_COOKIEsuperglobalvariable,84cookie_domaindirective,451cookie_lifetimedirective,451,459cookie_pathdirective,451cookieschoosingcookiesorURLrewriting,450cross-sitescripting,552description,446retrievingsessionname,447retrievinginformationstoredwithin,84setcookiefunction,84settingsessioncookielifetime,451settingsessioncookievaliddomain,451settingsessioncookievalidURLpath,451–452storingsessioninformation,450use_cookiesdirective,450CoordinatedUniversalTime(UTC),324copyrightsymbolcharacterentityreferencefor,255corporate_mysqliclass,889countfunction,arrays,143count_charsfunction,271count_wordsfunction,481CPAN(ComprehensivePerlArchiveNetwork),309CrackLibextension,PHPavoidingeasilyguessablepasswords,381installation,381minimumpasswordrequirements,381using,382–383usingdictionaries,383cracklib_dict.
pwddictionary,383craigslistprominentMySQLusers,631CREATE(SHOWCREATE)statement,MySQL,843createcommand,mysqladminclient,676CREATEDATABASEstatement,MySQL,719CREATEprivilege,752CREATEROUTINEprivilege,752CREATETABLEstatement,MySQL,720copyingtables,722IFNOTEXISTSclause,721TEMPORARYkeyword,722CREATETEMPORARYTABLESprivilege,752969INDEXCREATETRIGGERstatement,MySQL,854triggernamingconventions,856CREATEUSERprivilege,752CREATEUSERstatement,MySQL,750CREATEVIEWprivilege,752CREATEVIEWstatement,MySQL,865Create_privcolumndbtable,745hosttable,747usertable,739,742Create_routine_privcolumndbtable,746hosttable,747usertable,740,744Create_tmp_table_privcolumndbtable,746hosttable,747usertable,740,743Create_user_privcolumn,usertable,740,744Create_view_privcolumndbtable,746table,747usertable,740,744credentialsbindingtoLDAPserver,429LDAP_INVALID_CREDENTIALSerrorcode,442Creole,606crontabusingmysqlinbatchmode,668cross-sitescripting,551cryptTypeelementAuth_HTTPclass,PEAR,380CSS(CascadingStyleSheets)clashofsyntaxbetweenSmartyand,495embeddingintoSmartytemplate,492literaltag,Smarty,492Smartyconfigurationfilesand,494tweakingtablestyleswithCSSandHTML_Table,884usingwithSmartytemplatingengine,495–497CSVfilescommonusageof,292readingCSVfileintoarray,292CSVstorageengine,MySQL,703curlybrackets{}clashofsyntaxbetweenSmartyandCSS,495currencycharacterentityreferences,255localizedformats,335currentfunction,arrays,139current_userfunction,759currentpagevariable,MySQL,896cursor_offsetparameterfetchmethod,PDO,812cursor_orientationparameterfetchmethod,PDO,812cursors,MySQL,902–906asensitivecursors,903client-sidecursors,903closing,906creating,904forward-onlycursors,903insensitivecursors,903introduction,879,903opening,904read-onlycursors,903server-sidecursors,903using,904usingwithPHP,906CustominstallationinstallingMySQLonWindows,643customsessionhandlers,462–469D%dtypespecifier,64\D,\dmetacharacters,Perlregularexpressions,241Doption,mysqlclient,673D,dparameters,datefunction,326Dparameter,numericdatatypesdigitsfollowingdecimalpoint,710970INDEXdtypecode,datatypes,785daemonsstartingandstoppingMySQL,646datadelimitingdata,940exportingdata,951–954hidingsensitivedata,549–550importingdata,941–951outputtingdatatowebbrowser,61–65poorlyprotecteddata,539salestable,940sanitizinguserinput,550–558PEAR:Validatepackage,556–558datadelimitation,940dataencryptionseeencryptiondatahandlingdeletingLDAPdata,438–439insertingLDAPdata,436–437ldap_addfunction,436ldap_deletefunction,439ldap_mod_addfunction,437ldap_mod_delfunction,439ldap_modifyfunction,438ldap_renamefunction,438updatingLDAPdata,438datahandlingcategoryPHPconfigurationdirectives,40–45datamanagement,MySQL,622datamining,MySQL,624dataretrieval,PDO,811–815datasets,PHP,127DataSourceNameseeDSNdatatypesPHParrays,128precisiondirective,PHP,32typecodes,785datavalidationPEAR:HTML_QuickForm,358–362databaseabstractionlayers,793PDO(PHPDataObjects),795–817databaseabstractionsolutionsgeneralPHPlanguagefeatures,9databasebasedauthentication,PHP,373–375authenticatinguseragainstMySQLdatabase,374authenticatingusingloginpairandIPaddress,376databaseconfigurationinstallingMySQLonWindows,644databaseconnectionsseeconnectionsdatabaseoption,mysqlclient,673databasesecurityseesecuritydatabasesupportgeneralPHPlanguagefeatures,9PDO(PHPDataObjects),797databasetransactionsseetransactionsdatabaseversionsofferedbywebhost,52databasesapplicationsaccessing,793changingtablestructure,724copyingtables,722creating,719creatingSQLitedatabase,571creatingtables,720creatingtablesconditionally,721creatingtemporarytables,722deleting,720deletingtables,724designatingasdefault,719indexes,907–919migratingbetween,311MySQLaccessprivilegesystem,738MySQLstorageengines,693–706selectingdatabase,mysqliextension,771transactions,925–937usingmultiplestorageengines,706viewing,718viewingtables,722,723datadiroption,MySQL,655datadirparameter,MySQL,655971INDEXdatatypeattributes,MySQL,714–718AUTO_INCREMENT,714BINARY,714DEFAULT,714INDEX,715NATIONAL,715NOTNULL,716NULL,716PRIMARYKEY,716UNIQUE,717ZEROFILL,717datatypes,65datatypes,MySQL,707–714dateandtimedatatypes,707DATE,707DATETIME,708invalidvalueinsertedinto,708nonalphanumericdelimiters,707TIME,708TIMESTAMP,708YEAR,710numericdatatypes,710–711BIGINT,710BOOL(BOOLEAN),710constrainingmaximumdisplaysize,710DECIMAL,711digitsfollowingdecimalpoint,710DOUBLE,711FLOAT,711INT,711MEDIUMINT,711SMALLINT,711TINYINT,710,711stringdatatypes,712–714BLOB,713CHAR,712ENUM,713LONGBLOB,712LONGTEXT,713MEDIUMBLOB,713MEDIUMTEXT,713SET,714TEXT,713TINYBLOB,713TINYTEXT,713VARCHAR,712datatypes,PHP,65–72adaptingdatatypes,70–71array,67Boolean,65compounddatatypes,67–68convertingbetweendatatypes,69–70float,66functionsfordeterminingvariabletype,72functionsforverifyingandconverting,71gettypefunction,71integer,65is_namefunction,72object,68scalardatatypes,65settypefunction,71string,66typecasting,69–70typeidentifierfunctions,72typejuggling,70–71typerelatedfunctions,71dateandtimedatatypes,MySQL,707invalidvalueinsertedinto,708nonalphanumericdelimiters,707dateandtimefunctions,PHP,324calculatingdates,340checkdatefunction,325datefunction,325–329determiningdaysincurrentmonth,339displayinglocalizeddateandtime,334–338displayingwebpagemodificationdate,338getdatefunction,330–331getlastmodfunction,338gettimeofdayfunction,329mktimefunction,332–333972INDEXsetlocalefunction,334–336strftimefunction,336–338strtotimefunction,340timefunction,332dateclassesCalendarpackage,PEAR,342DATEdatatype,MySQL,707datefunction,325–329determiningdaysincurrentmonth,339formatparameters,326insertingpunctuation,328outputtingamorpm,329outputtingcurrenttime,329outputtingstandarddate,327outputtingverbosedate,328outputtingweekday,328tparameter,339Datemethod,DateTimeclass,345date_default_timezone_setfunction,324date_formatfunction,Smarty,481datescalculatingdates,340Calendarpackage,PEAR,341–345datespriortoUnixepoch,324determiningdaysincurrentmonth,339displayinglocalizeddateandtime,334–338displayingwebpagemodificationdate,338formattingdatesandtimes,325–330formattingdates,Smarty,481localizedformats,335localizing,598–600object-orientedenhancements,345–348standardizedformatfor,323USandEuropeanformats,598validatingdates,325DateTimeclass,345–348constructor,345Datemethod,345formatmethod,346modifymethod,347setDatemethod,346setTimemethod,347timezoneparameter,346DATETIMEdatatype,MySQL,708Dbcolumncolumns_privtable,749dbtable,745hosttable,746procs_privtable,749tables_privtable,748DBpackage,PEAR,311dbtableaccesscontrol/authorization,736columns,tablelistingof,745MySQLaccessprivilegesystem,738,745User/Dbmatch,745User/Host/Dbtriplet,745DB_Table,606dbloginarrayAuth_HTTPclass,PEAR,379DDLstatementsMySQLrollbacks,933debpackagesinstallingMySQLonLinux,637debugoption,mysqlimportutility,946debugging,mysqli,768DECIMALdatatype,MySQL,711DecisionSupport(DSS)installingMySQLonWindows,644DECLAREstatement,MySQLcursors,903,904storedroutines,828declaringvariables,PHP,74decode_binaryparametersqlite_columnfunction,578sqlite_fetch_arrayfunction,576decodingsession_decodefunction,457sqlite_udf_decode_binaryfunction,588decoratorclassesCalendarpackage,PEAR,342973INDEXdecrement(--)operator,91dedicatedserverhosting,50defaultargumentvalues,118–119DEFAULTdatatypeattribute,MySQL,714defaultdirectorycreatingZendFrameworkfront-endcontroller,612defaultfunction,Smarty,482default_charsetdirective,PHP,44default_mimetypedirective,PHP,44default_socket_timeoutdirective,PHP,47default-character-setoption,mysqlclient,674defaultshighlight.
defaultdirective,PHP,38defaults-extra-fileoption,mysqlxyzclients,658,685defaults-fileoption,mysqlxyzclients,685default-storage-engineparameter,MySQL,655default-table-typeparameter,MySQL,655definefunction,86define_syslog_variablesfunction,218DEFINERclause/setting,MySQLCREATETRIGGERstatement,854modifyingstoredroutines,841SQLSECURITYcharacteristic,827storedroutines,825views,871DELETEcommand,mysqliextension,777deleteoption,mysqlimportutility,946DELETEprivilege,752Delete_privcolumndbtable,745hosttable,747usertable,739,742delimiterparameter,preg_quotefunction,244DELIMITERstatement,MySQL,830delimitersyntaxasp_tagsdirective,PHP,31delimiterschangingSmartydefaultdelimiters,496choosinginExcel,955creatingdesigntemplate,477templatingengines,472,473delimitingdataimportingandexportingdata,940delimitingPHPcode,56–58ASP-stylesyntax,58defaultdelimitersyntax,56embeddingmultiplecodeblocks,59scripttag,58shorttags,57derefparameter,ldap_searchfunction,432DESCRIBEstatement,MySQL,723usingmysqlininteractivemode,666viewingviewdefinition,872views,866destroyingvariables,8destructfunction,186destructors,OOP,186–187DetailedConfigurationMySQLConfigurationWizard,644,645DETERMINISTICcharacteristic,MySQL,827dictionariesCrackLibextensionusing,383digitcharacterclass,235digitalsignaturesencryptingdatawithmd5function,559directives,PHPseePHPconfigurationdirectivesdirectoriesseealsoLDAPclosingdirectorystream,299datadiroption,MySQL,655extension_dirdirective,46open_basedirdirective,36,545openingdirectorystream,299parsingdirectorycontents,299readingdirectorycontents,299,301readingdirectoryintoarray,300974INDEXremoving,301retrievingdirectoryfrompath,279retrievingdirectorysize,283returningelementsof,299safe_mode_include_dirdirective,542user_dirdirective,46,545directoriescategoryPHPconfigurationdirectives,45–46directoryservices,425seealsoLDAPdirectorystructurecreatingZendFrameworkwebsite,611–612dirnamefunction,279disable_classesdirective,PHP,37,544disable_functionsdirective,PHP,37,543disable-teeoption,mysqlclient,674disk_free_spacefunction,281disk_total_spacefunction,282disksdeterminingfreespaceondiskpartition,281determiningsizeofdiskpartition,282determiningusedspaceondiskpartition,282displaymethod,HTML_QuickFormclass,356displaymethod,Smarty,479display_errorsdirective,215,544display_startup_errorsdirective,216DistinguishedNameseeDNdivision(/)operator,90division-assignmentoperator,90DN(DistinguishedName)convertingDNtoreadableformat,440LDAPworkingwith,440–441ldap_dn2ufnfunction,440ldap_explode_dnfunction,440loadingDNintoarray,440–441retrievingLDAPdata,432DNS(DomainNameSystem),407checkingforexistenceofDNSrecords,402–404DNS_prefixfordns_get_recordfunction,404,405recordtypes,403,405retrievingDNSresourcerecords,404–406retrievingMXrecords,407verifyingexistenceofdomain,404verifyingwhetherdomainnameistaken,403DNSfunctions,PHPcheckdnsrrfunction,402–404dns_get_recordfunction,404–406getmxrrfunction,407DNSresolutionskip-name-resolveparameter,MySQL,657DNS_ALLrecordtype,405DNS_ANYrecordtype,405dns_get_recordfunction,404–406DNS_HINFOrecordtype,405DNS_NSrecordtype,405DOWHILEstatementMySQLequivalent,838dowhilestatement,PHP,103doc_rootdirective,PHP,46,544DocBlocks,phpDocumentor,60documentextensionconfiguringPHPsecurely,548documentation,Apache,14documentation,PHP,14,15DocumentRootdirective,Apache,549documentsrecentlyvieweddocuments,461Dollarsignescapesequences,PHP,96DOM(DocumentObjectModel)loadingXMLfromDOMdocument,522domainnameservers,402DomainNameSystemseeDNS975INDEXdomainnamesIPaddressesand,402domainrecordtypes,405domainssession.
cookie_domaindirective,451doubledatatypeseefloatdatatypeDOUBLEdatatype,MySQL,711doublequotesescapesequences,PHP,96stringinterpolation,95downloadsdownloadingApache,12–13downloadingApachemanual,14downloadingPHP,13–14downloadingPHPmanual,15MySQL,636DreamweaverAdobeDreamweaverCS3,48driver_optsarray,PDO,798driversdeterminingavailablePDOdrivers,798dropcommand,mysqladminclient,676DROPDATABASEcommand,MySQL,720DROPprivilege,MySQL,752DROPPROCEDURE,MySQL,832DROPstatement,MySQL,841DROPTABLEstatement,MySQL,724DROPTRIGGERstatement,MySQL,859DROPUSERstatement,MySQL,751DROPVIEWstatement,MySQL,875Drop_privcolumndbtable,745hosttable,747usertable,739,742DSN(DataSourceName)Auth_HTTPclass,PEAR,379DSNparameterconnectingtodatabaseserver,PDO,798dsttimevalue,gettimeofdayfunction,329ducommand,283DUMPFILEoptionSELECTINTOOUTFILEstatement,952durabilitydatabasetransactions,926dynamicextensionscategoryPHPconfigurationdirectives,48dynamicMyISAM,697EE,eoptions,mysqlclient,676E_ALLerrorlevel,214E_STRICTerrorlevel,215eachfunction,arrays,140echostatement,PHP,62Eclipseframework,49editorschoosingcodeeditor,48–50ELSEstatement,MySQL,833elsestatement,PHP,99else/elseifclauses,Smarty,485ELSEIFstatement,MySQL,833elseifstatement,PHP,100e-mail,418seealsomailfunctionInvalid_Email_Exceptionclass,226,229Mailpackage,PEAR,311sendingattachments,418sendinge-mailusingPHPscript,412–418sendinge-mailwithmultiplerecipients,414sendingHTMLformattede-mail,415–417sendingplaintexte-mail,413verifyinge-mailaddressexists,404e-mailaddressesvalidatingwithPEAR:Validate,558emailrulePEAR:HTML_QuickForm,359embeddedMySQLserverMySQL4,629mysqli,768976INDEXembeddingPHPcodeinwebpages,56–59ASP-stylesyntax,58defaultdelimitersyntax,56embeddingmultiplecodeblocks,59scripttag,58shorttags,57employeebonusinterfaceintegratingroutinesintowebapplications,845enable_dldirective,PHP,46encapsulation,164accessingprivatefields,171publicfields,170ENCLOSEDBYoptionLOADDATAINFILEstatement,943encodingsession_encodefunction,456sqlite_udf_encode_binaryfunction,588encodingparameter,SoapServerconstructor,533encryption,559–565Auth_HTTPclass,PEAR,380determiningmessageintegrityandauthenticity,562effectonperformanceusingSSL,765encryptingdatawithmd5function,559ensuringtrafficisencrypted,765MCryptpackage,562–565mhashlibrary,560onwhatportisencryptedtraffic,765PHP4features,3usingMySQLandHTTPS,765encryptionfunctions,PHP,559–562mcrypt_decrypt,564mcrypt_encrypt,564md5,559mhash,561endfunction,arrays,141endoffile(EOF)identifyingifEOFreached,287recognizingendoffilecharacter,287end-of-line(EOL)characterauto_detect_line_endingsdirective,PHP,47enginedirective,PHP,30ENGINEStable,725ENT_XYZvaluesquote_styleparameter,htmlentitiesfunction,255EnterpriseApplicationIntegration(EAI),505enterprise-levelSQLfeatures,623ENUMdatatype,MySQL,713NULLattribute,713placeholdersforenum,823,824$_ENVsuperglobalvariable,85environmentvariables,PHPsafe_mode_allowed_env_varsdirective,36,543safe_mode_protected_env_varsdirective,36,543EOF(endoffile),287equalityoperators,93eregfunction,235–236ereg_replacefunction,237–238eregifunction,236–237eregi_replacefunction,238errnomethod,mysqli,772,789erroratribute,$_FILESsuperglobal,85errorcodeparameter,exceptionclassconstructor,224errorhandlingseealsoexceptionhandlingconfigurationdirectives,213,214–217displayingerrorstobrowser,215–216displayingstartuperrors,216errormessagesinsyslog,217errormessagesintextfile,218identifyinglogfile,216ignoringerrorsoriginatingfromsamelocation,217ignoringrepeatederrors,217ldap_err2strfunction,441ldap_errnofunction,442977INDEXldap_errorfunction,442loggingerrors,216MySQLtriggersand,853PDO(PHPDataObjects),802–804PDO_ERRMODE_EXCEPTIONmode,802PDO_ERRMODE_SILENTmode,802PDO_ERRMODE_WARNINGmode,802reportingsensitivitylevel,214settingdesirederrorsensitivitylevel,214–215settingmaximumloglinelength,217storingmostrecenterrorinvariable,217errorhandling,LDAP,441–442convertingerrornumberstomessages,441LDAP_XYZerrorcodes,442retrievingmostrecenterrormessage/number,442errorlogging,217–220seealsologfilesbriefintroduction,213categoryofprogramloggingmessage,219closelogfunction,219closingconnectiontosystemlogger,219define_syslog_variablesfunction,218identifyingPHP-relatedmessages,218initializingPHP'sloggingfacility,218LOG_XYZerrorloggingoptions,219loggingoptionsusedinmessagegeneration,219openingconnectiontosystemlogger,218openlogfunction,218permissions,217sendingcustommessagetosyslog,219syslogfunction,219syslogprioritylevels,220errormessages,PHPuploaderrormessages,393–394errormethod,mysqli,773,789errorreportingmodesPDO_ATTR_ERRMODEoption,800errorreportingsensitivitylevel,214errorvariable,$_FILESarray,391uploaderrormessages,393–394error_logdirective,216,217error_messageparameter,sqlite_openfunction,572error_msgparametersqlite_queryfunction,574sqlite_unbuffered_queryfunction,575error_reportingdirective,214,215errorCodemethod,PDO,802errorInfomethod,PDO,803errorMsgmethod,HTTP_Upload,396errorsdisplay_errorsdirective,544MySQLerrormessages,774mysqliextension,772–774escapeformatsshort_open_tagdirective,PHP,31escapemethodcreatingZendFrameworkviews,616escapesequences,PHP,95,96escapestringssqlite_escape_stringfunction,586ESCAPEDBYoptionLOADDATAINFILEstatement,943escapeshellargfunction,304sanitizinguserinput,554escapeshellcmdfunction,305sanitizinguserinput,554EVENTprivilege,752eventscheduling,MySQL5.
1,631Event_privcolumndbtable,746hosttable,747usertable,740,744events,MySQLtriggers,849EVENTStable,725EXAMPLEstorageengine,MySQL,704Excel,Microsoftchoosingdelimiterin,955exportingMySQLdatato,953TextImportWizard,954978INDEXexceptionclass,223–225constructor,223,225extending,225–226getXyzmethods,224Invalid_Email_Exceptionclassextending,227,229methods,224My_Exceptionclassextending,225overridingmethods,224exceptionhandling,221–229seealsoerrorhandlingbriefintroduction,213catchingmultipleexceptions,226–229classesimplementing,223–229PHP5features,5raisinganexception,225stepstoimplement,221throwingandcatchingexceptions,221trycatchblock,222valueof,221–223exceptionsparameter,SoapClientconstructor,529exclusiveORoperator,92execfunction,305execmethod,PDO,805executemethod,mysqli,784,787executemethod,PDO,807,808executeoption,mysqlclient,674EXECUTEprivilege,752Execute_privcolumndbtable,746hosttable,747usertable,740,743EXISTSclause,MySQL,900EXPLAINstatement,MySQL,919explicitdeclarationofvariables,PHP,74explodefunction,261arrays,132filebasedauthentication,371EXPORTOPTIONSoption,952exportingdata,951–954example,953exportingdatatoExcel,953mysqldumpcommand,951SELECTINTOOUTFILEstatement,951,952exportvaluemethod,HTML_QuickFormclass,362expose_phpdirective,PHP,38,547expressionsdescription,87regularexpressions,232–248expressions,PHP,87operands,87operators,88extend-checkoption,myisamchkclient,682extended-statuscommand,mysqladminclient,676extendskeyword,OOP,199extensibility,Smarty,475extensiondirective,PHP,48extension_dirdirective,PHP,46customizingPHPbuildonWindows,26enablingmysqliextension,769extensionsconfiguringPHPsecurely,548denyingaccesstosomeextensions,550installingApacheandPHPonLinux,17installingApacheandPHPonWindows,19PHPfileextensionssupportedbywebhost,52phpsextension,38F%ftypespecifier,64fflag,installcommandCalendarpackage,PEAR,342foption,mysqlclient,674Fparameter,datefunction,326facilityparameter,openlogfunction,219979INDEXFastCGIconfiguringFastCGItomanagePHPprocesses,22confirmingFastCGIHandlerMappingisinstalled,23installingIISandPHPonWindows,20,21testingPHPinstallation,25fclosefunction,289featuresofPHPlanguage,7–10FEDERATEDstorageengine,MySQL,701Fedorarunlevels,649feeds,RSSseeRSSfeedsfeoffunction,287fetchmethod,mysqli,789fetchmethod,PDO,811choosingfetchorfetchAllfunction,814cursor_offsetparameter,812cursor_orientationparameter,812PDO_FETCH_XYZvalues,811fetchstatement,Smarty,491FETCHstatement,MySQLusingcursors,903,904fetch_arraymethod,mysqli,780fetch_objectmethod,mysqli,779fetch_rowmethod,mysqli,780fetch_styleparameterPDO_FETCH_XYZvalues,811fetchAllmethod,PDO,813choosingfetchorfetchAllfunction,814fetchColumnmethod,PDO,814fetchingPDO_ATTR_PREFETCHoption,800PDO_DEFAULT_FETCH_MODEoption,800fgetcfunction,295fgetcsvfunction,292loadingtabledatawithPHP,950fgetsfunction,293fgetssfunction,294fieldsretrievingfieldnames,580sqlite_field_namefunction,580sqlite_num_fieldsfunction,581FIELDSTERMINATEDBYoptionLOADDATAINFILEstatement,942fields,OOP,168–172classcharacteristics,166declaring,168fieldscopes,169–172finalfields,172gettingfieldsavailabletoobject,190invoking,169privatefields,171protectedfields,171publicfields,169referringto,169restrictingaccessto,169staticfields,187staticscope,187fields-xyzoptions,mysqlimportutility,947filebasedauthentication,PHP,371–373authenticationFile.
txt,371drawbacks,372fileextensionsretrievingfrompath,279filefunction,290,371filehandlingclosingfiles,289fileaccessmodes,288identifyingifEOFreached,287ignoringnewlinecharacters,295movingfilepointertobeginningoffile,299movingfilepointertooffset,298openingfiles,288outputtingdatatofile,297PHP4features,3readingCSVfileintoarray,292readingentirefile,296readingfileinpredefinedformat,297readingfileintoarray,290readingfileintostring,291readingsinglecharacter,295readingspecificnumberofcharacters,293recognizingendoffilecharacter,287980INDEXrecognizingnewlinecharacters,287resourcehandling,286retrievingcurrentpointeroffset,299settingaccesslevel,288strippingHTMLandPHPtagsfrominput,294writingstringtofile,297fileI/Oseefilehandlingfileinclusionstatements,PHP,108–112includestatement,109–110include_oncefunction,111requirestatement,111require_oncefunction,111fileownershipsafe_moderestrictions,541filepointersmovingtobeginningoffile,299movingtooffset,298retrievingcurrentpointeroffset,299FILEprivilegedescription,753fileuploaddirectives,PHP,389–390seealsoresourcedirectives,PHPfileuploaddirectives,389post_max_sizedirective,390upload_max_filesizedirective,389upload_tmp_dirdirective,390fileuploadfunctions,PHP,391–393fileuploadsseeuploadingfilesfile_get_contentsfunction,291File_privcolumn,usertable,739,743File_SMBPasswdpackage,PEAR,319file_uploadsdirective,PHP,389fileatimefunction,284filectimefunction,285filemtimefunction,286filenameparameter,sqlite_openfunction,571filescross-sitescripting,551determiningsizeof,281ensuringfileincludedonlyonce,111ensuringfilerequiredonlyonce,111filedeletionrisk,550getLinemethod,exceptionclass,224init_fileparameter,MySQL,656renaming,302requiringfiles,111retrievingdirectoryfrompath,279retrievingfileextensionfrompath,279retrievingfilenamefrompath,278,279retrievinginformationaboutfilesuploadedusingPOST,84retrievinglastaccesstime,284retrievinglastchangedtime,285retrievinglastmodificationtime,286settingaccesslevel,288settingmodification/accesstimes,302touching,302uploadingfiles,387–399PEAR:HTTP_Uploadclass,395–399uploadingfilesviaHTTP,387–388uploadingfileswithPHP,388–395$_FILESsuperglobalarray,PHP,390–391$_FILESsuperglobalvariable,84filesstorageoptionsave_pathdirective,449storingsessioninformation,448FILEStable,725filesizefunction,281filtersenforcingfiltersandrules,360–362PEAR:HTML_QuickForm,358finalfields,172finalkeyword,181finalmethods,181finalscopeexceptionclassmethods,224final_funcparameter,sqlite_create_aggregatefunction,589Firebird,797firewalls,MySQLsecurity,733first-in-first-out(FIFO),134981INDEXFlexinstallingApacheandPHPonLinux,15flexibility,PDO,795floatdatatype,66typecasting,69FLOATdatatype,MySQL,711floating-pointnumbersseealsofloatdatatypetypespecifierfor,64FLOSS(Free/LibreandOpenSourceSoftware)usingwithMySQL,626FLOSSException,626flushingimplicit_flushdirective,PHP,34flush-xyzcommands,mysqladminclient,677footer.
phtmlfile,617footersauto_append_filedirective,PHP,44fopenfunction,288include_pathconfigurationdirective,288,289purposeof,289safe_modedirective,541use_include_pathparameter,288zcontextparameter,288fopenwrapperscategoryPHPconfigurationdirectives,46–47fopen_with_pathfunction,45forstatement,PHP,104forceoption,mysqlclient,674forceoption,mysqlimportutility,947force_extra_parametersdirectivemailfunction,412foreachstatement,PHP,105foreachfunction,Smarty,485foreachelsefunction,Smarty,487foreignkeys,InnoDBtables,699formatmethod,DateTimeclass,346formatparameters,datefunction,326formsseewebformsformsbasedsearchesseesearches,MySQLforward-onlycursors,MySQL,903frameworksolutions,605–607CakePHPframework,605Solarframework,606symfonyframework,606ZendFramework,607–620freadfunction,295freemethod,mysqli,778,789freespacedeterminingfreespaceondiskpartition,281FreeTDSPDOsupporteddatabases,797fromdirective,PHP,47fromparameterforeachfunction,Smarty,485frontcontroller,MVC,604frontcontroller,ZendFrameworkwebsitecreatingfront-endcontroller,612–613fscanffunction,297fseekfunction,298fsockopenfunction,408–411ft_max_word_lenparameterstopwords,MySQL,916ft_min_word_lenparameterstopwords,MySQL,916ft_stopword_fileparameterstopwords,MySQL,916ftellfunction,299fulltextindexes,MySQL,913–918AGAINSTfunction,914,915Booleanfull-textsearches,917MATCHfunction,914,915queryexpansion,915stopwords,916full-textsearch,MySQL,923–924functionparameters,77functionprototype,61functionsaddAttachmentmethod,PEAR,418buildmethod,344982INDEXcasemanipulationfunctions,252–254creatingcustomstringreplacementfunction,246creatingfunctions,115–124creatingSQLitefunctions,587–588defaultargumentvalues,118–119disable_functionsdirective,PHP,37,543encryptionfunctions,559–562fileuploadfunctions,391–393formatmethod,DateTimeclass,346functionlibraries,124–125functionsyntax,114,115functionsandmethodscompared,OOP,177headersmethod,414helperfunctions,189–191HTML/stringconversionfunctions,254–260includestatement,109–110invokingfunctions,113–114modifymethod,DateTimeclass,347nestingfunctions,7optionalarguments,118output_handlerdirective,PHP,33passingargumentsbyreference,117passingargumentsbyvalue,115–116passingarrayvaluestofunction,142–143passingformdatato,352–353Perlcompatibleregularexpressionfunctions,242–248PHPfunctionlist,114predefinedtemplates,115recursivefunctions,80,121–124regularexpressionfunctions,POSIX,235–239returningmultiplevaluesfrom,120–121returningvaluesfrom,119–121setDatemethod,DateTimeclass,346setTimemethod,DateTimeclass,347storedfunctions,MySQL,821stringcomparisonfunctions,249–252string-specificfunctions,248–260type-relatedfunctions,71usingwithviews,MySQL,868validatingformdatain,352verifyingandconvertingdatatypes,71functions,listofarray_flip,258autoload,192basename,278bin2hex,562bindtextdomain,593,595,597checkdate,325checkdnsrr,402–404class_exists,189closedir,299construct,183count_chars,271date,325,339date_default_timezone_set,324define,86define_syslog_variables,218destruct,186dirname,279disk_free_space,281disk_total_space,282dns_get_record,404–406ereg,235–236ereg_replace,237–238eregi,236–237eregi_replace,238escapeshellarg,304,554escapeshellcmd,305,554exec,305explode,261fclose,289feof,287fgetc,295fgetcsv,292fgets,293fgetss,294file,290file_get_contents,291983INDEXfileatime,284filectime,285filemtime,286filesize,281fopen,288fread,295fscanf,297fseek,298fsockopen,408–411ftell,299fwrite,297get,174get_class,189get_class_methods,190get_class_vars,190get_declared_classes,190get_html_translation_table,258get_object_vars,190get_parent_class,190getdate,330–331getlastmod,338getmxrr,407getservbyname,407getservbyport,408gettimeofday,329gettext,592gettype,71htmlentities,255,350,555htmlspecialchars,257,555implode,262include_once,111insert_banner,492insert_name,491interface_exists,191is_a,191is_name,72is_subclass_of,191is_uploaded_file,391ldap_add,436ldap_bind,429ldap_close,430ldap_connect,427ldap_count_entries,435ldap_delete,439ldap_dn2ufn,440ldap_err2str,441ldap_errno,442ldap_error,442ldap_explode_dn,440ldap_get_entries,432–433ldap_mod_add,437ldap_mod_del,439ldap_mod_replace,438ldap_modify,438ldap_read,433ldap_rename,438ldap_search,430–432ldap_set_option,428ldap_sort,435ldap_start_tls,428ldap_unbind,430list,577localeconv,599ltrim,269mail,311,413md5,559method_exists,191mktime,332–333money_format,599move_uploaded_file,392nl2br,254number_format,599opendir,299openlog,218passthru,307pathinfo,279preg_grep,242preg_match,243preg_match_all,243preg_quote,244preg_replace,245preg_replace_callback,246984INDEXpreg_split,247putenv,543readdir,299readfile,296realpath,280rename,302requirestatement,111require_once,111rewind,299rmdir,301rtrim,269scandir,300set,173setcookie,84setlocale,334–336,592,597,598–600settype,71shell_exec,308split,238spliti,239sql_regcase,239sqlite_array_query,578sqlite_changes,582sqlite_close,573sqlite_column,578sqlite_create_aggregate,589sqlite_create_function,587sqlite_current,582sqlite_escape_string,586sqlite_fetch_array,576–577sqlite_fetch_column_types,585sqlite_fetch_single,579sqlite_fetch_string,579sqlite_field_name,580sqlite_has_more,583sqlite_last_insert_rowid,576sqlite_next,583sqlite_num_fields,581sqlite_num_rows,581sqlite_open,571sqlite_popen,572sqlite_query,574sqlite_rewind,584sqlite_seek,584sqlite_udf_decode_binary,588sqlite_udf_encode_binary,588sqlite_unbuffered_query,575str_ireplace,265str_pad,270str_replace,265strcasecmp,250strcmp,249strcspn,251strftime,336,481,599strip_tags,143,259,556stripos,264strlen,249strpos,263strrpos,264strspn,251strstr,265strtok,260strtolower,252strtotime,340,599strtoupper,252strtr,259substr,266substr_count,267substr_replace,268syslog,219system,306textdomain,593,597time,332touch,302trim,270ucfirst,253ucwords,254vstr_word_count,272functions,Smartytemplatingengineseealsostatements,Smartytemplatingenginecapitalize,480config_load,494count_words,481985INDEXdate_format,481default,482foreach,485foreachelse,487if,484include_php,493section,487sectionelse,490strip_tags,482truncate,483fwritefunction,297lengthparameter,298Ggmodifier,Perlregularexpressions,240Goption,mysqlclientdisplayingresultsvertically,668SHOWSTATUSstatement,842G,gparameters,datefunction,326garbagecollectiongc_maxlifetimedirective,453session_garbage_collectfunction,463gc_maxlifetimedirective,453gcctoolinstallingMySQLonLinux,640,641$_GETsuperglobalvariable,83getfunction,174GETmethodarg_separator.
inputdirective,PHP,40passingdatabetweenscripts,350get_classfunction,189get_class_methodsfunction,190get_class_varsfunction,190get_config_varsmethodreferencingconfigurationvariables,Smarty,495get_declared_classesfunction,190get_html_translation_tablefunction,258get_object_varsfunction,190get_parent_classfunction,190getAttributemethod,PDO,804retrievingattributevalues,801settingerrormode,802getCodemethod,exceptionclass,224getdatefunction,330–331getFilesmethod,HTTP_UploaduploadingfileswithPEAR:HTTP_Upload,396uploadingmultiplefiles,398getFunctionsmethod,SOAP,530getlastmodfunction,338getLinemethod,exceptionclass,224getMessagemethod,exceptionclass,224getmxrrfunction,407getPropmethod,HTTP_UploadusingHTTP_Uploadtoretrievefileproperties,398getQuotefunction,SOAP,531,533boxingserver,536executingboxingclient,537getservbynamefunction,408getservbyportfunction,408getSubmitValuesmethod,HTML_QuickFormclass,362gettermethodscreatingcustomgettersandsetters,175GettexttranslatingwebsiteswithGettext,592–598creatinglocalizationrepository,594creatingtranslationfiles,595–596generatingbinaryfiles,597settingdesiredlanguageinscripts,597–598translatingtext,596–597updatingwebsitescripts,592–594xgettextcommand,595gettextfunctionrecognizingstringsfortranslation,592supportmultiplelanguageswith,594gettextutilitydownloadingandinstalling,592gettimeofdayfunction,329getTracemethod,exceptionclass,224getTraceAsStringmethod,exceptionclass,224gettypefunction,71986INDEXGID(groupID)safe_mode_giddirective,PHP,35GLOBALkeyword,78globalscope,functionsreturnstatement,119globalscope,variablesregister_globalsdirective,41globalsearchPerlregularexpressionmodifier,240globalvariablesconfigurationfiles,Smarty,493variablescope,PHP,78GLOBAL_STATUStable,726GLOBAL_VARIABLEStable,726globalizationseeinternationalizationglobalsregister_globalsdirective,PHP,41$_GLOBALSsuperglobalarray,78,85GNOMEXMLlibraryPHP5'sSOAPextension,529gotostatement,PHP,107GPL(GeneralPublicLicense)usingwithMySQL,626GRANTcommand,MySQLaccessprivilegesmanagedby,752,753addingprivilegestouser,754creatingnewuser,754description,750grantingcolumn-levelprivileges,756,758grantingmultipletable-levelprivileges,755grantingtable-levelprivileges,755,758importanceofIDENTIFIEDBYclause,758privilegetypessupported,758syntax,753tipswhenworkingwith,758userandprivilegemanagement,753–756wildcards,758GRANTOPTIONprivilege,753grantoptionsdetermininguser'sSSLrequirements,761REQUIRECIPHERoption,762REQUIREISSUERoption,762REQUIRESSLoption,761REQUIRESUBJECToption,762REQUIREX509option,761Grant_privcolumndbtable,745hosttable,747usertable,739,743Grantorcolumnprocs_privtable,749tables_privtable,748granularityBooleanfull-textsearches,917graphcharacterclass,235greaterthan(>)characterdisplayingspecialHTMLcharacters,257htmlentitiesfunctiontranslating,555greaterthan(>,>=)operators,93groupIDssafe_mode_giddirective,542GUIclientprograms,MySQL,686–691GUITools,MySQLinstalling,687gunziptoolinstallingMySQLonLinux,639,640,641Gutmans,Andi,2HH,hoptions,mysqlclient,671,674,684H,hparameters,datefunction,326handlemethod,SOAP,535handlersstoredroutines,MySQL,844handlesseefilehandlinghandlingerrorsseeerrorhandlinghardcodedauthentication,PHP,370hashmarkreferencingconfigurationvariables,Smarty,495hashedindexes,700987INDEXhashingencryptingdatawithmd5function,559mhashfunction,561mhashlibrary,560headerfunctionauthentication,PHP,368header.
phtmlfilecreatingZendFrameworkviews,617headersseealsomessageheadersauto_prepend_filedirective,PHP,44output_bufferingdirective,PHP,32headersmethodsendinge-mailwithmultiplerecipients,414headlineslimitingnumberdisplayed,MagpieRSS,518HEAPstorageengine,MySQL,693,699helpcommand,PEAR,316helpoptionmysqlimportutility,947mysqlxyzclients,685SQLite,569helperfunctions,189–191class_exists,189get_class,189get_class_methods,190get_class_vars,190get_declared_classes,190get_object_vars,190get_parent_class,190interface_exists,191is_a,191is_subclass_of,191method_exists,191heredoc(pathinfofunction,279pathscookie_pathdirective,451datadiroption,MySQL,655hidingsensitivedata,549identifyingabsolutepath,280include_pathdirective,PHP,45retrievingdirectoryfrom,279retrievingfilenamefrom,278,279safe_mode_include_dirdirective,542save_pathdirective,449settingpathtosendmailbinary,412pathsanddirectoriescategoryPHPconfigurationdirectives,45–46patternparameter,preg_replace_callbackfunction,246PDF(PortableDocumentFormat)files,8PDO(PHPDataObjects),795–817adding/modifying/deletingdata,805connectingtodatabaseserver,798–801embeddingparametersintoconstructor,799handlingconnectionerrors,801PDOconnection-relatedoptions,799placingparametersinfile,799referringtophp.
inifile,799databaseabstractionlayersand,795databasessupported,797determiningavailabledrivers,798errorhandling,802–804retrievingSQLerrorcodes,802retrievingSQLerrormessages,803executingqueries,805–806features,795installing,796preparedstatements,805,807–810executingpreparedquery,808namedparameters,807,809questionmarkparameters,807retrievingattributes,804retrievingdata,811–815fetchingsinglecolumn,814retrievingnextrowinresultset,811returningnumberofretrievedcolumns,811simultaneouslyreturningallresultsetrows,813selectingdatabase,801selectingtabledata,806settingattributes,805settingboundcolumns,815–816transactions,816using,817PDOmethodsbeginTransaction,817bindColumn,815bindParam,807,808,809,810columnCount,811commit,817errorCode,802errorInfo,803exec,805execute,807,808fetch,811fetchAll,813fetchColumn,814getAttribute,804prepare,8071010INDEXquery,806rollback,817rowCount,806setAttribute,805PDO_ATTR_AUTOCOMMIToption,800PDO_ATTR_CASEoption,800PDO_ATTR_CLIENT_VERSIONattribute,801PDO_ATTR_CONNECTION_STATUSattribute,801PDO_ATTR_EMULATE_PREPARESoption,800PDO_ATTR_ERRMODEoption,800PDO_ATTR_ORACLE_NULLSoption,800PDO_ATTR_PERSISTENToption,800PDO_ATTR_PREFETCHoption,800PDO_ATTR_SERVER_INFOattribute,801PDO_ATTR_SERVER_VERSIONattribute,801PDO_ATTR_TIMEOUToption,800PDO_DEFAULT_FETCH_MODEoption,800pdo_driversfunction,798PDO_ERRMODE_EXCEPTIONmode,802PDO_ERRMODE_SILENTmode,802PDO_ERRMODE_WARNINGmode,802PDO_FETCH_XYZvalues,811PDO_PARAM_XYZvalues,809PDOStatementclass,811PDT(PHPDevelopmentTools)choosingcodeeditor,49PEAR(PHPExtensionandApplicationRepository),309–322background,309Calendarpackage,341–345convertingnumeralformats,312–313creatingtabularoutputwith,880–889creatingsimpletable,882installingHTML_Table,881directoriesandpackagenames,320generalPHPlanguagefeatures,8helpcommand,316infocommand,317installcommand,318installing,313–315hostingcompanypermission,315onLinux,314onWindows,314packages,319listcommand,316uninstallcommand,322updating,315upgradecommand,320upgrade-allcommand,321PEARPackageManager,316–322downgradingPEARpackages,322gettinghelp,316includingpackageswithinscripts,320installer-suggestedpackages,310installingPEARpackages,318–319automaticallyinstallingdependencies,319manuallyfromPEARwebsite,319learningaboutinstalledPEARpackages,317preinstalledpackages,310uninstallingPEARpackages,322upgradingPEARpackages,320–322viewinginstalledPEARpackages,316PEARpackages,310–312Archive_Tar,310Auth,319Auth_HTTP,377–380Calendar,341–345Console_Getopt,310DB,311File_SMBPasswd,319HTML_Common,356HTML_QuickForm,355–363HTML_Table,880–889HTTP_Upload,395–399Mail,311,413–418Mail_Mime,413–418MDB2,3111011INDEXNet_SMTP,311Net_Socket,311Numbers_Roman,312PEAR,310PHPUnit,312Validate,556–558Validate_US,274–276XML_Parser,312PEAR_ENV.
regfile,315PEAR:Auth_HTTPclassseeAuth_HTTPclassPEAR:HTML_QuickFormclassseeHTML_QuickFormclassPEAR:HTTP_UploadclassseeHTTP_UploadclassPEAR:ValidatepackageseeValidatepackagePEAR:Validate_USpackageseeValidate_USpackagePECL(PHPExtensionCommunityLibrary),382performancechoosingstorageengine,706indexingtips,918mysqlinbatchmode,667PDOfeatures,795reasonsforMySQLpopularity,623storedroutines,820,821templatecaching,501PerlinstallingApacheandPHPonLinux,15XAMPPastestenvironment,12PerlCompatibleRegularExpressions(PCRE)library,4PerlDBI,794Perlregularexpressionsseeregularexpressions,Perlpermissionsseealsoprivilegeserrorlogging,217mysql_setpermissionscript,756mysqliextension,775uploadingfileswithPHP,395persistenceopeningpersistentconnections,SQLite,572PDO_ATTR_PERSISTENToption,800phonenumbersValidate_USpackage,PEAR,275PHP(PersonalHomePage)buildingtransactionalapplicationswith,933–936choosingcodeeditor,48–50codereuse,309compressionhandlerfunction,33conditionalstatements,98–101configurationtemplates,27configuringatbuildtimeonLinux,25configuringFastCGItomanageprocesses,22configuringforMySQL,661configuringsecurely,540–545hidingconfigurationdetails,547–549constants,86–87controlstructures,98–112customizingWindowsbuild,26datatypesseedatatypes,PHPdateandtimefunctionsseedateandtimefunctions,PHPDateTimeclass,345–348downloading,13–14downloadingPHPmanual,15enablingIMAPextension,26escapesequences,95,96expressions,87fileinclusionstatements,108–112fileuploaddirectives,389–390fileuploadfunctions,391–393frameworksolutions,605–607generallanguagefeatures,7–10handlingexternalvariables,40hidingconfigurationdetails,547–549history,2–6identifiers,731012INDEXinstallingApacheandPHPonLinux,15–17installingApacheandPHPonWindows,17–20installingIISandPHPonWindows,20–22LDAPextension,427–442loadingtabledatawith,950loopingstatements,101–108network-specificfunctionality,401–424object-orientedPHP,163–192,193–211featuresnotsupportedbyPHP,194outputtingdatatowebbrowser,61–65programexecutionfunctions,305reasonsforinstalling,11,12reconfiguringafterMySQLinstall,661removingHTMLandPHPtags,259resourcedirectives,PHP,389–390restrictionsplacedonscriptsbywebhost,52run-timePHPconfiguration,27–48sendinge-mailusingPHPscript,412–418SQLitelibrary,571–590storingmostrecenterrorinvariable,217stringinterpolation,95strippingHTMLandPHPtagsfrominput,294superglobalvariables,80–86testingPHPinstallation,23–25uploaderrormessages,393–394uploadingfileswithPHP,388–395$_FILESsuperglobalarray,390–391fileuploaddirectives,389–390is_uploaded_filefunction,391move_uploaded_filefunction,392usingCrackLibextension,382–383usingcursorswith,906usingLDAPfromPHP,427–442usingPHPwithMySQL,767usingsubquerieswith,901variables,73–86versions,2–6versionsofferedbywebhost,52viewingPHPdocumentation,14webforms,349–355XAMPPastestenvironment,12PHP4,3–4PHP5,4–5SOAPextension,528–537GNOMEXMLlibrary,529PHP6,5–6PHParraysseearraysPHPauthentication,367–380Auth_HTTPclass,PEAR,377–380authenticationmethodologies,370–380authenticationvariables,367databasebasedauthentication,373–375filebasedauthentication,371–373hardcodedauthentication,370headerfunction,368IPaddressbasedauthentication,375–377issetfunction,369md5function,384uniqidfunction,384PHPcodecomments,59–60delimitingPHPcode,56–58embeddinginwebpages,56–59embeddingmultiplecodeblocks,59typespecifiers,64PHPconfigurationdirectives,30–48briefintroduction,213comments,28datahandlingcategory,40–45dynamicextensionscategory,48fileuploaddirectives,389–390fopenwrapperscategory,46–47languageoptionscategory,30–34managing,30miscellaneouscategory,38modifying,27Apachehttpd.
confand.
htaccessfiles,29ini_setfunction,29php.
inifile,27scopesformodification,301013INDEXpathsanddirectoriescategory,45–46resourcedirectives,389–390resourcelimitscategory,39–40restrictionsplacedonscriptsbywebhost,52run-timePHPconfiguration,27–48safemodecategory,34–37scopesformodifying,30syntaxhighlightingcategory,37–38PHPconfigurationdirectives,listofallow_call_time_pass_reference,34allow_url_fopen,47,110,111always_populate_raw_post_data,45arg_separator,40asp_tags,31assoc_case,571auto_append_file,44auto_detect_line_endings,47auto_prepend_file,44auto_start,450cache_expire,453cache_limiter,452cookie_domain,451cookie_lifetime,451cookie_path,451default_charset,44default_mimetype,44default_socket_timeout,47disable_classes,37disable_functions,37display_errors,215display_startup_errors,216doc_root,46enable_dl,46engine,30error_log,216error_reporting,214expose_php,38extension,48extension_dir,46file_uploads,389force_extra_parameters,412from,47gc_maxlifetime,453highlight,38ignore_user_abort,37ignore_repeated_errors,217ignore_repeated_source,217implicit_flush,34include_path,45,320log_errors,216log_errors_max_len,217magic_quotes_gpc,43,97magic_quotes_runtime,43magic_quotes_sybase,44max_execution_time,39,389max_input_time,39memory_limit,40,389name,450open_basedir,36,545output_buffering,32output_handler,33post_max_size,42,390precision,32referer_check,452register_argc_argv,42register_globals,41,42register_long_arrays,42safe_mode,35safe_mode_allowed_env_vars,36safe_mode_exec_dir,36safe_mode_gid,35safe_mode_include_dir,35,542safe_mode_protected_env_vars,36save_handler,448save_path,449sendmail_from,411,413sendmail_path,412serialize_precision,34sessionhandling,448–453short_open_tag,31SMTP,411smtp_port,4121014INDEXtrack_errors,217unserialize_callback_func,34upload_max_filesize,389upload_tmp_dir,390use_cookies,450use_trans_sid,450user_agent,47user_dir,46,545variables_order,40,85y2k_compliance,32zend,31zlib,33PHPDataObjectsseePDOPHPExtensionCommunityLibrary(PECL),382phpfunction,Smarty,492PHPfunctionsseefunctions,listofPHPlibraries,124–125PHPscriptsreferencingPOSTdata,350PHPwebsite,914php.
inifileseealsoPHPconfigurationdirectives,listofaspectsofPHPbehaviorcontrolledby,27comments,28connectingtodatabaseserver,PDO,799customizingPHPbuildonWindows,26description,27installingApacheandPHPonLinux,16installingApacheandPHPonWindows,20installingZendFramework,610modifyingPHPconfigurationdirectives,27reconfiguringPHPonWindowsafterMySQLinstall,661renamingoneofconfigurationtemplatesas,27run-timePHPconfiguration,27–48syntax,28whenchangestakeeffect,29php.
ini-distconfigurationtemplate,27php.
ini-recommendedconfigurationtemplate,27php_admin_flagkeyword,29php_admin_valuekeyword,29PHP_AUTH_PWvariable,367hardcodedauthentication,370PHP_AUTH_USERvariable,367hardcodedauthentication,370php_errormsgvariable,217php_flagkeyword,29PHP_INI_ALLscope,30PHP_INI_PERDIRscope,30PHP_INI_SYSTEMscope,30PHP_INI_USERscope,30php_valuekeyword,29phpDocumentor,60phpinfofunctiondeterminingavailabledrivers,798hidingPHPconfiguration,548reconfiguringPHPafterMySQLinstall,661testingPHPinstallation,23,24PHPIniDirdirectiveinstallingApacheandPHPonWindows,19modifyingPHPconfigurationdirectives,27phpMyAdmin,691–692phpsextension,38PHPUnitpackage,PEAR,312pingcommand,mysqladminclient,677pingingserver,418–419pipe(|)operator,regularexpressions,233pipeoption,mysqlxyzclients,684pipesprotocol,mysqlclient,675PluggableStorageEngineAPI,MySQL5.
1,630PLUGINStable,726PointerRecord,DNS,4031015INDEXpointersmanipulatingresultsetpointer,SQLite,582–585movingfilepointertobeginningoffile,299movingfilepointertooffset,298movingresultsetpointerforward,583movingresultsetpointertofirstrow,584movingresultsetpointertospecificrow,584retrievingcurrentpointeroffset,299retrievingrowatcurrentpointerposition,582sqlite_currentfunction,582sqlite_nextfunction,583sqlite_rewindfunction,584sqlite_seekfunction,584polymorphism,166portoptionmysqlclient,674mysqlimportutility,948mysqlxyzclients,685portparameter,MySQL,657portability,storedroutines,821ports,408–411creatingportscannerwithfsockopenfunction,410creatingportscannerwithNMap,419defaultportsforinternetservices,407establishingport80connection,409establishingsocketconnections,408–411MySQLsecurity,733portforencryptedtraffic,765retrievingportnumber'sservicename,408retrievingservice'sportnumber,407settingporttoconnecttoserver,412POSIX(PortableOperatingSystemInterfaceforUnix),232POSIXregularexpressionsseeregularexpressions,POSIX$_POSTsuperglobalvariable,83retrievinginformationaboutfilesuploadedusing,84POSTmethodalways_populate_raw_post_datadirective,45arg_separator.
inputdirective,40passingdatabetweenscripts,350referencingPOSTdatainPHPscripts,350POSTvariablesnamingconventions,351post_max_sizedirective,PHP,42,390postalCodemethodValidate_USpackage,PEAR,275postdecrementoperation,92PostgreSQLPDOsupporteddatabases,798postincrementoperation,92PRCE(PerlCompatibleRegularExpressions)library,4precedence,operators,88,89precisionserialize_precisiondirective,PHP,34precisiondirective,PHP,32predecrementoperation,92predefinedcharacterranges(characterclasses)POSIXregularexpressions,234–235prefixingleftmostprefixing,912preg_grepfunction,242preg_matchfunction,243preg_match_allfunction,243,244preg_quotefunction,244preg_replacefunction,245preg_replace_callbackfunction,246preg_splitfunction,247PREG_XYZvalues,244preincrementoperation,92preparemethodmysqli,783PDO,8071016INDEXpreparedstatementsmysqli,767,789bindingparameters,785–787bindingvariables,787boundparameters,783boundresults,783executingpreparedstatements,784mysqliextension,782preparingstatementsforexecution,783recuperatingpreparedstatementresources,785retrievingrowsfrompreparedstatements,789usingotherpreparedstatementmethods,789PDO,805,807–810presentationallogicseparatingbusinesslogicfrom,472templatingenginesand,471,472presentationallogic,Smarty,474,479–493comments,480controlstructures,484–490statements,490–493variablemodifiers,480–484preserve_keysparameter,array_reversefunction,146prevfunction,arrays,141PRIMARYKEYattribute,MySQL,716creatingautomaticallyincrementingprimarykey,717creatingmultiplefieldprimarykey,717creatingsinglefieldprimarykey,717primarykeyindexes,MySQL,908–909notusingmeaningfulvalues,909NULLvalues,909uniqueness,908,909printstatement,PHP,61,63print_rarrayfunction,133print-defaultsoption,mysqlxyzclients,686printfstatement,PHP,63typespecifiers,64priorityparameter,syslogfunction,220privatefields,171privatekeyword,179privatemethods,179privatevalue,452private_no_expirevalue,452privilegecolumns,usertable,742privilegetables,MySQL,822–824privilegesseealsoauthentication;permissionsaddingprivilegestousers,754authentication,735authorization,735COLUMN_PRIVILEGEStable,725columns_privtable,738,749flush-privilegescommand,mysqladmin,677GRANT/REVOKEcommands,752–758grantingcolumn-levelprivileges,756grantingmultipletable-levelprivileges,755grantingprivileges,753–756grantingtable-levelprivileges,755managedbyGRANT/REVOKEcommands,752MySQLaccessprivilegesystem,734–750MySQLuserandprivilegemanagement,750–760procs_privtable,738,749reloadcommand,mysqladminclient,677reviewingprivileges,759revokingcolumn-levelprivileges,757revokingpreviouslyassignedprivileges,756revokingprivileges,MySQLsecurity,756–758revokingtable-levelprivileges,757SCHEMA_PRIVILEGEStable,726TABLE_PRIVILEGEStable,727tables_privtable,738,747tracingconnectionrequest,737userprivilegecolumns,usertable,742userprivileges,MySQLextension,7691017INDEXusertableandrequestauthorization,738,739USER_PRIVILEGEStable,727User/Host/Dbtaskmatch,745User/Host/Dbtripletlocated,745proctable,822Proc_privcolumn,procs_privtable,749proceduresstoredprocedures,MySQL,821processmethod,HTML_QuickFormclass,362PROCESSprivilege,753Process_privcolumn,usertable,739,743processlistcommand,mysqladminclient,677PROCESSLISTtable,726procs_privtablecolumns,tablelistingof,749MySQLaccessprivilegesystem,738,749storedroutines,MySQL,823producttablecreating,880mysqliextensionsampledata,769profilemanagerinterfaceintegratingtriggersintoWebapplications,860promptoption,mysqlclient,670promptsmodifyingmysqlprompt,670Propel,606properties,OOP,172–176creatingcustomgettersandsetters,175PHPlimitations,172protectedfields,171protectedkeyword,179protectedmethods,179protocoloption,mysqlclient,675protocolparameter,408protocols,8statelessprotocol,445prototype,61,606proxy_hostparameter,SoapClient,529proxy_loginparameter,SoapClient,530proxy_passwordparameter,SoapClient,530proxy_portparameter,SoapClient,530PTR(PointerRecord)recordtype,DNS,403publicfields,169encapsulating,170publickeyword,178publicmethods,178publicvaluesession.
cache_limiterdirective,452punctcharacterclass,235putenvfunctionsafe_mode_protected_env_varsdirective,543Pythonwebsite,914QquantifiersPerlregularexpressions,240POSIXregularexpressions,233–234queries,MySQLseealsostoredroutines,MySQLencapsulatingqueriesseeviews,MySQLpagedoutput,892–895querycaching,624,628queryexpansion,915queryoptimization,907replicatingqueriesseeviews,MySQLsubqueriesseesubqueries,MySQLtabular_outputmethodsortingresults,890queries,mysqliextensionparsingresults,779–781preparedstatements,782–789recuperatingquerymemory,778queryrelatedtasks,775–789queries,PDO,805–806queries,SQLite,574–576executingqueries,574executingunbufferedqueries,575retrievingmostrecentlyinsertedrowidentifier,5761018INDEXsqlite_array_queryfunction,578sqlite_queryfunction,574sqlite_unbuffered_queryfunction,575QueryBrowser,MySQL,688–689querymethodmysqli,775,782PDO,806questionmarkparameterspreparedstatements,PDO,807queuesorderofelementremoval,134quote_styleparameter,htmlentitiesfunction,255quotesdisplayingspecialHTMLcharacters,257doublequotes,95enablingmagicquotes,43htmlentitiesfunctiontranslating,555magic_quotes_gpcdirective,PHP,43,97magic_quotes_runtimedirective,PHP,43magic_quotes_sybasedirective,PHP,44singlequotes,96usingquotesinprogramming,43R\rescapesequence,96r,r+fileaccessmodes,288roptionmyisamchkclient,682mysqlcheckclient,682rparameter,datefunction,327randomvaluesreturningrandomkeysfromarrays,160rangefunction,arrays,132rangelengthrule,HTML_QuickForm,360readdirfunction,299readfilefunction,296readingreadingdirectorycontents,299,301readingfiles,289–297ignoringnewlinecharacters,295readingCSVfileintoarray,292readingentirefile,296readingfileinpredefinedformat,297readingfileintoarray,290readingfileintostring,291readingsinglecharacter,295readingspecificnumberofcharacters,293strippingHTMLandPHPtagsfrominput,294read-onlycursors,MySQL,903READSSQLDATAcharacteristic,827realnumbersseefloatdatatypeRealSimpleSyndicationseeRSSrealpathfunction,280recoveroption,myisamchkclient,682recovery,InnoDBtables,698recursivefunctions,80,121–124RedHatrunlevels,649referenceallow_call_time_pass_referencedirective,34passingargumentsby,117referenceassignmentvariabledeclaration,PHP,75REFERENCESprivilege,753References_privcolumndbtable,745hosttable,747usertable,739,743referentialintegrityreasonsforusingtriggers,850REFERENTIAL_CONSTRAINTStable,726referer_checkdirective,452referersvalidatingsessionsusing,452refreshcommand,mysqladminclient,677regeditscript,315regexrule,HTML_QuickForm,360regionmethod,Validate_USpackage,275register_argc_argvdirective,42register_globalsdirective,41,42register_long_arraysdirective,421019INDEXregistryexecutingPEAR_ENV.
regfile,315regularexpressions,232–248alternativestoregularexpressionfunctions,260–273convertingstringcharactersintobracketedexpressions,239performingsearch,case-insensitive,236–237performingsearch,case-sensitive,235–236PerlCompatibleRegularExpressionslibrary,4PHPfunctions,235–239pipe(|)operator,233replacingtext,case-insensitive,238replacingtext,case-sensitive,237splittingstringintoelements,case-insensitive,239splittingstringintoelements,case-sensitive,238regularexpressions,Perl,239–248compatiblePHPregularexpressionfunctions,242–248metacharacters,241–242modifiers,240–241preg_grepfunction,242preg_matchfunction,243preg_match_allfunction,243preg_quotefunction,244preg_replacefunction,245preg_replace_callbackfunction,246preg_splitfunction,247quantifiers,240regularexpressions,POSIX,232–235brackets([]),233charactersbasedonfrequencyorposition,233PHPregularexpressionfunctions,235–239predefinedcharacterranges(characterclasses),234–235quantifiers,233–234reloadcommand,mysqladminclient,677RELOADprivilege,753Reload_privcolumn,usertable,739,742REMOTE_ADDR,$_SERVERsuperglobal,82,83renamefunction,302RENAMEUSERcommand,MySQL,751rendermethodcreatingZendFrameworkviews,617renderingretrievedfeed,MagpieRSS,515REPAIRTABLEcommand,MySQL,917REPEATstatement,MySQL,838Repl_client_privcolumn,usertable,740,744Repl_slave_privcolumn,usertable,740,744REPLACEoptionLOADDATAINFILEstatement,942replaceoption,mysqlimportutility,948replaceparameter,headerfunction,368replicationbackingupInnoDBtables,932mysqli,768reasonsforMySQLpopularity,624REPLICATIONCLIENTprivilege,753REPLICATIONSLAVEprivilege,753reportingsensitivitylevel,errors,214$_REQUESTsuperglobal,85retrievingcookieinformation,448requestauthorizationseeauthorizationrequestverificationseeauthorizationREQUEST_URI,$_SERVERsuperglobal,83REQUIRECIPHERoption,762requirefunction,124makingunnecessary,44settingbasepathfor,45REQUIREISSUERoption,762REQUIRESSLoption,761REQUIRESUBJECToption,762REQUIREX509option,761requirestatement,PHP,111requirestatement,Smarty,477require_oncefunction,PHP,111,124require_oncestatement,1911020INDEXrequiredrule,HTML_QuickForm,360,361,362resetfunction,arrays,141resourcedirectives,PHP,389–390resourcehandlingseefilehandlingresourcelimitscategoryPHPconfigurationdirectives,39–40resourceslimitinguserresources,759–760RESTRICTkeyword,MySQL,875resultsetsiteratingwithcursors,902–906manipulatingresultsetpointer,SQLite,582–585determiningifendofresultsetisreached,583movingpointerforward,583movingpointertofirstrow,584movingpointertospecificrow,584retrievingrowatcurrentpointer,582MySQLtriggersand,853parsing,SQLite,576–580retrievingfirstcolumninresultset,579retrievingresultsetdetails,SQLite,580–582fieldnames,580numberofaffectedrows,582numberofcolumnsinresultset,581numberofrowsinresultset,581retrievingselectresultsetcolumns,578returningresultsetasassociativearray,576–577sqlite_currentfunction,582sqlite_has_morefunction,583sqlite_nextfunction,583sqlite_queryfunction,574sqlite_rewindfunction,584sqlite_seekfunction,584startingindexoffsetfor,584result_typeparametersqlite_fetch_arrayfunction,576sqlite_queryfunction,574sqlite_unbuffered_queryfunction,575resultmodeparameter,querymethod,776resultsbinding,mysqli,787boundresults,mysqli,783customizingviewresults,MySQL,867pagedresults,MySQL,879returnkeyword/statementreturningvaluesfromfunctions,119–121returningmultiplevalues,120–121returnparameters,MySQL,825–826reusingsoftware,webservices,505REVOKEcommand,MySQLaccessprivilegesmanagedby,752,753deletingusers,757description,750revokingcolumn-levelprivileges,757revokingpreviouslyassignedprivileges,756revokingtable-levelpermissions,757syntax,756tipswhenworkingwith,758userandprivilegemanagement,756–758rewindfunction,299right_delimiterattributechangingSmartydefaultdelimiters,496rmdirfunction,301rollbackdatabasetransactions,925InnoDBtablesexample,931,932MySQLtransactionstips,933rollbackmethodmysqli,790PDO,817Romannumeralsconvertingnumeralformats,312rootchrootoption,mysqlddaemon,734doc_rootdirective,46,544DocumentRootdirective,Apache,549hidingsensitivedata,549rootuserpassword,MySQL,7331021INDEXRoutine_namecolumn,procs_privtable,749Routine_typecolumn,procs_privtable,749ROUTINEStable,726routines,MySQLseestoredroutines,MySQLrowCountmethod,PDO,806rowscreatingmorereadablerowoutputwithHTML_Table,884retrievingnumberofaffectedrows,582retrievingnumberofrowsinresultset,581retrievingrowatcurrentpointerposition,582sqlite_changesfunction,582sqlite_last_insert_rowidfunction,576sqlite_num_rowsfunction,581rows,MySQLinsertingrowsviaviews,876retrievingmultiplerows,846rows,mysqliextensiondeterminingrowsselected/affected,781RPMinstallingMySQLonLinux,637–639learningmoreabout,638uninstallingMySQLonLinux,639rsortfunction,arrays,149RSS(RealSimpleSyndication),506–519MagpieRSS,510–519RSSaggregators,507RSSsyntax,509–510RSSBanditinterface,508RSSfeedsaggregatingfeeds,MagpieRSS,516–517description,507parsingfeeds,MagpieRSS,511–515popularaggregators,507publicationofRSSfeeds,508renderingretrievedfeed,MagpieRSS,515–516rtrimfunction,269RubyonRails,605rules,HTML_QuickForm,359–360enforcingfiltersandrules,360–362runlevelsRedHat/Fedora,649S%stypespecifier,64\S,\smetacharacters,Perlregularexpressions,241smodifier,Perlregularexpressions,240soptionmysqlclient,669mysqlxyzclients,685,686S,sparameters,datefunction,327stypecode,datatypes,785safe_modedirective,35,540–542configuringPHPsecurely,540–543functions/variables/directivesaffectedby,541PHPconfigurationdirectives,34–37restrictionswhenenabled,541sql.
safe_modedirective,545safe_mode_allowed_env_varsdirective,36,543safe_mode_exec_dirdirective,36,543safe_mode_giddirective,35,542safe_mode_include_dirdirective,35,542safe_mode_protected_env_varsdirective,36,543safe-updatesoption,mysqlclient,670,675safe-user-createoption,mysqlddaemon,734salestable,creating,880,940SavantTemplateSystem,606save_handlerdirective,448save_pathdirective,449scalabilitydatabasebasedauthentication,373PHP4features,3scalardatatypes,65scandirfunction,300schemacommand,SQLite,5701022INDEXschema,MySQLINFORMATION_SCHEMA,725–728,857SCHEMA_PRIVILEGEStable,726SCHEMATAtable,726scopeabstractmethods,180fieldscopes,169–172finalizedmethods,181methodscopes,178–181modifyingPHPconfigurationdirectives,30privatemethods,179protectedmethods,179publicfields,169publicmethods,178staticmethods,187scopeattributeconfig_loadfunction,Smarty,494scope,functionspassingargumentsbyreference,117passingargumentsbyvalue,115–116returnstatement,119scope,PHPvariables,76–80functionparameters,77globalvariables,78localvariables,76staticvariables,79scriptparameterinserttag,Smarty,491scripttagembeddingPHPcodeinwebpages,58scriptingcross-sitescripting,551scriptsdirectorycreatingZendFrameworkfront-endcontroller,612searches,MySQL,624,919–924Booleanfull-textsearches,917extendingsearchcapabilities,921full-textsearch,923–924simplesearchinterface,919textsearching,908searchingldap_readfunction,433ldap_searchfunction,430–432secvalue,gettimeofdayfunction,329secondssinceUnixepochvalue,331secondsvalue,getdatefunction,330sectionattributeconfig_loadfunction,Smarty,494sectionfunction,Smarty,487sectionelsefunction,Smarty,490sectionsconfigurationfiles,Smarty,493SecureLDAP(LDAPS),428SecureSocketsLayer(SSL)HTTPauthentication,367securityseealsoauthenticationadvantagesofusingviews,864configuringPHPsecurely,540–545changingdocumentextension,548configurationparameters,543–545expose_phpdirective,547hidingApache,546hidingconfigurationdetails,546–549hidingPHP,547–549removingphpinfocalls,548safemode,540–543cross-sitescripting,551dataencryption,559–565determiningmessageintegrityandauthenticity,562displayingerrorstobrowser,215expose_phpdirective,38filedeletion,550hidingsensitivedata,549–550DocumentRootdirective,549usingfileextensions,550LOADDATAINFILEstatement,945,950mysqlimportutility,950passwordoption,mysqlxyzclients,684PHP6features,6poorlyprotecteddata,5391023INDEXprogrammingsecurelyinPHP,539–565reasonsforMySQLpopularity,625register_globalsdirective,41restrictionsplacedonscriptsbywebhost,52safemodeconfigurationdirectives,35sanitizinguserinput,550–558escapeshellcmdfunction,554functionsfor,553htmlentitiesfunction,555PEAR:Validatepackage,556–558strip_tagsfunction,556Smartytemplatingengine,475softwarevulnerabilities,539SQLitedatabasesecurity,567storedroutines,820userinput,539security,MySQLseeMySQLsecuritysecurity,mysqliextensionsecuringconnectioninformation,775storingconnectioninformation,774SEEK_CUR/SEEK_END/SEEK_SETvaluesmovingfilepointer,299SELECTcommandmysqlclient,667mysqliextension,776SELECTINTOOUTFILEstatementexample,953exportingdata,951exportingdatatoExcel,953options,951tipsforusing,952SELECTINTOstatement,MySQL,829SELECTprivilege,753select_dbmethod,mysqli,771Select_privcolumndbtable,745hosttable,746usertable,739,742selectingdata,MyISAMtables,696selfkeywordstaticclassmembers,188sendmail_fromdirective,413mailfunction,411sendmail_pathdirectivemailfunction,412sequences,MySQLAUTO_INCREMENTattribute,714serializationunserialize_callback_funcdirective,34serialize_precisiondirective,PHP,34$_SERVERsuperglobalvariable,82postingdatabacktosamescript,352serverresourcesmanagingoverconsumptionof,39serversignatureexpose_phpdirective,547serversembeddedMySQLserver,629pingingserver,418server-sidecursors,MySQL,903ServerSignaturedirective,Apache,546disablingbroadcastofserversignature,39expose_phpdirective,547ServerTokensdirective,Apache,547servicesseeinternetservicesServicesRecord,DNS,403$_SESSIONsuperglobalvariable,86creating/deletingsessionvariables,455sessionfunctionssession_close,463session_decode,457session_destroy,454,463session_encode,456session_garbage_collect,463session_id,455session_open,463session_read,463session_register,456session_set_save_handler,463,468session_start,449,4531024INDEXsession_unregister,456session_unset,454,455session_write,463sessionhandling,469autologinexample,459–461automaticallyenablingsessions,449automatingURLrewriting,450choosingcookiesorURLrewriting,450configurationdirectives,448–453cookies,446creating/deletingsessionvariables,455customMySQL-basedsessionhandlers,464–469decodingsessiondata,457description,445–448destroyingsessions,454encodingsessiondata,456generatingrecentlyvieweddocuments,461howtheprocessworks,447managingobjectswithinsessions,450managingsessionstoragemedia,448retrievingandsettingSID,454settingcacheexpirationtimeforsession-enabledpages,453settingcachingdirectionsforsession-enabledpages,452–453settingsessioncookielifetime,451settingsessioncookievaliddomain,451settingsessioncookievalidURLpath,451–452settingsessionfilespath,449settingsessionlifetime,453settingsessionname,450startingsessions,453storingsessioninformation,448URLrewriting,447userdefinedsessionhandlers,462–469tyingintoPHPlogic,463validatingsessionsusingreferer,452sessionhandlingdirectivesauto_start,449,454cache_expire,453cache_limiter,452cookie_domain,451cookie_lifetime,451,459cookie_path,451gc_maxlifetime,453name,450referer_check,452save_handler,448save_path,449use_cookies,450use_trans_sid,450session_closefunction,463session_decodefunction,457session_destroyfunction,454,463session_encodefunction,456session_garbage_collectfunction,463session_idfunction,455session_openfunction,463session_readfunction,463session_registerfunction,456session_set_save_handlerfunction,463,468session_startfunction,449,453SESSION_STATUStable,726session_unregisterfunction,456session_unsetfunction,454SESSION_VARIABLEStable,726session_writefunction,463session-handlingsupportPHP4features,3SETdatatype,MySQL,714setfunction,173SETPASSWORDcommand,645SETstatement,MySQL,828setAttributemethod,PDO,805setBaseUrlmethodcreatingZendFrameworkfront-endcontroller,613setCancelTextmethod,Auth_HTTPclass,3791025INDEXsetCellAttributesmethod,884setClassmethod,SOAP,534setcookiefunction,84setDatemethod,DateTimeclass,346setlocalefunction,334–336,592,597,598–600localeparameter,335sortingarraysinanotherlanguage,145setPersistencemethod,SOAP,536setRowAttributesmethod,884settermethodscreatingcustomgettersandsetters,175setTimemethod,DateTimeclass,347settypefunction,71sharedmemoryprotocol,mysqlclient,675sharedserverhosting,51shellcommandsexecuting,301–302,308systemlevelprogramexecution,303–308shellsyntaxcomments,PHP,60SHELL,$_ENVsuperglobal,85shell_execfunction,308shiftleft(>)bitwiseoperator,94shorttags,57short_open_tagdirective,31,57shortcutassignmentoperators,90SHOWcommand,MySQL,723SHOWCREATEstatement,MySQL,843SHOWCREATEVIEWstatement,MySQL,873SHOWDATABASESstatement,MySQL,718SHOWDATABASESprivilege,753SHOWENGINESstatement,MySQL,705SHOWGRANTSFORstatement,MySQL,759showparametersectionfunction,Smarty,488SHOWSTATUScommand,mysqlclient,672SHOWSTATUSstatement,MySQL,841,842SHOWTABLEstatement,MySQL,722SHOWTABLEScommand,mysqlclient,665SHOWTRIGGERSstatement,MySQL,856SHOWVARIABLEScommand,mysqlclient,671SHOWVIEWprivilege,753Show_db_privcolumn,usertable,739,743show_sourcefunction,38Show_view_privcolumndbtable,746hosttable,747usertable,740,744shufflefunction,arrays,160shutdowncommands,mysqladminclient,677SHUTDOWNprivilege,753Shutdown_privcolumn,usertable,739,743SIDcookiesstoring,446persistenceusingURLrewriting,447retrievingandsetting,454sessionhandlingusingSID,446,447session_idfunction,455use_trans_siddirective,450signaturesdigitalsignatures,559ServerSignaturedirective,Apache,546silentoptionmysqlimportutility,948mysqlxyzclients,686SimpleXML,519–526functions,520–522loadingXMLdocument,520–522fromDOMdocument,522fromfile,521fromstring,522methods,523–526asXMLmethod,524attributesmethod,523childrenmethod,524xpathmethod,5251026INDEXparsingXMLdocument,523–526creatingXMLfromSimpleXMLobject,524informationaboutXMLelements,523learningaboutnodechildren,524usingXPathtoretrievenodeinformation,525simplexml_import_domfunction,522simplexml_load_filefunction,521simplexml_load_stringfunction,522singlequotesstringinterpolation,96single-columnnormalindexes,MySQL,911sizeatribute,$_FILESsuperglobal,84sizevariable,$_FILESarray,391size_limitparameter,ldap_searchfunction,431sizeoffunction,arrays,144skip-column-namesoption,mysqlclient,675skip-name-resolveoption,mysqlddaemon,734skip-name-resolveparameter,MySQL,657skip-networkingoption,mysqlddaemon,734skip-networkingparameter,MySQL,657skip-show-databaseoption,mysqlddaemon,734SMALLINTdatatype,MySQL,711Smartyclassinstantiating,477Smartytemplatingenginecache_lifetimeattribute,498caching,497–501creatingmultiplecachespertemplate,499is_cachedmethod,499performance,501cachingattribute,497cachingtemplates,474changingSmartydefaultdelimiters,496clashofsyntaxbetweenSmartyandCSS,495comments,480configurability,475configurationfiles,493–495CSSand,494referencingconfigurationvariables,494controlstructures,484–490else/elseifclauses,485creatingdesigntemplate,477,478creatingZendFrameworkwebsite,617displaymethod,479embeddingJavaScriptandCSSintotemplate,492embeddingPHPcodeintotemplate,492extensibility,475features,474functionscapitalize,480config_load,494count_words,481date_format,481default,482foreach,485foreachelse,487if,484include_php,493section,487sectionelse,490strip_tags,482truncate,483get_config_varsmethod,495hashmark,495includingtemplatesintocurrenttemplate,490index.
tpltemplateapplicationlogic,478insertingconstantlyupdateddata,491installing,475instantiatingSmartyclass,477introduction,474–475makingavailabletoexecutingscript,477outputtingdataintagswithoutinterpretation,492presentationallogic,474,479–4931027INDEXreferencingconfigurationvariables,495renderingSmartytemplate,473security,475statements,490–493fetch,491include,490insert,491literal,492php,492require,477storingconfigurationfilesandtemplates,476syntaxoftypicaltemplate,472templatecompilation,474usingCSSinconjunctionwith,495variablemodifiers,480–484$smarty.
configvariable,495SMARTY_DIRconstant,476SMTPdirective,mailfunction,411SMTPprotocolimplementationof,311smtp_portdirective,mailfunction,412SOA(StartofAuthorityRecord)recordtype,DNS,403SOAP,526–537clientandserverinteraction,536–537boxingclient,537boxingserver,536creatingSOAPclientgetFunctionsmethod,530getQuotefunction,531SoapClientconstructor,529–530creatingSOAPserver,531–536addFunctionmethod,533addingclassmethods,534exportingallfunctions,534getQuotefunction,533handlemethod,535setClassmethod,534setPersistencemethod,536SoapServerconstructor,533definition,527instantiatingSOAPclient,529–530PHP5'sSOAPextension,528–537retrievingexposedmethods,530–531SOAPmessages,527–528SOAP_PERSISTENCE_REQUESTmode,536SOAP_PERSISTENCE_SESSIONmode,536soap_versionparameterSoapClientconstructor,530SoapServerconstructor,533SoapClientclass,529SoapClientconstructor,529–530actorparameter,529compressionparameter,529creatingSoapClientobject,530exceptionsparameter,529locationparameter,529loginparameter,529optionsparameter,529passwordparameter,529proxy_hostparameter,529proxy_loginparameter,530proxy_passwordparameter,530proxy_portparameter,530soap_versionparameter,530traceparameter,530uriparameter,530wsdlparameter,529SoapServerconstructor,533actorparameter,533encodingparameter,533optionsparameter,533soap_versionparameter,533wsdlparameter,533socialsecuritynumbers(SSNs)Validate_USpackage,PEAR,275socketconnections,408–411socketfilesprotocol,mysqlclient,675socketoptionmysqlimportutility,948mysqlxyzclients,6851028INDEXsoftwareasaservice,505securityvulnerabilities,539Solarframework,606sortfunction,arrays,147sort_flagsparameter,arraysarsortfunction,149asortfunction,148ksortfunction,151rsortfunction,149sorsortfunction,147sortingldap_sortfunction,435tabularoutput,MySQL,890sorting_orderparameter,scandirfunction,300sourcecodehighlighting,37sourcecodeinstallationdownloadingApache,13downloadingPHP,14sourcecommand,mysqlclient,668sourceinstallationinstallingMySQLonLinux,640–642spacecharacterclass,235spatialextensions,MySQL4,629specialcharactersconvertingintoHTMLequivalents,255displayingHTMLcharacters),257insertingbackslashdelimiterbefore,244splitfunction,238filebasedauthentication,371splitifunction,239sprintfstatement,PHP,65SQLSECURITYcharacteristicstoredprocedures,MySQL,827SQLServerPDOsupporteddatabases,798sql.
safe_modedirective,545sql_regcasefunction,239SQL_SECURITYclauseviews,MySQL,871SQLite,567–590binarydata,585–587casesensitivity,571characteristics,567closingconnections,573command-lineinterface,569–570creatingaggregatefunctions,589–590creatingdatabase,571creatingSQLitefunction,587creatingtableinmemory,573databasesecurity,567handlingreturneddata,575helpoption,569indexesforresultsets,574installing,568library,571–590customizedfunctions,587–590licensing,568manipulatingresultsetpointer,582–585objectorientation,572openingconnections,571–573persistentconnections,572openingSQLitedatabase,571parsingresultsets,576–580passingoutputtofunctions,576PDOsupporteddatabases,798PHPbundledwith,570queryingdatabase,574–576renderingcodemorereadable,577retrievingresultsetdetails,580–582returningresultsetasassociativearray,576schemacommand,570support,5transactions,568sqliteoptionstoringsessioninformation,449sqlite.
assoc_casedirective,571,577sqlite_array_queryfunction,578SQLITE_ASSOCvaluedeterminingcaseofcharacters,577parsingqueryresults,576resultsetindexes,5741029INDEXSQLITE_BOTHvaluedeterminingcaseofcharacters,577parsingqueryresults,576,577resultsetindexes,574sqlite_changesfunction,582sqlite_closefunction,573sqlite_columnfunction,578sqlite_create_aggregatefunction,589sqlite_create_functionfunction,587sqlite_currentfunction,582sqlite_escape_stringfunction,586sqlite_fetch_arrayfunction,576–577consolidatingwithsqlite_queryfunction,578sqlite_fetch_column_typesfunction,585sqlite_fetch_singlefunction,579sqlite_fetch_stringfunction,579sqlite_field_namefunction,580sqlite_has_morefunction,583sqlite_last_insert_rowidfunction,576sqlite_nextfunction,583SQLITE_NUMvalueparsingqueryresults,576resultsetindexes,574sqlite_num_fieldsfunction,581sqlite_num_rowsfunction,581sqlite_openfunction,571,572,573sqlite_popenfunction,572sqlite_queryfunction,574consolidatingwithsqlite_fetch_arrayfunction,578creatingtableinmemory,573handlingreturneddata,575passingoutputtofunctions,576sqlite_rewindfunction,584sqlite_seekfunction,584sqlite_udf_decode_binaryfunction,588sqlite_udf_encode_binaryfunction,588sqlite_unbuffered_queryfunction,575,576SQLSTATEcodes,802SRV(ServicesRecord)recordtype,DNS,403SSL(SecureSocketsLayer)connectingusingSSL-enabledclient,764determininguser'sSSLrequirements,761effectofencryptiononperformance,765installingOpenSSLlibrary,761MySQL4,629REQUIRESSLoption,761securingconnectioninformation,mysqliextension,775startingSSL-enabledMySQLserver,764storingSSLoptionsinmy.
cnffile,764ssloptionmysqlclient,763mysqlimportutility,948ssl_ciphercolumn,usertable,740ssl_typecolumn,usertable,740ssl-caoption,mysqlclient,763ssl-capathoption,mysqlclient,763ssl-certoption,mysqlclient,763ssl-cipheroption,mysqlclient,763ssl-keyoption,mysqlclient,764ssnmethod,Validate_USpackage,275StandardConfigurationMySQLConfigurationWizard,644,645StartofAuthorityRecord,DNS,403startparametersectionfunction,Smarty,487STARTTRANSACTIONcommandconformingtoSQL-99syntax,930MySQLtransactionstips,933STARTINGBYoptionLOADDATAINFILEstatement,943start-slavecommand,mysqladminclient,678startupdisplay_startup_errorsdirective,216stateabbreviationsValidate_USpackage,PEAR,275statelessprotocol,445statementspreparedstatements,PDO,807–8101030INDEXstatements,Smartytemplatingengine,490–493seealsofunctions,Smartytemplatingenginefetch,491include,490insert,491literal,492php,492require,477staticclassmembersselfkeyword,188staticclassmembers,OOP,187–188staticfields/keyword/methods,187STATICkeyworddeclaringstaticvariables,79staticMyISAMoptimizingMyISAM,696staticvariablesvariablescope,PHP,79statisticss/statusoptions,mysqlclient,669STATISTICStable,726STATUS(SHOWSTATUS)statementstoredroutines,MySQL,841statuscommand,mysqladminclient,678statusoption,mysqlclient,669statusvariablesflush-statuscommand,mysqladminclient,677stepparameterrangefunction,arrays,132sectionfunction,Smarty,487step_funcparameter,sqlite_create_aggregatefunction,589stop-slavecommands,mysqladminclient,678stopwords,MySQLfulltextindexes,916reasonforignoring,917storageengines,MySQL,622,693–706ARCHIVE,703availabilityonservers,705BLACKHOLE,704convertingISAMtablestoMyISAMtables,705CSV,703EXAMPLE,704fasteststorageengine,706FEDERATED,701HEAP,693,699InnoDB,698MEMORY,699MERGE,700MyISAM,695–698PluggableStorageEngineAPI,630specifyingatcreationtime,706usingonWindows,705usingseveralinsamedatabase,706storedfunctionsseestoredroutines,MySQLstoredprocedures,MySQL,821accessprivilegesystem,738attributes,826characteristics,826COMMENT,827CONTAINSSQL,827DETERMINISTIC,827LANGUAGESQL,827MODIFIESSQLDATA,827NOSQL,827NOTDETERMINISTIC,827READSSQLDATA,827SQLSECURITY,827creating,824MySQL5.
0,629storedroutines,MySQL,819–847advantages,820BEGIN/ENDblock,828,829,832callingfromanotherroutine,840conditionalstatements,832–834conditions,8441031INDEXconsiderationsforusing,820creating,824–827creatingemployeebonusinterface,845declaringvariables,828DEFINERclause,825deleting,841described,819disadvantages,820ELSE/ELSEIFclauses,833executing,830generalreasonsforusing,819handlers,844implementing,821–845inputandreturnparameters,825integratingintoWebapplications,845–847iterativestatements,834–840managingstoredroutines,832modifying,841multistatementstoredroutines,830–840NOTFOUNDcondition,844privilegetables,822–824proctable,822procs_privtable,823retrievingmultiplerows,846settinginputandreturnparameters,825–826settingsecurityprivileges,825settingvariables,828–830statementsALTER,841CALL,830CASE,833CREATE,824DECLARE,828DELIMITER,830DROP,841IF-ELSEIF-ELSE,833ITERATE,834LEAVE,836LOOP,836REPEAT,838SET,828SHOWCREATE,843SHOWSTATUS,841WHILE,839viewingcreationsyntax,843viewingstatus,841str_ireplacefunction,265str_padfunction,270str_replacefunction,265ereg_replacefunctioncompared,238str_word_countfunction,272strcasecmpfunction,250strcmpfunction,249strcspnfunction,251strftimefunction,599strftimefunction,PHP,336–338formattingdates,481StrictModeinstallingMySQLonWindows,644stringdatatype,66MySQL,712–714typecasting,69typejuggling,70,71stringfunctions,248–260casemanipulationfunctions,252–254convertingnewlinecharactersintoHTML,254HTML/stringconversionfunctions,254–260stringcomparisonfunctions,249–252stringfunctions,listofarray_flip,258count_chars,271ereg,235–236ereg_replace,237–238eregi,236–237eregi_replace,238explode,261get_html_translation_table,258htmlentities,255htmlspecialchars,257implode,2621032INDEXltrim,269nl2br,254preg_match,243preg_match_all,243preg_quote,244preg_replace,245preg_replace_callback,246preg_split,247rtrim,269split,238spliti,239sql_regcase,239str_ireplace,265str_pad,270str_replace,265str_word_count,272strcasecmp,250strcmp,249strcspn,251strip_tags,259stripos,264strlen,249strpos,263strrpos,264strspn,251strstr,265strtok,260strtolower,252strtoupper,252strtr,259substr,266substr_count,267substr_replace,268trim,270ucfirst,253ucwords,254stringinterpolation,95doublequotes,95heredocsyntax,97singlequotes,96stringoperators,91stringparsing,9stringsback-referencingparenthesizedsubstrings,237calculatingdifferencebetween,251calculatingsimilaritybetween,251checkingvalidityof,237comparing,249–252case-insensitively,250case-sensitively,249convertingarraysinto,262convertingHTMLtoplaintext,259convertingspecialcharactersintoHTML,255convertingcharactersintobracketedexpressions,239convertingtoandfromHTML,254–260countingnumberofcharactersin,271countingnumberofwordsin,272countingoccurrencesofsubstring,267creatingstringreplacementfunction,246customizedcharacterconversion,259determininglengthof,249displayingspecialHTMLcharacters(&,",257dividingintoarrayofsubstrings,261dividingstringbasedondelimiters,260findingfirstoccurrenceofsubstringcase-insensitive,264case-sensitive,263findinglastoccurrenceofsubstring,264highlight.
stringdirective,PHP,38insertingbackslashdelimiterbeforespecialcharacters,244localizedformats,335manipulatingcaseofcharactersin,252–254capitalizingfirstletterofeachword,254capitalizingfirstletterofstring,253convertingstringtoalllowercase,252convertingstringtoalluppercase,252paddingstrings,2701033INDEXPerlregularexpressionmodifiers,240–241readingfileintostring,291removingHTMLandPHPtags,259removingmarkuptags,Smarty,482replacingalloccurrencesofsubstringscaseinsensitive,265casesensitive,265replacingalloccurrencesofpattern,245replacingpartofstring,268aftersubstring,265betweenoffsets,266searchingarrayforallmatchingelements,242searchingforpatternassigningoccurrencestoarray,243returningtrue/false,243splittingstringbasedoncase-insensitivepattern,239,247basedoncase-sensitivepattern,238tokenizingstringbasedonspecifiedcharacters,260translatingHTMLintotext,258translatingtextintoHTML,258trimmingcharactersfrombeginning,269frombeginningandend,270fromend,269truncatingstrings,Smarty,483typespecifierfor,64validatingstringswithPEAR:Validate,557writingstringtofile,297strip_tagsfunction,143sanitizinguserinput,556Smartytemplatingengine,482strip_tagsfunction,257,259striposfunction,264stripslashesfunction,43strlenfunction,249strposfunction,263strrposfunction,264strspnfunction,251strstrfunction,265strtokfunction,260strtolowerfunction,252strtotimefunction,599calculatingdates,340strtoupperfunction,252strtrfunction,259subclass,OOP,199subnetconverter,creating,420–422subqueries,MySQL4,629subqueries,MySQL,897databasemaintenancewith,901determiningexistencewith,899introduction,879performingcomparisonswith,899usingwithPHP,901substrfunction,266substr_countfunction,267substr_replacefunction,268substringsback-referencingparenthesizedsubstrings,237dividingstringintoarrayof,261subtraction(-)operator,90SUPERprivilege,753Super_privcolumn,usertable,740,743superglobalvariables,PHP$_COOKIE,84$_ENV,85$_FILES,84$_GET,83$_GLOBALS,85$_POST,83$_REQUEST,85$_SERVER,82$_SESSION,80–86Suraski,Zeev,2switchstatement,PHP,101SybasePDOsupporteddatabases,798symfonyframework,606syntaxfeatures,PHP6,61034INDEXsyntaxhighlightingcategoryPHPconfigurationdirectives,37–38syslogclosingconnectiontosystemlogger,219define_syslog_variablesfunction,218errormessagesin,217initializingPHP'sloggingfacility,218loggingerrorsin,216openingconnectiontosystemlogger,218prioritylevels,220sendingcustommessageto,219syslogfunction,219initializingconstantsfor,218messageparameter,220priorityparameter,220systemfunction,306systemlevelprogramexecution,303–308backtickoperator,307delimitinginput,304escapingshellmetacharacters,305executingoperatingsystemlevelapplication,305executingshellcommandwithbackticks,307executingshellcommands,308executingsystem-levelcommand,305outputtingexecutedcommand'sresults,306retrievingsystemcommandresults,306returningbinaryoutput,307sanitizinguserinput,303systemprogramssafe_mode_exec_dirdirective,543systemservicesMySQLsecurity,732system-levelcommands,301T\tescapesequence,96tfileaccessmode,288Toption,mysqlclient,669Tparameter,datefunction,327tparameter,datefunction,327,339tableattributesseedatatypeattributes,MySQLtablehandlers,MySQL,622tableindexingseeindexes,MySQLTABLE_CONSTRAINTStable,726Table_namecolumncolumns_privtable,749tables_privtable,748Table_privcolumn,tables_privtable,748TABLE_PRIVILEGEStable,727tableschangingtablestructure,724copying,722creatingtablefromdatabasedatawithHTML_Table,885creating,720creatingtablesconditionally,721creatingtemporarytables,722default-table-typeparameter,MySQL,655deleting,724description,693flush-tablescommand,mysqladminclient,677grantingmultipletable-levelprivileges,755grantingtable-levelprivileges,755INFORMATION_SCHEMA,725loadingtabledatawithPHP,950MySQLstorageengines,693–706partitioning,MySQL5.
1,631privilegeverificationprocess,738proctable,MySQLstoredroutines,822procs_privtable,MySQLstoredroutines,823refreshcommand,mysqladminclient,677retrievingtable'scolumntypes,585revokingtable-levelprivileges,757salestable,940sqlite_fetch_column_typesfunction,585TIMESTAMPdefinitions,708,709updatingtablesviaviews,8751035INDEXviewingavailabletables,722viewingtablestructure,723virtualtablesseeviews,MySQLTABLEStable,726tables_privtableaccesscontrol/authorization,736columns,tablelistingof,748MySQLaccessprivilegesystem,738,747User/Host/Dbtripletindbtable,745tableset,748tabulardateclassesCalendarpackage,PEAR,342tabularoutput,MySQL,879,890tabular_outputmethod,mysqliclass,887sortingqueryresults,890tagsallowable_tagsparameter,259removingmarkuptags,Smarty,482strip_tagsfunction,Smarty,482strippingHTMLandPHPtagsfrominput,294strippingtagsfromuserinput,556tarfiles,managementof,310tartoolinstallingMySQLonLinux,639,640,641TCPprotocolinstallingMySQLonWindows,644mysqlclient,675TCPsockets,managing,311technicianprofile,860teeoption,mysqlclient,669,675$template_dirclassmembermodifyingdirectorylocations,476templatespredefinedfunctiontemplates,115templatecompilation,Smarty,474templatesdirectorycreatingdesigntemplate,478installingSmarty,476templates_cdirectoryinstallingSmarty,476templatingengines,471–474benefitsof,472delimiters,472,473presentationallogicand,471renderingSmartytemplate,473separatingpresentationalfrombusinesslogic,472Smartytemplatingengine,474–501syntaxoftypicaltemplate,472TEMPORARYkeywordCREATETABLEstatement,MySQL,722TEMPORARYtableMySQLtriggersand,853TEMPTABLEalgorithm,MySQL,870TERMINATEDBYoptionLOADDATAINFILEstatement,943ternary(==)operator,93testingfacilitatingunittests,312userbandwidth,422–424TEXTdatatype,MySQL,713textfiles,errormessagesin,218textsearchingindexes,MySQL,908Text_Wiki,606textdomainfunction,593,597third-partysoftwarewebhostsupportfor,53thiskeywordaccessingprivatefields,171referringtofields,OOP,169staticfields,188threadsback_logparameter,MySQL,655flush-threadscommand,mysqladmin,677throwingexceptions,221tiersdatabaseabstractionlayers,7931036INDEXtimeseealsoDateTimeclassCalendarpackage,PEAR,341–345CoordinatedUniversalTime(UTC),324default_socket_timeoutdirective,47displayinglocalizeddateandtime,334–338formattingdatesandtimes,325–330gettimeofdayfunction,329localizedformats,335localizingtimes,598–600max_execution_timedirective,39,544max_input_timedirective,39modifymethod,DateTimeclass,347object-orientedenhancements,345–348modifyingtimeafterinstantiation,347settingtimeafterinstantiation,347outputtingamorpm,329outputtingcurrenttime,329setTimemethod,DateTimeclass,347standardizedformatfor,323strftimefunction,599strtotimefunction,599TIMEdatatype,MySQL,708timefunction,PHP,332timefunctions,PHPseedateandtimefunctions,PHPtime_limitparameter,ldap_searchfunction,431timeoutparameter,fsockopenfunction,409timeoutsPDO_ATTR_TIMEOUToption,800Timestampcolumncolumns_privtable,749procs_privtable,749tables_privtable,748TIMESTAMPdatatype,MySQL,708,709timestampsconvertingtouser-friendlyvalues,330creating,basedongivendateandtime,332–333determiningcurrenttimestamp,332retrievingfile'slastaccesstime,284retrievingfile'slastchangedtime,285retrievingfile'slastmodificationtime,286settingfilemodification/accesstimes,302Unixtimestamp,323Windowslimitation,331timezoneparameter,DateTimeclass,346TINYBLOBdatatype,MySQL,713TINYINTdatatype,MySQL,710,711TINYTEXTdatatype,MySQL,713titleattributeincludestatement,Smarty,490TLS(TransportLayerSecurity),428tmp_nameatribute,$_FILESsuperglobal,84,391TMPDIRenvironmentvariable,MySQL,722tokensServerTokensdirective,Apache,547topxmlwebsiteformstutorialsonline,350totalspace,diskpartition,282totalpagesvariablepagedoutput,MySQL,896touchfunction,302traceparameter,SoapClientconstructor,530traces,224track_errorsdirective,217track_varsconfigurationparameter,82transactions,925–937ACIDacronym,926beginningtransactions,933buildingtransactionalapplications,933–936DDLrollbacks,933description,694InnoDBtables,698,928–933creating,927verifyingtableavailability,927MyISAMtables,696MySQLtriggersand,853mysqli,768,790nesting,9331037INDEXnontransactionaltables,933PDO(PHPDataObjects),816SQLite,568closingconnection,574systemrequirements,927tipsforusing,933whentouse,933with-innodboption,927translatingwebsiteswithGettext,592–598TransportLayerSecurity(TLS)protocol,428traversingarrays,138–143TRIGGERprivilege,753Trigger_privcolumndbtable,746hosttable,747usertable,740,744TRIGGERStable,727triggers,MySQL,849–861ad/ai/auprefixesintriggername,856aftertriggers,851beforetriggerscompared,852namingconventions,856bd/bi/buprefixesintriggername,856beforetriggers,850aftertriggerscompared,852namingconventions,856caution:droppingdatabases,859CREATETRIGGERstatement,854creating,854–855deleting,859DROPTRIGGERstatement,859INFORMATION_SCHEMAdatabase,857integratingintoWebapplications,859–861limitationsusing,853modifying,859MySQL5.
0,630MySQLversionssupporting,853namingconventions,856reasonstouse,850SHOWTRIGGERScommand,856tasksbenefitingfrom,849uniqueness,853viewing,856–858trimfunction,270truncatefunction,Smarty,483trunkstable,InnoDB,929addingdata,930checkingdata,931trycatchblockcatchingmultipleexceptions,227multiplehandlerblocks,222PHP5features,5pseudocodefor,222ttlattributedns_get_recordreturning,405typeattribute$_FILESsuperglobal,84dns_get_recordreturning,405typecasting,PHP,69–70typecodes,datatypes,785typeconversion,PHP,88typehinting,181typeidentifierfunctions,PHP,72typejuggling,PHP,70–71typerelatedfunctions,PHP,71typespecifiersprintfstatement,64typevariable,$_FILESarray,391typesparameterbind_parammethod,mysqli,785types,PHPisidenticalto(===)operator,93TypicalinstallationinstallingMySQLonWindows,643typing,7U%utypespecifier,64Umodifier,Perlregularexpressions,240Uoption,mysqlclient,675uoption,mysqlxyzclients,685Uparameter,datefunction,327ucfirstfunction,2531038INDEXucwordsfunction,254UID/GIDcheckssafe_mode_include_dirdirective,PHP,35UNDEFINEDalgorithm,MySQL,870Unicode,591UNICODEattributeCHARdatatype,MySQL,712Unicodesupport,6uninstallcommand,PEAR,322uniqidfunction,384UNIQUEdatatypeattribute,MySQL,717uniqueindexes,MySQL,910–911uniqueness,MySQLindexes,908PRIMARYKEYattribute,716primarykeyindexes,908,909unittests,facilitating,312Unixepoch,324Unixtimestamp,323unserialize_callback_funcdirective,34unsetfunction,455UPDATEcommand,mysqliextension,777UPDATEprivilege,753UPDATEquery,MySQL,875Update_privcolumndbtable,745hosttable,746usertable,739,742updatesInnoDBtables,698PEAR,315sqlite_changesfunction,582upgradecommand,PEAR,320upgrade-allcommand,PEAR,321upgradingPEARpackages,320–322uploaderrormessages,PHP,393–394UPLOAD_ERR_XYZstatuscodeerrorvariable,$_FILESarray,393,394retrievingfilesuploadinfo.
usingPOST,85upload_max_filesizedirective,PHP,389upload_tmp_dirdirective,PHP,390uploadingfiles,387–399PEAR:HTTP_Uploadclass,395–399uploadingfilesviaHTTP,387–388uploadingfileswithPHP,388–395$_FILESsuperglobalarray,390–391determiningiffilewasuploaded,391fileuploaddirectives,389–390fileuploadfunctions,391–393is_uploaded_filefunction,391move_uploaded_filefunction,392permissions,395specifyingMIMEtypeoffile,391specifyingname/sizeoffile,391uploaderrormessages,393–394uppercharacterclass,235uppercaseconvertingstringtoalluppercase,252uriparameter,SoapClientconstructor,530URLrewritingautomating,450choosingcookiesor,450referer_checkdirective,452retrievingsessionname,447SIDpersistenceusing,447use_trans_siddirective,450webhostrestrictionsplacedon.
htaccessfile,53URLsarg_separator.
outputdirective,PHP,40globalscopeofvariables,41onetimeURLsone-timeURLgenerator,385recovering/resettingpasswords,383–386USAGEprivilege,753USEcommanddesignatingdatabase,MySQL,719mysqlclientconnectionoptions,664settingtargetdatabase,673usingmysqlininteractivemode,665use_cookiesdirective,4501039INDEXuse_include_pathparameterfopenfunction,288readfilefunction,296use_trans_siddirective,450usecvalue,gettimeofdayfunction,329usedspace,diskpartition,282useraccountsonserverMySQLsecurity,733userauthenticationauthenticatingagainstMySQLdatabase,374databasebasedauthentication,373HTTPauthentication,366–367IPaddressbasedauthentication,375PHPauthentication,367–380userloginadministration,380–386userbandwidth,testing,422–424Usercolumncolumns_privtable,749dbtable,745hosttable,746procs_privtable,749tables_privtable,748usertable,739,741usercommunity,627userdefinedsessionhandlers,462–469useridentificationuser@hostcombination,742userinputconvertingintoHTMLentities,555cross-sitescripting,551escapingshellarguments,554filedeletionrisk,550insecureuserinput,539sanitizinguserinput,550–558PEAR:Validatepackage,556–558strippingtagsfrom,556userloginadministration,380–386recovering/resettingpasswords,383–386testingpasswordguessability,380–383useroptionmysqlimportutility,948mysqlxyzclients,685userparameter,MySQL,657userprivilegecolumns,usertable,742userprivileges,MySQL,769userprofilesignore_user_abortdirective,PHP,37usertableauthentication/authorization,735Alter_privcolumn,743Alter_routine_privcolumn,744columns,tablelistingof,739Create_privcolumn,742Create_routine_privcolumn,744Create_tmp_table_privcolumn,743Create_user_privcolumn,744Create_view_privcolumn,744Delete_privcolumn,742Drop_privcolumn,742Event_privcolumn,744Execute_privcolumn,743File_privcolumn,743Grant_privcolumn,743Hostcolumn,740Index_privcolumn,743Insert_privcolumn,742Lock_tables_privcolumn,743max_connectionscolumn,759max_questionscolumn,759max_updatescolumn,760max_user_connectionscolumn,760MySQLaccessprivilegesystem,738–744Passwordcolumn,741Process_privcolumn,743References_privcolumn,743Reload_privcolumn,742Repl_client_privcolumn,744Repl_slave_privcolumn,744Select_privcolumn,7421040INDEXShow_db_privcolumn,743Show_view_privcolumn,744Shutdown_privcolumn,743Super_privcolumn,743Trigger_privcolumn,744Update_privcolumn,742Usercolumn,741userprivilegecolumns,742user_agentdirective,47user_dirdirective,46,545USER_PRIVILEGEStable,727userauthtableseeuserauthenticationUser/Host/Dbtriplet,dbtable,745userfile,390usersautologin,sessionhandling,459CREATEUSERcommand,758DROPUSERcommand,758GRANTcommand,754limitinguserresources,759–760MySQLaccessprivilegesystem,738MySQLuserandprivilegemanagement,750–759PHP_AUTH_USERauthenticationvariable,367resettinguserpassword,386REVOKEcommanddeleting,757safe-user-createoption,mysqlddaemon,734simultaneousconnectionsforusers,736usortfunction,arrays,151–153UTC(CoordinatedUniversalTime),324VV,voptions,mysqlxyzclients,686validatemethod,HTML_QuickFormclass,360Validatepackage,PEAR,556–558installing,556validatinge-mailaddresses,558validatingstrings,557Validate_USpackage,PEAR,274–276installing,274methods,275using,275–276validationValidatepackage,PEAR,556–558reasonsforusingtriggers,850validatingdates,325validatingdatesandtime,344validatinge-mailaddresses,558validatingforminput,358–362validatingstrings,557validationclassesCalendarpackage,PEAR,342validationrulesHTML_QuickForm,PEAR,359valuepassingargumentsbyvalue,115–116valueassignmentvariabledeclaration,PHP,75valuesassigningdefaultvalue,Smarty,482defaultargumentvalues,118–119returningvaluesfromfunctions,119–121varkeyword,OOP,170varparameterinserttag,Smarty,491VARCHARdatatype,MySQL,712BINARYattribute,712NATIONALattribute,712variablemodifiers,Smarty,480–484capitalizefunction,480count_wordsfunction,481date_formatfunction,481defaultfunction,482strip_tagsfunction,482truncatefunction,483variablesauthenticationvariables,PHP,367bindingvariables,mysqli,787Boolean,65configurationfiles,MySQL,6601041INDEXdeclaringvariables,MySQL,828destroyingvariables,8handlingexternalvariables,40PHP,73–86settingvariables,MySQL,828–830superglobalvariables,PHP,80–86testingifvariableisanarray,134variabledeclaration,PHP,74explicitdeclaration,74referenceassignment,75valueassignment,75variablescope,PHP,76–80functionparameters,77globalvariables,78localvariables,76staticvariables,79variablevariables,PHP,86variablescommand,mysqladminclient,678variables_orderconfigurationdirective,85variables_orderdirective,40vehiclestable,899verboseoptionmysqlimportutility,948mysqlxyzclients,686versioncommand,mysqladminclient,678versionoptionmysqlimportutility,948mysqlxyzclients,686versions,PHP,2–6PHP4,3–4PHP5,4–5PHP6,5–6verticaloption,mysqlclient,676view,MVC,604viewscreatingZendFrameworkwebsiteabout.
phtmlview,616creatingviews,615–617index.
phtmlview,615you.
phtmlview,616searchingwebwithZend_Service_Yahoocreatingviews,619–620viewsdirectorycreatingZendFrameworkfront-endcontroller,612VIEWStable,727views,MySQL,863–878advantagesofusing,864ALGORITHMattribute,869–870MERGEalgorithm,869TEMPTABLEalgorithm,870UNDEFINEDalgorithm,870creating,865–866customizingviewresults,867DEFINERclause,871deletingviews,875encapsulatingqueries,863executing,866–867passinginparameters,868incorporatingintoWebapplications,876–878insertingrowsviaviews,876modifyingreturnedcolumnnames,869modifyingviewdefinition,874MySQL5.
0,630SQL_SECURITYclause,871triggersand,853updatingtablesviaviews,875usingclauseswith,868usingfunctionswith,868versionsupportfor,865viewcolumnscontainingexpressions,876viewingviewdefinition,872DESCRIBEstatement,872INFORMATION_SCHEMAdatabase,873SHOWCREATEVIEWcommand,873WITHCHECKOPTIONclause,871virtualprivateserverhosting,51virtualtables,MySQLseeviews,MySQLvirtualization,51VistaenablingIISonVista,221042INDEXWW,wmetacharacters,Perlregularexpressions,241w,w+fileaccessmodes,288Woption,mysqlxyzclients,684W,wparameters,datefunction,327w3schoolswebsite,350wdayvalue,getdatefunction,331websearchingwebwithZend_Service_Yahoo,617–620webapplicationsincorporatingviewsinto,876–878integratingstoredroutines,845–847integratingtriggersinto,859–861webbrowsersoutputtingdatato,61–65webforms,349–355formstutorialsonline,350passingdatabetweenscripts,350passingformdatatofunction,352–353PEAR:HTML_QuickForm,355–363validatingformdatainfunctions,352workingwithmultivaluedformcomponents,354–355webframeworksCakePHPframework,605Solarframework,606symfonyframework,606webhostsupportfor,53ZendFramework,607–620webhostingvirtualization,51webhostingproviderschoosing,50–53databaseversionsofferedby,52dedicatedserverhosting,50PHPfileextensionssupportedby,52PHPsoftwareofferedbydefaultby,53PHPversionsofferedby,52questionsforprospectivewebhost,51–53restrictionsplacedonApache.
htaccessfilesby,53restrictionsplacedonPHP-enabledscriptsby,52sharedserverhosting,51specificwebframeworksupportoffered,53virtualprivateserverhosting,51webpagesdisplayingmodificationdate,338embeddingPHPcodeinwebpages,56–59webserversseealsoApache;IISreasonsforinstalling,11XAMPPastestenvironment,12WebServiceshighprofiledeployments,506MagpieRSS,510–519RealSimpleSyndication(RSS),506–519reasonsfor,504–506SimpleXML,519–526SOAP,526,537PHP5'sSOAPextension,528–537WebServicessupport,5websitescreatingusingZendframework,610–617internationalizing,592localizing,592translatingwebsiteswithGettext,592–598creatinglocalizationrepository,594creatingtranslationfiles,595–596generatingbinaryfiles,597settingdesiredlanguageinscripts,597–598translatingtext,596–597updatingwebsitescripts,592–594weekdayvalue,getdatefunction,331whenceparameter,fseekfunction,298WHEREclauseindexes,MySQL,9181043INDEXWHILEstatementMySQLDOWHILEequivalent,838storedroutines,MySQL,839whilestatement,PHP,102dowhilestatement,103whitespacecharactersPerlregularexpressionmodifier,240predefinedcharacterranges,235WikipediaprominentMySQLusers,632wildcardsGRANTcommand,MySQL,758WindowsdownloadingMySQLforWindows,636installingApacheandPHPon,17–20installingIISandPHPon,20–22installingMySQLasWindowsservice,650installingMySQLon,642–645reconfiguringPHPonWindowsafter,661installingPEARon,314startingMySQLon,647automatically,650–651stoppingMySQLon,648takingadvantageofstorageengineson,705uninstallingMySQLasWindowsservice,651WindowsinstallerdownloadingPHP,14WindowszippackagedownloadingPHP,14WITHCHECKOPTIONclauseviews,MySQL,871WITHQUERYEXPANSIONclause,MySQL,915with-mysqlioptionreconfiguringPHPonLinuxafterMySQLinstall,661wordscountingnumberofwordsinstring,272countingwordsinvariable,Smarty,481writingfiles,297WSDLcreatingSOAPserver,531wsdlparameterSoapClientconstructor,529SoapServerconstructor,533X%X,%xtypespecifiers,64\xescapesequence,96xmodifier,Perlregularexpressions,240Xoption,mysqlclient,671,676X509REQUIREX509option,761x509_issuercolumn,usertable,740x509_subjectcolumn,usertable,740XAMPP,12xdigitcharacterclass,235xgettextcommand,595XMLGNOMEXMLlibrary,529outputtingmysqlqueryresultsin,671SimpleXML,519–526SOAPdefinition,527XMLdocumentloading,520–522parsing,523–526xmloption,mysqlclient,671,676XMLsupport,PHP,5XML_Parserpackage,PEAR,312XOR(^)bitwiseoperator,94XORoperator,92xpathmethod,SimpleXML,525YYparameter,datefunction,327y2k_compliancedirective,PHP,32YahooprominentMySQLusers,632searchingwebwithZend_Service_Yahoo,617–620Yawp,606ydayvalue,getdatefunction,3311044INDEXYEARdatatype,MySQL,710yearvalue,getdatefunction,331you.
phtmlviewcreatingZendFrameworkviews,616creatingZendFrameworkwebsite,617ZZ,zparameters,datefunction,327zcontextparameter,fopenfunction,288ZendFramework,607–620components,608creatingwebsite,610–617creatingcontrollers,613–615creatingdirectorystructure,611–612creatingfront-endcontroller,612–613creatingviews,615–617downloadingandinstalling,609–610searchingwebwithZend_Service_Yahoo,617–620creatingcontroller,618–619creatingviews,619–620ZendGuardsecuringconnectioninformation,mysqli,775Zendscriptingengine,2ZendStudiochoosingcodeeditor,50zend.
ze1_compatibility_modedirective,31Zend_Amazoncomponent,608Zend_Cachecomponent,608Zend_Configcomponent,608Zend_Controllercomponent,608Zend_Dbcomponent,608Zend_Feedcomponent,608Zend_Filtercomponent,608Zend_Filter_Inputcomponent,608Zend_Gdatacomponent,608Zend_HTTP_Clientcomponent,608Zend_Jsoncomponent,608Zend_Logcomponent,608Zend_Mailcomponent,609Zend_Mimecomponent,609Zend_Pdfcomponent,609Zend_Search_Lucenecomponent,609Zend_Service_Amazoncomponent,609Zend_Service_Flickrcomponent,609Zend_Service_Yahoocomponent,609searchingwebwithZend_Service_Yahoo,617–620Zend_Viewcomponent,609Zend_XmlRpccomponent,609ZEROFILLdatatypeattribute,MySQL,717ZIPcodeusingValidate_USpackage,PEAR,275zipfilesmanagementof,310zlib.
output_compressiondirective,33zlib.
output_handlerdirective,33Zmievski,Andrei,474