53 Task 8 Application of Database in Laravel (for User Login)PHP动态网站开发项目教程课件

Project3OverwritetheMemberAdministrationSystemwiththePHPFrameworkLaravelTask8ApplicationofDatabaseinLaravel(forUserLogin)SchoolofSoftware,ChengduPolytechnicLecturer:MuQichunWehavefinishedthesheetdataverification.Next,let'sconnecttoadatabasetodetermineiftheuserhasloggedintothedatabase.ApplicationofDatabaseinLaravel(forUserLogin)Tomakeuseofadatabase,weneedtouseamodel.First,configurethedatabase.Opena.envfileandconfigurethedatabase:ApplicationofDatabaseinLaravel(forUserLogin)Or,maketheconfigurationinconfig/database.php,butgivefirstpriorityto.envconfigurationfile.Next,entercommandsbelowataterminaltocreateamodel:ApplicationofDatabaseinLaravel(forUserLogin)Themodel,withthefilenameUserModel.php

isautomaticallyproducedunderapp/Models.Modifythemodelfilebyreferringtocodesbelow:Inamodelfile,informationsuchasdatatableandprimarykeyfieldhavebeendesignated.ApplicationofDatabaseinLaravel(forUserLogin)Next,modifyacontroller,andcheckiftheusernameandpasswordarecorrectfromthedatatable.Modifyrelevantverificationdeterminationcodesinthecontroller:Obviously,whenacorrectcaptchaisentered,youcansearchiftheenteredusernameexistsinthedatatableviaUserModelofthemodelinthe4thline.Throughfirst(),thefirstsatisfactoryrecordcanbereturned.Usethe5thlinetodetermineifthisusernameisfound.Ifnot,addoneerrortothepasswordfieldatthe6thline,andreturntheerrorinformationtotheloginfrontendpagefromthe7thline.ApplicationofDatabaseinLaravel(forUserLogin)The9thlineisusedforsearchingfromthedatatabletheusernameandpasswordenteredbytheuser.Whenthe15thand16thlinesindicatethatcorrectrecordsarefoundaccordingtothedesignatedusernameandpassword,thismeanstheloginissuccessful,theusernameofthecurrentloggeduserandissavedinsession,andiftheadministratorinformationissavedinsession.Inthe17thline,thecurrentloggeduserisdeterminedastheadministratorornot.Ifyes,redirecttoanewviewwhichislocatedunderview>admin>index.Ifnot,directlysetanindexview.Correspondingparameterswillbecarriedatthetimeofredirection.Theseparameterswillbereadandusedinatargetview.ApplicationofDatabaseinLaravel(forUserLogin)ItisfoundinPhpStormthatthroughthewheremethodofthemodelinthe4thline,thesystempromptisunavailable.Thesolutiontothisproblemissimple.Justexecutecommandsbelowataterminal,andrebootPhpStorm:ApplicationofDatabaseinLaravel(forUserLogin)ApplicationofDatabaseinLaravel(forUserLogin)Thehomepageprocessinghasbeenbriefedinthepartofviewandroute.Now,maincontentsonthehomepagecanbenormallydisplayed.AfterauserlogsintoLaravel,informationofthecurrentloggeduser,suchastheusername,isavailable.Atthistime,youneedtoupdaterelevantinformationinnav,tonormallydisplaythecurrentloggeduser.Amongtheabovecodes,whenthecodesofthe18thand21stlinesareusedforredirectingtotheadministratorinterfaceorhomepage,theycarrycorrespondingparameters.Next,let'sreadanddisplaytheminnav.Pleasemodifyrelevantcontentinnavbyreferringtocodesbelow:ApplicationofDatabaseinLaravel(forUserLogin)ApplicationofDatabaseinLaravel(forUserLogin)Obviously,wecanreplacetheoriginalifstatementwiththe@iftemplatetag,oruse@phptowriteanativePHPcode.Inthe1stline,wehavejudgedifthevariable$loggedUsernameexists.Whenweenterthehomepageforthefirsttime,thesystemisnotloggedinto.Therefore,thisvariabledoesnotexist.Aftersuccessfulloginandredirectingtothehomepage,thisparameteristransmitted.Therefore,todealwithvarioussituations,weneedtodetermineifthevariableexistsbyusingisset.Ifyes,theusernameofthecurrentloggeduserwillbedisplayed,andalogoutlinkwillbedisplayedaswell.Next,determineifthecurrentloggeduseristheadministratorornot.Ifyes,"Welcome"willbedisplayed.ApplicationofDatabaseinLaravel(forUserLogin)Wehavemodifiedthetargetaddressofnavigationlinksinthe13thand19thline,withtheurlhelperusedforgeneratingaddresses.Onthehomepage,wedirectlyredirecttothe"/"routewhichhasbeenaddedattheverybeginning.Thisalsoappliestothe"memberlogin"linkthroughwhichwecandirectlyredirecttotheroute"login".Wehavecompletedthebackgroundadministrationroutewhichhaven'taddedtoweb.phpyet.Next,let'saddthisroute.Thelogintestresultisshowninthepicturebelow:ApplicationofDatabaseinLaravel(forUserLogin)Next,let'saddthe"Logout"function.First,modifythelogoutlink.Wehaveusedtheroute"logout".Forthisroute,let'slogoutjustthroughacontroller.Secondly,addlogoutmethodintheLogincontroller.Specially,usetheflush()methodtoclearsession.ApplicationofDatabaseinLaravel(forUserLogin)Createarouteinweb.php.Logoutiscompletenow.SummaryTocompleteuserlogin,weneedtoreadrecordsinadatatableinLaravel.ThisneedstouseamodelinLaravel.ThemodelinLaravelisamethodforquicklyo