16 Task 13 The Administrator Views All MembersPHP動(dòng)態(tài)網(wǎng)站開發(fā)項(xiàng)目教程課件

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