decidingheadersalreadysent

INDEXNumbersandsymbols@symbol,626,659*/symbol,300.
.
/symbol,105/*symbol,300+(additionoperator),306,308&(ampersand)symbol,657=(assignmentoperator),299\(backslash),303–304\\(backslash)escapesequence,303}(closingcurlybrace)escapesequence,303](closingsquarebracket)escapesequence,303.
=(combinedconcatenationoperator),304,333.
(concatenationoperator),304,638:(conditionaloperator),316–317{}(curlybraces),303,336–337,668--(decrementoperator),306–307/(divisionoperator),306$(dollarsign),298,303""(doublequotes),301–305//(doubleslash),300=(equalto),535,581==(equalityoperator),299,313>(greaterthan)operator,313–314,536,581,583,642>=(greaterthanorequalto)operator,314,536,583#(hashsign),300===(identicaloperator),314++(incrementoperator),306–307(notequal)operator,314,502,536,581!
==(notidentical)operator,314INDEX732{(openingcurlybrace)escapesequence,303[(openingsquarebracket)escapesequence,303%(percentagesign),537,579,583,589–594;(semicolon),297,331,418-(subtractionoperator),306_(underscore)character,589–594Aabsolutepositioning,25,171accesslevels,contentdisplayaccordingto,513–514accessrestrictionsforindividualpages,511–512Seealsouserregistrationsystemsaccessibilityissues,withSpry,189,670accessibilityoptions,forms,253–254.
Accordionselector,231.
AccordionFocusedselector,232.
AccordionPanelselector,231.
AccordionPanelContentselector,232.
AccordionPanelOpenselector,232.
AccordionPanelTabselector,232.
AccordionPanelTabHoverselector,232accordionwidget,229–239changingdefaultswithobjectinitialization,236–238changingopenpanel,236–237colorselection,235–236convertingtoflexibleheight,237–238editingandstyling,232–236inserting,230openingfromalink,238–239structure,230–232stylerules,231–232actionattribute,249,330–331Actionfield,251ActiveServerPages(ASP),37,73additionoperator(+),306,308ADDTControlPanel,702AdobeBridgeCS3,2AdobeCreativeSuite,2–3AdobeDeviceCentral,2,24–25AdobeDreamweaverDeveloperToolbox(ADDT),698,702AdobeLabs,654Advancedselector,145AES_ENCRYPT(),516Ajaxaccessibilityproblemswith,60introductionto,34limitationsof,38–39alias,usingfordatamanipulation,543Allmode(CSSStylespanel),141–142allow_url_fopen,622,633,706allow_url_include,93allow_url_open,93Amazon,36ANDkeyword,536,583,588AP(absolutelypositioned)elements,18–20Apache,37–38,73casesensitivity,83changingdefaultport,83–86creatingvirtualhostson,110–115disabling,79downloadingsoftware,73installinginparallelwithIIS,75installingonWindows,76–77runninginparallelwithIIS,83–86settingdefaultfilefor,108startingandstopping,onMacOSX,86–87startingandstopping,onWindows,79ApacheMonitor,runningonVista,78Apacheserverrootlocationof,107moving,107–108Appear/Fadeeffect,51–52arguments,passing,320arithmeticoperators,306–308,535–536arrayelements,308–310arrayindex,308arraykey,308arrays,40associative,310foreachloops,319indexed,308inspectingcontentsof,withprint_r(),310usingtostoremultiplevalues,308–311withzeroelements,482array_key_exists()function,332array_push()function,342ASP.
SeeActiveServerPagesASP.
NET,37,73assignmentoperator(=),299associativearrays,310asynchronouscommunication,38attributes,node,659autocompletion,30–31Autorefreshdataoption,661Bbackgroundcolors,54–55,167–169backgroundimages,adding,169–173backgroundproperty,147,168backslashes,303–304gettingridofunwanted,338–340backupscreating,424–426ofdatabase,424loadingdatafrom,426BalanceBracestool,336–337bashshell,amendingPATHin,414BBCOnlinenewsfeed,622BBEdit,62–64behaviorsapplying,43–45applyingmultipletotriggerelement,58–59editing,48–50removing,50restoringdeleted,50–51INDEX733Spryeffects,40–59triggereventsfor,41using,40–59Behaviorspanel,accessing,40–45BETWEENkeyword,583BETWEENminANDmax,536BeyondCompare,62–64binarydata,441BINARYkeyword,586binarylargeobject(BLOB),441Blindeffect,51–53BLOB(MySQLcolumntype),441Blockextracharactersoption,287blockproperty,147tag,176–178tags,duplicate,373Booleansearches,595–596Booleanvalues,312–313bordersadding,tomenubars,191properties,147boxproperties,148–149breakkeyword,320Bridge,16addingmetadata,17controllingthumbnails,17dragginganddroppingfiles,18renamingfiles,17browserbugs,23browsersecurityrestrictions,XMLsourcedataand,654BuildFilterarea,645built-inCSSlayoutsaddingpullquote,176–178adjustingfonts,175–176applyingconditionalcomments,164–165choosing,163insertingimages,175–176linkingtoexternalstylesheets,164removingcomments,179–181stylerulelocations,163–165stylingapagewith,165–173addingbackgroundimages,169–173using,162–181linkingtoexternalstylesheets,164Ccache,118calculations,performing,306–307CASCADEoption(MySQL),528CascadingStyleSheets(CSS)attachingexternalstylesheets,144classes,138,662comments,removing,179–181controllingpagestructurewith,677–678creatingsimple,138–140DreamweaverCS3featuresfor,136management,21–22properties,142–143,168Propertyinspectorand,136–138rules,defining,175settingpreferencesfor,156–158structure,22–23supportfor,18,23visualaidsfor,22–23SeealsoCSSlayouts;CSSpages;CSSselectors;CSSStylespanelcasekeyword,316casesensitivityofApache,83ofPHP,328oftablenames,438case-sensitivelinks,118case-sensitivesearches,586Ccheader,353CDATAsections,657,704,716cgi-bindirectory,249CHAR(MySQLcolumntype),439Charwidthoption,256charactercounter,Spry,288–289@charsetrule,166CheckBrowsercompatibilityfeature,23CheckNewUsernameserverbehavior,480–483,502,509,545checkboxgroup,Spryvalidation,289–291checkboxwidget,277,289–292checkboxes,262–267,354–356checkdate()function,615childnodespopulatingwithdynamicobjects,704Spryand,655–656Seealsonodeschildtables,523definingforeignkeyconstraintsin,527deletingrecordsfrom,523,567–568displayinglistofrecords,563–564insertingrecordsin,539–545updatingrecordsin,563–567chmod777,708classnames,149,264classselectors,145classesCSS,138,662tabbedpanelswidget,213–214client-serverrelationship,34–35,38client-sidetechnology,34–35client-sidevalidation,248,275–292,330Spryvalidationwidgets,277–292checkbox,289–292custompatterns,285–286drop-downmenuvalidation,292inserting,279limitationsof,278removing,279textareavalidation,286–289textfieldvalidation,280–285ValidateFormbehavior,275–277client-sideXSLT,621Cloakingcategory,125codecommenting,300includingfromotherfiles,364–388indenting,30reusing,withincludes,378–380CodeFormatcategory,156codehints,30–31,328,334–335,704,714–715codelibrary,JavaScript,38INDEX734Codeview,12,27–31,251Coderlayout,14Codingtoolbar,27–29ColdFusion,37CollapsiblePanelsselectors,240–241collapsiblepanels,239–244editingandstyling,241–243inserting,239openingfromlink,243–244structureof,239–241collation,446colname,577–579colorselectionaccordionwidget,235–236menubar,190–191,203–206tabbedpanels,218–222colorwheels,218columntypes,439–444columns,436addingindexesto,525combingcontentsof,insinglefield,543–545indexing,524NOTNULL,441numberof,438searchingmultiple,588searchingseveralsimultaneously,598combinedassignmentoperators,308combinedconcatenationoperator(.
=),304,333CommandLineClient,411–412commands,PHP,297commas,removing,639commentsaddingtoPHPscripts,300conditional,164–165removingCSS,179–181Commontab,Insertbar,9–10CommunityServer(MySQL),404comparisonoperators,313,535–536,581–583comparisons,oftwovalues,313–314CONCAT()function,543concatenationoperator(.
),304,638CONCAT_WS()function,543–545conditionalexpressions,testing,639–642conditionaloperator(:),316–317conditionalregionscreating,639–642multiple,640,642conditionalstatements,311–317Booleanvalues,312–313comparisons,313–314elsestatements,311elseifstatements,312if.
.
.
elsestatements,327ifstatements,311,332logicaloperators,314–315switchstatement,316true/falsetest,348wrappingrecordsetcodein,585–588constants,definingforsite-relevantpaths,369contact.
css,330content,dynamic.
SeedynamicdataContenttab,Bridge,17Content-Typeheader,351copyrightissues,707copyrightnotice,automaticallyupdating,375–378COUNT(*),599Counteroption(textareavalidationwidget),287CreativeSuite,2–3CSS.
SeeCascadingStyleSheetsCSSlayoutsaddingbackgroundimages,169–173addingpullquotes,176–178adjustingfonts,175–176applyingconditionalcomments,164–165choosing,163decidingwheretolocatestylerules,163–165insertingimages,175–176linkingtoexternalstylesheets,164ready-made,136removingcomments,179–181stylingapagewith,165–173using,162–181CSSpagesaddingpullquote,176–178adjustingfonts,175–176insertingimages,175–176usingbuilt–inlayoutsfor,162–181CSSpropertiesadding,168displayingonlyset,143displayingalphabetically,143displayingbycategory,142–143CSSRuleDefinitiondialogbox,146–152,175,177CSSselectorscasesensitivityof,167defining,145–146typesof,145CSSsignatures,167CSSStylespanel,20,140creatingnewstylerules,145–152definingproperties,146–152definingselectors,145–146Currentmode,141–142,168,173–174modes,141–142movingstylesrules,152–156opening,141Propertiespane,142–144stylingapagewith,165–173stylingSprymenubarswith,193–206CSSZenGarden,136cURL(ClientURLLibrary)extension,706–707curlybraces{},336–337,668Currentmode,CSSStylespanel,141–142,168,173–174currentnode,403current-nodedynamicplaceholder,638custompatterns,inSpry,285–286INDEX735Ddaemon,403datafiltering,withXSLTparameters,646–650insertingintoSETcolumns,454–457storingrelated,inseparatetables,520–530avoidingorphanedrecords,523definingdatabasetables,524–530linkingwithforeignkeys,521–523structurefor,520–521transferringbetweenservers,403,424–426datamanipulation,usingMySQLfunction,543–545dataretrieval,withsuperglobals,327–328datasetsactivatingeventhandling,688–691creatingdynamically,689–691displayingaslist,670displayinginSprytable,662–667distinguishingbetween,688handling,withSpryandPHP,59–60datasourcelocalXML,634–636selecting,684–686datasubmission,GETvs.
POSTmethods,259–260Datatab,Insertbar,10databasedesign,normalization,520–521databaserecordsdisplaying,457–459creatingrecordset,457–462individualrecords,462–467preservingintegrityof,480–487,489–490,492–493updatinganddeleting,474,493–507databasetables.
Seetablesdatabase-drivenwebsites,36databasescreatingbackupof,424–426creatinglocaltest,431deletingusersfrom,505–506displayingresultsfromqueries,572–580insertingrecordsin,441–457listingregisteredusersin,494–496movingbetweenservers,424–426MySQL,useraccountcreation,432–435preventingduplicateusernamesin,480–481querying,572–580querying,tocreaterecordset,457–459searchresults,improvingpresentationof,573–575searchingfortext,586–588multiplecolumns,588noresultsmessage,587–588partialmatches,589–598settingsearchcriteria,580–598withwildcardcharacters,589–594settingupMySQL,430–435storageofinformationin,436–441tabledesign,437–441DATE(MySQLcolumntype),440datecolumns,440date()function(PHP),608–611datesinMySQL,603–607,612–615inPHP,572,607–611validatingandformattingfordatabaseinput,612–615DATETIME(MySQLcolumntype),440,443DATE_FORMAT()function(MySQL),604–607debugging,commentingfor,300DECIMAL(MySQLcolumntype),440decrementoperator(--),306–307decryption,password,516DefaultDocumentType(DTD),5–7defaultencoding,6–7defaultextension,5defaultfileaddingtoIIS,109–110setting,onApacheonWindows,108defaultimagesfolder,117defaultselectors,editingmenubar,198–199definitionlists,670–674DELETEcommand(MySQL),538deleteform,addingcheckfordependentrecordsto,560deletepages,creating,497–500DELETEprivileges(MySQL),432DeleteRecordserverbehavior,558dependentrecords,deletingsimultaneously,560–563Deprecatedcategory,42descendantselectors,145.
VTabbedPanels,224,226accordionwidget,231–232DesignTimeStyleSheets,25,374–375Designview,13,372–373Designerlayout,14detailregions,684–687detailspage,displayingrecordcontentsin,464–467developmentenvironmentlocal,68settingup,68–100checkingremoteserverforsupportofPHP,69–70creatinglocaltestingserver,70–89DeviceCentral,24–25DisplayRecordCount,61display_errors,92–93,98–99DISTINCTkeyword,599Distinctonloadcheckbox,661DIV(MySQL),536INDEX736tags,18–20absolutelypositioned,25–26accordionwidgetsand,231forSlideeffect,56–58tabbedpanelswidgetsand,213wrappingmenubarin,193–195divisionoperator(/),306do…whileloops,318,600–603DOCTYPEdeclarations,373DocumentObjectModel(DOM),35,713documentpreferences,setting,5–7documentroot,82Documenttoolbar,12Documentwindow,11–13document-relativelinks,105,365,369documents,creatingnew,4–5doublequotes(""),301–305doubleslash(//),300DreamweaverCS3accessinghiddenfilesandfolders,15approachof,tolayout,25–27behaviors,40–59buildingofSQLqueriesby,576–580bundlingof,withAdobeCreativeSuite,2–3codehints,328,334–335,704,714–715creatingnewdocuments,4–5cross-browsercompatibilityprovidedby,35customizedlayouts,14–15definingPHPsitein,115–130definingsitedetails,117–118definingtestserver,121–125openingSitedefinitiondialogbox,115–116remoteserveraccess,119–121savingsitedefinition,126siteoptions,125–126troubleshooting,128–129displayingoptionaltoolbars,15hidingallpanels,15improvedhandlingofCSSin,136processingofXMLby,618rearrangingpanels,14serverbehaviors,474server-sideXSLThandlingby,623–624settingdocumentpreferences,5–7settinguptestenvironmentfor,68–100checkingPHPconfiguration,90–100checkingremoteserverforsupportofPHP,69–70creatinglocaltestingserver,70–89sitemanagement,131–132startingup,3–7trackingofusersby,513–515useofruntimevariablesby,577–579workspace,7–14DreamweaverExchange,3Dreamweaverextensions,40Dreamweaverpop-upmenus,42DreamweaverSystemColorPicker,219Dreamweavertemplates.
Seetemplatesdrop-downmenus,248,262,267–269,670–672gettingdatafrom,356–357populatingfromadatabase,540–545Spryvalidation,292DTD(DocumentTypeDefinition),5–7,669DualScreenlayout,14dump,database,424dynamiccodeaddingtoincludes,375–378testing,68dynamicdata,36applyingtoradiogroups,490–493displayof,bySpry,654displaying,299–300handling,withSpryandPHP,59–60DynamicList/Menudialogbox,541–542dynamicpagesclient-sidetechnologyfor,35embeddingXSLTFragmentin,632–633understanding,34dynamicsourcecreatingXMLdocumentfrom,707–711local,710dynamictextdisplaying,464–467formatting,withlinebreaks,467–469dynamicwebpagesadvantagesof,694Ajaxand,38–39basicconceptsof,39–40server-sidetechnologyand,35–38understanding,34Seealsowebpagesdynamicwebsites,402.
SeealsowebsitesEecho,299–301,310editableregions,addingtotemplate,391–393Effectsetting,52elementtriggerapplyingmultipleeventsto,58–59elementsformatting,643–644idattributesfor,45–47sorting,642–643supportedtarget,51–52elsestatements,311elseifstatements,312emailfilteringoutattacks,348–350gettingridofunwantedbackslashesin,338–340sending,withPHP,328–359INDEX737testing,337troubleshooting,338emailaddresses,328,352emailheaderinjection,348–350emailheaders,includinguseraddressin,350–354empty()function,342,356ENCODE()function,516encodingattribute,636encryptedpasswords,511,516Enctypeoption,251tag,669ENUM(MySQLcolumntype),440,443equalsign(=),differentmeanings,299,535,581equalityoperator(==),299,313eregfunctions,352errormessages,321–322forduplicateusernames,481MySQL,579suppressing,99errorsdisplayinginPHP,98fatal,321parse,302,321strict,322warning,321error_reporting,92–93escapesequences,instrings,303–304eventhandlers/handling,39,58,688–691eventlisteners,684events,39applyingmultiple,totriggerelement,58–59displayedindrop-downmenu,48trigger,41exclusiveORoperator(xor),315existingstylesheets,linkingto,164$expectedarray,342,354,583ExportRecordsetasXMLserverbehavior,699–701ExtensibleMarkupLanguage(XML).
SeeXMLExtensibleStylesheetLanguageTransformations.
SeeXSLTExtensionManager,2,40extensions,40,147externalcodelibraries,88externalfilesconvertingtoincludes,370–373include_pathfor,365–368includingtextandcodefrom,364–370,372–384,387–388externalstylesheetsattaching,144movingrulesbetween,155–156Ffalse,305,312–313fatalerrors,321Favoritestab,Insertbar,10–11fclose()function,708feedbackforms.
Seeformsfeedback.
php,convertingtousegenericscript,383–388fields,436bindingvaluestoupdateform,503–505combiningcontentsoftwocolumnsinsingle,543–545empty,441redisplayingcontentsof,afterformsubmittal,486–490tag,274fieldsets,274–275FileComparefeature,62settingup,61–62using,62–64file_get_contents()function,710fileuploads,enabling,99file_uploads,93filenameextensionsdisplayinginWindows,72–73forincludefiles,369–370filesaccessinghidden,15comparingversionsof,61–64dragginganddropping,18merginglocalandremoteversions,64renaming,withBridge,17writingsettingpermissionsfor,708usingPHP,708–711$_FILESarray,327FindandReplace,usingstoredqueryin,180–181firewalls,121Flash,35FLOAT(MySQLcolumntype),440folders,accessinghidden,15fontchanges,192–193,203–206Fontproperty,148fontsadjusting,175–176Propertyinspectorand,137–138footers,automaticallyupdating,375–378fopen()function,708forattribute,254forloops,318–319foreachloops,319,342,382foreignkeyconstraints,523defining,inInnoDBtables,526–530optionsfor,528referentialintegrityand,556removing,530setting,inphpMyAdmin,527foreignkeyscreating,520inserting,539–545linkingrecordswith,521–523NULLvaluesfor,539primarykeysand,521referentialintegrityand,523usingasprimarykey,525formelementsmultiplechoice,354–359checkboxes,354–356drop-downmenus,356–357multiple-choicelists,357–358radiobuttongroups,358–359organizing,274–275forminput,mergingwithmailprocessing,469–471format-number()(XSLT),644INDEX738formats,recognizedbytextfieldvalidationwidget,283–285FormMail,249tag,255formsactivating,327–359buildingsimplefeedback,248–262checkingrequiredfields,341–345client-sidevalidation,330deletepages,building,497–500design,GIGOprincipleand,480eventprocessingin,326–327fieldsets,adding,274–275filteringoutpotentialattacks,348–350GETvs.
POSTmethods,259–260hiddenfields,260–262inputvalidation,248,275–292insertinginCodeview,251insertingintoPHPpage,250–252introductionto,248multiple-choiceelements,262–273,354–359names,251pagetypesfor,248preservinguserinputonincomplete,345–347processingandacknowledgingmessagesfrom,330–336processingsubmitted,248redirectionstodifferentpages,359resetbuttons,255scripting,329–336sendingemail,328–359storinginputfrom,441–457styling,257–258testing,337–338textinputelements,adding,252–255textinputelements,settingpropertiesfor,255–256troubleshooting,338updatepages,building,497–500validatingfieldsin,481–486Formstab,Insertbar,10Fport,77Fromheader,350–354FTPaccess,119FTPoptions,120–121FULLTEXTindex,595–598limitationsof,596multiple-column,598functions,39,320passinganargumentto,320wrapper,41Seealsospecificfunctionsfwrite()function,708Ggarbagecollection,507$_GETarray,327GETmethod,259–260getdate()function,612–613GetSQLValueString()function,453,547,578–579GIGOprinciple,480globalaccess,setting,forwritingfiles,708–709goldshields,336GoLive,3greaterthan(>)operator,313–314,581,583greaterthanorequalto(>=)operator,314,583groupselector,145Grow/Shrinkeffect,51–54Hhashsign(#),300tags,21,373header()function,359,388,702headers,inserting,forXMLoutput,705"headersalreadysent"error,388headings,editingstylesfor,150hiddencharacters,displayof,30hiddenfields,informs,260–262Highlighteffect,51,54–55Hintoption,283horizontalmenubar,inserting,185–186Hostdirectoryfield,124Hoverclassaction,663.
htaccessfiles,100htdocsfolder,108HTMLentitiesdefining,636inXML,620HTMLpages,250tags,lockingcodeoutsideof,398htmlentities()function,346–347,503HTTPaddress,118Iidattributes,45–47,254,271assigning,throughPropertyinspector,45–46duplicate,45removing,47setting,withQuickTagEditor,46–47IDfield,254IDmenu,719IDselectors,145,719identicaloperator(===),314if.
.
.
elsestatements,317,327ifstatements,311,332IIS,38,73–75addingdefaultPHPfileto,109–110changingdefaultport,84–86registeringvirtualdirectorieson,115runninginparallelwithApache,83–86IISserverrootlocation,107imagegallery(casestudy)building,676–691activatingeventhandling,688–691addingdetailregions,684–687buildingthumbnailimages,679–684controllingstructure,677–678creatingdatasets,679–684INDEX739dynamicallyselectingdataset,677planning,676buildingwithPHP,717–725creatinggallerymenu,718–720creatingthumbnailsandlinks,721–722enhancingwithSpry,727–728generatingXMLsources,725–726mainimagedisplay,722–724makingnon-JavaScriptaccessible,717–728imagesaddingbackground,169–173aligning,149inserting,175–176wrappingtextaround,149implode()function,355–357,456@import,146IN()comparisonoperator(MySQL),536.
incfileextension,369.
inc.
phpfileextension,370includecommands,364–368includefilesadaptingmailprocessingscriptas,380–388addingdynamiccodeto,375–378brokenlinksin,374convertingnavigationmenuto,370–373creating,364–368displayingXHTMLoutput,370filenameextensionsfor,369–370forfooters,375–378"headersalreadysent"error,388pathfor,365–368problemswith,373–374reusingPHPcodewith,378–380site-root-relativelinkswith,368–369storageof,370styling,374–375usesof,369include()command,364includesfolder,updating,701–702include_once()command,364include_path,365–368incrementoperator(++),306–307index.
php,addingasdefaultfile,109–110indexedarrays,308indexedcolumns,528indexes,308,524–525inequalityoperator(!
=),314,502,536Initvaloption,256ini_set()function,99innerjoins,565InnoDBtables,404–407,524convertingtoMyISAMtables,527,597definingforeignkeyrelationshipin,526–530performingcascadedeletein,560–563supportfor,524InputTagAccessibilityAttributesdialogbox,253–254,264,268,270,720tag,248,345–346inputvalidation,248beforeformsubmission,275–292client-side,248,275–292Spryvalidationwidgets,277–292ValidateFormbehavior,275–277server-side,248,329validationalerts,280–282Insertbar,9–11INSERTcommand,537InsertDivTagdialogbox,194,680insertformsadaptingforupdates,553–555building,545–546creating,539insertpage,adaptingforupdates,566–567INSERTprivileges,432InsertRecordserverbehavior,483–484,493,542applying,450–453combiningwithmailprocessing,469–471elseclausewith,550removing,553–554InsertSpryRegiondialogbox,666,680InsertSpryTabledialogbox,662–663,665INT(MySQLcolumntype),439InterAKT,698Internet,client-serverrelationshipon,34–35invalidcode,highlighting,30in_array()function,342,356,583IPv6transfermode,121isset()function,343,354isSuspect()function,349–350is_array()function,342is_numeric(),614JJavaScript,35cross-browsercompatibilityof,35disabled,59enabled,38framework,38usingSprywithout,711–717imagegallery(casestudy),717–728JavaScriptobjects,41,228–229JavaServerPages(JSP),37KKollection,698Llanguagesupport,inMySQL,408layers,endof,18LayoutCSSmenu,163–165LayoutMode,26–27Layouttab,Insertbar,10INDEX740layoutsaddingbackgroundimages,169–173addingpullquotes,176–178adjustingfonts,175–176applyingconditionalcomments,164–165choosing,163insertingimages,175–176removingcomments,179–181stylerulelocations,163–165stylingapagewith,165–173usingbuilt-inCSS,162–181leftjoin,564–565tag,274lessthan(tags,214LIKEkeyword,536,589,592,594LIMITclause,537linebreaks,intext,467–469linenumbers,displayof,30line–heightproperty,148tag,154linkingtables,522linkscase-sensitive,118document-relative,105root-relative,105–106selectingdefaultstyleof,118site-root-relative,withincludes,368–369Linksrelativetooption,118listproperties,147listsdefinition,creating,671–674displayingdatasetsas,670–674LiveDataview,testingPHPsitewith,126–128Liyanage,Marc,88Local/Networkaccess,119localrootfolder,117localtestenvironment,68blockingApacheinstallation,77creating,70–89databasefor,431individualorall-in-oneinstallation,71settinguponMacOSX,86–89settinguponWindows,72–86checkingport80,75downloadingsoftware,73installingApache,76–77installingPHP,80–82preparinginstallationonVista,73startingandstoppingApache,79testingPHPinstallation,82–83troubleshooting,82softwareversionsfor,70localtestingoptions,122–123localhost,115LogInUserserverbehavior,509–513LogOutUserserverbehavior,509,512–513logicalANDoperator(&&),315,536logicaloperators,314–315,536logicalORoperator(||),315,536login,redirectingtopersonalpageafter,515loginsystems,creating,509–511log_errors,92–93LONGBLOB(MySQLcolumntype),441lookuptables,522loops,317–318do…while,318ending,320for,318–319foreach,319,382while,317MMacOSXaccessingphp.
inion,96–97installingMySQLon,412–418registeringvirtualhostson,113–115securingMySQLon,416–418serverrootlocation,107settingpermissionsin,708–709settinguplocaltestenvironmenton,86–89startingandstoppingApache,86–87upgradingPHPon,87–89usingMySQLmonitoron,418–419Macworkspace,8–9Macromedia,2magicquotes,93,338–340,346,493mailprocessingadaptingasinclude,380–388mergeforminputwith,469–471mail()function,328–359emailheaders,350–354fifthargumentfor,338,353testing,337–338troubleshooting,338mailtransportagent(MTA),329MAMP,71ManageSitesdialogbox,116,131–132many-to-manyrelationships,522marginproperty,148MarkoftheWeb,64mastertemplateaddingeditableregionsto,391–393creatingchildpagesfrom,393–398moving,391MATCHkeyword(MySQL),598Maxcharsoption,256,283max_execution_time,94mbstringextension,698MEDIUMBLOB(MySQLcolumntype),441menubarschangingcolorsandfonts,203–206changingwidth,190colorchanges,190editing,188–189,196–198editingdefaultselectors,198–199INDEX741inserting,196–198horizontal,185–186vertical,186–187removing,188settingwidths,199–203wrappingintags,193–195SeealsoSprymenubarmessagebody,329metadata,adding,toimages,17methodattribute,GETvs.
POST,259–260Methodmenu,251methods,228MicrosoftIIS.
SeeIISMicrosoftVista.
SeeVistaMicrosoftVisualSourceSafe,119MicrosoftWindows.
SeeWindowsMincharsoption,283missingrecords,564–565mixeddatatype,332mktime()function,609MMHTTPDB.
php,449_mmServerScriptsfolder,449MM_XSLTransformerrormessage,633MM_XSLTransform.
class.
php,622,624,633mobiledevices,previewingwebsiteon,24–25modulooperator,306–307,574–575MultifunctionalDatabaseoption(MySQL),407,410–411multilinetextarea,248multipleattribute,269–270multipletablesadvantagesofusing,520disadvantagesof,520insertingrecordsinchildtable,539–545managingcontentwith,538–568selectingrecordsfrom,530–534storingrelateddatain,520–530avoidingorphanedrecords,523definingdatabasetables,524–530linkingwithforeignkeys,521–523structurefor,520–521multiple-choiceformelements,262–273checkboxes,262–267drop-downmenus,267–269radiobuttons,262,272–273scrollablelists,269–271multiple-choicelists,262,357–358multiple-columnindexes,598multiplicationoperator(*),306MyISAMtables,404,523addingFULLTEXTindexto,598advantagesanddisadvantagesof,526convertingtoInnoDBtables,527MySQL,403addingtoPATH,414–416advantagesof,37configuringonWindows,406–411databasesetup,430–435defaultdatabases,430errormessages,579formattingdatesin,603–607formattingtimein,603–607installation,404–418onMacOSX,412–418onWindows,404–410interface,402introductionto,402–403securingonMacOSX,416–418startingandstopping,onWindows,411storingdatesin,612–615terminology,403useraccountcreation,432–435usingwithphpMyAdmin,419–424MySQLAdministrator,419mysql,variousmeaningsexplained,403MySQLconnections,60creating,447–449restricted,forvisitors,457site-relative-rootsand,453troubleshooting,449–452MySQLdatabasesinsertingdatain,695–696informationstoragein,436–441MySQLdateformatspecifiers,604MySQLEnterprise,404MySQLfunctionsAES_ENCRYPT(),516CONCAT(),543CONCAT_WS(),543–545COUNT(*),599datamanipulationwith,543–545DATE_FORMAT(),604–607ENCODE(),516fortwo-wayencryption,516RAND(),533MySQLmonitoronWindows,411–412using,418–419MySQLQueryBrowser,419MySQLWindowsEssentialschangingdefaulttabletype,410–411configuring,406–411mysql.
php,449mysqld,403mysql_data_seek()function,601mysql_fetch_assoc()function,603N\n(newline)escapesequence,303nameattribute,255,271namesarrayelement,309–310table,438variable,298naturallanguagesearches,595–596navigation.
Seesitenavigationnavigationmenu,convertingtoincludefile,370–373negation,314Netscape,35NewCSSRuledialogbox,177NewCSSStylebutton,719NewDocumentdialogbox,4–5NewDocumentPreferencesdialogbox,5–7INDEX742newsfeeds.
SeeRSSnewsfeedsNOACTIONoption,529nodetree,displaying,634–635nodes,626attributesof,659child.
Seechildnodescurrent,638determiningpositionof,inXMLhierarchy,631filtering,withXPath,644–646formatting,643–644selecting,627sorting,642–643Non-TransactionalDatabaseOnlyoption,407normalization,520–521notidenticaloperator(!
==),314NOTLIKEoperator,536NOTNULLoperator,441,525_notesfolder,375notices,321null,305,441,525NULLoption,529Numlinesoption,256numbers,40,306–308numericcolumns,439–440numericalcomparisons,581–583numericalrange,searchingwithin,583–586Oobjectinitiation,236–238objectliterals,229objects,40,228ONDELETECASCADE,561onchangeeventhandler,690onclickeventhandler,713,727one-to-manyrelationships,522onlineforms.
Seeformsopen()method,243–244openPanel()method,238–239open_basedir,94tag,267,542Optionsfromrecordsetdrop-downmenu,542ORkeyword,536,588–589ORDERBYclause,537orderedlists,670–672orphanedrecords,avoiding,523output,displayingselectively,644–650Ppaddingproperty,148PagePropertiesdialogbox,138–140pages.
Seewebpagespanelgroups,13–15parenttables,523cascading,560–563deletingrecordsfrom,523,556,560–563insertingrecordsin,545–550updatingrecordsin,551–555parent-childrelationships,626parseerrors,302,321partialmatches,589–598passinganargument,320Passwordoption,257passwordsencryptinganddecrypting,516root,409–411,416–418validating,481–486PATH,addingMySQLto,414–416pattern-matchingfunctions,352PCREfunctions,352percentagesign(%)aswildcardcharacter,589–594Perl-compatibleregularexpression(PCRE),348–349permissionssetting,forPHPtowritefiles,708personalpages,redirectingto,afterlogin,515PHP,34–37advantagesof,37–38arrays,308–311basicsof,296–322buildingwebsiteswith,withDreamweaver,60–61checkingremoteserversupports,69–70commands,297conditionalstatements,311–317configuringtodisplayerrors,98creatingimagegallerywith(casestudy),717–725creatinggallerymenu,718–720creatingthumbnailsandlinks,721–722enhancingwithSpry,727–728generatingXMLsources,725–726mainimagedisplay,722–724datesin,572,607–611downloadingsoftware,73embeddinginawebpage,296–297enablingfileuploadsandsessions,99errormessages,321–322extensions,enablinginWindows,98–99formattingdatesin,610–611functions,320garbagecollection,507generatingXMLsourceswith,725–726handlingofdynamicdataby,59–60individualorall-in-oneinstallation,71installing,onWindows,80–82loops,317–318outputdisplay,299–300previouslyinstalledversionsof,74–75processingformswith,248reusingcode,withincludes,378–380scriptingfeedbackforms,329–336sendingemailwith,328–359settingpermissionfor,towritefiles,708settingtimezonein,608superglobalarrays,327–328testinginstallation,82–83upgrading,onMacOSX,87–89usingtoprocessXSLT,621variables,298–299INDEX743workingwithnumbers,306–308writingtoafileusing,708,710–711PHPconfigurationchecking,90–100checkinginstalledextensions,95–96phpinfo()output,90php.
ini,90–91PHPCoresettings,92–94.
phpfileextension,296PHPfilesaddingdefaulttoIIS,109–110settingdefaultonApache,108PHPincludecommands,364–368PHPpagescreating,249–250asdatasource,701decidingwheretotest,68elementsof,297embeddingXSLTFragmentin,632–633importanceofsitedefinitionfor,104insertingforminto,250–252mixingwithHTMLpages,250PHPscriptsadaptingasincludes,380–388commenting,300quotesaround,301–304PHPsessionscheckingforenabled,509creating,507destroying,508UserAuthenticationserverbehaviorsand,513PHPsiteschoosinglocationfor,104–110defining,inDreamweaver,115–130definingsitedetails,117–118definingtestserver,121–125openingSiteDefinitiondialogbox,115–116remoteserveraccess,119–121savingsitedefinition,126siteoptions,125–126troubleshooting,128–129management,131–132PreviewinBrowsersettings,129–130testing,126–128usingDreamweavertemplatesin,389–398PHPsnippetscollection,339–340PHPstringsaddingtexttoexisting,304–305escapesequencesin,303–304joiningtogether,304PHPtablesaddingSpryfunctionalityto,714–716building,712–713PHPtags,296PHPvariables,96,578php.
inifile,74–75checkinglocationof,90–91editing,96,98–99phpinfo()function,69–70,320displayingoutputof,706outputof,90,96phpMyAdmin,435configuring,420–423creatinguserstablein,475–476definingtablein,444–446downloadingandinstalling,420generatingXMLwith,696–697interface,423launching,423loggingoutof,424settingforeignkeyconstraintsin,527usingMySQLwith,419–424pop-upmenus,42,184port80,75–77,83–86position()function(XSLT),631positioningproperties,147$_POSTarray,259–260,308,327,331–332,335checkboxesand,354–356drop-downmenusand,356–357multiple-choicelists,357–358radiobuttonsand,358–359POSTmethod,259–260post_max_size,94$_POSTvariables,automatingnamingof,341–342predefinedlists,440Preferencespanel,5–7CodeFormatcategory,156settingCSSpreferences,156–158PreviewinBrowsersettings,129–130primarykeys,436–437,493–494adding,toquerystring,462–464columnfor,442foreignkeysand,521message_id,462uniquenessof,522print,299–300,310print_r()function,310,327proceduralcode,388ProjectHoover,18Properties(Spry),228Propertiespane(CSSStylespanel),142–144,152Propertyinspector,13assigningidattributethrough,45–46fontsand,137–138problemswith,136–138tabbedpanelswidget,214–218textinputelements,255–256proxyscripts,usingtofetchremotefeed,706–707proxy.
php,710pseudo-classselector,145pseudo–elementselector,145pullquotes,adding,176–178Qqueries,saving,181querystrings,addingprimarykeyto,462–464QuickTagEditor,settingidattributewith,46–47quotationmarks,40efficientuseof,305runtimevariablesand,547singlevs.
double,301–304withinuserinput,345–346INDEX744R\r(carriagereturn)escapesequence,303RadioButtonoption,272radiobuttons,262,272–273bindingfieldvaluesto,503–505gettingdatafrom,358–359RadioGroupoption,272radiogroups,applyingdynamicvaluesto,490–493RAND()function(MySQL),533ranges,specifyinginSQLqueries,583–586RDS(RemoteDevelopmentServices),119ReconfigureInstanceoption(MySQLWindowsEssentials),410RecordInsertionFormWizard,476–480recordmanagement,withmultipletables,538–568RecordUpdateFormWizard,496records,436addingtotables,539avoidingorphaned,523checkingforduplicate,546–548counting,599deleting,538–563cascading,560–563deleting,fromchildtables,567–568displayingindividual,462–467displayinglistof,563–564findingincomplete,withleftjoin,565insertinginchildtables,539–545insertingintoparenttable,545–550insertingnew,537linkingwithforeignkeys,521–523many-to-manyrelationships,522missing,564–565one-to-manyrelationships,522pagingthroughlistof,551–553preventingduplicate,548–550primarykeysof,437retrieving,withSELECTcommand,535–537selectingfrommultipletable,530-–534sortorderof,446updating,538,551–555inchildtables,563–567recordsetdefinitions,725RecordsetdialogboxAdvancedmode,577,583Simplemode,576–577RecordsetNavigationBar,551–552RecordsetNavigationStatusdataobject,573–574RecordsetPaging,61recordsetscreating,60,457–462displayingresultsof,459–462eliminatingduplicatesfrom,599generatingXMLfrom,703–706reusinga,599–600,602wrappinginconditionalstatement,585–588redirections,afterlogin,515REFERENCESkeyword,528referentialintegrity,523,556registeredusers,listing,494–496register_globalssetting,94,328registrationformsbuilding,476–480completing,489–493Seealsoformsregularexpressions,179–181,348–349relationaldatabasemanagementsystem(RDBMS),430.
SeealsoMySQLremotefeedscopyrightissueswith,707fetchingwithproxyscript,706–707SeealsoRSSnewsfeedsremoteserversaccessingthroughFTP,119–121checking,forsupportofPHP,69–70definingaccessoptions,119–121fortesting,123–125overridingsettingson,99–100testingon,69remotesource,creatingXMLdocumentfrom,710remotetestingoptions,123–125RemoveInstanceoption(MySQLWindowsEssentials),410RepeatRegionserverbehavior,60,704,721–722repeatregions,600–603,674displayingresultsofrecordsetin,459–462displayingthumbnailimageswith,721–722repeatingelements,626,637–639Reply-Toheader,350,352–354$_REQUESTarray,328require()command,364,711require_once()command,364,452$requiredarray,342Resetform,255resourcepathsdocument-relativelinks,105root-relativelinks,105–106RestrictAccesstoPageserverbehavior,509–512RESTRICToption,529returnfalse,713–714rootaccess,409,416rootelement,626rootpassword,409,411,416–418root-relativelinks,105–106rows,436,482,574–575RSSnewsfeedsconvertingheadlinestolinks,629–630displayinginWebpage,632–633fetchingwithproxyscript,706–707limitingnumberofitemsdisplayed,630–631pullingin,622–633sourcesof,622Rulespane(CSSStylespanel),174runtimevariables,547BINARYkeywordwith,586conversionoftoPHPvariables,578INDEX745defaultvalueof,584–586defining,547–548handlingof,inDreamweaver,585–587quotesand,547withSQLqueries,577–579textsearches,596Ssafe_mode,94schema,625scientificnotation,306scriptsadaptingasincludes,380–388ondynamicpages,35scrollablelists,248,269–271searchcriterianumericalcomparisons,581–583setting,580–598textsearch,586–588searchenginespiders,JavaScriptand,38searchenginesnon-JavaScriptenabledpagesfor,716Spryand,669searchresultscreatingstripedtablerows,574–575displayingmessageforempty,587–588displayingnumberof,573–574improvingpresentationof,573–575partialmatches,589,591–592,594–598withinnumericalrange,583–586searchescase-sensitive,586FULLTEXTindex,595–598withwildcardcharacters,589–594SecureFTP(SFTP),121security,ofsessions,507securitysettings,MySQL,409,416–418SELECTcommands,535–537,572DISTINCToption,535LIMITclause,537ORDERBYclause,537WHEREclause,535–537SELECTCOUNT(*),599SelectImageSourcedialogbox,684SELECTprivileges,432tag,248,267,269,356selectwidget,277selectors,145–146select_list,535semicolons,297,331,418$_SERVERarray,327,331serverbehaviorcode,453serverbehaviors,60–61,474buildingcustom,486–490usingwithsite-root-relativelinks,452–454Seealsospecificserverbehaviorsserverroot,82,104–108server-sidelanguages,296server-sidetechnology,34–38server-sidevalidation,248,329server-sideXSLT,621$_SERVERvariables,96,368serverschangingdefaultportfor,83–86checkingXSLTsupporton,621–622choosing,73retrievinginformationfrom,withsuperglobals,327–328$_SESSIONarray,327,508sessionvariables,507createdbyUserAuthenticationserverbehaviors,513creatinganddestroying,508creating,fromuserdetails,515sessionscheckingforenabled,509creating,507destroying,508enabling,99introductionto,507securityof,507UserAuthenticationserverbehaviorsand,513session_destroy()command,508session_start()function,508,513SETcolumns,440,443,454–457SetID,47SETNULLoption,529setColumnType()method,716setCurrentRow()method,690setCurrentRowNumber()method,714setup.
php,configuringphpMyAdminwith,420–422sha1()function,516Shakeeffect,52,55shellprompt,88short_open_tag,94ShowIfRecordsetIsNotEmptyoption,588ShowRegionserverbehavior,60,562,587–588showPanel()method,238–239siblings,626sidebarbackground,168–169simplemailtransferprotocol(SMTP),329sitedefinitionduplicating,131exporting,131importanceof,104,115importing,132inDreamweaver,115–130definingsitedetails,117–118definingtestserver,121–125openingSiteDefinitiondialogbox,115–116remoteserveraccess,119–121saving,126settingupforSpry,125–126siteoptions,125–126troubleshooting,128–129removing,131SiteDefinitiondialogboxCloakingcategory,125LocalInfooptions,117–118opening,115–116RemoteInfooptions,119–121TestingServercategory,121–125sitemanagement,131–132sitename,117INDEX746sitenavigationbuildingwithSprymenubar,184buildingnavigationstructure,195–198horizontalmenubar,185–186Sprymenubaraccessibility,189customizingstyles,190–193editing,188–189removing,188verticalmenubar,186–187SiteRootbutton,170site-root-relativelinkswithincludes,368–369usingserverbehaviorswith,452–454sizeattribute,269–270Slideeffect,52,55–58spam,329,338,348–350tags,280,289specialpatterncharacters,285–286spreadsheets,437sprintf()function,578–579,583Spry,34,38accessibilityissueswith,60,670addingtoPHPtables,714–716bookmarksand,39capabilitiesof,654childnodesand,655–656codelibrary,41developmentof,654disadvantagesof,669–670handlingofdynamicdataby,59–60handlingofXMLdataby,654–675limitationsof,38–39lists,670–674settingupsitedefinitionfor,125–126sizeofcodelibraries,39syntax,668usinginpageswithoutJavaScript,711–717usingwithoutJavaScriptenabled(casestudy),717–728usingXHTMLwith,716–717validatingpagesthatuse,668–669XMLdataand,655–656Spry1.
4,654Spry1.
5,654SpryAccordionWidget,210,229–239changingdefaultswithobjectinitialization,236–238colorselection,235–236editingandstyling,232–236inserting,230openingfromalink,238–239structure,230–232Sprycharactercounter,288–289SpryCollapsiblePanelWidget,239–244editingandstyling,241–243openingfromalink,243–244structureof,239–241SpryCollapsiblePanels,210Sprydatacode,understanding,668–669Sprydatasetsactivatingeventhandling,688–691creating,654–662,679–684,689–691casestudy,676–691distinguishingbetween,688dynamicallyselecting,677incorporatinginordinarywebpage,711–716initializationof,662loadingXMLdatawith,727Sprydetailregions,684–687,727–728Spryeffects,40–59accessing,52Appear/Fade,52applying,43–45applyingmultipleeventstotriggerelement,58–59Blind,53commonsettingsfor,52editing,48–50Grow/Shrink,53–54Highlight,54–55removing,50restoringdeleted,50–51Shake,55Slide,55–58Squish,56supportedtargetelements,51–52typesof,51–52Sprymenubar,43buildingsitenavigationwith,184–206customizingstyles,190–193addingborders,191–192changingcolors,190–191changingmenuwidth,190fontchanges,192–193editing,188–189insertingandediting,196–198insertinghorizontalmenubar,185–186insertingverticalmenubar,186–187maintainingaccessibilitywith,189removing,188structureof,185–187styling,withCSSStylespanel,193–206changingcolorsandfonts,203–206editingdefaultselectors,198–199settingwidths,199–203wrappingintags,193–195XHTMLstructure,187–188Spryobjects,228–229Spryregions,663,680–682SpryRepeatListbutton,671,680–682Sprytab,Insertbar,10SpryTabbedPanelswidget,210–228colorselection,218–222convertingtoverticaltabs,223–226designproblemswith,227–228editing,214–218structureof,212–214INDEX747SpryValidationTextFieldwidget,612Spryvalidationwidgets,277–292checkbox,289–292custompatterns,285–286drop-downmenuvalidation,292inserting,279limitationsof,278removing,279textarea,286–289textfieldvalidation,280–285Sprywidgets,210buildingtabbedinterface,211–228collapsiblepanels,239–244featuresof,210–211removing,244SeealsospecificwidgetsSpryXMLDataSetdialogbox,657–662,717Spry.
Data.
XMLDataSet()method,689spry:contentproperty,713–715,727–728spry:detailregionproperty,713–715,728spry:repeatproperty,674–675spry:repeatchildrenproperty,672–675spry:setrowproperty,688SpryEffects.
js,44SpryMenuBarHorizontal.
css,190SpryMenuBarVertical.
css,190SQL(StructuredQueryLanguage),403,502SQL(StructuredQueryLanguage)commands,534–538casesensitivityof,534DELETEcommand,538INSERTcommand,537rulesfor,534–535SELECT,535–537UPDATEcommand,538whitespaceand,534SQL(StructuredQueryLanguage)injectionattacks,474,547SQL(StructuredQueryLanguage)queriescommonproblemswith,598–603countingrecords,599innerjoins,565leftjoin,564numericalcomparisons,581–583partialmatches,589–598passingformvaluesto,546–548runtimevariablesin,577–579,584–586searchingwithinnumericalrange,583–586SELECTcommand,572settingsearchcriteria,580–598troubleshooting,579–580understanding,576–580usingvariablesin,546–550Squisheffect,52,56SSLconnections,507Standardtoolbar,15standards-compliantwebpages,18–31statements,conditional,311–317statements,PHP,297staticwebpages,34staticXMLdocuments,creating,707–711.
stefiles,importingsitedefinitionfrom,132StickyEditFieldserverbehaviorapplying,503creating,496–497StickyTextAreasserverbehavior,creating,488–489StickyTextFieldserverbehavioradapting,496–497applying,489–490creating,486–488StorageEngine,524,527strcmp()function,492strftime()function,608–611stricterrors,322strings,40strlen()function,483strtotime()function,609StyleRenderingtoolbar,24stylerules,166–167adding,144cascadeof,173–174creatingandediting,157–158creatingnew,145–152,175definingproperties,146–152definingselectors,145–146creatingwithPageProperties,138–140decidingwheretolocate,163–165defaultformatfor,158exportingtonewstylesheet,152–154foraccordionwidgets,231–232forcollapsiblepanels,240forverticaltabs,224moving,152–156specificityof,174thingstoavoidwhencreating,136–138stylesheetmanagement,21–22stylesheetsapplyingconditionalcomments,164–165attachingexternal,144exportingrulesto,152–154linkingtoexisting,164menubar,customizing,190–193movingrulesbetween,155–156movingruleswithin,154removingcommentsfrom,179–181SeealsoCascadingStyleSheetsstylesdeleting,144DesignTimeStyleSheets,374–375editing,144subjectline(email),329subtractionoperator(–),306SummaryforSelectionpane(CSSStylespanel),173superglobalarrays,327–328superglobalvariables,331$suspect,349switchstatement,316INDEX748synchronouscommunication,38syntaxcoloring,30T\t(tab)escapesequence,303tabbedpanels,211–228changingorientationof,223–226classes,213–214colorselection,218–222convertingtoverticaltabs,223–226designproblemswith,227–228editing,214–218inserting,212openingfromalink,222–223structureof,212–214styling,220–222TabbedPanelsclass,213TabbedPanelsContentclass,214TabbedPanelsContentGroupclass,214TabbedPanelsContentVisibleclass,214TabbedPanelsTabclass,213TabbedPanelsTabGroupclass,213TabbedPanelsTabHoverclass,214TabbedPanelsTabSelectedclass,214tabindexattribute,214tabledefinitiondefiningforeignkeyrelationshipin,526–530notnullin,525nullin,525tablestructure,437–441tables(database)addingnewrecordsto,539changingdefaulttype,onWindowsEssentials,410–411checkingstorageengineof,526child,523collation,446columntypes,439–441columns.
Seecolumnscreatingforusers,475–476defining,524–530defininginphpMyAdmin,444–446deletingrecordsfrom,556,560–563,567–568designing,437–441displayingrecordlist,563–564foreignkeys,520–523,539–545inconsistencyin,521informationstoredin,436–441InnoDB.
SeeInnoDBtablesinsertingrecordsintoparent,545–550lookup,522managingcontentwithmultiple,538–568MyISAM.
SeeMyISAMtablesnames,438parent,523populating,530primarykeys,436–437,442,462–464,493–494,521–522recordsin,436,521–523,530–534redundancyin,521restoringcontentof,530rows,436adding,482striped,574–575selectingrecordsfrommultiple,530–534vs.
spreadsheets,437storageengineof,converting,527forstoringfeedbackforminputs,441–457storingrelatedinformationinseparate,520–530avoidingorphanedrecords,523definingdatabasetables,524–530linkingwithforeignkeys,521–523structurefor,520–521updatingrecordsin,563–567tablespaces,407table_list,535TagEditor,insertingformusing,252TagInspectorpanelgroup,42,271Tagselector,13,145tags,autocompletionof,30–31TargetElementsetting,52targetelementsidentifying,45–47forSpryeffects,51–52Targetoption,251tcshshell,amendingPATHin,416templatesaddingeditableregionsto,391–393advantagesof,389creating,390–391creatingchildpagesfrom,393–398lockingcodeoutsideoftags,398movingmaster,391usinginPHPsite,389–398temporaryfilesforpreview,129–130usedbyDreamweaver,tocheckXSLTFragment,629testenvironmentdefining,121–125local,68,122–123remotetestingoptions,123–125settingup,68–100checkingPHPconfiguration,90–100checkingremoteserverforsupportofPHP,69–70creatinglocaltestserver,70–89onMacOSX,86–89onWindows,72–86TestingServercategory,121–125Testingserverfolderoption,122TEXT(MySQLcolumntype),439textcenteringinbrowser,151includingfromotherfiles,364–388linebreaksin,467–469searchingfor,586–588wrapping,149textareavalidation,286–289textareawidget,277INDEX749textareasconvertingtotextfield,257propertiesof,255–256tag,248textcolumns,439textfieldvalidation,283textfieldwidget,277,280–285textfieldsaddingtoforms,253–255convertingtotextarea,257propertiesof,255–256Spryvalidation,280–285.
textfieldFlashTextinput,input.
textfieldFlashTextselector,283.
textfieldFocusStateinput,input.
textfieldFocusStateselector,283textinputelementsaddingtoforms,252–255settingpropertiesfor,255–256textsearch,multi-column,588Texttab,Insertbar,10textwrapping,29TextWrangler,62,64third-partydevelopers,40thumbnailimagescontrolling,withBridge,17displaying,679–682,684time,formattinginMySQL,603–607timecolumns,440timezone,setting,608TIMESTAMP(MySQLcolumntype),440,443,445TINYBLOB(MySQLcolumntype),441TINYINT(MySQLcolumntype),439Toggleeffectsetting,52TransactionalDatabaseOnlyoption,407transactions,526triggerevents,41,58–59trim()function,342,483troubleshootingemail,338MySQLconnections,449–452sitedefinition,128–129SQLqueries,579–580testenvironment,77,82true,305,312–313TRUNCATEkeyword,530TurnXMLDataCachingOffoption,661two-wayencryption,516typeattribute,248Typecategory(CSSRuleDefinitiondialogbox),148Typeoption(TextFieldproperties),256–257,283typeproperty(CSSRuleDefinitiondialogbox),147typeselector(CSS),145Uunderscore(_)aswildcardcharacter,589–594Unicode(UTF–8),7,408UnicodeNormalizationForm,6UniversalBinary,88–89Unix,87Unixepoch,608Unixtimestamp,creating,609–610unorderedlists,670,672unset()function,343UPDATEcommand,538updateform,bindingfieldvaluesto,503–505UpdateIncludesFolderdialogbox(XMLExport),702updatepagesadaptingfordeletes,568creating,497–500UPDATEprivileges,432UpdateRecordserverbehavior,566–567applying,498–500,554–555mergingwithvalidationcode,500–502upload_max_filesize,94upload_tmp_dir,94URLprefixfield,122–124UserAccountControl(UAC),73–74useraccounts,creatingforMySQL,432–435useraddress,includinginemailheader,350–354UserAuthentication,61,509,511UserAuthenticationserverbehaviors,509,513userinputpreservationof,onfeedbackforms,345–347quotesin,345–346validating,248beforeformsubmission,275–292userprivileges,settingfordatabase,432userrecords,updatinganddeleting,493–507userregistrationsystems,474,489–493creating,474–479buildingregistrationform,476–480definingdatabasetable,475–476preservingdatabaserecordintegrity,480–493updatinganddeletinguserrecords,493–507user-controlledcomparisons,581–583usernamescheckingforduplicate,502preventingduplicate,480–481usersdeletingfromdatabase,505–506greetingbyname,514listingregistered,494–496loggingin,512–513loginsystemfor,509–511registering,509restrictingaccessof,511–512trackingof,byDreamweaver,513–515userstable,creating,475UTC(CoordinatedUniversalTime),608INDEX750VValidateFormbehavior,275–277validationwidgetsand,279validation.
Seeinputvalidationvalidationalerts,editingandcontrolling,280–282valueattribute,542VARCHAR(MySQLcolumntype),439,443variables,39,298–299assigningvaluesto,298–299forformfields,327naming,298runtime.
Seeruntimevariablessession,507–508,515Seealsospecifictypesverticalmenubar,inserting,186–187Viewmenu,261virtualdirectories,registeringonIIS,115virtualhosts,104creating,onApache,110–115registeringonMacOSX,113–115registeringonWindows,111workingwith,106–107virtual()function,368,452visibilityproperty,20Vistacreatingvirtualhostsin,111installingtestenvironmenton,73runningApacheMonitoron,78turningoffUACon,74visualaids,forCSSstructure,22–23VisualAidssubmenu,261visualassets,organizingwithBridge,16–18visuallayout,25–27VTabbedPanelsselectors,224–226WW3Cvalidation,668–669warningerrors,321webbrowsers,withJavaScriptdisabled,670WebContentAccessibilityGuidelines(WCAG),60webfilesaddingdefaulttoIIS,109–110choosinglocationfor,104–110organizingonserverroot,106settingdefault,108webpagesdisplayingdatabasecontentin,457–469creatingrecordset,457–462individualrecords,462–467displayingnewsfeedin,632–633dynamicadvantagesof,694Ajaxand,38–39basicconceptsof,39–40client-sidetechnologyfor,35creatingfromtemplate,393–398server-sidetechnology,35–38understanding,34embeddingPHPin,296–297incorporatingSprydatasetinordinary,711–716parsing,104PreviewinBrowsersettings,129–130restrictingaccesstoindividual,511–512standards-compliant,18–31static,34validatingSpry,668–669webserverschangingdefaultportfor,83–86choosing,73websitesbuildingPHP,60–61database-driven,36dynamic,402simplestructure,105WebDAV(Web–basedDistributedAuthoringandVersioning),119welcomescreen,4well-formeddocuments,componentsof,619WHEREclause,535–537ANDkeyword,588BINARYkeywordwith,586Booleansearches,596conditionsin,580DELETEcommand,538foreignkeysand,532missingrecordsand,564–565naturallanguagesearches,596numericalrangesand,583–586operators,535–536ORkeyword,588SELECTstatement,547UPDATEcommand,538usingnumericalcomparisonswith,581–583withwildcardcharacters,589–594whileloops,317whitespace,534header()and,388ignoredincode,297removing,483wildcardcharactersinsearches,589–594withnumbers,592,594WindowsconfiguringMySQLon,406–411displayingfilenameextensionsin,72–73enablingPHPextensionson,98–99installingMySQLon,404–410minimumsystemrequirements,72registeringvirtualhostson,111serverrootlocation,107–108settinguplocaltestenvironmenton,72–86checkingport80,75choosingwebserver,73compatibilityissues,74–75downloadingsoftware,73installingApache,76–77installingPHP,80–82INDEX751preparinginstallationonVista,73startingandstoppingApache,79testingPHPinstallation,82–83troubleshooting,77,82startingandstoppingMySQLon,411usingMySQLmonitoron,411–412,418–419workspace,7WindowsEssentialschangingdefaulttabletype,410–411configuring,406–411installation,404–406WindowsInstaller,enablingfileuploadsandsessions,99Windowsinstallerpackages,73Windowsservice,runningMySQLas,408WinMerge,62wordwrapping,29,333wordwrap()function,333workspace,7–13Documentwindow,11–13Insertbar,9–11Mac,8–9organizing,14–15accessinghiddenfilesandfolders,15customizedlayouts,14–15displayingoptionaltoolbars,15hidingallpanels,15rearrangingpanels,14Windows,7wrapperfunctions,41writeToFile()function,710–711XXAMPP,71XHTMLdeletingunwanted,705displayingoutput,370embeddinginXSLT,636–637tags,716usingwithSpry,716–717XHTMLstructure,ofSprymenubar,187–188XML(ExtensibleMarkupLanguage)attributes,626,688buildingmanuallyfromarecordset,703–706comments,636declaration,619,636,705generatingdynamically,695–706HTMLentitiesin,620objectiveof,618tags,619,626usingXSLTtodisplay,621–622XMLdatafilteringselectively,644–646gettingfromlocalsource,634–636handlingof,bySpry,654–675XMLdatasource,accessingusingXSLT,624–631XMLdeclaration,619,636adding,705XMLdocumentscreatingfromdynamicsource,707–711fromlocaldynamicsource,710withphpMyAdmin,697fromremotesource,710Sprydatasetsfrom,656–662static,707–711purposeof,694rootelement,626structureof,618–620,656XPathand,628XMLExportextension,using,697–703XMLfeeds,701–707XMLfiles,exportingsitedefinitionas,131XMLnodetree,659XMLnodes,655–656XMLprolog,619XMLsourceschema,626XMLsources,generatingwithPHP,725–726XMLtags,619attributeswithin,626XMLExportfolder,701XPath,628filteringnodeswith,644–646XPathExpressionBuilder,628,638filteringnodes,644–646XPathExpressionBuilder(RepeatRegion)dialogbox,630tags,640tag,637tag,631,640tag,640–641tag,647tags,640tags,640XSLTransformationdialogbox,61,632XSLTransformationserverbehavior,621–622communicationwithXMLdatasource,624using,624–631workingwithRSSnewsfeeds,622–633INDEX752XSLT(ExtensibleStylesheetLanguageTransformations),61accessingnestedrepeatingelements,637–639accessingXMLdatasourcewith,624–631checkingserversupportof,621–622client-side,621conditionalregions,630–631displayingoutputselectively,644–650embeddingXHTMLin,636–637formattingelements,643–644introductionto,618processingwithPHP,621repeatregions,630–631server-side,621–624sortingelements,642–643structureof,636–637syntax,640tags,636templates,637usingtodisplayXML,621–622XSLTFragments,624codedetails,636–637creating,624–629,634–635creatingconditionalregions,639–642creatingparametersfor,646definingnewentitiesfor,636embeddingindynamicpage,632–633encodingattribute,636temporaryfilesand,629using,629–630XSLTparameterscreatingdefault,646–647filteringdatawith,646–650sending,fromPHPpage,647,650Zz-indexproperty,20Zoomtool,641