14 Task 11 Member Information ModificationPHP动态网站开发项目教程课件

Project1MemberManagementSystemSchoolofSoftware,ChengduPolytechnicLecturer:MuQichunTask11MemberInformationModificationDisplayExistingInformationintheFormCheckthememberloginfunctionwemade.Afterloggingin,wesavetheloginsessionidentifier.Thepagestaysatthelogininterfacesincewehavenootheractions.Atthistime,weshouldaddajumpfunctiontomakeiteitherjumptothehomepageortothepersonalinformationmodificationpage.WemodifythepostLogin.phpfile.Iftheloginsucceeds,itjumpstoindex.php;iftheloginfails,returntothelastpagedirectly.DisplayExistingInformationintheFormInthenav.php,wehaveaddedthetargetpagemodify.phptothepersonalinformationmodificationpage.Therefore,weshouldcreateanewfilemodify.phpinthememberitem.Thecontentofthisfileisquitesimilarwiththatofsingup.php,sowemaycopyitdirectlyformodification.Whenmodifyingtheinformation,weneedtodisplaytheexistingallkindsofinformationintheform.Aftertheinformationismodified,clicktheSubmitbuttontosubmitthedatatothebackoffice,thenwecanusetheupdatestatementinSQLtoupdatetheformrecord.Whenmodifyingtheinformation,weshouldpayattentiontotheprocessingmethodofpassword.Therearetwoproposedmethods:1)Leavethepasswordblankbydefault,inwhichcase,anewpasswordandaconfirmpasswordarerequiredifyouneedtomakemodification,orthepasswordwillnotbemodifiedifnocontentisfilledin.2)Addacheckboxbehindthepassword,inwhichcase,checkingtheboxrepresentsthepasswordwillbemodified,ornotcheckingtheboxrepresentsthepasswordwillnotbemodified.Whenmodifyingtheinformation,weshouldcheckifthecurrentuserhasloggedin.Theinformationcanonlybemodifiedaftertheuserlogsin.Andingeneral,theusernameisnotallowedtobemodified.Front-endCodeFront-endCodeFront-endCodeInthemodifyh.phppage,weusedsession.So,weaddedthesession_start()attheverybeginningofthepagetostartasession.Thenweneedtojudgeifthecurrentuserhasloggedin.Ifnot,theinformationmodificationwouldmakenosense.Weshouldatfirstjudgewhether$_SESSION['loggedUsername']exists.Ifyes,theuserdoesnotlogin.If$_SESSION['loggedUsername']exists,weshouldjudgewhetherthevalueisnull.Ifitisnull,itindicatesthattheloginisinvalid.Iftheuserdoesnotlogin,apopupwillshowanditjumpstothelogininterface.Becauseweneedtodeterminethelogininseveralpages,wecanplacethispieceofcodeinaseparatefileandincludeitwhennecessary.Next,weuseinclude_once'nav.php';andinclude_once'conn.php';toincludethenavigationbaranddatabaseconnectingfiles.Wethenuse$sql="select*frominfowhereusername='".$_SESSION['loggedUsername']."'";statementtoquerywhethertheusernameofthecurrentuserloggedinexistsinordertoguaranteetheexistenceofthecurrentuserandthereliabilityoffollow-upoperations(whichaimstoincreaseprecisenessofoperations,forexample,whatifauserisdeletedbytheadministratorwhenhe/shejustlogsin?)Ifthecurrentuserdoesnotexist,ahintwillshowandtheprogramwillbesuspended.Iftheusersexists,themysqli_fetch_array(result,resulttype);functionwillbeusedtotakealineofdatafromtheresultsetandsaveitto$infoarray.Thislineofdatacanbeeitheranassociativearrayordigitalarrayorbothofthem.Front-endCodeThehobbyneedstobeprocessedseparatelybecausethehobbysavedindatatableisacharacterstringconnectedbymultiplevalues.Inthefront-endinterface,weneedtosplitthecharacterstringintoanarrayinorderthatitcanbeautomaticallycheckedinfrontoftherelatedhobby.Weusethefunctionexplode(separator,string,limit).Theexplode()functionwilluseacharacterstringtodivideanothercharacterstringandreturnthearraycomposedofcharacterstrings.Next,itisaboutthedisplayingofallkindsofinformationintheform.Itissimpleforausernameandanemailasweonlyneedtodirectlydisplaythevalueinthevalue.Becausetheusernameisuniqueandunchangeable,wecanaddareadonlyattributetotheusername.Forthepasswordandconfirmpassword,weleavethemblankifnomodificationisrequired.Forradiobutton,judgeifthecurrentvalueistrueorfalse(0and1indatabase)directly.Forcheckbook,itrequiresmoreeffortsbecauseweusedthefunctionin_array.Thein_array()functionwillsearchifanassignedvalueexistsinthearray.Back-endCodeBa