7 Task 4 Creating Database and Data TablePHP动态网站开发项目教程课件

Project1MemberManagementSystemSchoolofSoftware,ChengduPolytechnicLecturer:MuQichunTask4CreatingDatabaseandDataTableCreatingDatabaseandDataTablewithphpMyAdminEnablethemysqldatabaseserviceinphpStudy.LogintheDatabaseinterfacetoviewthedatabaseadministratoraccountanditspassword.Or,click+CreateDatabasetodirectlyanewdatabase,andthensetausernameanditspasswordforaccess.Thedefaultadministratoraccountisrootandthepasswordisrootaswell.Theaccountcanbeusedforaccessingandmanagingalldatabasesinthecurrentserver.CreatingDatabaseandDataTablewithphpMyAdminLogintheSoftwareManagementinterface,clicktheToolbaronthetop,andclicktheDatabaseTool(Client),andinstallathird-partytoolsoftwaretomanagethemysqldatabase.Inadditiontomanagingthemysqldatabasewiththetoolsoftware,thewebtoolismorecommonlyusedformanagingthedatabase,makingthestepsimpleandconvenient.ClickWebApplicationonthelefttoolbar,andclickDatabaseTool(web)ontherightside.Bydoingso,onetoolphpMyAdminappears,whichisthemysqldatabasemanagementtoolpureforthewebversion.Clickthetoolandinstallit.Toinstallthetool,selecttheinstallationlocationatfirst.Generally,thedefault“localhost”websiteisok.CreatingDatabaseandDataTablewithphpMyAdminAfterphpMyAdminisinstalled,clickAdministrationtoopen“phpMyAdmin”inawebpage,asshowninFigure2.5.3.CreatingDatabaseandDataTablewithphpMyAdminAfterthedatabaseiscreated,thenextstepistocreatethedatatable“info”,andcreate7datafieldsin“info”,includingid(IDfield,astheuniqueidentificationofeachrowofdata),username,pw(password),email,sex,fav(favorite)andcreateTime.Descriptionofeachfieldisasfollows.CreatingDatabaseandDataTablewithphpMyAdminid:Whencreatingafield,eachdatatablemusthasoneidfield,whichisthemasterkeyofthetableandusedforidentifyingeachrowofdata.Thefieldisofthetype“INT”.Checkthe“A_I”identitycolumnbelow,andsetitasan“AUTO_INCREMENT”field.Inthecourseoffurtheruse,itisnotrequiredtoprovidethevalueofthefieldwhencreatingarecord.Thesystemwillautomaticallyprovidethevaluefrom1insequence.username:Itisofthetype“VARCHAR”andis50inlength,thatis,thefieldcontainsvariablecharacterswiththemaximumlengthof50characters.Inotherwords,ifonly1characterisentered,thelengthis1.Themaximumlengthis50.pw:Itisofthetype“CHAR”andis32inlength.Whensavingapasswordinadatabase,thepasswordcannotbesavedastheplaintext,whichneedstobeencryptedandsavedastheciphertext.Generally,theencryptionismadeintheformofmd5.Generally,md5isusedforencryptingthefixedlengthof32bits.Therefore,thefieldisofthetype“CHAR”,withthefixedlengthof32bytes.email:Itisofthetype“VARCHAR”andis256inlength.sex:Itisofthetype“TINYINT”andis1inlength.fav:Itisofthetype“VARCHAR”andis300inlength.createTime:Itisofthetype“INT”.Thefield“createTime”isofthetype“DATETIME”or“DATETIME”.Ifitisofthetype“DATETIME”,thetimeisdirectlysavedintheformofdatetime.Ifitisofthetype“INT”,thetimeissavedintheformoftimestamp.Thetimestampisa10-bitinteger,specifically,thetotalsecondsfromJanuary,1,1970,00:00:00GMT(January,1,1970,08:00:00,BeijingTime)tonow.ConclusionThislecturespecifieshowtoinstallphpMyAdmin,howtocreateadatabasea