基于PHP和MySQL的网站设计外文资料

DesignandImplementationoftheWebsiteBasedonPHP&MYSQLAbstractPHPandMYSQLhasbeenthemainwebdevelopmenttoolforitisfreeandopensource.TheauthorshavediscussedtheenvironmentalissuesindevelopmentprocessbasedonPHPandMYSQLandtheimplementationprocessofthewebsite.KeywordsPHP;MYSQL;Developmentand.Implementation1.INTRODUCTIONWiththedevelopmentofWebtechnology,itisinevitablechoiceforallkindofcorporategrowthtocombinetraditionalmarketingwithnetworkmarketing.Theeffectivemethodofnetworkmarketingistoestablishthewebsitewhichissuitablefortheircompany.Atpresentthewebsitedevelopment'smainstreamplatformincludes:LAMP(Linuxoperatingsystem,Apachenetworkserver,MYSQLdatabase,PHPprogramminglanguage),J2EEand.Netcommercialsoftware.BecausePHPandMYSQLisfree,opensourceandsoon,theyarenotedforITprofessionals.Fromtheperspectiveofwebsitetraffic,morethan70%ofwebsitetrafficisprovidedwithLAMP,whichismostpopularplatformfordevelopingthewebsite.Inthispaper,wedesignedawebsitebasedonPHPandMYSQL.Thepaperisorganizedasfollows.Section1analyzesdevelopmentenvironment.InSection2,weproposedthedevelopmentmodelbasedonPHP.ThencasestudyinSection4.wemakeconclusionInSection5.2.DEVELOPMENTENVIRONMENTANALYSISA.TheChoiceofDevelopmentLanguageASP.NET,PHP&JSParethreemainstreamlanguagesofthewebsitedevelopment,whichhavetheiradvantagesanddisadvantagesrespectively,thecomparisonbetweenthemisshowninTable1.TheprojecttakesPHPasthedevelopmentlanguage,thereasonisasfollows:•Free.Theprojectissmall,whichisnoneedtousethepaymentdevelopmentplatformsuchasASP.NETandJSP.•Strongsupporting.Middleandsmallscalewebsites,evensomelarge-scalewebsitessuchasbaidu,SinainChinatakePHPasthedevelopmentlanguage,whichcancontributetosolvetheproblemduringtheprogramming.•Goodportability.AlthoughitisdesignedtouseintheenvironmentofLinuxandApacheWebserversystematfirst,nowPHPisalreadytransplantedanyoperatingsystemandcompatiblestandardWebserversoftware.•Simplegrammar.PHPhasmanysimilaritieswiththeCprogramminglanguage,soitiseasytoprogramusingPHPfortheCprogrammers.•Rapiddevelopment.Becausethesourcecodeisopen,PHPwillcontinuetodeveloprapidly.B.BuildDevelopmentEnvironmentAtpresenttherearemanydevelopmentplatformbasedonPHP.GenerallymostdeveloperslikethedevelopmentenvironmentLAMP.Thosewhohavecertaindevelopmentexperiencecansetuptheirdevelopmentplatformbychoosingtherelatedserver,DBMS,andoperatingsystem.TherearesomePHPIDE(integrateddevelopmentenvironment)suchasAMPSERV,WAMP,XMAPP,APPSERV,PHPSTUDYinthemarketforthedevelopersdevelopthewebsitebyusingPHP.AtpresentthemainPHPIDEisZendStudio,whichhasincludeddevelopingcomponentsforPHP.Itreducesthedevelopmenttimeandsimplifiesthecomplexapplicationplanduringedition,debugging,analysisandoptimization.TheZendStudionotonlyhascodeforhighmeasurement,grammarshrinkingautomaticallyandbookmark,butalsoitsembeddeddebuggerwhichfitsforlocalandremotedebuggingpatterns.Itismanyhighdebuggingfunctionssuchasvariabletracking,Single-stepoperation,breakpoint,functioncalling,andsoon.Moreover,itisalsoverystableinsupportingChineseforthelatestversion.C.NotesinBuildingtheDevelopmentEnvironmentThosewhoareunfamiliarwiththedevelopmentenvironmentdonotsetitupbyhimselfforitmaycauseaconflictbetweenvariousedition,moreoveritisverydifficulttosolvethecomplexconfigurationproblem.•PHPlanguageversion.Beforedevelopment,youmustensureconsistenceoftheeditionbetweenPHPlanguageandtheserver.NowPHPmainlyhastwoeditions(PHP4andPHP5).ThedifferentversionshavethedifferencewithSESSION,exceptionhandling,thevariablerange,thedatatypeandsoon.•Serverproblem.TheprogramwhichiseditedwithPHPinthewindowsplatformwillbearrangedontheapacheserver.IfitisarrangedonIISitleadstosomeincompatibleproblemsandsomeupdatebymanualsuchaswritablerightsissetupbeforeuploadingthedocument.Therearenottheseproblemsifitisarrangedontheapacheserver.•Databaseproblem.DBMSusingwithPHPhasMYSQL,ORACLEandsoon.MYSQLiswelcomedbymostofthedevelopersforitisopensource,free,andefficient.MYSQLisperfectdatabaseserversoftwareformediumandsmallapplicationsystem.BesidesstandardANSISQL,italsosupportsmanyplatforms.OntheUnix/Linuxsystem,MYSQLalsosupportsthemulti-thread.MYSQLbecomesthefirstchoiceofmiddleandsmalllevelPHPwebsiteforitisopensourceanditprovidesaseriesofsupportssuchasread-writeaccess.3.THEDEVELOPMENTMODELBASEDONPHPPHPbecomesthemaindevelopmentlanguageinthesmallandmedium-sizedenterprisewebsiteforitisfree,opensource,etc.Thedevelopmentstepisasfollows:A.DemandanalysisTherearevariousdemandsforawebsiteproject.Thosedemandsoftenstemfromorcompanyoneselfneeds,mostofwhichistheactualneedsofcustomers.Whatextenttheprojectleadersunderstandtheuser'sneedshasdecidedwhetherissuccessorfailureindevelopingthewebsite.Thereforeuser'sneedsintheformofdocumentcanclearlybetransformedintoallprojectdevelopmentmembers,whichisthemainproblemduringtheprojectdevelopment.Besidesbasicuser'sneeds,therearesomeproblemsasfollowsareneededtonotice:•Thedemandshouldbeconfirmedbywayofthedocument.•Thefeasibilityandpriceoftheirdemandsareinformedtothedemandsideaftereffectiveanalysisanddiscussion.B.FunctionalmoduledesignThedemandreportwillbeorgani