datatyperewritebase

369IndexSpecialCharacters!
operator,53->(arrow)notationobject-orientedPHP,214s_(underscore)characterdenotingprivateproperties,213domainnames,343)notationobject-orientedPHP,214ASP-styledelimiters,31assignmentoperatorsarithmeticassignmentoperators,47,48assignmentbyreference,49concatenating,54associativearrays,59AUTO_INCREMENT,MySQL,102auto-complete,16Bbackreferences,rewriterulesaccessing,173passingURLvaluestoadmin.
phpwith.
htaccess,191settingupruleforpage-and-entryURLs,174bind_param()method,MySQLi,115bind_result()method,MySQLi,116bindingparameters,115bit.
lyAPIcreatingshortenedlink,363—365BLOBtype,MySQL,102blockcomments,46DocBlocks,220blog,6blogprojectseesimple_blogprojectblog_idcolumn,commentstable,284Booleanvalues,37breakstatement,60breaktag,HTML,34browsersmakingRSSfeedavailableto,278—279outputtingdatato,41—46storinginformationonuser'smachine,93,95built-infunctionreferences,16businesslayermappingfunctionstooutputsavedentries,141writingbusinessfunctions,148—149businesslogic,140CCAPTCHA,353CascadingStyleSheetsseeCSScase(switch)statement,61channeltag,RSSfeeds,265CHARtype,MySQL,101characterclasses,174,191charactersmatchingnon-wordcharacters,181matchingwordcharacters,173checkSaveDir()method,ImageHandlerclass,228—236classkeyword,OOP,212classescharacterclasses,174Commentsclass,285ImageHandlerclass,218—240classes,OOP,211,212classconstructors,214usingclasses/objectsinscripts,215—218visibilitydeclarations,213client-sidescripting,4—5close()method,MySQLi,113,116closeCursor()method,PDO,117,136codefolding,16codinglogicINDEX371separationinprogramming,139—140commandsecho()statement,42print()statement,41print_r()function,49printf()statement,43sprintf()statement,45commentcolumn,commentstable,284comments,46—47addingerrormessagestocommentsform,348—353blockcomments,46buildingcommententryform,286—287modifyingindex.
phptodisplay,287—289deletingcomments,304—310creatingconfirmationform,305—306modifyingupdate.
inc.
phptohandle,307—310removingcommentsfromdatabase,306displayingcommentsforentries,296—298,300—302modifyingindex.
phpfor,302—304displayingstoredcommentinformation,345DocBlocks,220emailaddressvalidationforposting,341—353inlinecomments,46retrievingcommentsforentries,293—296savinginsessions,344shell-stylecomments,47spamprevention,353—362storingnewcomments,289—291modifyingupdate.
inc.
phpfor,291—293Commentsclassbuilding,285confirmDelete()method,304,305,307deleteComment()method,304,306,308generateChallenge()method,354,355retrieveComments()method,293saveComment()method,289,343,347,348,359showCommentForm()method,286,345,350,356,360showComments()method,296,300,301,323validateEmail()method,342verifyResponse()method,358commentstable,283—285storingnewcommentsin,289comments.
inc.
phpfileaddingmethodcodetofileconfirmDelete(),305deleteComment(),306generateChallenge(),354,355retrieveComments(),294saveComment(),289,344,347,348,359showCommentForm(),286,345,350,356,360showComments(),297,300,301validateEmail(),342verifyResponse(),359creating,285hidingdeletelinkfromunauthorizedusers,323comparisonoperators,47,50concatenatingassignmentoperator,54concatenation,35concatenationoperator,54confirmationformdeletingcommentsfrom,305—306confirmDelete()function,197,198,200confirmDelete()method,Commentsclass,304,305,307connectingPHPscriptstoMySQL,109—118index.
phpfile,149scripttoprocessentryforminput,134—135connections,databaselogic,139constructors,OOP,214contenttype,237contenttypeheader,88,265content,syndicating,264—281continuestatement,62controlstructures,54—66breakstatement,60continuestatement,62do-whileloop,57else/elseifstatements,55forloop,58foreachloop,59gotostatement,65ifstatement,55include/include_onceconstructs,63require/require_onceconstructs,63returnstatement,63switchstatement,61whileloop,56controlsdisplayingtoauthorizedusers,330—337INDEX372hidingfromunauthorizedusers,318—328conversionspecifications,43$_COOKIEsuperglobalarray,93—95arraycontainingthecontentsof,84CREATEDATABASEstatement,MySQL,100CREATETABLEstatement,MySQL,100—102IFNOTEXISTSclause,101createdcolumn,entriestable,126,128,272createUserForm()function,312,315credentialsstoringdatabasecredentials,134CSS(CascadingStyleSheets),129,132displayingentriessavedindatabase,139curlybraces{}checkingbracesusedinpairs,196customURLscreatingfriendlyURLsusing.
htaccess,170—175creatingfriendlyURLsautomatically,175—183DdatatypesMySQL,102MySQLi,115databaseconnectionscreatingblogentries,266databasecredentialscheckingiflogincredentialsvalid,331storing,134databaselayerwritingdatabasefunctions,141—148databaselogic,139database-accessabstractionlayer,116databasesseealsoMySQLaddingadministrators,312—317addingcolumnstotables,157,176addingcommentingsystemtoblog,283avoidingstorageofredundantdata,118—121CREATEDATABASEstatement,100creatingadmintable,311creatingcommentstable,283—285creatinginphpMyAdmin,126deletingentries,197—204displayingentries,138—139DROPDATABASEstatement,99mappingfunctionstooutputsavedentries,140modifyingupdate.
inc.
phptosaveURLsin,182MySQL,109—111MySQLi,111—116PDO(PHPDataObjects),116—118planningdatabasetables,118—122removingcomments,306storingcomments,289—291storing/retrievingimages,240—247supportingmultipledatabasetypes,116updatingentriesin,194—197usingpagetofilterdatabaserecords,159—164datatypespecifiers,45datatypes,32arrays,38—41Booleanvalues,37floatingpointnumbers,37integers,37strings,33—37datecolumn,commentstable,284date()function,274,298—299DATE_RSSconstant,274datescreatingcustomdateformattingstring,298—299DATETIMEtype,MySQL,102dayformattingcharacters,298db.
inc.
phpfile,134,149,266debugging,arrays,75decrementingoperators,47,52DEFAULTkeyword,157deletelink,188,189deletingentriesindatabase,197,198,200hidingfromunauthorizedusers,323DELETEstatement,MySQL,109deleteComment()method,304,306,308deleteEntry()function,201,203deletingcomments,304—310deletingdatabaseentries,197—204delimiters,30,31delimiters,regex,182designpatterns,140developmentenvironment,settingup,3—28die()function,110directivesRewriteBase,172RewriteEngine,171RewriteRule,172,173,174,190,264short_open_tag,31INDEX373displayingoutput,140,149—154divisionoperator,48DocBlocks,220doImageResize()method,254,255,256,258domainnamesuseof_(underscore)character,343double-quotesyntax,34doubles,37do-whileloop,57DROPDATABASEstatement,MySQL,99dst_arguments,imagecopyresampled(),255,256dynamicwebpages,4dynamicwebsites,3Eecho()statement,42Eclipse,18choosingprojectworkspace,20creatingproject,23—26DocBlocks,220downloading,19installing,18—21showingresourcesstartingwithperiod,171unpackingPDTarchive,19editlinkcreatingadministrativelinks,188displayingadministrativelinks,189else/elseifstatements,55emailvalidateEmail()method,342—343emailcolumn,commentstable,284embeddingPHPscripts,29—31encodingURLencoding,78encryptionalgorithm,316,331enctype,207entriestableautomaticallypopulatedfields,128createdcolumn,126,128,272creatinginphpMyAdmin,127creatinginputformfor,128—132deletingentriesindatabase,197—204displayingrecordssavedindatabase,138—139entrycolumn,126,128idcolumn,125,128imagecolumn,adding,241modifyingfunctionstoacceptpageparameters,158—164pagecolumn,adding,157planningforbloggingapplication,125—127savingentriesto,132scripttoprocessentryforminput,132—138connectingtodatabase,134—135retrievinguniqueID,136savingvaluesinentriestable,135verificationofinput,133structureinphpMyAdmin,127titlecolumn,125,128updatingentriesindatabase,194—197urlcolumn,adding,176entries,simple_blogprojectdeletingrelatedcomments,304—310displayingcommentsfor,296—298,300—304retrievingcommentsfor,293—296storingnewcomments,289—291entrycolumn,entriestable,126,128savingvaluesinentriestable,135verificationofentryforminput,133,134EODidentifier,36equalcomparisonoperator,50errorcontroloperators,47,51errorhandling,OOPthrowkeyword,222errorsuppressionoperators,52errorvalue,$_FILES,85error_reporting()function,70,71errorsaddingerrormessagestocommentsform,348—353checkingforerrorduringfileupload,221—222handlingerrorswithtry.
.
.
catch,226—228turningofferrors,70escapingcharactersinstrings,33exceptionstry.
.
.
catchstatement,226—228execute()methodMySQLi,116PDO,117savingvaluesinentriestable,136exit()commandaliasfor,110ExtensibleMarkupLanguage(XML),264extensionsdeterminingfileextensions,237INDEX374FF(forbidden)flag,URLrewriting,173feedreadersseeRSSaggregatorsfeedsseeRSSfeedsfeedsfolder,264fetch()method,MySQLi,116retrievinguniqueIDfornewentry,136fileextensions,determining,237filepermissions,231fileuploadsseeuploadingfilesfile_get_contents()function,363filepathproperty,ImageHandlerclass,224filesseealsoadmin.
phpfile;comments.
inc.
phpfile;db.
inc.
phpfile;functions.
inc.
phpfile;images.
inc.
phpfile;index.
phpfile;rss.
phpfile;update.
inc.
phpfileaccessinguploadedfile,208—211checkingfileuploadedandwithouterrors,88checkingfileuploadedisJPGimage,88creatingPHPfile,26—27savinguploadedfiletofilesystem,223—225settinguprulesforURLrewriting,172$_FILESsuperglobalarray,85—89,208—211checkingwhetherfilewasuploaded,208,209—211methodsusingDocBlocks,220filtersusingpageasfilter,158,159—164flags,URLrewriting,173,174FLOATtype,MySQL,102floatingpointnumbers,37folderpermissions,231folderscheckingiffolderalreadyexists,228—231creatingdirectoryin,232creatingtostoreimages,228—236forloop,58forbidden(F)flag,URLrewriting,173foreachloop,59creatingblogentries,268,270formtagchangingenctypetoacceptfileuploads,207formatImage()function,246—247formattingdates,298—299formscreatinginputformforentriestable,128—132populatingformwithentrytoedit,191—194scripttoprocessentryforminput,132—138friendlyURLscreatingcustomURLsusing.
htaccess,170—175creatingcustomURLsautomatically,175—183previewingblogentrieswith,175FTPoption,XAMPP,13functionprototypes,43functionreferences,16functions,66accessinginformationabout,29mappingtooutputsavedentries,140modifyingtoacceptpageparameters,158—164recursivefunctions,148returnstatement,63,66returningvaluesfrom,67scopeofvariablesdeclaredwithin,71user-defineds,66—67writingbusinessfunctions,148—149writingdatabasefunctions,141—148functions,customseealsomethodsadminLinks(),187—188confirmDelete(),197,198,200createUserForm(),312deleteEntry(),201,203formatImage(),246—247makeUrl(),181postToTwitter(),365,366retrieveEntries(),141—148sanitizeData(),141,148—149shortenUrl(),363,364,365functions,listofPHParray_map(),148,355array_pop(),267array_push(),146date(),274die(),110file_get_contents(),363getimagesize(),250header(),155htmlentities(),111imagecopyresampled(),255imagecreatefromjpeg(),88imagecreatefromxyz()functions,252imagecreatetruecolor(),255imagedestroy(),88INDEX375imagejpeg(),88imagexyz()functions,253is_dir(),230list(),72md5(),316min(),251mkdir(),231move_uploaded(),224mt_rand(),354mysql_close(),111mysql_connect(),110mysql_error(),110mysql_fetch_array(),111mysql_free_result(),111mysql_query(),111mysql_real_escape_string(),111mysql_select_db(),110ord(),355preg_replace(),180rand(),354session_destroy(),92session_start(),90setcookie(),93sha1(),316simplexml_load_string(),364strip_tags(),111,148strtolower(),181strtotime(),274time(),93unset(),92,358urldecode(),78urlencode(),78functions.
inc.
phpfileacceptingpageinfo.
inURL,158adminLinks()function,187,188confirmDelete()function,200createUserForm()function,312creatingblogentries,266creatingdifferentviewingstylesforpages,185deleteEntry()function,203formatImage()function,246includinginindex.
php,149modifyingtohandleURLs,176—178postToTwitter()function,366reinforcinglogicalseparations,141retrieveEntries()function,143,144,145,147,244,272sanitizeData()function,149shortenUrl()function,363,364,365usingpagetofilterdatabaserecords,159,160,161writingdatabasefunctions,141GgenerateChallenge()method,Commentsclass,354,355GETmethod,77$_GETsuperglobalarray,77—82acceptingpageinfo.
inURL,159arraycontainingthecontentsof,84checkingifsetusingternaryoperator,166,192,194deletingcommentsindatabase,307deletingentriesindatabase,197loggingusersout,339modifyingindex.
phptocheckforurlnotid,178passingentryIDsinURL,150getImageExtension()method,237getImageFunctions()method,253,254getimagesize()function,250,253getNewDims()method,250,251,252,254GIFimagesdeterminingfileextensionofuploads,237globalscope,70,71$GLOBALSsuperglobalarray,73gotostatement,65greaterthancomparisonoperators,50GUID(GloballyUniqueIdentifier),271Hheader()functiondescribingRSSfeeds,265redirects,155heredocsyntax,36,200hiddeninputs,165,166deletingentriesindatabase,200inserting,193storingpagein,167highlightingsyntaxhighlighting,16hourformattingcharacters,299.
htaccessfilecreating,171—175creatingfriendlyURLsusing,170—175declaringbase-levelfolderforURLrewriting,172description,170INDEX376passingURLvaluestoadmin.
phpwith,190—191settinguprulesforadmin.
phpaccess,173forpage-and-entryURLs,174forpage-onlyURLs,174forURLrewriting,172turningonURLrewriting,171htdocsfolderchoosingEclipsePDTprojectworkspace,20creatingnewprojectsautomaticallyin,21HTMLbreaktag,34scripttags,31HTMLformsaddingadministrators,312—315enctype,207insertinghiddeninputs,165,166UPLOAD_ERR_OKconstant,221htmlentities()function,111creatingblogentries,268storingnewcomments,289HTTP_HOSTvalue,$_SERVER,74HTTP_REFERERvalue,$_SERVER,75,77,292,305HTTP_USER_AGENTvalue,$_SERVER,75Iidcolumn,commentstable,284idcolumn,entriestable,125,128identicalcomparisonoperator,50,51IDEs,15PDTIDE,18ifelsestatement,166IFNOTEXISTSclauseCREATETABLEstatement,101ifstatement,55compressingintooneline,150imagecolumn,entriestable,241imageuploadsseeuploadingimagesimagecopyresampled()function,255,256imagecreatefromjpeg()function,88imagecreatefromxyz()functions,252imagecreatetruecolor()function,255imagedestroy()function,88ImageHandlerclass,218—240checkingforerrorduringfileupload,221—222checkSaveDir()method,228—231,232doImageResize()method,254getImageExtension()method,237getImageFunctions()method,253max_dimsproperty,249processUploadedImage()method,219renameFile()method,237save_dirproperty,219savinguploadedfiletofilesystem,223—225imagejpeg()function,88imagescreatingfoldertostore,228—236determiningfileextensions,237ensuringimagenameisunique,237formatImage()function,246—247modifyingupdate.
inc.
phptosaveimages,225—226renaming,236—240resizing,248—259addingpropertyformaximumdimensions,249choosingimagefunctiontouse,252—254determiningnewimagedimensions,249—252resamplingimageatpropersize,254—258savinguploadedimages,219storingandretrievingfromdatabase,240—247modifyingindex.
phptodisplayimages,246—247modifyingretrieveEntries()toretrieveimages,244—246modifyingupdate.
inc.
phptosavepathtoimages,241—244uploading,207writingclasstohandle,218images.
inc.
phpfilecallingformatImage()function,247checkingforerrorduringfileupload,221creating,218declaringgetImageFunctions(),253definingImageHandlerproperties,219modifyingupdate.
inc.
phptosaveimages,226savinguploadedfiletofilesystem,223,224imagexyz()functionschoosingimagefunctionstouse,253incfoldercreating,132db.
inc.
phpfile,134INDEX377functions.
inc.
phpfile,141storingdatabasecredentials,134update.
inc.
phpfile,132,135includeconstruct,63includingdatabasecredentials,135include_onceconstruct,63creatingblogentries,266tryingtoreferencenonexistentfilewith,51writingpresentationcode,149incrementingoperators,47,52index.
phpfileacceptingpageinfo.
inURL,158—159callingpostToTwitter(),366callingretrieveEntries(),150callingsanitizeData(),151displayingadministrativelinks,188displayingentriessavedindatabase,138ensuringpagevariableispassed,166hidingadministrativelinksfromusers,318loggingusersout,337makingRSSfeedavailabletobrowsers,278—279makingRSSfeedavailabletonon-browsers,279—280modifyinglinksbetweenpages,162modifyingtodisplaycommentform,287—289modifyingtodisplayentrycomments,302—304modifyingtodisplayimages,246—247modifyingtohandleURLs,178—180openingconnectiontodatabase,149redirects,155retrievinguniqueIDfornewentry,136,138writingpresentationcode,149,152,153indexingcolumns,MySQL,103ADDINDEXcommand,157inheritance,OOP,213inlinecomments,46inputtagmaxlengthattribute,128INSERTstatement,MySQL,103—105VALUESkeyword,103installationsEclipsePDT,18—21PHP,Apache,andMySQL,6XAMPP,6—15instantiationofobjects,OOP,214INTtype,MySQL,102integers,37integrateddevelopmentenvironmentsseeIDEsinterfacesproceduralinterface,109IPaddress,13accessingIPaddressofsitevisitors,74is_dir()function,230JJavaScriptclient-sidescripting,4JOINclause,MySQL,108JPEGimagesdeterminingfileextensionofuploads,237JPGfiles,88Kkeytovaluepairing,38keywords,OOPseeOOPkeywordsLL(lastrule)flag,URLrewriting,173,174LAST_INSERT_ID()function,136Lerdorf,Rasmus,3lessthancomparisonoperators,50LIMITclause,DELETEstatement,MySQL,109linktagmakingRSSfeedavailabletobrowsers,278—279linkscreatingadministrativelinks,187—188creatingshortenedlinkwithhttp://bit.
ly,363—365displayingadministrativelinks,188—190modifyinglinksbetweenpages,162PosttoTwitterlink,362—368list()function,72,73descriptionsofmethodsusingDocBlocks,220determiningimagedimensions,250retrievinginformationsuppliedaboutuploadedfile,221localscope,71localhostverifyingApache/PHPrunning,13loggingusersout,337—340logicbusinesslogic,140INDEX378databaselogic,139presentationlogic,140reinforcinglogicalseparations,141separationofcodinglogic,139—140logicaloperators,47,52loginform,328—330loopingbreakstatement,60continuestatement,62do-whileloop,57forloop,58foreachloop,59whileloop,56Mmagicmethods,214magic_quotes_gpcsetting,15makeUrl()function,181,182manual,PHP,29max_dimsproperty,ImageHandlerclass,249maxlengthattribute,inputtag,128md5()function,316menusaddingmenutowebpages,184methodsseealsofunctions,customdescriptionsofmethodsusingDocBlocks,220doImageResize(),254getImageExtension(),237getImageFunctions(),253getNewDims(),250,251,252magicmethods,214processUploadedImage(),219renameFile(),237methods,CommentsclassconfirmDelete(),304,305,307deleteComment(),304,306,308generateChallenge(),354,355retrieveComments(),293saveComment(),289,343,347,348,359showCommentForm(),286,345,350,356,360showComments(),296,300,301validateEmail(),342—343verifyResponse(),358methods,OOPaccessing,object-orientedPHP,214definingclassmethods,214min()function,251mkdir()function,231mod_rewritedocumentation,172Model-View-Controller(MVC)pattern,140modulusoperator,48monthformattingcharacters,298move_uploadedfile()function,224mt_rand()function,354multidimensionalarrays,40nestingforeachstatements,59multiplicationoperator,48MultitierArchitecturepattern,140MySQLseealsodatabasesaddingcolumnstotables,157,176AUTO_INCREMENTkeyword,102bindingparameters,115connectingPHPscriptsto,109—118datastorage,97datatypes,102description,5eliminatingperformanceissues,118indexingcolumns,103installing,6verifyinginstallation,14—15introduction,98manipulatingdatainMySQLtables,98—109planningdatabasetables,118—122PRIMARYKEYkeywords,102MySQLextension,109—111die()function,110htmlentities()function,111mysql_xyz()functions,110,111recommendedfurtherreading,122securityweaknesses,109SQLinjection,111strip_tags()function,111MySQLstatementsALTERTABLE,103CREATEDATABASE,100CREATETABLE,100—102DELETE,109DROPDATABASE,99INSERT,103—105JOINclause,108SELECT,105—107avoidingshortcutselector(SELECT*),122UPDATE,107USINGclause,108INDEX379MySQLtimestampcreatingpubDatefrom,274mysql_close()function,111mysql_connect()function,110mysql_error()function,110mysql_fetch_array()function,111mysql_free_result()function,111mysql_query()function,111mysql_real_escape_string()function,111mysql_select_db()function,110MySQLi,111—116bind_param()method,115bind_result()method,116close()method,113,116datatypes,115execute()method,116fetch()method,116PDOcompared,116prepare()method,115query()method,113recommendedfurtherreading,122usingmethods,113usingpreparedstatementswith,113—116Nnamecolumn,commentstable,284namevalue,$_FILES,85NC(nocase)flag,URLrewriting,173,174negativelookahead,regex,181newkeyword,OOP,215newlinecharacter(\n),34NewPHPFiledialog,26NewProjectwindow,23nocase(NC)flag,URLrewriting,173,174NOTNULLconstraint,157nowdocsyntax,36NULL,declaringvariablesas,160Oobfuscation,354OOP(object-orientedprogramming),211—218accessingpropertyormethod,214callingamethodin,113classconstructors,214classesandobjects,211,212comparedtoproceduralcode,112definingclassmethods,214enablingreferencetoselfwithoutknowingname,214errorhandling,222objectinstantiation,214useofarrow(->)notation,214usingclasses/objectsinscripts,215—218visibilitydeclarationsforclassmembers,213writingclasstohandleimages,218OOPkeywordsclasskeyword,212newkeyword,215privatekeyword,212,213protectedkeyword,213publickeyword,213thiskeyword,214throwkeyword,222varkeyword,213open-sourcesoftware,3operators,47—54!
operator,53additionoperator,48AND(&&)operator,52arithmeticassignmentoperators,47,48arithmeticoperators,47,48comparisonoperators,47,50concatenatingassignmentoperator,54concatenationoperator,54decrementingoperators,47,52divisionoperator,48equalcomparisonoperator,50errorcontroloperators,47,51errorsuppressionoperators,52greaterthancomparisonoperators,50identicalcomparisonoperator,50,51incrementingoperators,47,52lessthancomparisonoperators,50logicaloperators,47,52modulusoperator,48multiplicationoperator,48OR(||)operator,52stringoperators,47,54subtractionoperator,48XORoperator,53OR(||)operator,52ord()function,355outputcommands,41—46echo(),42print(),41print_r(),49printf(),43sprintf(),45INDEX380Ppagecolumn,entriestable,157page-and-entryaccess,174page-onlyaccess,174pagesseewebpagesparametersbindingparameters,115descriptionsofmethodsusingDocBlocks,220parsingerrorschecking{}usedinpairs,196passwordcolumn,admintable,311passwordsaddingadministrators,316SHA1()hashof,331pathsrelativepaths,137patterns,programming,140patterns,regularexpressionsseealsoregexenclosingpatternsindelimiters,182makeUrl()function,181matchingnon-wordcharacters,181preg_replace()function,181URLrewriting,172PDO(PHPDataObjects),116—118closeCursor()method,117connectingtodatabase,149database-accessabstractionlayer,116execute()method,117MySQLicompared,116potentialissueswhenusing,116prepare()method,117recommendedfurtherreading,122PDTIDE,18installingEclipsePDT,18—21performance,MySQLavoidingshortcutselector(SELECT*),122eliminatingperformanceissues,118permissions,file/folder,231photos,uploading,88PHP,3—4comments,46—47controlstructures,54—66creatingPHPfile,26—27creatingPHPscript,27—28datatypes,32DocBlocks,220file/folderpermissions,231installing,6verifyinginstallation,13magicmethods,214operators,47—54PDO(PHPDataObjects),116—118reservedwords,66settingupdevelopmentenvironment,3—28superglobalarrays,69—95user-defineds,66—67viewingsourcecodeinPHPproject,166PHPdelimiters,30PHPfilesseefilesPHPfunctionsseefunctionsPHPfunctions,listofseefunctions,listofPHPPHPmanual,29PHPProjectwindow,24PHPscriptsseescriptsPHP_SELFvalue,$_SERVER,75phpMyAdmincreatingentriestablein,127creatingnewdatabasein,126PNGimagesdeterminingfileextensionofuploads,237POSTmethod,82deletingentriesindatabase,201verificationofentryforminput,133,134verifyingformwassubmittedusing,88$_POSTsuperglobalarray,82—84arraycontainingthecontentsof,84checkingiflogincredentialsvalid,330deletingcommentsindatabase,308deletingentriesindatabase,201insertinghiddeninputsinHTMLforms,165,168usingpreparedstatementswithMySQLi,113,116verificationofentryforminput,134PosttoTwitterlink,362—368creatingshortenedlinkwithhttp://bit.
ly,363—365postpendingvariables,51postToTwitter()function,365,366preg_replace()function,180prepare()method,MySQLi,115prepare()method,PDO,117,135preparedstatements,111,116usingpagetofilterdatabaserecords,160usingwithMySQLi,113—116prependingvariables,51,52INDEX381preprocessing,4presentationlayermappingfunctionstooutputsavedentries,141writingpresentationcode,149—154presentationlogic,140PRIMARYKEYkeywords,MySQL,102print()statement,41print_r()function,49debuggingarrays,75printf()statement,43privatekeyword,OOP,212,213proceduralinterface,109comparedtoOOP,112,212processingdatabusinesslogic,140processUploadedImage()method,ImageHandlerclass,219,221callingcheckSaveDir(),232callingdoImageResize(),258callinggetImageExtension(),238callingrenameFile(),238determiningfileextensions,237programmingOOP,211—218planningscripts,139—154separationoflogicin,139—140programmingpatternsModel-View-Controller(MVC)pattern,140MultitierArchitecturepattern,140projectschoosingEclipsePDTprojectworkspace,20creatingEclipseproject,23—26creatingPHPproject,23PHPProjectwindow,24viewingsourcecodeinPHPproject,166promotingwebsites,170properties,OOPaccessing,214classproperties,212privatekeyword,212visibilitydeclarationsfor,213protectedkeyword,OOP,213pubDatecreatingfromMySQLtimestamp,274publickeyword,OOP,213publishingdate,RSSfeeds,272Qquery()method,MySQLi,113quotesdouble-quotesyntax,34single-quotesyntax,33Rrand()function,354randomnumbers,354realnumbers,37ReallySimpleSyndicationseeRSSrecursivefunctions,148redirects,155redundantdataavoidingstorageof,118—121referenceassignmentbyreference,49regex(regularexpressions),171creatingcharacterclasses,191enclosingpatternsindelimiters,182furtherinformationon,172makingexpressionslazy,174matchingeithernothingorsomething,190matchingnon-wordcharacters,181matchingwordcharacters,173negativelookahead,181optionallymatchingperiod(.
)in,342patterns,172settinguprulesforURLrewriting,172signifyingendofstring,190useofsymbolsinregex$,172,173,174,190*,342+,173,181,174!
,181\,172\s,181\w,173,181(),172[],174,191^,173|,172,190usinginvalidateEmail()method,342wildcardsin,342relationaldatabasemanagementsystems,97relativepaths,137releases,productionvs.
development,4REMOTE_ADDRvalue,$_SERVER,75INDEX382renameFile()method,ImageHandlerclass,237replacements,URLrewriting,173makeUrl()function,181preg_replace()function,181$_REQUESTsuperglobalarray,84—85REQUEST_METHODvalue,83require/require_onceconstructs,63reservedwords,66resizingimages,248—259determiningdimensions,249—252determiningfunctionstouse,252—254resamplingimageatpropersize,254—258retrieveComments()method,293,296retrieveEntries()function,141—148,150adding$pagevariableasargumentinindex.
php,159creatingblogentries,266,267creatingdifferentviewingstylesforpages,185modifyingindex.
phptocheckforurlnotid,178modifyingtoacceptURLnotid,176modifyingtoretrieveimages,244—246modifyingtoreturncreatedcolumn,272populatingformwithentrytoedit,192usingpagetofilterdatabaserecords,159returnstatement,63,67returnvaluesdescriptionsofmethodsusingDocBlocks,220RewriteBasedirective,172RewriteEnginedirective,171RewriteRuledirectivecreatingRSSfeeds,264modifyingruleforadmin.
phpaccess,190settingupruleforadmin.
phpaccess,173,174settingupruleforpage-onlyURLs,174settinguprulesforURLrewriting,172rewritingURLsseeURLrewritingRFC-822format,272,274RSS(ReallySimpleSyndication),263creatingRSSfeeds,264—277formatfor,264publishingRSSfeeds,278—280RSSaggregators,263makingRSSfeedavailabletonon-browsers,279—280RSSfeedscreating,264—277creatingfeeditems,266—277describingfeeds,265—266makingavailabletobrowsers,278—279makingavailabletonon-browsers,279—280publishing,278—280publishingdate,272usingURLasGUID,271rsstag,versionattribute,265rss.
phpfilecreatingblogentries,266,267,268creatingRSSfeeds,264describingRSSfeeds,265insertingGUID,271reformattingandaddingdate,275rulesaccessingbackreferences,rewriterules,173flags,173modifyingruleforadmin.
phpaccess,190—191patterns,172replacements,173settingupruleforadmin.
phpaccess,173settingupruleforpage-and-entryURLs,174settingupruleforpage-onlyURLs,174settinguprulesforURLrewriting,172SS(skip)flag,URLrewriting,173sanitizeData()function,141,148—149,151SaveEntrybutton,133,134save_dirproperty,ImageHandlerclass,219creatingfoldertostoreimages,230savinguploadedfiletofilesystem,223saveComment()method,289emailaddressvalidationforpostingcomments,343,347,348modifyingupdate.
inc.
phptocall,291spampreventionusingsimplemathquestion,359scaling,125planningscripts,139scopeglobalscope,70localscope,71variablescope,70—73scripttags,HTML,31scriptedlanguages,4scriptingINDEX383client-sidescripting,4—5server-sidescripting,4—5scriptschoosingSDK/IDE,15connectingPHPscriptstoMySQL,109—118creatingPHPscript,27—28emailaddressvalidationforpostingcomments,341—353embeddingPHPscripts,29—31planningscripts,139—154mappingfunctionstooutputsavedentries,140redirects,155separationoflogicinprogramming,139—140writingbusinessfunctions,148—149writingdatabasefunctions,141—148writingpresentationcode,149—154scripttoprocessentryforminput,132—138usingclasses/objectsinscripts,215—218SDKs(softwaredevelopmentkits)benefitsof,15choosingSDK,15,18EclipseSDK,18searchengineoptimization(SEO),170searchenginesindexingURLs,170SELECTstatement,MySQL,105—107avoidingshortcutselector(SELECT*),122JOINclause,108USINGclause,108WHEREclause,106SelectWorkspaceDirectorywindow,21SEO(searchengineoptimization),170$_SERVERsuperglobalarray,74—77checkingREQUEST_METHODvalue,83creatingfoldertostoreimages,230savinguploadedfiletofilesystem,223verificationofentryforminput,134server-sidescripting,4—5$_SESSIONsuperglobalarray,89—93addingerrormessagestocommentsform,348displayingcontrolstoauthorizedusers,330,331displayingstoredcommentinformation,345hidingadministrativelinksfromusers,318loggingusersout,337savingcommentsinsessions,344spampreventionusingsimplemathquestion,354,358session_destroy()function,92loggingusersout,339session_start()function,90displayingcontrolstoauthorizedusers,331hidingadministrativelinksfromusers,318sessions,89—93,318SETkeyword,UPDATEstatement,MySQL,107setcookie()function,93sha1()function,316SHA1()hash,passwords,331shell-stylecomments,47shorttags,31XMLdeclarationsconflictwith,265short_open_tagdirective,31shortenUrl()function,363,364,365showCommentForm()method,286emailaddressvalidationforpostingcomments,345,350spampreventionusingsimplemathquestion,356,360showComments()method,296,300,301hidingdeletelinkfromunauthorizedusers,323storingoutputof,302simple_blogdatabaseadmintable,311commentstable,283—285creatinginphpMyAdmin,126deletingentries,197—204displayingentries,138—139entriestable,125—132addingimagecolumn,241addingpagecolumn,157addingurlcolumn,176creatinginputformfor,128—132simple_blogprojectAbouttheAuthorpage,162,164admin.
phpfile,128addingfileinputto,207modifyingtosavepageasssociations,165—168modifyingaccessrule,190—191administrationcreatingadministrativelinks,187—188displayingadministrativelinks,188—190restrictingadministrativeaccess,311—340blogentriesINDEX384creating,266—277previewingwithfriendlyURL,175commentingsystem,283—310emailaddressvalidationforpostingcomments,341—353creatingdirectorytostoreimages,232creatingfriendlyURLsautomatically,175—183functions.
inc.
phpfile,141,143,144,145,147modifyingtohandleURLs,176—178.
htaccessfilecreating,171—175creatingfriendlyURLsusing,170—175passingURLvaluestoadmin.
phpwith,190—191incfolder,132index.
phpfile,138modifyingtohandleURLs,178—180populatingformwithentrytoedit,191—194PosttoTwitterlink,362—368previewspageloadedwithURLvariables,161programmingpattern,140redirects,155RSSfeeds,264,265—266makingavailabletobrowsers,278—279makingavailabletonon-browsers,279—280scripttoprocessentryforminput,132—138connectingtodatabase,134—135retrievinguniqueID,136savingvaluesinentriestable,135verificationofinput,133spamprevention,353—362syndicatingcontent,264—281update.
inc.
phpfile,132,135modifyingtosaveURLsindatabase,182updatingentriesindatabase,194—197webpagesaddingmenuto,184creatingdifferentviewingstylesfor,185—186modifyingfunctionstoacceptpageparameters,158—164savingpageasssociations,168—169simplexml_load_string()function,364single-quotesyntax,33sizevalue,$_FILES,85skip(S)flag,URLrewriting,173softwaredevelopmentkitsseeSDKssourcecodeviewinginPHPproject,166spampreventionAkismet,353CAPTCHA,353emailaddressvalidationforpostingcomments,341—353usingsimplemathquestion,354—362sprintf()statement,45SQLinjection,111src_arguments,imagecopyresampled(),255,256stringoperators,47,54strings,33—37double-quotesyntax,34escapingcharactersin,33heredocsyntax,36nowdocsyntax,36single-quotesyntax,33stringconcatenation,35strip_tags()function,111,148,289strtolower()function,181strtotime()function,274,300subtractionoperator,48superglobalarrays,69—95$_COOKIE,93—95$_FILES,85—89$_GET,77—82$_POST,82—84$_REQUEST,84—85$_SERVER,74—77$_SESSION,89—93$GLOBALS,73switchstatement,61syndicatingcontent,264—281syntaxhighlighting,16Ttables,MySQLaddingcolumns,157,176admintable,311ALTERTABLEstatement,103automaticallypopulatedfields,128commentstable,283—285CREATETABLEstatement,100—102datastorage,97DELETEstatement,109entriestable,125—127INDEX385indexingcolumns,103INSERTINTOphrase,103—105JOINclause,108manipulatingdatain,98—109modifyingdatain,107planningdatabasetables,118—122retrievingdata,105frommultipletables,108SELECTstatement,105—107UPDATEstatement,107tagsstrip_tags()function,148ternaryoperator,150,166TEXTtype,MySQL,102textareatag,128,193this($this)variable,214throwkeyword,OOP,222timeformattingcharacters,299time()function,93titlecolumn,entriestable,125,128savingvaluesinentriestable,135verificationofentryforminput,133,134tmp_namevalue,$_FILES,85ToyRobotclass,212declaringprivatepropertyin,213writeName()method,215,216ToyRobot.
phpfile,212try.
.
.
catchstatement,226—228Twitter,363generatingautomaticstatusupdatefor,365—368PosttoTwitterlink,362—368postToTwitter()function,365,366typevalue,$_FILES,85Uunderscore(_)characterdenotingprivateproperties,213uniqueIDretrievingfornewentry,136unset()function,92,93,358UPDATEstatement,MySQL,107importanceofWHEREclause,108update.
inc.
phpfile,132accessinguploadedfiles,208—211addingerrormessagestocommentsform,349checkingiflogincredentialsvalid,330,331handlingcommentdeletion,307—310handlingnewcomments,291—293includingdatabasecredentials,135loggingusersout,339redirects,155retrievinguniqueIDfornewentry,137savingimages,225—226savingnewadministratorsindatabase,315,316savingpageasssociations,168—169savingpathtoimages,241—244savingURLsindatabase,182savingvaluesinentriestable,135testingcheckSaveDir()method,233—236updatingentriesindatabase,195UPLOAD_ERR_OKconstant,221uploadingfiles,85accessinguploadedfile,208—211addingfileinputtoadmin.
php,207changingenctypetoacceptfileuploads,207checkingfileuploadedandwithouterrors,88checkingfileuploadedisJPGimage,88checkingforerrorduringupload,221—222checkingwhetherfilewasuploaded,208move_uploaded()function,224retrievingfileinformation,221savinguploadedfiletofilesystem,223—225savinguploadedimages,219uploadingimagescreatingfoldertostoreimages,228—236determiningfileextensions,237ensuringimagenameisunique,236handlingerrorswithtry.
.
.
catch,226—228savinguploadedimages,219uploadingphotos,88urlcolumn,entriestable,176URLencoding,78URLrewritingaccessingbackreferences,173declaringbase-levelfolder,172flags,173furtherinformationon,172patterns,172replacements,173settingupruleforadmin.
phpaccess,173settingupruleforpage-onlyURLs,174settinguprulesforrewriting,172turningon,171using.
htaccessfile,170urldecode()function,78INDEX386urlencode()function,78URLsacceptingpageinfo.
inURL,158—159accessingURLvariables,78—82blogpreviewspageloadedwithURLvariables,161creatingfriendlyURLsusing.
htaccess,170—175creatingfriendlyURLsautomatically,175—183ensuringvariablepassedwhenlinkclicked,166enteringURLwithouttrailingslash,174modifyingfunctions.
inc.
phptohandle,176—178modifyingindex.
phptohandle,178—180modifyingupdate.
inc.
phptosave,182passingentryIDsin,150passingURLvaluestoadmin.
phpwith.
htaccess,190—191previewingblogentrieswithfriendlyURL,175searchengineindexingof,170searchengineoptimization,170settingupruleforpage-and-entryURLs,174shortenUrl()function,363,364usingasGUIDforblogentries,271user-defineds,66—67usernamecolumn,admintable,311users,restrictingadministrativeaccessaddingadministratorsindatabase,312—317creatingloginform,328—330displayingcontrolstoauthorizedusers,330—337hidingadministrativelinksfromusers,318hidingcontrolsfromunauthorizedusers,318—328hidingdeletelinkfromunauthorizedusers,323loggingusersout,337—340USINGclause,SELECTstatement,MySQL,108VvalidateEmail()method,Commentsclass,342—343validationemailaddress,forpostingcomments,341—353VALUESkeywordINSERTINTOphrase,MySQL,103varkeyword,OOP,213VARCHARtype,MySQL,101,102variables,32accessingURLvariables,78—82arrays,38—41Booleanvalues,37concatenating,36declaringasNULL,160ensuringpassedwhenlinkclicked,166floatingpointnumbers,37integers,37placinganoperatorsignbefore/after,51postpending,51prepending,51,52scope,70—73storingvaluesin,32strings,33—37superglobalarrays,69verifyResponse()method,Commentsclass,358versionattribute,rsstag,265Viewoption,browsermenu,166viewscreatingdifferentviewingstylesforpages,185—186voidkeyword,42Wwebpagesacceptingpageinfo.
inURL,158—159accessingpubliclydisplayedpages,174addingmenu,184checkingpagebeforedisplayingdelete,189creatingdifferentviewingstylesfor,185—186differentiatingbetweenmulti-andsingle-entrypages,185modifyingadmin.
phptosavepageasssociations,165—168modifyingfunctionstoacceptpageparameters,158—164modifyinglinksbetween,162movinginformationfrompagetopage,69passingdatabetweenpagesusingGET,77passingdatabetweenpagesusingPOST,82savingpageasssociations,168—169supportingmultiplepages,157INDEX387usingpagetofilterdatabaserecords,159—164websitemarketing,170websitesaccessingIPaddressofsitevisitors,74addingmenutopages,184creatingfriendlyURLsusing.
htaccess,170—175creatingfriendlyURLsautomatically,175—183dynamicwebsites,3identifyingsitereferringvisitor,74,77modifyingfunctionstoacceptpageparameters,158—164nameofhostsite,74storinginformationonuser'smachine,93,95WHEREclause,MySQLDELETEstatement,109SELECTstatement,106UPDATEstatement,108usingpagetofilterdatabaserecords,159whileloop,56whitespace,36Windowssettingmagic_quotes_gpcOff,15wordcharactersmatchingnon-wordcharacters,181matchingwordcharacters,173WorkspaceLauncherwindow,20workspaceschoosingEclipsePDTprojectworkspace,20writeName()method,ToyRobotclass,215,216XYZXAMPP,6downloading,7FTPoption,13installing,6—15testinginstallation,11—13verifyingApache/PHPrunning,13verifyingMySQLrunning,14XAMPPControlPanel,11xamppfolder,7,11XML(ExtensibleMarkupLanguage),264XMLdeclaration,265XORoperator,53yearformattingcharacters,299