max_connectionspathinfo

859IndexNumbersandsymbolscharactershtmlentitiesfunctiontranslating,527.
NETFrameworkSDK,5121045Accessdenied.
.
.
error,7242005UnknownMySQL.
.
.
error,7242013Lostconnection.
.
.
error,724401(Unauthorizedaccess)message,325,327,329404Filenotfounderror,321AA/A6/AAAArecordtypes,DNS,360abstractclasses,OOP,157,168–169abstractkeyword,169abstractmethods,146accentedlanguages,280AcceptPathInfodirective,316accesscontrol,MySQL,664Accessdeniedforuser.
.
.
error1045,724accessprivilegesystem,MySQL,663–675accessibility,webservices,475accessors,140,142ACIDacronym,831actorparameterSoapClientconstructor,503SoapServerconstructor,508addDaysmethod,Date/TimeLib.
,294addFunctionmethodcreatingSOAPserver,509addingdataldap_mod_addfunction,416addingentriesldap_addfunction,416addition(+)operator,71addl_headersparameter,mail(),368,369addl_paramsparameter,mail(),368addMonthsmethod,Date/TimeLib.
,295AddTypedirectiveinstallingApache/PHPonWindows,15installingPHPonLinux/Unix,13addWeeksmethod,Date/TimeLib.
,296addYearsmethod,Date/TimeLib.
,297ad/ai/auprefixestriggernaming,MySQL,772adlattribute,messages,379administratorssettingMySQLadministratorpassword,591affected_rowsmethod,mysqli_stmt,741aftertriggers,MySQL,768beforeoraftertriggers,769namingconventions,772AGAINSTfunction,MySQL,823aggregatefunctionscreating,SQLite,551–553sqlite_create_aggregatefunction,552aggregators,RSSMagpieRSS,483popularaggregators,476ALGORITHMAttribute,MySQL,784algorithmsMERGEalgorithm,785TEMPTABLEalgorithm,785UNDEFINEDalgorithm,785aliases,LDAP,419alignmentspecifier,printf,49ALLPRIVILEGESprivilege,677allow_call_time_pass_referencedirective,25allow_url_fopendirective,39requirestatement,88:alnum:characterclass,194:alpha:characterclass,194ALTERprivilege,677ALTERstatement,MySQL,761ALTERTABLE,656ALTERVIEW,788Alter_privcolumndbtable,671usertable,667,670Alter_routine_privcolumndbtable,672hosttable,673usertable,667,670always_populate_raw_post_datadirective,37amortizationTablefunction,97ampersand(&)convertingspecialcharactersintoHTML,212AND(&&)operator,73answeredattribute,messages,379,383ANYrecordtype,DNS,360Apachebuildprocessfeatures,11configuration,19documentation,downloading,19downloading,9860INDEXhidingconfigurationdetails,520–521htaccess(.
htaccess)file,21httpd.
conffile,21installingonLinux/Unix,11–13installingonWindows,13–16lookbackfeature,314configuring,315–316rewritefeature,315architecturestoredroutinesadvantages,746ARCHIVEstorageengine,MySQL,638Archive_Tarpackage,PEAR,260archivinginnodb_log_archive,835arg_separator.
input/outputdirectives,33argcregister_argc_argvdirective,34argumentsseealsoparametersdefaultvalues,94escapeshellargfunction,526optionalarguments,94passingbyreference,93passingbyvalue,92argvregister_argc_argvdirective,34arithmeticoperators,70arraydatatypes,PHP,52arrayfunctionsarray,107array_chunk,130array_combine,124array_count_values,117array_diff,128array_diff_assoc,128array_flip,116,213array_intersect,127array_intersect_assoc,127array_key_exists,112array_keys,111array_merge,125array_merge_recursive,125array_multisort,121array_pad,110array_pop,110array_push,109array_rand,129array_reverse,116array_search,112array_shift,110array_slice,125,484array_splice,126array_sum,130array_unique,118array_unshift,110array_values,112array_walk,114arsort,122asort,120count,116current,113each,113end,114in_array,111is_array,108key,113krsort,123ksort,122list,107natcasesort,120natsort,119next,114prev,114print_r,105range,108reset,113rsort,120shuffle,129sizeof,117sort,118usort,123arraypointers,105arraysaddingandremovingelements,109–111appendingarrays,125arraypointers,105associativekeys,104breakingarrayintosmallerarrays,130combiningarrayofkeystoarrayofvalues,124countingnumberofvaluesin,116countingoccurrencesofvaluesin,117creatingarrays,106–108described,104fetch_arraymethod,mysqli,730keys,104locatingarrayelements,111–112manipulatingarrays,124–129multidimensionalarrays,104mysql_fetch_arrayfunction,698mysqli_fetch_arraymethod,730numericalkeys,104NuSOAP,returninganarray,498outputting,105–106passingelementstouser-definedfunction,114printingarrays,105register_long_arraysdirective,34removingandreturningsectionofarray,126removingduplicatevalues,118returninganarraytotheclient,498returningarrayofkeys,111returningarrayofvalues,112returningarrayvalueatcurrentpointer,113returningarrayvaluebeforecurrentpointer,114returningcommonkey/valuepairsinarrays,127861INDEXreturningfirstelementofarray,110returningkeyelementatcurrentpointer,113returningkey/valuepairatcurrentpointer,113returningkey/valuepairsnotcommontoarrays,128returninglastelementofarray,110returninglastelementofarray,pointertoend,114returningnextarrayvaluebeyondcurrentponter,114returningrandomvalues,129returningsectionofarray,125returningvaluescommontoarrays,127returningvaluesnotcommontoarrays,128reversingkey/valueroles,116reversingorderofelements,116searchingarrays,111–112allelements,201forspecifickey,returningtrue/false,112forspecificvalue,returningkey,112forspecificvalue,returningtrue/false,111settingarraypointertoendofarray,114settingarraypointertostartofarray,113single-dimensionalarrays,104sizingarrays,116–117sortingarrays,118–124byASCIIvalue,118bykeysNOTvalues,122byuser-definedfunction,123caseinsensitive,120inanotherlanguage,118key/valueassociationsmaintained,120key/valueassociationsnotmaintained,119multidimensionalarrays,121naturalnumberordermaintained,119numerically,118orderingelementsfromlowesttohighestvalue,118reverse(descending)order,120reverseorder,bykeysNOTvalues,123reverseorder,key/valueassociationsmaintained,122sqlite_array_queryfunction,543sqlite_fetch_arrayfunction,541startingpositionzero,104testingifvariableisanarray,108–109traversing,112–116uniqueness,118workingwithmultivaluedformcomponents,307arsortarrayfunction,122ASCIIattributeCHARdatatype,MySQL,646asensitivecursors,MySQL,813asortarrayfunction,120ASPstyletagsdelimitingPHPcode,45asp_tagsdirective,23assignparameterinserttag,Smarty,463assignmentoperators,71assoc_casedirective,sqlite,538associativearrays,creating,106associativekeys,arrays,104associativityfetch_assocmethod,mysqli,732mysqli_fetch_assocmethod,731operators,69,70asXMLmethod,SimpleXML,489atomicity,831attachmentssendinge-mailattachments,371–372attributesldap_first_attributefunction,407ldap_get_attributesfunction,408ldap_next_attributefunction,408storedprocedures,750attributesmethod,SimpleXML,488attributesparameter,ldap_search(),404attributes_onlyparameter,ldap_search(),404auditinggenerallanguagefeatures,7reasonsforusingtriggers,768Authpackage,PEAR,261authenticatingagainstSamba,266Auth_HTTPclass,PEARauthenticatingagainstMySQL,335–336authenticationmethodologies,PHP,334–336installing,334–335validatingusercredentialswith,335authenticationseealsoprivilegesaccesscontrolstages,664description,663headerfunction,PHP,327HTTPauthentication,325–326imap_openfunction,374issetfunction,PHP,328PEARpackage,261PHPauthentication,326–336PHPauthenticationandIIS,327tracingconnectionrequest,665authenticationmethodologies,PHP,328–336Auth_HTTPclass,PEAR,334–336databasebasedauthentication,331–332filebasedauthentication,329–331hardcodedauthentication,328–329IPaddressbasedauthentication,333–334authenticationvariables,PHP,327–328determiningifproperlyset,328PHP_AUTH_PW,327PHP_AUTH_USER,327authentication_dynamictable,MyISAM,634authentication_statictable,MyISAM,634862INDEXauthenticationFile.
txtfilebasedauthentication,329locationforsecurity,329PHPscriptforparsing,330authorizationaccesscontrolstages,664description,663tracingconnectionrequest,665usertableand,666autologinexamplesessionhandling,437–439auto_append_filedirective,36auto_detect_line_endingsdirective,39AUTO_INCREMENTattribute,MySQL,648auto_prependconfigurationdirective,100auto_prepend_filedirective,36auto_startdirective,429autocommitmethod,mysqli,742AUTOCOMMITvariable,MySQL,839autoload(_autoload)function,155autoloadingobjects,OOP,155–156autoload(_autoload)function,155require_oncestatement,155--auto-rehashoption,mysqlclient,610B-boption,mysqlclient,611btypecode,datatypes,738back_logparameter,MySQL,599backgroundshighlight.
bgdirective,28backslash(\)character,MySQL,851backtickoperatorsystemlevelprogramexecution,257Bakken,Stig,259bandwidth,testing,397–398basedirectoryopen_basedirdirective,27baseexceptionclassseeexceptionclassbase_convertfunction,240baseclassclassinheritance,OOP,162basenamefunction,230bccaddressattribute,messages,379bcc[]attribute,messages,379bd/bi/buprefixestriggernaming,MySQL,772beforetriggers,MySQL,768beforeoraftertriggers,769namingconventions,772BEGINcommandconformingtoSQL-99syntax,837BEGIN/ENDblockstoredroutines,754beginTransactionmethod,PDO,572BerkeleyDB(BDB)storageengine,MySQL,637BIGINTdatatype,MySQL,645bin2hexfunction,530BINARYattribute,MySQL,648CHAR/VARCHARdatatypes,646binarydataNULLcharacter,550sqlite_udf_decode_binaryfunction,551sqlite_udf_encode_binaryfunction,551binarydata,SQLite,549–550binarydistributioninstallingMySQLonLinux,586–587binaryinstallationdownloadingApache,10downloadingPHP,11bind_parammethod,mysqli_stmt,738bind_resultmethod,mysqli_stmt,740bindColumnmethod,PDO,571bindingldap_bindfunction,402ldap_unbindfunction,403parameters,mysqli,738preparedstatements,735results,mysqli,740bindParammethod,PDO,564,565,566bitwiseoperators,74BLACKHOLEstorageengine,MySQL,640BLOBdatatype,MySQL,647blockfiletype,232body,messages,386imap_fetchbodyfunction,385BOOL(BOOLEAN)datatype,MySQL,645Booleandatatype,PHP,50Booleanfull-textsearches,MySQL,824operators,825boundcolumnssetting,PDO,571–572boundparameters/resultspreparedstatements,735boxingclient/serverSOAPclientandserverinteraction,511brackets([])regularexpressions,193breadcrumbtrailscreatingfromstaticdata,318–319creatingfromtabledata,319–321navigationalcues,317–321navigationaltrailillustrated,317breakstatement,PHP,85B-treeindexes,636bufferedresultsets,729bufferinginnodb_buffer_pool_size,834innodb_log_buffer_size,835key_buffer_sizeparameter,600net_buffer_lengthparameter,601output_bufferingdirective,23read_buffer_sizeparameter,601sqlite_unbuffered_queryfunction,541863INDEXbusinesslogicseparatingpresentationallogicfrom,448bytesattribute,messages,382C-Coption,mysqlclient,609,610C#C#SOAPclient,513usingC#clientwithPHPWebService,512–514CA(CertificateAuthority)--ssl-caoption,685--ssl-capathoption,685REQUIREISSUERoption,684REQUIREX509option,684cachedirectoryinstallingSmarty,451cache_lifetime($cache_lifetime)attributecachingwithSmarty,468cachingcache_expiredirective,431cache_limiterdirective,431compilationcompared,468determininghowsessionpagesarecached,431feeds,MagpieRSS,485pagecaching,468querycaching,MySQL4,575,578Smartytemplatingengine,450$cache_lifetimeattribute,468–471creatingmultiplecachespertemplate,470is_cachedmethod,469table_cacheparameter,601thread_cache_sizeparameter,602calculate_bonusstoredfunction,764Calendarpackage,PEAR,285–288classes,286creatingmonthlycalendar,286–288dateandtimeclasses,286decoratorclasses,286installing,285isValidmethod,288tabulardateclasses,286validatingdatesandtimes,288validationclasses,286CALLstatementexecutingstoredroutines,753callbackhandlersserialize_handlerdirective,430capabilitystoredroutinesdisadvantages,746capitalizefunctionSmartytemplatingengine,454CASCADEkeyword,MySQL,788WITHCHECKOPTIONclause,786cascadingtriggers,MySQL,775–776casemanipulatingstringcase,208–209casesensitive/insensitivefunctionsseestringfunction'sactionsCASEstatementstoredroutines,755case-insensitivesearchPerlregularexpressionmodifier,199casingPDO_ATTR_CASEattribute,560casting,type,54ccaddressattribute,messages,379cc[]attribute,messages,380c-clientlibrary,373ceilfunction,MySQL,806certificates--ssl-certoption,685REQUIRESUBJECToption,684CHARdatatype,MySQL,646,646charfiletype,232charactercasingPDO_ATTR_CASEattribute,560characterclassespredefinedcharacterranges,194characterencodingseealsoencodingldap_8859_to_t61function,420ldap_t61_to_8859function,421characterentityreferences,210charactersets,211default_charsetdirective,36CHARACTER_SETStable,657characteristicsstoredprocedures,750characterscountsnumberofcharactersinstring,224htmlentitiesfunction,527localizedformats,280--checkoption,myisamchkclient,623checkboxesworkingwithmultivaluedformcomponents,307checkdatefunction,PHP,272checkdnsrrfunction,360–361chgrpfunction,240childclass,OOP,162childrenmethod,SimpleXML,489chownfunction,239ciphers--ssl-cipheroption,685REQUIRECIPHERoption,684classconstants,143classinheritance,OOP,162childclass(subclass),162constructorsandinheritance,164–165extendskeyword,162parentclass(baseclass),162classinstantiation,136classlibrarieshelperfunctions,153–155864INDEXclassmanagementautoload(_autoload)function,155class_existshelperfunction,153classes,135seealsoobjectsassigningdatatoclassfield,140characteristicsandbehaviors,136checkingifclassexists,153classconstants,143disable_classesdirective,27,519generalizedclasscreationsyntax,136gettingfieldsofclass,154gettinglistofdefinedclasses,154gettingmethodsofclass,154gettingnameofclass,153gettingparentclass,154objectsandclasses,136ReflectionClassclass,170retrievingaclassvariable,142staticclassmembers,152–153Clienterrorfaultstringattribute,NuSOAP,500clientsmysql_get_client_infofunction,718PDO_ATTR_CLIENT_VERSIONattribute,561client-sidecursors,MySQL,813clonekeyword,158clonemethod,160cloning,OOP,158–161closemethod,mysqli,726closemethod,mysqli_stmt,737CLOSEstatement,MySQLclosingcursors,815closedirfunction,251closelogfunction,182closingconnectionsimap_closefunction,375closingfiles,244CNAME(CanonicalNameRecord),DNS,360:cntrl:characterclass,194codecodereuse,259getCodemethod,exceptionclass,186codingconsistency,PDO,557COLLATION_CHARACTER_SET_APPLICABILITYtable,657COLLATIONStable,657columnoverviewcolumns_privtable,674dbtable,671hosttable,672procs_privtable,674tables_privtable,673usertable,666Column_namecolumncolumns_privtable,674Column_privcolumncolumns_privtable,674tables_privtable,673,674COLUMN_PRIVILEGEStable,657columnCountmethod,PDO,568--column-namesoption,mysqlclient,610columnsgrantingcolumn-levelprivileges,679KEY_COLUMN_USAGEtable,657privilegeverificationprocess,666revokingcolumn-levelprivileges,680settingboundcolumns,PDO,571–572sqlite_columnfunction,543sqlite_fetch_column_typesfunction,548sqlite_fetch_singlefunction,544tableattributesmodifyingbehaviour,631,648–651--columnsoption,mysqlimport,853COLUMNStable,657columns_privtableaccesscontrolstages,664columnoverview,674MySQLaccessprivilegesystem,674privilegeverificationprocess,666columnset,673COM/DCOMsupport,3commaseparatedvalue(CSV)files,246commandlineoptionsPEARpackageforreading,260commandsescapeshellcmdfunction,527COMMENTcharacteristicstoredprocedures,751comments,46–47highlight.
commentdirective,28multiplelineCsyntax,46php.
inifile,21shellsyntax,46singlelineC++syntax,46Smartytemplatingengine,454commitmethod,mysqli,742commitmethod,PDO,572PDO_ATTR_AUTOCOMMITattribute,560commitsdatabasetransactions,831InnoDBtablehandlerexample,838,839innodb_flush_log_at_trx_commit,835comparingvaluesldap_comparefunction,411comparisonoperators,74performingcomparisonswithsubqueries,809compatibilityzend.
ze1_compatibility_modedirective,22CompatibleRegularExpressions(PCRE)library,3compilationcachingcompared,468865INDEXcompilerflagsinstallingMySQLonLinux,588CompleteinstallationinstallingMySQLonWindows,589composingmessagesimap_mail_composefunction,386--compressoption,mysqlclient,609,610mysqlimportutility,854compressedMyISAM,635compressionzlib.
output_compressiondirective,24compressionhandlerfunction,24compressionparameterSoapClientconstructor,503concatenation(.
)operator,71CONCURRENToptionLOADDATAINFILEstatement,850conditionalstatements,MySQL,755conditionalstatements,PHP,79–81alternativesyntax,80elsestatement,80ifstatement,79ifelsestatement,80switchstatement,81conditionsstoredroutines,764config_loadfunctioncreatingSmartyconfigurationfiles,465configsdirectoryinstallingSmarty,451configurationdirectives,177–180auto_start,429cache_expire,431cache_limiter,431cookie_domain,429cookie_lifetime,429cookie_path,429display_errors,179display_startup_errors,179entropy_file,430entropy_length,431error_log,180error_reporting,178force_extra_parameters,368gc_divisor,430gc_maxlifetime,432gc_probability,430hash_bits_per_character,432hash_function,431ignore_repeated_errors,180ignore_repeated_source,180log_errors,179log_errors_max_len,180mailfunction,367namedirective,429referer_check,430save_handler,427save_path,428sendmail_from,368sendmail_path,368serialize_handler,430sessionhandling,427–432SMTPdirective,367smtp_port,368track_errors,180url_rewriter.
tags,432use_cookies,428use_only_cookies,428use_trans_sid,431configurationdirectives,PHPseePHPconfigurationdirectivesconfigurationfilesinstallingSmarty,451my.
cnffileMySQL,602–604Smartytemplatingengine,465–466referencingconfigurationvariables,466configurationoptionsLDAP,418ldap_get_optionfunction,420ldap_set_optionfunction,420reasonsforMySQLpopularity,575configurationtemplates,MySQL,603CONFIGURATION-FLAGSinstallingMySQLonLinux,588configurationsconfiguringPHPsecurely,516–520changingdocumentextension,522configurationparameters,518–520expose_phpdirective,521hidingconfigurationdetails,520–522safemode,516–518stoppingphpinfocalls,522MySQL,596–604ConfigurationWizard,590my.
cnfconfigurationfile,602–604parameters,597–602PDO(PHPDataObjects),558phpinfofunction,522configurecommand,PHP,18configureWSDLmethod,499connectmethod,mysqli,721,722connectionauthenticationseeauthenticationconnectionoptionsmysqlclients,608connectionsback_logparameter,MySQL,599closing,SQLite,539imap_closefunction,375imap_openfunction,374ldap_connectfunction,401ldap_start_tlsfunction,402max_connectionsparameter,682max_connectionsparameter,MySQL,601866INDEXmax_user_connectionscolumn,682mysqliextension,721–722closingMySQLconnection,725–726connectionerrorreporting,722–725openingconnectionbutnotmailbox,374opening,SQLite,538–539PDO_ATTR_CONNECTION_STATUSattribute,561persistentconnections,692secureMySQLconnections,683–687simultaneousconnectionsforusers,664socketconnections,establishing,365–367sqlite_closefunction,540sqlite_openfunction,538tracingconnectionrequest,664connections,MySQLextensionclosing,692establishing,691usingopenconnectionsfirst,692mysql_closefunction,692mysql_connectfunction,691mysql_pconnectfunction,692securingconnectioninformation,693storingconnectioninformation,693consistencydatabasetransactions,831storedroutinesadvantages,746Console_Getoptpackage,PEAR,260runninginfocommandfor,265constants,OOP,143constants,PHP,68constraintsTABLE_CONSTRAINTStable,657constructorsdeclarationsyntax,148defaultexceptionconstructor,185inheritanceand,164–165invokingparentconstructors,150invokingunrelatedconstructors,150OOP,148–151overloadedconstructor,185overloading,151PHP4,148containerscontainernotmailbox,376CONTAINSSQLcharacteristic,751contextsstreamwrappers,391stream_context_createfunction,391continuestatement,PHP,86controlstructures,PHP,78–89conditionalstatements,79–81executioncontrolstatements,78–79fileinclusionstatements,86–89loopingstatements,81–86controlstructures,Smarty,457–462COOKIE($_COOKIE)superglobalvariable,66cookiesallowing/restrictingURLrewriting,428changingcookiename,429cookie_domaindirective,429cookie_lifetimedirective,429cookie_pathdirective,429cross-sitescripting,525namedirective,429retrievingsessionname,427sessionhandling,426storingsessioninformation,428use_cookiesdirective,428use_only_cookiesdirective,428CoordinatedUniversalTime,271copyingmessagesimap_mail_copyfunction,389corporate_mysqliclass,801countarrayfunction,116count_charsfunction,224count_wordsfunction,Smarty,455CrackLibextension,PHPavoidingeasilyguessablepasswords,339cracklib_dict.
pwddictionary,341installation,340minimumpasswordrequirements,339PECLwebsite,340using,340–341usingdictionaries,341cracklib_dict.
pwddictionaryCrackLibextension,PHP,341craigslistprominentMySQLusers,579crashrecoveryInnoDBtables,633CREATE(SHOWCREATE)statement,763createcommand,mysqladminclient,619CREATEDATABASEcommand,MySQL,652CREATEprivilege,677CREATETABLEstatement,MySQL,653,654CREATETEMPORARYTABLESprivilege,677CREATETRIGGERstatement,771,772CREATEUSERcommand,MySQL,675CREATEVIEWprivilege,677CREATEVIEWstatement,MySQL,781create_crumbsfunctioncreatingbreadcrumbsfromtabledata,320creatingbreadcrumbsfromstaticdata,318,319create_dropdownfunction,702autoselectingformsdata,310generatingformswithPHP,308Create_privcolumndbtable,671hosttable,672usertable,667,669867INDEXCreate_routine_privcolumndbtable,672hosttable,673usertable,667,670Create_tmp_table_privcolumndbtable,671hosttable,672usertable,667,670Create_user_privcolumnusertable,667,670Create_view_privcolumndbtable,671hosttable,672usertable,667,670credentialsldap_bindfunction,402,403crontabusingmysqlinbatchmode,616cross-sitescripting,524cryptTypeelementAuth_HTTPclass,PEAR,336CSS(CascadingStyleSheets)literaltag,Smarty,464Smartyconfigurationfiles,465tweakingtablestyleswithHTML_Table,797usingwithSmartytemplatingengine,467–468CSVstorageengine,MySQL,639curlybracketsyntaxchangeinPHP5,192currencylocalizedformats,280currentarrayfunction,113currentpagevariable,MySQL,807cursor_offsetparameterfetchmethod,PDO,569cursor_orientationparameterfetchmethod,PDO,568cursors,MySQL,812–815asensitivecursors,813client-sidecursors,813closing,815creating,813forward-onlycursors,813insensitivecursors,813introduction,793opening,813read-onlycursors,813server-sidecursors,813using,813usingwithPHP,815customerrorhandlersnavigationalcues,321–323CustominstallationinstallingMySQLonWindows,589Cygwin,430D-Doption,mysqlclient,611Dparameter,numericdatatypesdigitsfollowingdecimalpoint,645dtypecode,datatypes,738daemonsstartingandstoppingMySQL,592–593datadeletingfromdatabase,704–705delimiting,846exporting,846–849hidingsensitivedata,522–523importing,850–857insertingintodatabase,699–701modifyingindatabase,701–703sanitizinguserdata,524–528dataencryption,528–532MCrypt,531mcrypt_decryptfunction,532mcrypt_encryptfunction,531md5function,529mhashfunction,529,530PHP'sencryptionfunctions,528datahandlingdeletingLDAPdata,417insertingLDAPdata,415ldap_addfunction,416ldap_deletefunction,418ldap_mod_addfunction,416ldap_mod_delfunction,418ldap_modifyfunction,417ldap_renamefunction,417PHPdirectives,33–37streams,390–393updatingLDAPdata,417datamanagement,MySQL,574dataretrieval,PDO,567–571DataSourceName(DSN),336datatypes,50–57array,52Boolean,50compounddatatypes,52floatingpointnumbers,51gettypefunction,57integer,51null,54object,53precisiondirective,23resource,53settypefunction,56string,51typecasting,54typecodes,738typeidentifierfunctions,57typejuggling,55typerelatedfunctions,56868INDEXdatabaseabstractionlayers,PDO,555,556–572databasebasedauthentication,PHP,331–332loginpairandIPaddress,333MySQLtable,332--databaseoption,mysqlclient,611databasesupport,PDO,558databasetransactionsseetransactionsdatabasesapplicationsaccessing,555changingtablestructure,656copyingtables,654creating,652creatingtables,653creatingtemporarytables,654deleting,652deletingtables,656designatingforuse,MySQL,652indexes,817–826migratingbetween,260MySQLstorageengines,631–641mysql_db_namefunction,706mysql_list_dbsfunction,706mysql_select_dbfunction,694selectingdatabase,mysqliextension,725transactions,831–843usingmultiplestorageengines,641view_db_propertiesfunction,712viewingdatabaseproperties,MySQLextension,712viewing,651viewingavailabletables,655viewingtablestructure,655datadirparameter,MySQL,599datatypeattributes,MySQL,648–651AUTO_INCREMENT,648BINARY,648DEFAULT,648INDEX,648NATIONAL,649NOTNULL,649NULL,649PRIMARYKEY,649UNIQUE,650ZEROFILL,651datatypes,MySQL,642–647dateandtimedatatypes,642–643DATE,642DATETIME,642invalidvalueinsertedinto,643nonalphanumericdelimiters,642TIME,643TIMESTAMP,643YEAR,644numericdatatypes,644–646BIGINT,645BOOL(BOOLEAN),645constrainingmaximumdisplaysize,645DECIMAL,645digitsfollowingdecimalpoint,645DOUBLE,645FLOAT,646INT,645MEDIUMINT,645SMALLINT,645TINYINT,645stringdatatypes,646–647BLOB,647CHAR,646ENUM,647LONGBLOB,646LONGTEXT,647MEDIUMBLOB,647MEDIUMTEXT,647SET,647TEXT,647TINYBLOB,647TINYTEXT,647VARCHAR,646Date(DateandTimeLibrary),PHP5.
1,288–301accessors(getters),290cautionusing,289Dateconstructor,289datemanipulationcapabilities,294methodsaddDays,294addMonths,295addWeeks,296addYears,297date,290getArray,291getDay,291getDayOfYear,298getISOWeekOfYear,299getJulian,292getMonth,292getWeekday,298getWeekOfYear,299getYear,293isLeap,293isValid,294setDay,291setDMY,290setFirstDow,300setJulian,292setLastDow,301setMonth,292setToLastMonthDay,300setToWeekday,298setYear,293subDays,294subMonths,295subWeeks,296subYears,297869INDEXmutators(setters),290usinginconjunctionwithearlierversions,289validators,293dateandtimedatatypes,MySQL,642invalidvalueinsertedinto,643nonalphanumericdelimiters,642dateandtimefunctions,PHP,272–278calculatingdates,284checkdate,272date,272–275determiningdaysincurrentmonth,283displayinglocalizeddateandtime,279–282displayingwebpagemodificationdate,283getdate,275getlastmod,283gettimeofday,276mktime,277setlocale,279strftime,281–282strtotime,284time,278dateattribute,messages,380,383dateclassesCalendarpackage,PEAR,286DATEdatatype,MySQL,642datefunction,PHP,272–275determiningdaysincurrentmonth,283formatparameters,273datemethod,Date/TimeLib.
,290date_formatfunction,Smarty,455datesCalendarpackage,PEAR,285–288dateandtimefunctions,PHPseedateandtimefunctions,PHPlocalizedformats,280priortoUnixepoch,272standardizingformatfor,271DATETIMEdatatype,MySQL,642Dbcolumncolumns_privtable,674dbtable,671hosttable,672procs_privtable,674tables_privtable,673DBdatabaseabstractionlayer,556DBpackage,PEAR,260dbtableaccesscontrolstages,664columnoverview,671MySQLaccessprivilegesystem,671privilegeverificationprocess,665$dbloginarrayAuth_HTTPclass,PEAR,336DDLstatementsMySQLtransactionstips,840--debugoption,mysqlimport,854Debugversion,MySQL,583debug_flagproperty,NuSOAP,501debug_strproperty,NuSOAP,502debugginggetLastRequestmethod,SOAP,505getLastResponsemethod,SOAP,505mysqliextensionenhancements,719NuSOAP,501DECIMALdatatype,MySQL,645DECLAREstatement,751creatingcursors,813declarestatement,PHP,78declaringvariables,PHP,58–60decodingsession_decodefunction,436sqlite_udf_decode_binaryfunction,551decoratorclassesCalendarpackage,PEAR,286decrement(--)operator,72defaultargumentvalues,94DEFAULTattribute,MySQL,648defaultexceptionconstructorbaseexceptionclass,185defaultfunction,Smarty,456default_charsetdirective,36default_mimetypedirective,36default_socket_timeoutdirective,39--default-character-setoption,mysqlclient,611defaultshighlight.
defaultdirective,28--defaults-extra-fileoption,mysqlclient,609--defaults-fileoption,mysqlclient,609default-table-typeparameter,MySQL,600definefunction,68define_syslog_variablesdirective,40errorlogging,181DEFINERsettingSQLSECURITYcharacteristic,751deleteoption,mysqlimport,854DELETEprivilege,677Delete_privcolumndbtable,671hosttable,672usertable,667,669deletedattribute,messages,380,383deletingdatafromdatabase,704–705deletingentriesldap_deletefunction,418deletingvaluesldap_mod_delfunction,418DELIMITERstatementexecutingstoredroutines,754delimitersyntaxasp_tagsdirective,23delimiterschoosinginExcel,849importingandexportingdata,846templatingengines,448870INDEXdelimitingPHPcode,43–46ASPstyletags45defaultsyntax()operator,74groupIDssafe_mode_giddirective,517groupschanginggroupmembershipoffile,240innodb_log_files_in_group,835innodb_log_group_home_dir,835retrievinggroupIDoffileowner,240H-Hoption,mysqlclient,611,618-hoption,mysqlclient,608,611handlemethodcreatingSOAPserver,509handlersstoredroutines,764handlesresourcedatatype,PHP,53handlingerrorsseeerrorhandlinghardcodedauthentication,PHP,328–329hashmarkreferencingconfigurationvariables,Smarty,466hash_bits_per_characterdirective,432hash_functiondirective,431hashedindexes,636hashingmhashfunction,529headerfunctionauthentication,PHP,327877INDEXheadersseealsomessageheadersauto_prepend_filedirective,36output_bufferingdirective,24headlineslimitingnumberdisplayed,MagpieRSS,484HEAPstorageengine,MySQL,631,635--helpoption,mysqlclient,609--helpoption,mysqlimport,854helpoption,SQLite,536helperfunctions,153–155class_exists,153get_class,153get_class_methods,154get_class_vars,154get_declared_classes,154get_object_vars,154get_parent_class,154interface_exists,154is_a,155is_subclass_of,155method_exists,155MySQLextension,PHP,715–718heredocsyntax,77hexadecimalcharacterspredefinedcharacterranges,195Heyes,Richard,371highlight.
bgdirective,28highlight.
commentdirective,28highlight.
defaultdirective,28highlight.
htmldirective,28highlight.
keyworddirective,28highlight.
stringdirective,28historyofPHP,1–4HMAC(HashedMessageAuthenticationCode),531hostattribute,messages,379Hostcolumncolumns_privtable,674dbtable,671hosttable,672procs_privtable,674tables_privtable,673usertable,666,668--hostoption,mysqlclient,608,611--hostoption,mysqlimport,854hosttableaccesscontrolstages,664columnoverview,672MySQLaccessprivilegesystem,672privilegeverificationprocess,665HOSTNAME,$_ENVsuperglobal,67hostnamesprivilegeverificationprocess,665skip-name-resolveparameter,MySQL,601hostsmysql_get_host_infofunction,717.
htaccessfile,Apache,21HTMLconvertingintoplaintext,214convertingplaintextinto,210–213highlight.
htmldirective,28outputtingmysqlqueryresultsin,618sendingHTMLformattede-mail,370–371HTMLformscreating/rendering/validating,261HTMLMimeMail5sendinge-mailattachments,371--htmloption,mysqlclient,611,618HTMLtagsstrip_tagsfunction,528html_errorsdirective,32HTML_QuickFormpackage,PEAR,261HTML_TablecreatingtabularoutputwithPEAR,794–802creatingmorereadablerowoutput,797creatingsimpletable,795creatingtablefromdatabasedata,798–799generalizingoutputprocess,799–802installing,795tweakingtablestyleswithCSSand,797HTMLDOC,254htmlentitiesfunctionsanitizinguserdata,527stringconversion,210htmlgoodieswebsiteformstutorialsonline,304htmlspecialcharsfunction,211HTTPfileuploads,345–346HTTP404Filenotfoundmessagecreatingcustomerrorhandlers,321HTTPauthentication,325–326safe_moderestrictions,517HTTPproxy,NuSOAP,493HTTPsessionhandling,425–446seealsosessionhandlingPHP4features,3HTTP_AUTHORIZATIONvariablePHPauthenticationandIIS,327HTTP_REFERER,$_SERVERsuperglobal,65http_response_codeparameter,headerfunctionauthentication,PHP,327HTTP_Uploadclass,PEARfileuploads,355–357installing,355languages(foreign)supported,357movinguploadedfiletofinaldestination,356–357retrievinginformationaboutuploadedfiles,355–356retrievingvalueofsingleproperty,356uploadingmultiplefiles,357HTTP_USER_AGENT,$_SERVERsuperglobal,65878INDEXhttpd.
conffile,Apache,21denyingaccesstosomeextensions,523installingApache/PHPonWindows,15installingPHPonLinux/Unix,13HTTPSencryptionusingMySQLandHTTPS,687Hutteman,Luke,477I-ioption,myisamchkclient,623itypecode,datatypes,738IBMDB2PDOsupporteddatabases,558idattribute,messages,382IDENTIFIEDBYclause,GRANTcommand,681identifiers,PHP,57–58IFEXISTSkeywords,MySQL,788IFNOTEXISTSclauseCREATETABLEstatement,MySQL,654ifstatement,Smarty,457ifstatement,PHP,79ifelsestatement,PHP,80IF-ELSEIF-ELSEstatementstoredroutines,755ifidattribute,messages,382--ignoreoptions,mysqlimport,854IGNOREoptionLOADDATAINFILEstatement,851ignore_repeated_errorsdirective,31,180ignore_repeated_sourcedirective,31,180ignore_user_abortdirective,28IISPHPauthenticationandIIS,327IMAP(InternetMessageAccessProtocol),372–389composingmessages,386establishingandclosingconnections,375mailboxadministration,388–389mailboxesandmessages,375–378messageadministration,389NNTPprotocol,372openingandclosingconnections,374POP3protocol,372purposeandadvantages,372requirements,373–374retrievingmessages,378–386sendingmessages,387IMAPextension,PHP,18imap_closefunction,375imap_createmailboxfunction,388imap_deletemailboxfunction,388imap_expungefunction,389imap_fetchbodyfunction,385imap_fetchoverviewfunction,383imap_fetchstructurefunction,382imap_getmailboxesfunction,375imap_headerinfofunction,379–382imap_headersfunction,378imap_mailfunction,387imap_mail_composefunction,386imap_mail_copyfunction,389imap_mail_movefunction,389imap_num_msgfunction,376imap_openfunction,374performingnon-SSLconnection,375imap_renamemailboxfunction,389imap_statusfunction,377implementskeyword,OOP,166implicit_flushdirective,25implodefunction,strings,217importingdata,850–857LOADDATAINFILEstatement,850–853loadingtabledatawithPHP,856–857mysqlimportutility,853–856INclause,MySQLdeterminingexistencewithsubqueries,810INparametersstoredprocedures,750in_arrayarrayfunction,111in_reply_toattribute,messages,380includedirectoryc-clientlibraryconfusion,373includestatement,Smarty,462includestatement,PHP,87functionlibraries,100include_oncefunction,PHP,88include_pathdirective,37installingSmarty,451include_phpfunction,Smarty,464increment(++)operator,72INDEXattribute,MySQL,648INDEXprivilege,677Index_privcolumndbtable,671hosttable,672usertable,667,670indexes,817–826advantages,817Booleanfull-textsearches,824EXPLAINstatement,826fulltextindexes,822–825log_long_formatparameter,826normalindexes,820–822NOTNULLattribute,826ORDERBYclause,825primarykeyindexes,818–819queryoptimization,817rebuilding,824searchinganindexprefix,825textsearching,818tipsforusing,825uniqueindexes,819–820uniqueness,817WHEREclause,825879INDEXINFILEkeywordLOADDATAINFILEstatement,850–853infocommand,PEAR,265--informationoption,myisamchk,623information,LDAPmodels,400INFORMATION_SCHEMAdatabase,MySQL,656–659description,579tablenameswithbriefdescriptions,657triggers,773viewingviewdefinition,787inheritance,134,161–165abstractclasses,168classinheritance,162constructorsandinheritance,164–165description,157multipleinheritance,158ini_setfunction,21init_fileparameter,MySQL,600InnobaseOy,Inc.
,633InnoDBstorageengine,MySQL,632InnoDBtablehandlerbackingup/restoring,839configurationparameters,833–836description,578MySQL4and,578MySQLsystemrequirements,832MySQLtransactionscreatingtableoftypeInnoDB,833MySQLtransactionstips,840sampleproject,836–840addingdata,837executingtransaction,837participanttable,836trunktable,836verifyingInnoDBtableavailability,832with-innodboption,832innodb_additional_mem_pool_size,833innodb_buffer_pool_size,834innodb_data_file_path,834innodb_data_home_dir,833,834innodb_file_io_threads,834innodb_flush_log_at_trx_commit,835innodb_lock_wait_timeout,835innodb_log_arch_dir,835innodb_log_archive,835innodb_log_buffer_size,835innodb_log_file_size,835innodb_log_files_in_group,835innodb_log_group_home_dir,835INOUTparametersstoredprocedures,750inputsystemlevelprogramexecution,254input/outputfunctionssafe_moderestrictions,516insensitivecursors,MySQL,813INSERTprivilege,677inserttag,Smarty,463Insert_privcolumndbtable,671hosttable,672usertable,666,669insertingdata,MyISAMtables,634insertingdataintodatabase,699–701installcommand,PEAR,266installationsApacheonLinux/Unix,11–13ApacheonWindows,13–16MagpieRSS,479MySQLonLinux,584–588MySQLonWindows,588–591NuSOAP,493PDO(PHPDataObjects),558PEAR,262–264PEARpackages,266PHPonLinux/Unix,11–13PHPonWindows,13–16PHP,verifyinginstallation,16–17Smartytemplatingengine,450–452SQLite,536instanceofkeyword,OOP,153instantiationabstractclasses,OOP,168classinstantiation,136constructors,148INTdatatype,MySQL,645integerdatatype,PHP,51InterbasePDOsupporteddatabases,558interface_existsfunction,154interfaces,OOP,165–168abstractclassesorinterfaces,169caution:classmembersnotdefinedwithininterfaces,165checkingifinterfaceexists,154description,157generalsyntaxforimplementing,166implementingasingleinterface,167implementingmultipleinterfaces,168implementskeyword,166namingconventions,166internetservices,364–365defaultportsforinternetservices,364getservbynamefunction,364getservbyportfunction,364interoperabilityreasonsforwebservices,474introspection,170INVOKERsettingSQLSECURITYcharacteristic,751IPaddressbasedauthentication,PHP,333–334authenticatingusingloginpairandIPaddress,333IPspoofing,334880INDEXIPaddressesdomainnamesand,360IPspoofing,334isequalto(==)operator,73isidenticalto(===)operator,73isnotequalto(!
=)operator,73is_afunction,155is_arrayfunction,108is_cachedmethod,Smarty,469is_namefunction,57is_subclass_offunction,155is_uploaded_filefunction,PHP,349ISAMstorageengine,633convertingISAMtablestoMyISAMtables,641ISAPIsupport,3isexecutablefunction,241isLeapmethod,Date/TimeLib.
,293ISO8601specification,299isolation,832isreadablefunction,241issetfunction,PHP,328issuersREQUIREISSUERoption,684isValidmethodCalendarpackage,PEAR,288,Date/TimeLib.
,294HTTP_Uploadclass,PEAR,357iswriteablefunction,241itemattributeforeachstatement,Smarty,458ITERATEstatementstoredroutines,756JJavaPHPdirectives,41JavasupportPHP4features,3java.
class.
pathdirective,41java.
homedirective,41java.
librarydirective,41java.
library.
pathdirective,41JavaScriptpassingPHPvariableintoJavaScriptfunction,311–313JDBC(JavaDatabaseConnectivity),556joinfunction,strings,217Joye,Pierre-Alain,289Juliandates,292Kkeyarrayfunction,113keyattributeforeachstatement,Smarty,458,459key_buffer_sizeparameter,MySQL,600KEY_COLUMN_USAGEtable,657keys--ssl-keyoption,686arrays,104keywordshighlight.
keyworddirective,28killcommand,mysqladminclient,620krsortarrayfunction,123ksortarrayfunction,122Llanguagefeatures,4–7LANGUAGESQLcharacteristicstoredprocedures,750languages(foreign)supportedHTTP_Uploadclass,PEAR,357layersdatabaseabstractionlayers,555LDAP(LightweightDirectoryAccessProtocol)additionalresources,400bindingtoLDAPserver,402–403characterencoding,420–421closingLDAPserverconnection,403configurationfunctions,418–420connectingtoLDAPserver,401–402countingretrievedentries,407deallocatingmemory,415deletingLDAPdata,417–418errorhandling,422–423insertingLDAPdata,415–417introduction,400–401models,400retrievingattributes,407–410retrievingLDAPdata,404–405searchingforLDAPdata,404–405sortingandcomparingLDAPentries,410–412updatingLDAPdata,417usingfromPHP,401–423workingwithDistinguishedName,421–422workingwithentries,412–415workingwithentryvalues,405–406ldap_8859_to_t61function,420ldap_addfunction,416ldap_bindfunction,402ldap_closefunction,403ldap_comparefunction,411ldap_connectfunction,401ldap_count_entriesfunction,407ldap_deletefunction,418ldap_dn2ufnfunction,421ldap_err2strfunction,422ldap_errnofunction,422ldap_errorfunction,423ldap_explode_dnfunction,421ldap_first_attributefunction,407ldap_first_entryfunction,412ldap_free_resultfunction,415ldap_get_attributesfunction,408ldap_get_dnfunction,410ldap_get_entriesfunction,414ldap_get_optionfunction,420881INDEXldap_get_valuesfunction,406ldap_get_values_lenfunction,406ldap_listfunction,405ldap_mod_addfunction,416ldap_mod_delfunction,418ldap_mod_replacefunction,417ldap_modifyfunction,417ldap_next_attributefunction,408ldap_next_entryfunction,413LDAP_OPT_XYZoptions,419ldap_readfunction,405ldap_renamefunction,417ldap_searchfunction,404ldap_set_optionfunction,420ldap_sortfunction,411ldap_start_tlsfunction,402ldap_t61_to_8859function,421ldap_unbindfunction,403LEAVEcommandstoredroutines,757left_delimiterattributeusingCSSinconjunctionwithSmarty,467leftmostprefixing,821Lerdorf,Rasmus,1lessthan(PathInfodirective,316configuring,315–316Filesdirective,315ForceTypedirective,315userfriendlyURLs,314loopattributesectionfunction,Smarty,460LOOPstatementstoredroutines,757loopingstatements,PHP,81–86alternativesyntax,80breakstatement,85continuestatement,86do.
.
.
whilestatement,82forstatement,83foreachstatement,84whilestatement,81loosetypinggenerallanguagefeatures,5LostconnectiontoMySQL.
.
.
errornumber2013,724LOWPRIORITYoptionLOADDATAINFILEstatement,850:lower:characterclass,195--low-priorityoption,mysqlimport,854lstatfunction,233ltrimfunction,strings,222MMparameter,numericdatatypesconstrainingmaximumdisplaysize,645magic_quotes_gpcdirective,35magic_quotes_runtimedirective,35magic_quotes_sybasedirective,36MagpieRSS,479–486aggregatingfeeds,483–484cachingfeeds,485features,479installing,479limitingnumberofdisplayedheadlines,484parsingafeed,479–481renderingretrievedfeed,481–482mailPHPdirectives,40–41sendmail_fromdirective,41sendmail_pathdirective,41SMTPdirective,40smtp_portdirective,41Mailpackage,PEAR,260MailTransferAgent(MTA),367mailfunction,368seealsoe-mailaddl_headersparameter,368addl_paramsparameter,368configurationdirective,367examplesusing,369–372force_extra_parametersdirective,368MailTransferAgent,368sendmail_fromdirective,368sendmail_pathdirective,368SMTPdirective,367smtp_portdirective,368mailfunction,JavaScript,311mailboxattribute,messages,379mailboxescontainernotmailbox,376creating,388deleting,388expungingmailbox,374,375imap_createmailboxfunction,388imap_deletemailboxfunction,388imap_getmailboxesfunction,375imap_num_msgfunction,376imap_openfunction,374imap_renamemailboxfunction,389imap_statusfunction,377mailboxadministration,388–389movingmessagesbetween,389numberofmessagesin,376openingwithread-onlyprivileges,374renaming,389retrievinginformationabout,375883INDEXretrievingstatusinformationabout,377withoutchildren,376maintenanceadvantagesofusingviews,780storedroutinesdisadvantages,746Masinter,Larry,345masksumaskfunction,241master/slavesupportmysqliextensionenhancements,720MATCHfunction,MySQLfulltextindexes,823maxattributesectionfunction,Smarty,460Maxversion,MySQL,583max_allowed_packetparameter,MySQL,600max_connectionscolumnlimitinguserresources,682usertable,667max_connectionsparameter,MySQL,601max_execution_timedirective,29,519fileupload/resourcedirectives,346MAX_FILE_SIZEdirective,350max_heap_table_sizeparameter,636max_input_timedirective,29max_questionscolumnlimitinguserresources,682usertable,667max_updatescolumnlimitinguserresources,682usertable,667max_user_connectionscolumnlimitinguserresources,682usertable,667MCrypt,531mcrypt_decryptfunction,532mcrypt_encryptfunction,531md5functionfilebasedauthentication,330PHPencryptionfunction,529MEDIUMBLOBdatatype,MySQL,647--medium-checkoption,myisamchk,623MEDIUMINTdatatype,MySQL,645MEDIUMTEXTdatatype,MySQL,647member_to_vehicletable,810memorydeallocatingmemory,LDAP,415innodb_additional_mem_pool_size,833ldap_free_resultfunction,415recuperating,mysqliextension,728report_memleaksdirective,32MEMORYstorageengine,MySQL,635indexessupported,636memory_limitdirective,29,519fileupload/resourcedirectives,347MERGEalgorithmviews,MySQL,785MERGEstorageengine,MySQL,636messagebody(ofmessage),386imap_fetchbodyfunction,385messageheadersaddl_headersparameter,mail(),368imap_fetchoverviewfunction,383imap_headerinfofunction,379–382imap_headersfunction,378sendinge-mailwithadditionalheaders,369settingFromfieldof,368message_idattribute,messages,380,383messagescomposingmessages,386copying,389expunging,389getMessagemethod,exceptionclass,186headerattributes,379imap_expungefunction,389imap_fetchbodyfunction,385imap_fetchoverviewfunction,383imap_fetchstructurefunction,382imap_headerinfofunction,379–382imap_headersfunction,378imap_mailfunction,387imap_mail_composefunction,386imap_mail_copyfunction,389imap_mail_movefunction,389imap_num_msgfunction,376messageadministration,389moving,389numberofmessagesinmailbox,376retrievingmessagebody,385retrievingmessageheaderinformation,379retrievingmessageheadersintoarray,378retrievingmessageoverview,383retrievingmessagestructure,382retrievingmessages,378–386sendingmessages,387metacharactersPerlregularexpressionsyntax,199–200methodoverloading,OOP,158methodparametersReflectionParameterclass,174method_existshelperfunction,155methods,143–147abstractmethods,146checkingifmethodavailabletoobject,155declaring,144exceptionclass,186finalmethods,147functionsandmethodscompared,143gettingmethodsofclass,154invoking,144methodscopes,144–147privatemethods,145protectedmethods,146publicmethods,145884INDEXReflectionMethodclass,172staticscope,152metricsreasonsforMySQLpopularity,576mhashfunction,529,530MicrosoftSQLServer,558migratingdataseeimportingdataMimeMail5sendinge-mailattachments,371MIMEtypesdefault_mimetypedirective,36mirrorsdownloadingApache,10downloadingMySQL,583downloadingPHP,10mktimefunction,PHP,277determiningdaysincurrentmonth,284mm(sharedmemory)option,427modeparametersetFetchModemethod,PDO,571modessettingfileI/Oaccesslevel,243modifiersPerlregularexpressionsyntax,199MODIFIESSQLDATAcharacteristicstoredprocedures,751modifyingdata,701–703ldap_modifyfunction,417modulus(%)operator,71monetaryrepresentationslocalizedformats,280more_resultsmethod,mysqli,735MoreoverTechnologies,RSS,476mortgage.
php,98move_uploaded_filefunction,PHP,350moveTomethodHTTP_Uploadclass,PEAR,357movingmessagesimap_mail_movefunction,389msgnoattribute,messages,383MTA(MailTransferAgent)mailfunction,368settingformailfunction,367Muffett,Alec,339multi_querymethod,mysqli,733multidimensionalarrays,104sorting,121multipleinheritance,OOP,158multiplequeriesmysqliextension,733,735multipleselectboxes,307multiple-columnnormalindexes,MySQL,821multiplication(*)operator,71MustUnderstanderrorfaultstringattribute,NuSOAP,500mutatorssetter(_set)method,140,142MX(MailExchangeRecord)records,DNS,360getmxrrfunction,363–364my.
cnfconfigurationfile,MySQL,602–604locationandrelativescopeofdirectories,602storingSSLoptionsinmy.
cnffile,686MyExceptionclassextendingexceptionclass,187my-huge.
cnffile,603my-innodb-heavy-4G.
inifile,603MyISAMstorageengine,633–635compressedMyISAM,635convertingISAMtablestoMyISAMtables,641dynamicMyISAM,635optimization,634staticMyISAM,634myisamchkclient,623seealsomysqlclients(ingeneral)--checkoption,623--extend-checkoption,623--information(-i)option,623--medium-checkoption,623--recover(-r)option,624my-large.
cnf,MySQL,603,604my-medium.
cnf,MySQL,603my-small.
cnf,MySQL,603MySQLAPIs,574background,573backslash(\),useof,851commerciallicense,577configurationandoptimizationparameters,597–602back_log,599datadir,599default-table-type,600init_file,600key_buffer_size,600log_long_format,600log_slow_queries,600max_allowed_packet,600max_connections,601mysqld-version,601net_buffer_length,601port,601read_buffer_size,601skip-name-resolve,601skip-networking,601table_cache,601thread_cache_size,602user,602viewing,597configurationoptions,575configurationtemplates,603configuringandoptimizing,596–604my.
cnfconfigurationfile,602–604885INDEXconfusingwithmysql,607creatingdatabases,652cursors,812–815introduction,793datatypeattributes,648–651datatypes,642–647deletingdatabases,652designatingdatabases,652downloading,583–584downloadwebsite,573enterprise-levelSQLfeatures,574flexibility,574full-textindexingandsearching,575grantinguseraccess,666indexes,817–826INFORMATION_SCHEMA,656–659installing,584–591initialsecuritytasksfollowing,661–662installingonLinux,584–588binarydistribution,586–587distributionformats,584RedHatPackageManager,584–586sourceinstallation,587–588installingonWindows,588–591MySQLConfigurationWizard,590–591licensing,576,577conflictswithPHP,11issues,581–582managingdata,574metrics,576Navicat,629–630opensourcelicensing,576optimizedMySQLbinaryplatforms,574pagenumbers,listing,806,808pagedoutput,creating,803–806pagedresults,793PDOsupporteddatabases,558performance,574PHPMySQLextension,689–718phpMyAdmin,626–627prominentusers,579–580querycaching,575reasonsforpopularity,573–577replication,575safe_moderestrictions,517searches,826–830security,575,661–687seealsoMySQLsecuritysettingMySQLadministratorpassword,591startingandstopping,591–596startingandstoppingonLinux,592automatically,594–595startingMySQLonboot,595startingMySQLonshutdownorreboot,595startingandstoppingonWindows,593automatically,595–596installingMySQLasWindowsservice,595uninstallingMySQLasWindowsservice,596storageengines,574,631–641storedroutines,745–766subqueries,808–812introduction,793tablehandlers,574tabularoutputcreatingwithPEAR,794–802introduction,793sorting,793,802transactions,832–836triggers,767–778usercommunity,577viewingdatabases,651views,779–791MySQL4,577–578embeddedMySQLserver,578InnoDBtablehandler,578querycaching,578spatialextensions,578SSL(SecureSocketsLayer),578subqueries,578MySQL5,578–579foreignkeysupport,578INFORMATION_SCHEMA,579storedprocedures,579triggers,579views,579MySQLAB,573OptionalGPLLicenseExceptionforPHP,576MySQLAdministrator,624–626mysqlclient,610–619seealsomysqlclients(ingeneral)commandsDESCRIBE,613more,616quit,616SELECT,614SHOWSTATUS,615SHOWTABLES,613SHOWVARIABLES,614source,616status,617USE,613determiningdatabase,611disablingbeep,611disablingheadersinresults,612displayingqueryresultsvertically,612displayingresultsvertically,616enablingloggingofqueries,611executing(multiple)queries,611executingqueries,614executingregardlessoferrors,611exitingmysqlclient,616generalcommandsyntax,610gettingserverstatistics,617hashesfacilitatingauto-completion,610hyphensprefacingoptions,608listingconfigurationvariables,614886INDEXloggingcommands,612loggingqueries,617modifyingmysqlprompt,618namedpipes,612options,610–612,616–617auto-rehash,610column-names,610database(-D),611default-character-set,611disable-tee,611execute(-e),611force(-f),611\G,616html(-H),611,618no-auto-rehash,610no-beep(-b),611no-column-names,610notee(\t),617pager,611prompt(-p),618protocol,611\s(status),617safe-updates(-U),612,617skip-column-names,612tee(\T),612,617vertical(-E),612xml(-X),612,618outputtingqueryresultsinHTMLandXML,618outputtingresultsinHTML,611pagingoutput,616presentingresultspagebypage,611preventingmassdeletions,612,617resultsoutputinXML,612retrievingstatistics,617settingcharacterset,611sharedmemory,612socketfiles,611specifyingprotocol,611switchingdatabase,613TCPprotocol,611usinginbatchmode,616usingininteractivemode,612–614viewingconfigurationvariables,614viewingstructureofatable,613viewingsystemstatus,615viewingtables,613mysqlclients(ingeneral)seealsomysqlclientadministrativetasks,619casesensitivityofoptions,608checkingfortablecorruption,623connectinguser'susername,608connectionoptions,608databases/tables/columnsonserver,621decreasingclientchatter,609enablingcompressionprotocol,609,610exportingdata,621,622ignoringconfigurationfiles,609importingdatafromdelimitedtextfile,623MySQLmanualcoverage,607namedpipesspecified,609optionscompress(-C),609,610defaults-extra-file,609defaults-file,609help(-),609host(-h),608,611no-defaults,609password(-p),608,611pipe(-W),609port(-P),609,611print-defaults,609silent(-s),609socket(-s),609user(-u),608variable-nameplaceholder,609verbose(-v),609version(-V),609optionsrequiringvalues,608outputtinghelpinformation,609outputtingmorethandefault,609outputtingoptions,609passingoptionsto,607precedenceofoptionsassigned,608repairingcorruptedtables,624rulesrelatingtooptions,607settingvariablevalue,609short/longformsofoptions,608socketfilerequired,609specifyingconfigurationfiles,609specifyingport,609,611standardoptions,609targetingdatabasehost,608,611user'spassword,608,611versioninformation,609MySQLConfigurationWizardinstallingMySQLonWindows,590–591MySQLextension,PHP,689–718choosingdatabase,694closingconnections,692deletingdata,704–705displayingdata,696–699enablingonLinux,689enablingonWindows,690establishingconnections,691–692functionscreate_dropdown,702mysql_affected_rows,705mysql_client_encoding,715mysql_close,692mysql_connect,691,693mysql_db_name,706mysql_db_query,695mysql_errno,714887INDEXmysql_error,714mysql_fetch_array,698mysql_fetch_assoc,699mysql_fetch_field,708mysql_fetch_object,699mysql_fetch_row,697mysql_field_flags,710mysql_field_len,710mysql_field_name,711mysql_field_table,711mysql_field_type,711mysql_get_client_info,718mysql_get_host_info,717mysql_get_server_info,717mysql_list_dbs,706mysql_list_fields,709mysql_list_processes,716mysql_list_tables,707mysql_num_fields,709mysql_num_rows,705mysql_pconnect,692mysql_query,695mysql_real_escape_string,715mysql_result,696mysql_select_db,694mysql_stat,715mysql_stmt_execute,737mysql_tablename,707mysql_thread_id,716mysql_unbuffered_query,728view_db_properties,712view_table_properties,712helperfunctions,715–718insertingdata,699–701modifyingdata,701–703MySQLversionssuitablefor,689MYSQL_ASSOCvalue,698MYSQL_BOTHvalue,698mysql_convert_table_formatutility,641mysql_fix_privilege_tablesutility,668MYSQL_NUMvalue,698mysql_setpermissionscript,680numberofrowsaffected,705numberofrowsselected,705producttable,690queryingdatabase,694–696retrievingdata,696–699retrievingdatabaseinformation,706retrievingerrorinformation,713–715retrievingfieldinformation,708–711field_offsetposition,708retrievingtableinformation,707rowsselected/affected,numberof,705securingconnectioninformation,693storingconnectioninformation,693userprivileges,690viewingdatabaseproperties,712viewingtableproperties,712MySQLQueryBrowser,627–629MySQLsecurity,661–687accessprivilegesystem,663–675accesscontrol,664accessinformationstore,665–675columns_privtable,674connectionrequestexample,664–665dbtable,671hosttable,672howitworks,663–665procs_privtable,674tables_privtable,673usertable,666–671connections,683–687encryptionusingMySQLandHTTPS,687initialtasksfollowinginstallation,661–662applyingpatches,662auditingserver'suseraccounts,662closingfirewall,662disablingunusedsystemservices,662settingMySQLrootuserpassword,662limitinguserresources,682–683secureMySQLconnections,683–687connectingusingSSL-enabledclient,686determininguser'sSSLrequirements,683grantoptions,683–684installingOpenSSLlibrary,683SSLoptions,685–686startingSSL-enabledMySQLserver,686storingSSLoptionsinmy.
cnffile,686verifyingMySQLready,683securingmysqlddaemon,662–663userandprivilegecommands,675–682CREATEUSER,675DROPUSER,676GRANT,678,681RENAMEUSER,676REVOKE,679,681SHOWGRANTSFOR,682mysqlutilitiesseemysqlclientsmysqladminclient,619–620seealsomysqlclients(ingeneral)commands,619–620create,619drop,619extended-status,619flush-hosts,620flush-logs,620flush-privileges,620flush-status,620flush-tables,620flush-threads,620kill,620old-password,620password,620ping,620processlist,620888INDEXrefresh,620reload,620shutdown,620start-slave,620status,620stop-slave,620variables,620version,620mysqlbinlogclientrestoringInnoDBtables,839mysqlcheckclient,624seealsomysqlclients(ingeneral)mysqldbinaryconfiguringMySQL,597startingMySQLonWindows,593mysqlddaemonsecuring,662–663mysqld_safescriptconfiguringMySQL,597startingMySQL,592mysqldumpclient,621seealsomysqlclients(ingeneral)mysqldumpcommandbackingupInnoDBtables,839restoringInnoDBtables,839mysqld-versionparameter,601mysqlhotcopyclient,622seealsomysqlclients(ingeneral)mysqliclassinstantiating,721tabular_outputmethod,adding,799mysqliextension,719–743background,719caution:PDOsupportfor,564caution:PHPversioncompatibility,720closingMySQLconnection,725–726connectingtoMySQLServer,721–722connectionerrorreporting,722–725creatingcustomerrormessages,724databasetransactions,741–742enablingonUnix,720enablingonWindows,720enhancements,719debugging,719embeddedMySQLserver,720master/slavesupport,720objectorientation,719preparedstatements,719replication,720transactions,719instantiatingmysqliclass,721methodsaffected_rows,stmt,741autocommit,742bind_param,stmt,738bind_result,stmt,740close,726close,stmt,737commit,742connect,722errno,stmt,741error,stmt,741execute,stmt,737fetch,stmt,741fetch_array,730fetch_assoc,732fetch_object,732fetch_row,733free_result,728free_result,stmt,741more_results,735multi_query,733mysql_stmt_execute,737mysqli_autocommit,742mysqli_close,726mysqli_commit,742mysqli_connect,722mysqli_connect_errno,723mysqli_connect_error,723mysqli_fetch_array,730mysqli_fetch_assoc,731mysqli_fetch_object,732mysqli_fetch_row,732mysqli_free_result,728mysqli_more_results,734mysqli_multi_query,733mysqli_next_result,735mysqli_query,726mysqli_real_query,727mysqli_rollback,742mysqli_select_db,725mysqli_stmt_bind_param,737mysqli_stmt_bind_result,739mysqli_stmt_close,737mysqli_stmt_fetch,741mysqli_stmt_prepare,736mysqli_store_result,729mysqli_use_result,730next_result,735num_rows,stmt,741prepare,stmt,736query,727real_query,728rollback,742select_db,725store_result,729use_result,730MYSQLI_ASSOCvalue,731MYSQLI_BOTHvalue,731MYSQLI_NUMvalue,731MYSQLI_STORE_RESULTvalue,727MYSQLI_USE_RESULTvalue,727namingconventions,720programmingusing,720889INDEXqueryrelatedtasks,726–741multiplequeries,733–735parsingresults,730–733preparedstatements,735–741queryexecution,726–728readyingresultset,728–730recuperatingquerymemory,728sampledata,721selectingMySQLdatabase,725usingtransactionalmethods,841mysqlimportclient,623seealsoLOADDATAINFILEstatement;mysqlclients(ingeneral)dataimportexample,855importingdata,853–856options,853–855mysqlshowclient,621seealsomysqlclients(ingeneral)Nnameattributeforeachstatement,Smarty,458sectionfunction,Smarty,460namedirective,429nameparameterinserttag,Smarty,463namevariableFILES($_FILES)array,348namedparameterspreparedstatements,PDO,565,566namedpipes,mysqlclient,612namespaces,OOP,158namingconventionsbeforeandaftertriggers,772directoriesandPEARpackages,268interfaces,OOP,166LDAPmodels,400mysqliextension,720POSTvariables,304NAPTR(NamingAuthorityPointer)recordtype,DNS,360natcasesortarrayfunction,120NATIONALattribute,MySQL,649CHAR/VARCHARdatatypes,646natsortarrayfunction,119Navicat,MySQL,629–630navigationalcues,websites,313–323customerrorhandlers,321–323userfriendlyURLs,313–317navigational(breadcrumb)trails,317–321Nebel,Ernesto,345nestinggenerallanguagefeatures,5nestingfunctions,96.
NETFrameworkSDK,512net_buffer_lengthparameter,MySQL,601Net_SMTPpackage,PEAR,260Net_Socketpackage,PEAR,260Netcraft,2networking,393–398creatingportscannerwithNMap,395pingingserver,394–395skip-networkingparameter,MySQL,601subnetconverter,395–397testinguserbandwidth,397–398newkeyword,OOP,136newlinecharacter,242newsgroupsattribute,messages,380newsrcconfigurationfileimap_openfunction,374nextarrayfunction,114next_resultmethod,mysqli,735nl2brfunctionNuSOAPdebuggingfeature,502stringconversion,210Nmap(networkmapper)toolcreatingportscannerwithNMap,395NNTPprotocolIMAPprotocol,372openingconnectionstoNNTPmailboxes,374--no-beepoption,mysqlclient,611--no-defaultsoption,mysqlclient,609normalindexes,MySQL,820–822leftmostprefixing,821multiple-columnnormalindexes,821single-columnnormalindexes,820NOT(!
)operator,73,178NOTDETERMINISTICcharacteristic,751NOTEXISTSclause,MySQL,810NOTFOUNDcondition,757,764NOTNULLattribute,MySQL,649NS(NameServerRecord)recordtype,DNS,360NULLattributeENUMdatatype,MySQL,647NULLcharacterbinarydata,550nulldatatype,PHP,54NULLdatatypeattribute,MySQL,649nullsPDO_ATTR_ORACLE_NULLSattribute,560num_rowsmethod,mysqli_stmt,741number_formatfunction,710number_rowscomponent,LIMITclause,804numbersconvertingnumeralformats,261localizedformats,280Numbers_Romanpackage,PEAR,261numericdatatypes,MySQL,644–646constrainingmaximumdisplaysize,645digitsfollowingdecimalpoint,645numericalarrays,creating,106numericalkeysarrays,104890INDEXNuSOAP,492–502caution:namingconflict,493consumingaWebService,494–495creatingamethodproxy,495–496debuggingtools,501designatingHTTPproxy,501errorhandling,500–501features,492generatingWSDLdocument,499–500installing,493publishingaWebService,496–498returninganarray,498–499secureconnections,WebServices,502usingProxyclass,495Oob_gzhandlerfunction,24objectcloning,OOP,158–161clonekeyword,158clonemethod,160description,157example,158objectdatatype,PHP,53objectorientationgenerallanguagefeatures,6mysqliextensionenhancements,719NuSOAPfeatures,492PDOfeatures,557PHP4features,2PHP5features,4SQLite,539objectorientedprogrammingabstractclasses,157,168–169autoloadingobjects,155–156benefitsofOOP,134–135encapsulation,134inheritance,134polymorphism,135constructors,148–151destructors,151–152featuresnotsupportedbyPHP,157–158helperfunctions,153–155inheritance,157,161–165instanceofkeyword,153interfaces,157,165–168keyOOPconcepts,135–147classes,135constants,143fields,137–140methods,143–147objects,136properties,140–143methodoverloading,158multipleinheritance,158namespaces,158objectcloning,157,158–161operatoroverloading,158reflection,157,169–176staticclassmembers,152–153typehinting,147objects,136seealsoclassescheckingifmethodavailabletoobject,155checkingifobjectbelongstoclass,155checkingifobjectbelongstoinheritedclass,155constructors,148–151destructors,151–152fetch_objectmethod,mysqli,732gettingfieldsavailabletoobject,154instanceofkeyword,153mysql_fetch_objectfunction,699newkeyword,136objectsandclasses,136typehinting,147ODBC(OpenDatabaseConnectivity),556PDOsupporteddatabases,559offsetcomponent,LIMITclause,804old-passwordcommand,mysqladminclient,620onetimeURLgenerator,343opendevelopment,7opensourcesoftware,7OPENstatement,MySQLcursors,813open_basedirdirective,27,519opendirfunction,251openlogfunction,181OpenSSLlibraryinstalling,683operands,PHP,69operatingsystemssystemlevelprogramexecution,256operatoroverloading,OOP,158operatorsarithmeticoperators,70assignmentoperators,71associativity,69,70bitwiseoperators,74Booleanfull-textsearches,MySQL,825comparisonoperators,74decrement(--)operator,72equalityoperators,73expressions,PHP,69–75increment(++)operator,72logicaloperators,72precedence,69,70stringoperators,71typecasting,PHP,54OPTIONALLYflagLOADDATAINFILEstatement,851optionsparameterSoapClientconstructor,503SoapServerconstructor,508optionsstringmanagingstoredroutines,754OR(||)operator,73891INDEXOraclePDOsupporteddatabases,559ORDERBYclausetabular_outputmethodsortingresults,802ordinaryindexes,MySQLseenormalindexes,MySQLOrte,Monte,449OUTparametersstoredprocedures,750OUTFILEkeywordSELECTINTOOUTFILEstatement,847–849output,PHP,47–50echostatement,48printstatement,47printfstatement,49sprintfstatement,50output_bufferingdirective,23output_handlerdirective,24outputsoutputtingdatatofile,250overloading,OOPconstructors,151baseexceptionclass,185,186methodoverloading,158operatoroverloading,158overridingfinalscope,140ownershipoffileschangingownership,239effectofenablingsafemode,516P-Poption,mysqlclient,609,611-poption,mysqlclient,608,611packages,PEAR,259–262packetsmax_allowed_packetparameter,600paddingspecifierprintfstatement,49pagecaching,468pagenumbers,MySQL,808pagedoutput,MySQLcreating,803–806determiningcurrentpagenumber,807determiningtotalnumberofpages,806determiningtotalnumberofrows,805entriesperpage,804LIMITclause,803listingpagenumbers,806–808offsetforrecordstartpoint,804parametervariable,807previousandnextlinks,805rowoffset,804sampleoutput,805totalrowsinresultset,804usingmysqlinbatchmode,616pagedresults,MySQL,793pageLinksmethod,MySQL,807--pageroption,mysqlclient,611pagesizevariable,MySQL,807parametervariable,MySQL,807parametersseealsoargumentsaddl_paramsparameter,mail(),368binding,mysqli,738creatingstoredprocedures,749passingadditionalparameterstosendmailbinary,368ReflectionParameterclass,174storedfunctions,750parentclass,OOP,162parentkeywordinvokingparentconstructors,150parse_strfunction,215parsingqueryresultsmysqliextension,730–733SQLite,541–544sqlite_array_queryfunction,543sqlite_columnfunction,543sqlite_fetch_arrayfunction,541sqlite_fetch_singlefunction,544parsingXMLfiles,261participanttable,InnoDB,836addingdata,837checkingdata,838partitionidentifyingspaceon,236passingargumentsbyreferenceallow_call_time_pass_referencedirective,25passthrufunction,257Passwordcolumnusertable,666,668passwordcommand,mysqladmin,620--passwordoption,mysql,608,611--passwordoption,mysqlimport,854passwordparameterSoapClientconstructor,503passwordsassigningduringuserregistration,337–339avoidingeasilyguessable,339–341CrackLibextensionrequirements,339generallanguagefeatures,6hardcodedauthentication,328missioncriticalapplications,339MySQLupgradeaffecting,668PHP_AUTH_PWauthenticationvariable,327recovering/resettingwhenuserforgets,341onetimeURLgenerator,343settingMySQLadministratorpassword,591settingMySQLrootuserpassword,662storageformat,668patches,MySQLsecurity,662PATH_INFOvariableuserfriendlyURLs,314,316892INDEXpathinfofunction,231pathsdatadirparameter,599hidingsensitivedata,523include_pathdirective,37innodb_data_file_path,834innodb_data_home_dir,834PHPdirectives,37–38retrievingabsolutepath,231retrievingdirectorycomponentofpath,230retrievingfilenamecomponent,230retrievingtargetofsymboliclink,235safe_mode_include_dirdirective,517session.
cookie_pathdirective,429session.
save_pathdirective,428settingpathtosendmailbinary,368PDO(PHPDataObjects),556–572configuring,558connectingtodatabaseserver,559–561connectionrelatedoptions,560constructors,559embeddingparametersinto,559placingparametersinfile,559referringtophp.
inifile,560databaseabstractionlayersand,556databasesupport,558determiningavailabledrivers,559driver_optsarray,559errorhandling,562features,557gettingandsettingattributes,561installing,558methodsbeginTransaction,572bindColumn,571bindParam,564,565,566columnCount,568commit,572errorCode,562errorInfo,562exec,563execute,564,565fetch,568fetchAll,569fetchColumn,570getAttribute,561prepare,564,565query,563rollback,572rowCount,564setAttribute,561setFetchMode,571preparedstatements,563,564–567caution:mysqliextension,564namedparameters,565,566questionmarkparameters,565queryexecution,562–564retrievingdata,567–571selectingdatabase,559–561settingboundcolumns,571–572transactions,572using,557–572PDO_ATTR_AUTOCOMMIT,560PDO_ATTR_CASE,560PDO_ATTR_CLIENT_VERSION,561PDO_ATTR_CONNECTION_STATUS,561PDO_ATTR_ERRMODE,560PDO_ATTR_ORACLE_NULLS,560PDO_ATTR_PERSISTENT,560PDO_ATTR_PREFETCH,560PDO_ATTR_SERVER_INFO,561PDO_ATTR_SERVER_VERSION,561PDO_ATTR_TIMEOUT,560PDO_CASE_*valuesPDOcharactercasing,560PDO_ERRMODE_EXCEPTION,560,562PDO_ERRMODE_SILENT,560,562PDO_ERRMODE_WARNING,560,562PDO_FETCHvaluesfetch_styleparameter,568PDO_PARAM_*valuesdatatypeparameter,PDO,566PDOStatementclass,567PEAR,259–270Calendarpackage,285–288creatingtabularoutputwith,794–802HTML_Table,802downgradingPEARpackages,269installing,262–264hostingcompanypermission,263UNIX,262Windows,263installingPEARpackages,266automaticallyinstallingdependencies,267Calendarpackage,285faileddependencies,266fromPEARwebsite,267learningaboutinstalledpackages,265PEARpackages,259–262PEARpackagesdependingonreflectionAPI,176uninstallingPEARpackages,269updating,264upgradingPEARpackages,268,269usingPEARpackages,267viewinginstalledpackages,264PEARpackage,260PEARPackageManager,264–269PEARpackagesArchive_Tar,260Auth,261Console_Getopt,260DB,260File_SMBPasswd,266HTML_QuickForm,261893INDEXLog,261Mail,260Net_SMTP,260Net_Socket,260Numbers_Roman,261PEAR,260PHPUnit,260Validate_US,226–227XML_Parser,261XML_RPC,261PEAR_ENV.
regfile,263PEAR:Auth_HTTPclassseeAuth_HTTPclass,PEARauthenticatingagainstMySQLdatabase,335authenticationmethodologies,PHP,336installing,334–335PEAR:HTTP_UploadseeHTTP_Uploadclass,PEARPECL(PHPExtensionCommunityLibrary),340performancechoosingstorageengine,641identifyingslowqueries,mysql,616indexingtips,825PDOfeatures,557reasonsforMySQLpopularity,574storedroutines,746templatecaching,471PerlDBI(PerlDatabaseInterface),556Perlregularexpressionsyntax,198–205functions,200–205preg_grep,201preg_match,201preg_match_all,201preg_quote,202preg_replace,203preg_replace_callback,203preg_split,204metacharacters,199–200modifiers,199permissionsseealsoprivilegeserrorlogging,180mysql_setpermissionscript,680retrievingpermissionsforfiles,240,241triggers,MySQL,771views,MySQL,780persistencePDO_ATTR_PERSISTENTattribute,560persistentconnections,692personalattribute,messages,379pfsockopenfunction,367phonenumbersValidate_USpackage,PEAR,227PHP(PersonalHomePage)Apachedocumentation,19changeofPHPabbreviation,2codereuse,259commoninstallationpitfalls,18configuration,19–41hidingdetails,521–522security,516–520constants,68controlstructures,78–89CrackLibextension,340–341customizingUnixbuild,17–18customizingWindowsbuild,18datatypes,50–57delimitingcodeasPHP,43–46documentation,19downloading,10–11embeddingPHPcodeinHTML,43–46enablingIMAPextension,18errorreportinglevels,30escapesequences,76expressions,68–75fileuploads,346–355generallanguagefeatures,4–7history,1–4identifiers,57–58installing,11–17licensingconflictswithMySQL,11loadingtabledatawith,856–857MySQLextension,689–718output,47–50passingPHPvariableintoJavaScriptfunction,311–313variables,58–67webforms,303–313PHP4,2–3PHP5,3–4SOAPextension,502–512GNOMEXMLlibrary,503PHP5.
1Date(DateandTimeLibrary),288–301PHPauthentication,326–336authenticationmethodologies,328–336authenticationvariables,327–328PHPconfigurationdirectives,22–41seealsoconfigurationdirectivesApachehttpd.
confand.
htaccessfiles,21comments,21creatingSOAPserver,507–508listofdirectivesallow_call_time_pass_reference,25allow_url_fopen,39always_populate_raw_post_data,37arg_separator.
input,33arg_separator.
output,33asp_tags,23auto_append_file,36auto_detect_line_endings,39auto_prepend_file,36default_charset,36default_mimetype,36894INDEXdefault_socket_timeout,39define_syslog_variables,40disable_classes,27disable_functions,27display_errors,31display_startup_errors,31doc_root,37docref_ext,32docref_root,32enable_dl,38engine,22error_append_string,32error_log,33error_prepend_string,32error_reporting,30expose_php,29extension,40extension_dir,38file_uploads,38from,39highlight.
bg,28highlight.
comment,28highlight.
default,28highlight.
html,28highlight.
keyword,28highlight.
string,28html_errors,32ignore_repeated_errors,31ignore_repeated_source,31ignore_user_abort,28implicit_flush,25include_path,37java.
class.
path,41java.
home,41java.
library,41java.
library.
path,41log_errors,31log_errors_max_len,31magic_quotes_gpc,35magic_quotes_runtime,35magic_quotes_sybase,36max_execution_time,29max_input_time,29memory_limit,29open_basedir,27output_buffering,23output_handler,24post_max_size,35precision,23register_argc_argv,34register_globals,33register_long_arrays,34report_memleaks,32safe_mode,26safe_mode_allowed_env_vars,26safe_mode_exec_dir,26safe_mode_gid,26safe_mode_include_dir,26safe_mode_protected_env_vars,27sendmail_from,41sendmail_path,41serialize_precision,25short_open_tag,23SMTP,40smtp_port,41track_errors,32unserialize_callback_func,25upload_max_filesize,39upload_tmp_dir,38user_agent,39user_dir,38variables_order,33y2k_compliance,23zend.
ze1_compatibility_mode,22zlib.
output_compression,24zlib.
output_handler,24manipulating,20–22modifying,22php.
inifile,20scope,22syntaxhighlighting,28PHPDataObjectsseePDOPHPExtensionCommunityLibrary(PECL),340phpfunction,Smarty,464PHPreflectionAPIseereflectionAPIPHPscriptsreferencingPOSTdata,304php.
inifile,20comments,21installingApache/PHPonWindows,16installingPHPonLinux/Unix,13PDOconstructors,560syntax,20whenchangestakeeffect,21php_admin_flagkeyword,21php_admin_valuekeyword,21PHP_AUTH_PWauthenticationvariables,PHP,327hardcodedauthentication,329PHP_AUTH_USERauthenticationvariables,PHP,327hardcodedauthentication,329php_flagkeyword,21PHP_INI_ALLdirective,22PHP_INI_PERDIRdirective,22PHP_INI_SYSTEMdirective,22PHP_INI_USERdirective,22php_valuekeyword,21php5ts.
dllfileinstallingApache/PHPonWindows,14PHP'sbaseexceptionclass,185895INDEXphpinfofunctionhidingconfigurationdetails,522phpinfofunctionverifyingPHPinstallation,16,17PHPIniDirdirectiveinstallingApache/PHPonWindows,15phpMyAdmin,626–627PHPUnitpackage,PEAR,260pingcommand,mysqladminclient,620pingingserver,394–395pipe(|)operator,193--pipeoption,mysqlclient,609pointersmovingfilepointer,249,250retrievingfilepointerposition,250polymorphism,135POP3protocolIMAPprotocol,372openingconnectionstoPOP3mailboxes,374--portoption,mysqlclient,609,611--portoption,mysqlimport,854portparameter,MySQL,601portabilitystoredroutinesdisadvantages,746portsc-clientlibraryconfusion,373creatingportscannerwithfsockopen(),366creatingportscannerwithNMap,395defaultportsforinternetservices,364establishingport80connection,365establishingsocketconnections,365–367MySQLsecurity,662settingporttoconnecttoserver,368POSIXregularexpressionfunctions,195–198POSIXregularexpressionsyntax,193–195POSTmethodalways_populate_raw_post_datadirective,37arg_separator.
inputdirective,33passingdatabetweenscripts,304referencingPOSTdatainPHPscripts,304$_POSTsuperglobalvariable,65POSTvariablesnamingconventions,304post_max_sizedirective,PHP,35fileupload/resourcedirectives,347workingwithmultiplefileuploads,355postalCodemethodValidate_USpackage,PEAR,227PostgreSQLPDOsupporteddatabases,559precedence,operators,69,70precisionserialize_precisiondirective,25precisiondirective,23precisionspecifier,printf,49predefinedcharacterranges,194prefetchingPDO_ATTR_PREFETCHattribute,560prefixingleftmostprefixing,821preforkmultiprocessingmoduleinstallingPHPonLinux/Unix,12preg_grepfunction,Perl,201preg_matchfunction,Perl,201preg_match_allfunction,Perl,201preg_quotefunction,Perl,202preg_replacefunction,Perl,203preg_replace_callbackfunction,Perl,203preg_splitfunction,Perl,204preparemethod,mysqli_stmt,736preparemethod,PDO,564,565preparedstatementsboundparameters,735boundresults,735mysqliextensionenhancements,719PHPDataObjects,563,564–567caution:mysqliextension,564queries,mysqliextension,735–741presentationallogicseparatingbusinesslogicfrom,448Smartytemplatingengine,450,454–464templatingenginesand,448prevarrayfunction,114PRIMARYKEYattribute,MySQL,649–650primarykeyindexes,MySQL,818–819NULLvalues,819uniqueness,818usingmeaningfulvalues,819--printoption,mysqlclient,609printstatement,47print_rarrayfunction,105printfstatement,PHP,49privatedesignationcachingsessionpages,431privatefields,139privatemethods,145privilegetablesstoredroutines,747–749privilegesseealsoauthenticationaddingprivilegestousers,678authorization,663COLUMN_PRIVILEGEStable,657columns_privtable,666,674GRANT/REVOKEcommands,676–681granting,679managedbyGRANT/REVOKEcommands,677MySQLaccessprivilegesystem,663–675MySQLuserandprivilegemanagement,675–683procs_privtable,666,674reviewing,682revoking,680896INDEXSCHEMA_PRIVILEGEStable,657TABLE_PRIVILEGEStable,657tables_privtable,666,673tracingconnectionrequest,665userprivilegecolumns,usertable,669userprivileges,MySQLextension,690usertableandrequestauthorization,666USER_PRIVILEGEStable,658User/Host/Db/taskmatch,671proctablestoredroutineprivilegetables,747Proc_privcolumnprocs_privtable,675PROCESSprivilege,677Process_privcolumnusertable,667,669processesmysql_list_processesfunction,716processlistcommand,mysqladminclient,620procs_privtablecolumnoverview,674MySQLaccessprivilegesystem,674privilegeverificationprocess,666storedroutineprivilegetables,748procset,749producttablecreating,557,794gourmetdatabasediagram,775MySQLextension,PHP,690mysqliextensionsampledata,721profilemanagerinterfaceintegratingtriggersintoWebapplications,777programmingmysqliextension,720--promptoption,mysqlclient,618promptsmodifyingmysqlprompt,618properties,OOP,140–143creatingcustomgettersandsetters,142getter(_get)method,142PHPlimitations,140ReflectionPropertyclass,175setter(_set)method,140protectedfields,139protectedmethods,146--protocoloption,mysqlclient,611proxiesgeneratingC#proxyforWebService,513NuSOAPdesignatingHTTPproxy,501NuSOAP,creatingamethodproxy,495usingNuSOAP'sProxyclass,495proxyclasses,NuSOAP,493proxy_hostparameter,SoapClient,503proxy_loginparameter,SoapClient,503proxy_passwordparameter,SoapClient,503proxy_portparameter,SoapClient,503PTR(PointerRecord)recordtype,DNS,360publicdesignationcachingsessionpages,431publicfields,138encapsulating,138publicmethods,145:punct:characterclass,195putenvfunctionsafe_mode_protected_env_varsdirective,518Qquantifiersregularexpressions,193,194Perlstyle,198queries,MySQL,694encapsulatingqueriesseeviews,MySQLmysql_db_queryfunction,695mysql_queryfunction,695pagedoutput,803–806PHPDataObjects,562–564replicatingqueriesseeviews,MySQLsubqueries,808–812tabular_outputmethodsortingresults,802queries,mysqli,726–741multi_querymethod,733multiplequeries,733–735mysqli_multi_querymethod,733mysqli_querymethod,726mysqli_real_querymethod,727parsingresults,730–733preparedstatements,735–741queryexecution,726–728readyingresultset,728–730real_querymethod,728recuperatingquerymemory,728queries,SQLite,540–541sqlite_array_queryfunction,543sqlite_queryfunction,540sqlite_unbuffered_queryfunction,541QueryBrowser,MySQL,627–629querycachingdescription,578MySQL4and,578reasonsforMySQLpopularity,575querymethod,mysqli,727querymethod,PDO,563queryoptimizationindexes,MySQL,817questionmarkparameterspreparedstatements,PDO,565quotesenablingmagicquotes,35magic_quotes_gpcdirective,35magic_quotes_runtimedirective,35magic_quotes_sybasedirective,36usingquotesinprogramming,35897INDEXRr(-r)option,myisamchkclient,624randomvaluesreturningrandomvaluesfromarrays,129shufflingvaluesinarrays,129rangearrayfunction,108read_buffer_sizeparameter,MySQL,601readablefilescheckingiffilereadable,241readdirfunction,251readfilefunction,248readingldap_readfunction,405readingdirectory'scontents,251–252readingfiles,244–249readlinkfunction,235read-onlycursors,MySQL,813READSSQLDATAcharacteristicstoredprocedures,751RealSimpleSyndication(RSS),476–486introduction,473MagpieRSS,479–486MoreoverTechnologies,476RSSaggregators,476RSSfeeds,476publicationofRSSfeeds,477RSSsyntax,478SharpReaderinterface,477real_querymethod,mysqli,728realpathfunction,231recentattribute,messages,380,383recentlyvieweddocumentindexexamplesessionhandling,439–441--recoveroption,myisamchkclient,624recursivefunctions,63,97RedHatLinuxrunlevels,594RedHatPackageManagerseeRPMreferenceassignmentvariabledeclaration,PHP,59reference,passingargumentsbyallow_call_time_pass_referencedirective,25referencesattribute,messages,384REFERENCESprivilege,677References_privcolumndbtable,671hosttable,672usertable,667,670referentialintegrityreasonsforusingtriggers,768referer_checkdirective,430reflectionAPIclassescomprising,170othertasksusing,176PEARpackagesdependingon,176ReflectionClassclass,170ReflectionMethodclass,172ReflectionParameterclass,174ReflectionPropertyclass,175reflection,OOP,169–176description,157introspection,170ReflectionClassclass,170ReflectionMethodclass,172ReflectionParameterclass,174ReflectionPropertyclass,175refreshcommand,mysqladminclient,620regionmethodValidate_USpackage,PEAR,227register_argc_argvdirective,34register_globalsdirective,33register_long_arraysdirective,34register_tick_functionfunction,PHP,78registration.
phpfilepassworddesignation,338registrycaution:PEAR_ENV.
regfile,263regularexpressions,192–205alternativestoregularexpressionfunctions,214–222brackets([]),193Perlregularexpressionsyntax,198–205functions,200–205metacharacters,199–200modifiers,199PHPregularexpressionfunctions,195–198pipe(|)operator,193POSIXregularexpressionsyntax,193–195predefinedcharacterranges,194quantifiers,193–194reloadcommand,mysqladminclient,620RELOADprivilege,677Reload_privcolumnusertable,667,669REMOTE_ADDR,$_SERVERsuperglobal,65renamefunction,253RENAMEUSERcommand,MySQL,676renamingentriesldap_renamefunction,417REPAIRTABLEcommand,MySQL,824REPEATstatementstoredroutines,759Repl_client_privcolumnusertable,667,670Repl_slave_privcolumnusertable,667,670--replaceoption,mysqlimport,855REPLACEoptionLOADDATAINFILEstatement,850replaceparameter,headerfunctionauthentication,PHP,327898INDEXreplicationbackingupInnoDBtables,839mysqliextensionenhancements,720reasonsforMySQLpopularity,575REPLICATIONCLIENTprivilege,677REPLICATIONSLAVEprivilege,677reply_toattribute,messages,380reply_toaddressattribute,messages,380report_memleaksdirective,32reportingsensitivitylevelerror_reportingdirective,178$_REQUESTsuperglobalvariable,67requestattributeNuSOAPdebuggingfeature,502requestauthorizationseeauthorizationrequestverificationseeauthorizationREQUEST_URI,$_SERVERsuperglobal,65REQUIRECIPHERoption,684REQUIREISSUERoption,684REQUIRESSLoption,684requirestatementfunctionlibraries,100PHP,88Smartytemplatingengine,452REQUIRESUBJECToption,684REQUIREX509option,684require_oncestatement,89autoloadingobjects,OOP,155resetarrayfunction,113resourcedatatype,PHP,53resourcehandling,PHP4,2resourcesfileI/O,242limitinguserresources,682PHPdirectives,29responseattributeNuSOAPdebuggingfeature,502RESTRICTkeyword,MySQL,788resultsetsbufferedresultsets,729manipulatingresultsetpointer,SQLite,546–548MySQLtriggersand,770mysqliextension,728–730parsing,SQLite,541–544retrievingdetails,SQLite,544–546sqlite_currentfunction,546sqlite_has_morefunction,546sqlite_nextfunction,547sqlite_rewindfunction,547sqlite_seekfunction,547results,MySQLcustomizingviewresults,MySQL,783pagedresults,793results,mysqlibinding,740free_resultmethod,728more_resultsmethod,735mysqli_free_resultmethod,728mysqli_more_resultsmethod,734mysqli_store_resultmethod,729mysqli_use_resultmethod,730next_resultsmethod,735store_resultmethod,729use_resultmethod,730retrieveBiofunction,NuSOAP,498retrievingLDAPdata,404returnkeyword/statementreturningmultiplevalues,96returningvaluesfromfunctions,95returnstatement,PHP,78return_pathattribute,messages,380reusingsoftware,475REVOKEcommand,MySQLaccessprivilegesmanagedby,676,677background,675column-levelprivileges,680deletingusers,681previouslyassignedprivileges,680syntax,679table-levelpermissions,680tipswhenworkingwith,681userandprivilegemanagement,679–681rewindfunction,250rewritefeature,Apache,315right_delimiterattributeusingCSSinconjunctionwithSmarty,467rmdirfunction,252rollbackdatabasetransactions,831InnoDBtablehandlerexample,838,839MySQLtransactionstips,840rollbackmethod,mysqli,742rollbackmethod,PDO,572Romannumeralsconvertingnumeralformats,261rootdoc_rootdirective,37,519docref_rootdirective,32DocumentRootdirective,Apache,523hidingsensitivedata,523rootuserpassword,MySQL,662Routine_namecolumnprocs_privtable,674Routine_typecolumnprocs_privtable,675ROUTINEStable,657rowCountmethod,PDO,564rowscreatingmorereadablerowoutputwithHTML_Table,797fetch_rowmethod,mysqli,733insertingrowsviaviews,789mysql_affected_rowsfunction,705mysql_fetch_rowfunction,697899INDEXmysql_num_rowsfunction,705mysqli_fetch_rowmethod,732retrievingmultiplerows,storedroutines,765sqlite_changesfunction,546sqlite_last_insert_rowidfunction,541sqlite_num_rowsfunction,546RPCimplementationofXML-RPCprotocol,261RPM(RedHatPackageManager)installingMySQLonLinux,584–586learningmoreabout,585uninstallingMySQLonLinux,586rsortarrayfunction,120rtrimfunction,strings,223runlevelsRedHatLinux,594S\soption,mysqlclient,617-soption,mysqlclient,609stypecode,datatypes,738safemodeconfiguringPHPsecurely,516–518effectofenabling,516PHPdirectives,25–28sql.
safe_modedirective,520safe_modedirective,26,516–517safe_mode_allowed_env_varsdirective,26,518safe_mode_exec_dirdirective,26,518safe_mode_giddirective,26,517safe_mode_include_dirdirective,26,517safe_mode_protected_env_varsdirective,27,518safe_mysqld,597safe-show-databaseparameter,MySQL,663--safe-updatesoption,mysqlclient,612,617safe-user-createparameter,MySQL,663salestable,794importingandexportingdata,845save_handlerdirective,427save_pathdirective,428scalabilitydatabasebasedauthentication,331PHP4features,2scandirfunction,252schemacommand,SQLite,537schema,MySQLINFORMATION_SCHEMA,656–659,773schema,SQLitetableschemas,548SCHEMA_PRIVILEGEStable,657SCHEMATAtable,657schemaTargetNamespacemethodgeneratingWSDLdocument,499scopenestingfunctions,97passingargumentsbyreference,93passingargumentsbyvalue,92PHPconfigurationdirectives,22scopeattributeconfig_loadfunction,Smarty,466scope,PHPvariables,60–63functionparameters,61globalvariables,61localvariables,60staticvariables,62scriptparameterinserttag,Smarty,463scripttagdelimitingPHPcode,45scriptingcross-sitescripting,524searches,MySQL,826–830Booleanfull-textsearches,824extendingsearchcapabilities,827full-textsearch,829textsearching,818searchingldap_listfunction,405ldap_readfunction,405ldap_searchfunction,404sectionattributeconfig_loadfunction,Smarty,466sectionfunction,Smarty,459sectionelsefunction,Smarty,461securityadvantagesofusingviews,780configuringPHPsecurely,516–520changingdocumentextension,522configurationparameters,518–520expose_phpdirective,521hidingconfigurationdetails,520–522safemode,516–518safe_modedirective,516–517stoppingphpinfoCalls,522cross-sitescripting,524dataencryption,528–532expose_phpdirective,28,29filedeletion,524hidingsensitivedata,522–523LDAPmodels,400LOADDATAINFILEstatement,853,856MySQL,575,661–687seealsoMySQLsecurityNuSOAPconnections,502--passwordoption,mysqlclient,608programmingsecurelyinPHP,515–532register_globalsdirective,33sanitizinguserdata,524–528escapeshellargfunction,526escapeshellcmdfunction,527functionsfor,526htmlentitiesfunction,527strip_tagsfunction,528securingconnectioninformation,693Smartytemplatingengine,450SQLSECURITYcharacteristic,751900INDEXSQLite,535storedroutinesadvantages,746storingconnectioninformation,693variablefunctions,100SEEK_CUR/SEEK_END/SEEK_SETmovingfilepointer,249seenattribute,messages,384SELECT.
.
.
INTOstatementSELECTINTOOUTFILE,847–849storedroutines,752SELECTcommand,mysqlusingmysqlininteractivemode,614SELECTprivilege,677SELECTquerymysql_fetch_arrayfunction,698mysql_*functions,696–699select_dbmethod,mysqli,721,725Select_privcolumndbtable,671hosttable,672usertable,666,669selectingdata,MyISAM,634selfkeywordstaticclassmembers,153senderattribute,messages,381senderaddressattribute,messages,380sendingmessagesimap_mailfunction,387sendmail_fromdirective,41mailfunction,368sendmail_pathdirective,41mailfunction,368sequences,MySQLAUTO_INCREMENTattribute,648serializationunserialize_callback_funcdirective,25serializemethodNuSOAPerrorhandling,501serialize_handlerdirective,430serialize_precisiondirective,25$_SERVERsuperglobalvariable,65Servererrorfaultstringattribute,NuSOAP,500serversignatureexpose_phpdirective,521serversembeddedMySQLserver,578mysql_get_server_infofunction,717PDO_ATTR_SERVER_INFOattribute,561PDO_ATTR_SERVER_VERSIONattribute,561server-sidecursors,MySQL,813ServerSignaturedirective,Apache,520ServerTokensdirective,Apache,521servicesinternetservices,364–365$_SESSIONvariable,67sessionhandlerfunctionssession_close,441session_destroy,442session_garbage_collect,442session_open,441session_read,441session_set_save_handler,442session_write,441sessionhandling,425–446seealsocookiesautologinexample,437–439configurationdirectives,427–432creating/deletingsessionvariables,434customMySQL-basedsessionhandlers,442–445definingcallbackhandlers,430destroyingasession,433determininghowsessionpagesarecached,431encoding/decodingsessiondata,435howtheprocessworks,426managingobjectswithinsessions,429recentlyvieweddocumentindexexample,439–441retrievingandsettingSID,434sessiondirectivesauto_start,429,433cache_expire,431cache_limiter,431cookie_domain,429cookie_lifetime,429,437cookie_path,429entropy_file,430entropy_length,431gc_divisor,430gc_maxlifetime,432gc_probability,430hash_bits_per_character,432hash_function,431name,429referer_check,430save_handler,427save_path,428serialize_handler,430use_cookies,428use_only_cookies,428use_trans_sid,431sessionfunctionssession_close,441,443session_decode,436session_destroy,433,442,444session_encode,435session_garbage_collect,442,444session_id,434session_open,441,442session_read,441session_register,434session_set_save_handler,442901INDEXsession_start,433session_unregister,434session_unset,433session_write,441,443startingasession,432storingsessioninformation,427unsetfunction,434url_rewriter.
tagsdirective,432userdefinedsessionhandlers,441–445tyingintoPHPlogic,442verifyinglogininformationusingsessions,438session-handlingsupport,PHP4,3sessioninfotablecustomMySQL-basedsessionhandlers,442SETdatatype,MySQL,647SETcommandSETPASSWORD,591storedroutines,752setAttributemethod,PDO,561setCancelTextmethodAuth_HTTPclass,PEAR,336setClassmethodcreatingSOAPserver,510setcookiefunction$_COOKIEsuperglobal,66setDaymethod,Date/TimeLib.
,291setDMYmethod,Date/TimeLib.
,290setFetchModemethod,PDO,571setFirstDowmethod,Date/TimeLib.
,300setHTTPProxymethodNuSOAPdesignatingHTTPproxy,501setJulianmethod,Date/TimeLib.
,292setLastDowmethod,Date/TimeLib.
,301setlocalefunction,PHP,279setMonthmethod,Date/TimeLib.
,292setPersistencemethodcreatingSOAPserver,510setter(_set)methodcreatingcustomgettersandsetters,142properties,140setToLastMonthDaymethod,Date/TimeLib.
,300setToWeekdaymethod,Date/TimeLib.
,298settypefunction,56setYearmethod,Date/TimeLib.
,293sharedmemory,mysqlclient,612SharpReaderinterface,477shellcommands,252–253systemlevelprogramexecution,254–258shellsyntaxcomments,PHP,46SHELL,$_ENVsuperglobal,67shell_execfunction,258shorttagscaution:XMLclash,45delimitingPHPcode,44short_open_tagdirective,23shorttags,44showattributesectionfunction,Smarty,460SHOWCREATEstatement,MySQL,763SHOWCREATEVIEWstatement,MySQL,787SHOWDATABASEScommand,MySQL,651SHOWDATABASESprivilege,MySQL,677SHOWENGINEScommand,MySQL,640SHOWGRANTSFORcommand,MySQL,682SHOWSTATUScommand,mysql,615SHOWSTATUSstatement,MySQL,762SHOWTABLEstatement,MySQL,655SHOWTABLEScommand,mysql,613SHOWTRIGGERScommand,MySQL,772SHOWVARIABLEScommand,mysql,614SHOWVIEWprivilege,MySQL,677Show_db_privcolumnusertable,667,670Show_view_privcolumndbtable,672hosttable,672usertable,667,670shufflingaddingvaluesinarrays,130shufflearrayfunction,129shutdowncommands,mysqladminclient,620SHUTDOWNprivilege,677Shutdown_privcolumnusertable,667,669SIDcookiesstoring,426generationprocedure,430hash_bits_per_characterdirective,432hash_functiondirective,431persistenceusingURLrewriting,426retrievingandsetting,434sessionhandlingusingSID,425session_idfunction,434use_trans_siddirective,431--silentoption,mysqlclient,609--silentoption,mysqlimportutility,855SimpleXML,486–491functions,486–488methods,488–491asXMLmethod,489attributesmethod,488childrenmethod,489xpathmethod,490SimpleXMLextension,474simplexml_import_domfunction,488simplexml_load_filefunction,487simplexml_load_stringfunction,488simplicity,5singlequotesstringinterpolation,76single-columnnormalindexes,MySQL,820single-dimensionalarrays,104sizeattribute,messages,384902INDEXsizevariable$_FILESarray,348size_limitparameter,ldap_search(),404sizeofarrayfunction,117--skip-column-namesoption,mysqlclient,612skip-innodbparameter,MySQL,836skip-name-resolveparameter,MySQL,601,663skip-networkingparameter,MySQL,601,663skip-show-databaseparameter,MySQL,663SMALLINTdatatype,MySQL,645Smartyclassinstantiating,452Smartytemplatingenginecaching,450,468–471$cache_lifetimeattribute,468creatingmultiplecachespertemplate,470is_cachedmethod,469performance,471comments,454configurationfilesconfig_loadfunction,465creating,465–466CSSand,465referencingconfigurationvariables,466controlstructures,457–462elsestatement,458foreachstatement,458foreachelsestatement,459ifstatement,457sectionfunction,459sectionelsefunction,461creatingsimpledesigntemplate,452displaymethod,453features,449insertingbannerintotemplate,463installing,450–452instantiatingSmartyclass,452introduction,449–450makingavailabletoexecutingscript,452presentationallogic,450,454–464referencingconfigurationvariables$smarty.
configvariable,466get_config_varsmethod,466hashmark,466requirestatement,452security,450statements,462–464fetchstatement,462includestatement,462include_phpfunction,464inserttag,463literaltag,464phpfunction,464syntaxoftypicalSmartytemplate,449syntaxoftypicaltemplate,448templatecompilation,450using,452–454usingCSSinconjunctionwith,467variablemodifiers,454–457capitalizefunction,454count_wordsfunction,455date_formatfunction,455defaultfunction,456strip_tagsfunction,456truncatefunction,456$smarty.
configvariablereferencingconfigurationvariables,466SMARTY_DIRconstant,451SMTPdirective,40mailfunction,367SMTPprotocolimplementationof,260smtp_portdirective,41mailfunction,368SOA(StartofAuthorityRecord)recordtype,DNS,361SOAP,491–512C#SOAPclient,513clientandserverinteraction,511–512boxingclient,511boxingserver,511creatingSOAPclient,503–506getFunctionsmethod,504getLastRequestmethod,505getLastResponsemethod,505SoapClientconstructor,503SoapClientconstructor,503–504creatingSOAPserver,506–511addFunctionmethod,509addingclassmethods,510configurationdirectives,507–508exportingallfunctions,509getQuotefunction,509handlemethod,509setClassmethod,510setPersistencemethod,510SoapServerconstructor,508introduction,474NuSOAP,492–502PHP5'sSOAPextension,502–512soap.
wsdl_cache_dirdirective,508soap.
wsdl_cache_enableddirective,508soap.
wsdl_cache_ttldirective,508soap_faultclassNuSOAPerrorhandling,500,501SOAP_PERSISTENCE_REQUESTmode,511SOAP_PERSISTENCE_SESSIONmode,511soap_versionparameterSoapClientconstructor,504SoapServerconstructor,508SoapClientclassconstructor,503–504actorparameter,503compressionparameter,503creatingSoapClientobject,504903INDEXexceptionsparameter,503loginparameter,503optionsparameter,503passwordparameter,503proxy_hostparameter,503proxy_loginparameter,503proxy_passwordparameter,503proxy_portparameter,503soap_versionparameter,504traceparameter,504wsdlparameter,503SoapServerclassconstructor,508actorparameter,508optionsparameter,508soap_versionparameter,508wsdlparameter,508SOAPx4seeNuSOAPsocialsecuritynumbers(SSNs)usingValidate_USpackage,PEAR,227--socketoption,mysqlclient,609--socketoption,mysqlimport,855socketconnectionsseealsoportsestablishing,365–367fsockopenfunction,365–367pfsockopenfunction,367socketfiletype,232socketfiles,mysqlclient,611softwareasaservice,475sortarrayfunction,118sortflagsarray_multisortflags,121sort_flagsparameter,118sortingldap_sortfunction,411tabularoutput,MySQL,802sourcecodeinstallationdownloadingApache,10downloadingPHP,11sourcecommand,mysql,616sourceinstallationinstallingMySQLonLinux,587–588:space:characterclass,195spatialextensions,MySQL4,578specialcharactersconvertingintoHTML,211insertingbackslashdelimiterbefore,202spellcheckerGoogle'sWebService,494splitfunctionfilebasedauthentication,330regularexpressions,197splitifunction,198sprintfstatement,PHP,50SQLSECURITYcharacteristicstoredprocedures,751SQLServerPDOsupporteddatabases,558sql.
safe_modedirective,520sql_regcasefunction,198SQLite,535–553binarydata,549–550characteristics,535closingconnections,539command-lineinterface,536–537creatingaggregatefunctions,551–553creatingandoverridingSQLitefunctions,550–551creatingtableinmemory,539directives,537–538helpoption,536installing,536licensing,535manipulatingresultsetpointer,546–548objectorientation,539openingconnections,538–539parsingresultsets,541–544PDOsupporteddatabases,559PHP'sSQLitelibrary,537–553queryingdatabase,540–541retrievingresultsetdetails,544–546security,535tableschemas,548transactions,535sqliteoptionstoringsessioninformation,427SQLitesupportPHP5features,4sqlite.
assoc_casedirective,538sqlite_array_queryfunction,543SQLITE_ASSOCparsingqueryresults,542SQLITE_BOTHparsingqueryresults,542sqlite_changesfunction,546sqlite_closefunction,540sqlite_columnfunction,543sqlite_create_aggregatefunction,552sqlite_create_functionfunction,550sqlite_currentfunction,546sqlite_escape_stringfunction,549sqlite_fetch_arrayfunction,541,542sqlite_fetch_column_typesfunction,548sqlite_fetch_singlefunction,544sqlite_fetch_stringfunction,544sqlite_field_namefunction,545sqlite_has_morefunction,546sqlite_last_insert_rowidfunction,541sqlite_nextfunction,547SQLITE_NUMparsingqueryresults,542sqlite_num_fieldsfunction,545sqlite_num_rowsfunction,546904INDEXsqlite_openfunction,538,539sqlite_popenfunction,539sqlite_queryfunction,539,540sqlite_rewindfunction,547sqlite_seekfunction,547sqlite_udf_decode_binaryfunction,551sqlite_udf_encode_binaryfunction,551sqlite_unbuffered_queryfunction,541SQLSTATEcodes,562squarebracketoffsetsyntaxchangeinPHP5,192SquirrelMail,373SRV(ServicesRecord)recordtype,DNS,361SSL(SecureSocketsLayer)connectingusingSSL-enabledclient,686description,578determininguser'sSSLrequirements,683effectofencryptiononperformance,687installingOpenSSLlibrary,683MySQL4and,578NuSOAPfeatures,493REQUIRESSLoption,684secureconnections,NuSOAP,502startingSSL-enabledMySQLserver,686storingSSLoptionsinmy.
cnffile,686SSLconnectionsc-clientlibraryconfusion,373SSLoptions,mysqlimport--ssloption,685,855--ssl-caoption,685--ssl-capathoption,685--ssl-certoption,685--ssl-cipheroption,685--ssl-keyoption,686ssl_ciphercolumnusertable,667ssl_typecolumnusertable,667ssnmethodValidate_USpackage,PEAR,227StandardConfigurationMySQLConfigurationWizard,590,591standardversion,MySQL,583startattributesectionfunction,Smarty,460STARTTRANSACTIONcommandconformingtoSQL-99syntax,837MySQLtransactionstips,839STARTINGBYoptionLOADDATAINFILEstatement,851start-slavecommand,mysqladmin,620statfunction,234stateseesessionhandlingstateabbreviationsusingValidate_USpackage,PEAR,227statelessnesssessionhandlingandcookies,425statementspreparedstatements,PDO,564–567Smartytemplatingengine,462–464staticclassmembers,OOP,152–153selfkeyword,153staticMyISAM,634staticvariablesvariablescope,PHP,62statistics\soption,mysqlclient,617mysql_statfunction,715STATISTICStable,657STATUS(SHOWSTATUS)statementstoredroutines,762statuscommand,mysqladmin,620statusoption,mysqlclient,617stepattributesectionfunction,Smarty,460stmtobjectseepreparedstatementsstopatfirstmatchPerlregularexpressionmodifier,199stop-slavecommands,mysqladminclient,620stopwords,MySQLfulltextindexes,823ft_max_word_lenparameter,824ft_max_word_len_for_sortparameter,824ft_min_word_lenparameter,824ft_stopword_fileparameter,824reasonforignoring,824storageengines,MySQL,574,631–641ARCHIVE,638availabilityonservers,640BerkeleyDB(BDB),637BLACKHOLE,640convertingISAMtablestoMyISAMtables,641CSV,639EXAMPLE,640FEDERATED,637HEAP,631,635InnoDB,632MEMORY,635MERGE,636MyISAM,633–635specifyingatcreationtime,641usingonWindows,640usingseveralinsamedatabase,641withfastresponsetime,641store_resultmethod,mysqli,729storedfunctionsseestoredroutines,MySQLstoredproceduresseealsostoredroutines,MySQLattributes,750characteristics,750905INDEXCOMMENTcharacteristic,751CONTAINSSQLcharacteristic,751creating,749description,579DETERMINISTICcharacteristic,751LANGUAGESQLcharacteristic,750MODIFIESSQLDATAcharacteristic,751MySQL5and,579MySQLtriggersand,770parameters,749privilegeverificationprocess,666READSSQLDATAcharacteristic,751SQLSECURITYcharacteristic,751storedroutinesand,747storedroutines,MySQL,745–766seealsostoredproceduresadvantages,746ALTERstatement,761BEGIN/ENDblock,754CALLstatement,753callingfromanotherroutine,761CASEstatement,755conditionalstatements,755conditions,764CREATEstatement,749creating,749–751DECLAREstatement,751declaringvariables,751deleting,762DELIMITERstatement,754disadvantages,746DROPstatement,762ELSEstatement,755executing,753finishedvariable,757,764generalreasonsforusing,745handlers,764IF-ELSEIF-ELSEstatement,755implementing,747–764inputparameters,750integratingintoWebapplications,764–765ITERATEstatement,756iterativestatements,756LEAVEcommand,757LOOPstatement,757managingroutines,754modifying,761multistatementstoredroutines,753–760NOTFOUNDcondition,757,764privilegetables,747–749proctable,747procs_privtable,748REPEATstatement,759retrievingmultiplerows,765SETstatement,752settingvariables,752SHOWCREATEstatement,763SHOWSTATUSstatement,762viewingcreationsyntax,763viewingstatus,762whentouse,747WHILEstatement,760str_ireplacefunction,219str_padfunction,223str_replacefunction,219str_word_countfunction,225strcasecmpfunction,207strcmpfunction,206strcspnfunction,207streamfilters,391stream_context_createfunction,391stream_filter_appendfunction,393stream_filter_prependfunction,393stream_get_filtersfunction,392streams,390–393contexts,391streamfilters,391streamwrappers,390strftimefunction,PHP,281–282stringcomparisonfunctions,206–208stringconversionfunctionsconvertingHTMLtoplaintext,214convertingplaintexttoHTML,210–213manipulatingstringcase,208–209orderoffunctionexecution,212stringdatatype,PHP,51stringdatatypes,MySQL,646–647stringfunction'sactionscapitalizingfirstletter,209comparisonofstringscaseinsensitive,207casesensitive,206concatenatingarrayelements,217convertingcharactersintobracketedexpressions,198convertingcharactersintoreplacementvalue,213convertingnewlinecharactersintoHTML,210convertingspecialcharactersintoHTML,211convertingtoalllowercaseletters,208convertingtoalluppercaseletters,208convertingunusualcharactersintoHTML,210countingoccurrencesofsubstring,221countsnumberofcharacters,224countsoccurrencesofspecifiedcharacters,207countsnumberofwords,225delegatingstringreplacementprocedure,203determiningstringlength,205dividingintoarrayofsubstrings,216dividingstringbasedondelimiters,215caseinsensitive,198casesensitive,197stringdivision,204906INDEXfindinglastoccurrenceofparameter,218findingpositionofparametercaseinsensitive,218casesensitive,217inserting\delimiterbeforespecialcharacters,202paddingstringtonumberofcharacters,223parsingintovariousvariables,215removingcharactersfrombeginning,222removingcharactersfrombeginningandend,223removingcharactersfromend,223removingHTMLandPHPtags,214replacingalloccurrencesofpattern,203replacingpatterncaseinsensitive,197casesensitive,196replacingstringscaseinsensitive,219casesensitive,219forpartofstring,222returningremainderofstringafteroccurrenceofparameter,219betweenparameters,220searchingallelementsofanarray,201searchingforpatterncaseinsensitive,196casesensitive,195occurrencesintoarray,201true/false,201translatingHTMLintotext,213translatingtextintoHTML,212stringfunctionscount_chars,224eregregularexpression,195ereg_replaceregularexpression,196eregiregularexpression,196eregi_replaceregularexpression,197explode,216get_html_translation_table,212htmlentities,210htmlspecialchars,211implode,217join,217ltrim,222nl2br,210parse_str,215preg_grep,201preg_match,201preg_match_all,201preg_quote,202preg_replace,203preg_replace_callback,203preg_split,204rtrim,223splitregularexpression,197splitiregularexpression,198sql_regcaseregularexpression,198str_ireplace,219str_pad,223str_replace,219str_word_count,225strcasecmp,207strcmp,206strcspn,207strip_tags,214stripos,218strlen,205strpos,217strrpos,218strspn,207strstr,219strtok,215strtolower,208strtoupper,208strtr,213substr,220substr_count,221substr_replace,222trim,223ucfirst,209ucwords,209stringhandling,PHP5,4stringinterpolation,PHP,75–77doublequotes,75heredocsyntax,77singlequotes,76stringmanipulation,205–226Perlregularexpressionmetacharacters,199Perlregularexpressionmodifiers,199stringoffsetsyntaxchangeinPHP5,191–192stringoperators,71stringparsing,6stringserror_append_stringdirective,32error_prepend_stringdirective,32highlight.
stringdirective,28localizedformats,280strip_tagsfunctionsanitizinguserdata,528Smartytemplatingengine,456stringmanipulation,214striposfunction,218strlenfunction,205strposfunction,217strrposfunction,218strspnfunction,207strstrfunction,219strtokfunction,215strtolowerfunction,208strtotimefunction,284strtoupperfunction,208strtrfunction,213subclass,OOP,162subDaysmethod,Date/TimeLib.
,294907INDEXsubjectattribute,messages,380,384subMonthsmethod,Date/TimeLib.
,295subnetconverter,395–397subqueries,MySQL,808–812databasemaintenancewith,811description,578determiningexistencewith,809–811introduction,793MySQL4,578performingcomparisonswith,809usingwithPHP,811substrfunction,220exampleusing,240substr_countfunction,221substr_replacefunction,222subtraction(-)operator,71subWeeksmethod,Date/TimeLib.
,296subYearsmethod,Date/TimeLib.
,297SUPERprivilege,677Super_privcolumnusertable,667,670superglobalvariables,PHP,63–67$_COOKIE,66$_ENV,67$_FILES,66$_GET,65$_GLOBALS,67$_POST,65$_REQUEST,67$_SERVER,65$_SESSION,67switchstatement,PHP,81SybasePDOsupporteddatabases,559symboliclinkscreating,235retrievinginformationabout,233retrievingtargetof,235symlinkfunction,235syntaxhighlighting,PHP,28syslogdefine_syslog_variablesdirective,40errormessagesin,181syslogfunctionerrorlogging,182syslogprioritylevels,LOG_XYZ,182systemcommands,252–253systemfunction,256systemlevelprogramexecution,254–258backtickoperator,257delimitingarguments,255escapingshellmetacharacters,255executingoperatingsystemlevelapplication,256returningbinaryoutput,257executingshellcommands,257,258outputtingexecutedcommand'sresults,256sanitizinginput,254systemprogramssafe_mode_exec_dirdirective,518systemservices,MySQLsecurity,662T\Toption,mysqlclient,617\toption,mysqlclient,617tableattributes,MySQLseedatatypeattributes,MySQLtablehandlers,MySQL,574tableschemas,SQLite,548table_cacheparameter,MySQL,601TABLE_CONSTRAINTStable,657Table_namecolumncolumns_privtable,674tables_privtable,673Table_privcolumntables_privtable,673,674TABLE_PRIVILEGEStable,657tablesALTERTABLEstatement,656changingtablestructure,656copyingtables,654creatingtables,653temporarytables,654withHTML_Table,798default-table-typeparameter,600deletingtables,656description,631grantingtable-levelprivileges,679loadingtabledatawithPHP,856–857MySQLstorageengines,631–641mysql_list_tablesfunction,707mysql_tablenamefunction,707privilegeverificationprocess,666proctable,storedroutines,747procs_privtable,storedroutines,748revokingtable-levelprivileges,680TIMESTAMPdefinitions,643,644tweakingtablestyleswithHTML_TableandCSS,797updatingtablesviaviews,788view_table_propertiesfunction,712viewingavailabletables,655viewingtableproperties,MySQLextension,712viewingtablestructure,655virtualtablesseeviews,MySQLTABLEStable,657tables_privtableaccesscontrolstages,664columnoverview,673MySQLaccessprivilegesystem,673privilegeverificationprocess,666tableset,673tabulardateclassesCalendarpackage,PEAR,286908INDEXtabularoutput,MySQLcreatingwithPEAR,794–802introduction,793sorting,802tabular_outputmethod,mysqliclass,799sortingqueryresults,802tagsstrip_tagsfunction,Smarty,456tarfiles,260TCPprotocol,mysqlclient,611TCPsockets,260technicianprofileintegratingtriggersintoWebapplications,777--teeoption,mysqlclient,612templatecompilation,Smarty,450templatesdirectorycreatingsimpledesigntemplate,452installingSmarty,451templates_cdirectoryinstallingSmarty,451templatingengines,447–449benefitsof,448delimiters,448separatingpresentationalfrombusinesslogic,448Smartytemplatingengine,449–471syntaxoftypicalSmartytemplate,449syntaxoftypicaltemplate,448TEMPORARYkeywordCREATETABLEstatement,654TEMPORARYtableMySQLtriggersand,770TEMPTABLEalgorithmviews,MySQL,785TERMINATEDBYoptionLOADDATAINFILEstatement,851ternary(==)operator,74testingfacilitatingunittests,260userbandwidth,397–398textfulltextindexes,822TEXTdatatype,MySQL,647textfileserrormessagesin,181textsearchingindexes,MySQL,818thiskeywordaccessingprivatefields,139referringtofields,OOP,137staticfields,153thread_cache_sizeparameter,MySQL,602threadsback_logparameter,MySQL,599innodb_file_io_threads,834mysql_thread_idfunction,716throwinganexception,183ticks,78register_tick_function,78unregister_tick_function,78tiersdatabaseabstractionlayers,555timeCalendarpackage,PEAR,285–288CoordinatedUniversalTime,271default_socket_timeoutdirective,39localizedformats,280max_execution_timedirective,29,519max_input_timedirective,29standardizingformatfor,271TIMEdatatype,MySQL,643timefunction,PHP,278timefunctions,PHPseedateandtimefunctions,PHPtime_limitparameter,ldap_search(),404timeoutsinnodb_lock_wait_timeout,835PDO_ATTR_TIMEOUTattribute,560Timestampcolumncolumns_privtable,674procs_privtable,675tables_privtable,673,674TIMESTAMPdatatype,MySQL,643TIMESTAMPdefinitionspreversion4.
1.
2tables,643versions4.
1.
2andnewer,644timestampsretrievingfile'slastaccesstime,238retrievingfile'slastchangedtime,238retrievingfile'slastmodificationtime,239settingfilemodification/accesstimes,253Unixtimestamp,271Windowslimitation,276TINYBLOBdatatype,MySQL,647TINYINTdatatype,MySQL,645TINYTEXTdatatype,MySQL,647TLS(TransportLayerSecurity)ldap_start_tlsfunction,402tmp_namevariableFILES($_FILES)array,348to[]attribute,messages,381toaddressattribute,messages,381totalspaceidentifyingondiskpartition,236totalpagesvariablepagedoutput,MySQL,807touchfunction,253traceparameterSoapClientconstructor,504tracesgetTracemethod,186getTraceAsStringmethod,186track_errorsdirective,32,180909INDEXtransactions,832–836ACIDacronym,831beginningtransactions,839buildingtransactionalapplicationswithPHP,840–842DDLrollbacks,840description,631,831InnoDBconfigurationparameters,833InnoDBtablehandlerexample,836–840InnoDBtables,633MyISAMtables,634MySQLtriggersand,770mysqliextension,741–742mysqliextensionenhancements,719nesting,840nontransactionaltables,840PDO(PHPDataObjects),572SQLite,535systemrequirements,832tablecreation,InnoDB,833tipsforusing,839verifyingInnoDBtableavailability,832whentouse,839with-innodboption,832TransportLayerSecurity(TLS)protocolldap_start_tlsfunction,402triggers,767–778ad/ai/auprefixesintriggername,772aftertriggers,768beforeoraftertriggers,769namingconventions,772bd/bi/buprefixesintriggername,772beforetriggers,768beforeoraftertriggers,769namingconventions,772cascadingtriggers,775–776caution:droppingadatabase,774creating,771deleting,774description,579,767DROPTRIGGERstatement,774INFORMATION_SCHEMAdatabase,773integratingintoWebapplications,776–778limitationsusing,770modifying,774multipletriggers,770MySQL5and,579MySQLversionsupportfor,770namingconventions,772permissionrequirements,771reasonsforusing,768SHOWTRIGGERScommand,772tasksbenefitingfrom,767uniqueness,770variablefunctions,99viewing,772–774TRIGGERStable,657trimfunction,strings,223truncatefunction,Smarty,456trunktableInnoDBtablehandlerproject,836addingdata,837checkingdata,838try.
.
.
catchblockcatchingmultipleexceptions,188exceptionhandling,184PHP5features,4typeattribute,messages,383typecasting,PHP,54typecodes,datatypes,738typeconversion,PHPoperatorsand,69typehinting,147typeidentifierfunctions,PHP,57typejuggling,PHP,55typerelatedfunctions,PHP,56typespecifiersprintfstatement,49typevariable$_FILESarray,348types,PHPisidenticalto(===)operator,73TypicalinstallationinstallingMySQLonWindows,589typinggenerallanguagefeatures,5U-uoption,mysqlclient,608-Uoption,mysqlclient,612ucfirstfunction,strings,209ucwordsfunction,strings,209udateattribute,messages,381UID(userID)retrievinguserIDoffileowner,240uidattribute,messages,384UID/GIDcheckssafe_mode_include_dirdirective,26umaskfunction,241UNDEFINEDalgorithmviews,MySQL,785UNICODEattributeCHARdatatype,MySQL,646UNIQUEattribute,MySQL,650uniqueindexes,MySQL,819–820uniqueness,MySQLindexes,817PRIMARYKEYattribute,649,650primarykeyindexes,818unittests,260UnixinstallingPEARon,262Unixepoch,272Unixtimestamp,271910INDEXunknownfiletype,232UnknownMySQLserverhost.
.
.
error,724unregister_tick_function,PHP,78unseenattribute,messages,381unserialize_callback_funcdirective,25unsetfunction,sessions,434UPDATEprivilege,677UPDATEquerymodifyingdataindatabase,703updatingtablesviaviews,788Update_privcolumndbtable,671hosttable,672usertable,667,669updatesInnoDBtables,633sqlite_changesfunction,546UPLOAD_ERR_FORM_SIZE,350UPLOAD_ERR_INI_SIZE,350UPLOAD_ERR_NO_FILE,351UPLOAD_ERR_OK,350UPLOAD_ERR_PARTIAL,351upload_max_filesizedirective,39fileupload/resourcedirectives,347workingwithmultiplefileuploads,355upload_tmp_dirdirective,38fileupload/resourcedirectives,347uploadsfileuploads,HTTP,345–346fileuploads,PHP,346–355HTTP_Uploadclass,PEAR,355–357:upper:characterclass,195URLrewritingallowing/restrictingwhenusingcookies,428referer_checkdirective,430retrievingsessionname,426SIDpersistenceusing,426url_rewriter.
tagsdirective,432use_trans_siddirective,431url_rewriter.
tagsdirective,432URLsarg_separator.
outputdirective,33onetimeURLsrecovering/resettingpasswords,341userfriendlyURLs,313–317usability,websitesnavigationalcues,313–323USAGEprivilege,677USEcommand,MySQLdesignatingdatabase,652usingmysqlininteractivemode,613use_cookiesdirective,428use_only_cookiesdirective,428use_resultmethod,mysqli,730use_trans_siddirective,431--useroption,mysqlclient,608--useroption,mysqlimport,855useraccountsonserver,MySQL,662userauthenticationtabledatabasebasedauthentication,331IPaddressbasedauthentication,333userbandwidthtesting,397–398Usercolumncolumns_privtable,674dbtable,671hosttable,672procs_privtable,674tables_privtable,673usertable,666,668usercommunityreasonsforMySQLpopularity,577userfriendlyURLsApachelookbackfeature,314,315–316navigationalcues,313–317PHPcode,316useridentificationusername@hostnamecombination,669userloginadministration,337passworddesignation,337–339passwordguessability,339–341recovering/resettingpasswords,341userparameter,MySQL,602userprivilegecolumnsusertable,669userprivilegesMySQLextension,PHP,690userprofilesignore_user_abortdirective,28userregistrationpassworddesignation,337–339usertableaccesscontrolstages,664Alter_privcolumn,670Alter_routine_privcolumn,670columnoverview,666Create_privcolumn,669Create_routine_privcolumn,670Create_tmp_table_privcolumn,670Create_user_privcolumn,670Create_view_privcolumn,670Delete_privcolumn,669Drop_privcolumn,669Execute_privcolumn,670File_privcolumn,669Grant_privcolumn,669Hostcolumn,668Index_privcolumn,670Insert_privcolumn,669Lock_tables_privcolumn,670MySQLaccessprivilegesystem,666–671Passwordcolumn,668privilegeverificationprocess,665Process_privcolumn,669911INDEXReferences_privcolumn,670Reload_privcolumn,669Repl_client_privcolumn,670Repl_slave_privcolumn,670Select_privcolumn,669Show_db_privcolumn,670Show_view_privcolumn,670Shutdown_privcolumn,669Super_privcolumn,670Update_privcolumn,669Usercolumn,668userprivilegecolumns,669user_agentdirective,39user_dirdirective,38,520USER_PRIVILEGEStable,658userauthtabledatabasebasedauthentication,331IPaddressbasedauthentication,333usersautologin,sessionhandling,437creatingusers,675,681deletingusers,681GRANTcommandaddingprivilegesto,678GRANTcommandcreating,678limitinguserresources,682MySQLuserandprivilegemanagement,675–683PHP_AUTH_USERauthenticationvariable,327privilegeverificationprocess,665retrievinguserIDoffileowner,240REVOKEcommanddeleting,681sanitizinguserdata,524–528simultaneousconnectionsforusers,664usortarrayfunction,123UTC(CoordinatedUniversalTime),271V-Voption,mysqlclient,609-voption,mysqlclient,609Validate_USpackage,PEAR,226–227installing,226phoneNumbermethod,227postalCodemethod,227regionmethod,227ssnmethod,227using,227validationCalendarpackage,PEAR,286reasonsforusingtriggers,768valueassignmentvariabledeclaration,PHP,59valuesldap_comparefunction,411ldap_get_valuesfunction,406ldap_get_values_lenfunction,406ldap_mod_delfunction,418ldap_sortfunction,411varparameterinserttag,Smarty,463VARCHARdatatype,MySQL,646BINARYattribute,646NATIONALattribute,646variablefunctions,99securityrisk,100variablemodifiers,Smarty,454–457--variable-nameoption,mysqlclient,609variablescommand,mysqladminclient,620variables,PHP,58–67authenticationvariables,327–328superglobalvariables,63–67variabledeclaration,58–60explicitlydeclaration,59referenceassignment,59valueassignment,59variablescope,60–63functionparameters,61globalvariables,61localvariables,60staticvariables,62variablevariables,67variables_orderdirective,33vehicletable,809--verboseoption,mysqlclient,609--verboseoption,mysqlimport,855--versionoption,mysqlclient,609--versionoption,mysqlimport,855versioncommand,mysqladminclient,620VersionMismatcherrorfaultstringattribute,NuSOAP,500versionsmysqld-versionparameter,MySQL,601PDO_ATTR_CLIENT_VERSIONattribute,561PDO_ATTR_SERVER_VERSIONattribute,PDO,561--verticaloption,mysqlclient,612view_db_propertiesfunction,712view_table_propertiesfunction,712views,MySQL,779–791advantagesofusing,780ALGORITHMattribute,784–785MERGEalgorithm,785TEMPTABLEalgorithm,785UNDEFINEDalgorithm,785ALTERVIEWstatement,788creating,781–782customizingviewresults,783deletingviews,788description,579encapsulatingqueries,779executing,782–783passinginparameters,783incorporatingintoWebapplications,789–790insertingrowsviaviews,789modifyingreturnedcolumnnames,784912INDEXmodifyingviewdefinition,788MySQL5and,579MySQLtriggers,770MySQLversionsupportfor,780permissionrequirements,780updatingtablesviaviews,788usingclauseswith,783usingfunctionswith,783viewingviewdefinition,786–787DESCRIBEstatement,786INFORMATION_SCHEMAdatabase,787SHOWCREATEVIEWcommand,787WITHCHECKOPTIONclause,785VIEWStable,658virtualtables,MySQLseeviews,MySQLW-Woption,mysqlclient,609w3schoolswebsiteformstutorialsonline,304Webapplicationsincorporatingviewsinto,789–790integratingtriggers,776–778webapplicationsintegratingstoredroutines,764–765webformsautoselectingformsdata,310–311example,304–305formstutorialsonline,304generatingformswithPHP,308–310passingdatabetweenscripts,304passingformdatatofunction,306passingPHPvariableintoJavaScriptfunction,311–313PHPandwebforms,303–313workingwithmultivaluedformcomponents,307–308webpagesdisplayingmodificationdate,283WebServices,473–514highprofiledeployments,475MagpieRSS,479–486NuSOAP,492–502consumingaWebService,494–495creatingamethodproxy,495–496debuggingtools,501designatingHTTPproxy,501errorhandling,500–501generatingWSDLdocument,499–500publishingaWebService,496–498returninganarray,498–499secureconnections,502RealSimpleSyndication,473,476–486reasonsfor,474SimpleXML,474,486–491SOAP,474,491–512PHP5'sSOAPextension,502–512support,PHP5,4usingC#clientwith,512–514websiteusabilitynavigationalcues,313–323WHILEstatementstoredroutines,760whilestatement,PHP,81whitespacecharactersPerlregularexpressionmodifier,199predefinedcharacterranges,195widthspecifier,printfstatement,49Wikipedia,580wildcardsGRANTcommand,MySQL,681WindowsautomaticallystartingandstoppingMySQL,595–596enablingPHPMySQLextensionon,690PHPandMySQLlicensingissues,582takingadvantageofstorageengineson,640usingC#clientwithPHPWebService,512–514WindowsinstallationsdownloadingMySQL,583downloadingPHP,11installingMySQL,588–591installingPEARon,263WITHCHECKOPTIONclauseviews,MySQL,785without-mysqloptionenablingPHPMySQLextensiononLinux,689wordscountsnumberofwordsinstring,225wrappersstreamwrappers,390writeablefilescheckingiffilewriteable,241WSDL(WebServicesDefinitionLanguage)creatingSOAPserver,506configurationdirectives,507NuSOAPfeatures,493generatingWSDLdocument,499–500obtaining,494wsdlparameterSoapClientconstructor,503SoapServerconstructor,508wsdl_cache_dirconfigurationdirective,508wsdl_cache_enabledconfigurationdirective,508wsdl_cache_ttlconfigurationdirective,508X-Xoption,mysqlclient,612,618X509REQUIREX509option,684x509_issuercolumnusertable,667913INDEXx509_subjectcolumnusertable,667:xdigit:characterclass,195XMLGNOMEXMLlibrary,503outputtingmysqlqueryresultsin,618SimpleXML,486–491asXMLmethod,489SOAPdefinition,491--xmloption,mysqlclient,612,618XMLsupport,PHP5,4XML_Parserpackage,PEAR,261XML_RPCpackage,PEAR,261XML-RPCprotocolimplementationof,261XORoperator,73xpathmethod,SimpleXML,490Yy2k_compliancedirective,23Yahoo!
prominentMySQLusers,580YEARdatatype,MySQL,644ZZendscriptingengine,2zend.
ze1_compatibility_modedirective,22ZEROFILLattribute,MySQL,651ZIPcodeusingValidate_USpackage,PEAR,227zipfilesmanagementof,260zlib.
output_compressiondirective,24zlib.
output_handlerdirective,24Zmievski,Andrei,449