16 Task 13 The Administrator Views All MembersPHP动态网站开发项目教程课件

Project1MemberManagementSystemSchoolofSoftware,ChengduPolytechnicLecturer:MuQichunTask13TheAdministratorViewsAllMembersCircularlyOutputtingRecordsinDataTableTheadministratorcanentertheback-endmanagementafterlogin.Intheback-endmanagement,firstlycheckthelistofallmembers.Afterqueryingthedatabase,circularlyreadcontentsfromtherecordset,andoutputtheminsequence.Itisnecessarytoaddpermissionjudgmentcontentinthefileonalladministratorpagestoensurethattheadministratorcanviewthepageafterlogin.Next,separatelycreateacheckAdmin.phpfileusingthemethodofcreatingdatabaseconnectionfile,todeterminewhethertheadministratorhaspermission.CircularlyOutputtingRecordsinDataTableThen,createadmin.phpfile.Thecompletecodeofthisfileisasfollows:CircularlyOutputtingRecordsinDataTableCodeAnalysisFirstly,thecheckAdmin.phpfileisavailableattheopeningofthefile,whichisusedtodeterminewhetherthecurrentstatusistheadministratorloginstatus.Ifthestatusisinvalid,thesystemautomaticallyjumpstotheloginscreen.Next,use$sql=“select*frominfoorderbyiddesc”fordatatablequery,then,obtaintherecordsetbythefunctionmysqli_query,takeadataatatimebywhileloop,andoutputthecontentofeachcolumn.Displayoneserialnumberinthelist.Createavariable$i,add1tothevariableaftereachloop,andoutputtheminsequence.Itshouldbenotedthat,thisserialnumberisnotIDcolumnintherecordsofdatatable,becauseIDmaynotjuststartfrom1.Ifsomerecordsaredeleted,thisIDmayalsonotbecontinuous.Whendisplayingwhetheritistheadministrator,use?expressiontojudgethevalueof$info['admin'].DisplayYesifitistrue(thatis,1),otherwise,displayNo.Thelastcolumnisusedinthesubsequentoperation,i.e.,“Deletemembers”and“Setadministrator”.ConclusionThislectureintroducesthemeth