PHP課程設(shè)計(jì)報(bào)告

PHP編程基礎(chǔ)與實(shí)例教程課程設(shè)計(jì)報(bào)告

學(xué)生信息管理系統(tǒng)姓名：班級(jí)：14-1專業(yè)： 信息管理與信息系統(tǒng)完成日期：指導(dǎo)教師:StudentCourse(StudentID,CourseNumber,Marks);StudentInfo(StudentID,StudentName,Class,StudentPassword);Teacherinfo(TeacherID,TeacherName,TeacherPassword);TeachingInfo(CourseNumberTeacherlD);數(shù)據(jù)庫(kù)名稱：management擁有的表：administrator；Classinfo；Courseinfo；StudentCourse;Studentinfo；Teacherinfo；Teachinginfo；各個(gè)表的屬性及數(shù)據(jù)：Administrator(AdminlDchar(20)primarykey,,AdminNamechar(20),AdminPasswordchar(20));包含：管理員編號(hào)AdminlD、管理員姓名AdminName管理員密碼AdminPassword亡admlnlstiwItH?日廿dminktrMQF@manaqe.xFileEuitWindowHelp…NwMSjve3訕￡砧AcdFieldinsertFie<jDeleteFieh j.-'Primar/ <MovelFklds.Jndatesi-oreinrKeysriggersCJp'ionsmnrmcntS(JL-*rp^iewNameTypeIf阿hD吠im品kUgwNull>AdmrlDvarchar500 □AdminNtarrechar20o SAdrrn'rPa55ADTdyarchar500 fflAdminlDAdminNameAdrninPasswondjadnin張三admin自dmi忖2爭(zhēng)四^dnriinsadminS玨3cdminClassinfo(Classchar(20)primarykey,Majorchar(20),departmentchar(20));包含：班級(jí)號(hào)Class、專業(yè)Major、學(xué)院jf*idassinfoemanagment-.玉|OdaEnffl霞Egg所時(shí)rt3乂|I#EditWlrijcrtl-wlpE3NevrtrjSaveSaveAsrijjAddHeld三InsertFieldqDeleteField|PrimaryKey|#tJorafkkh；indexesparegnKeysiriagorrOptior&tanmentiQireviewNameTypeLengthDeciffs-HewMui>Clmsjchar50D□ 戶工Majorchar09depsrtmtntcihar如0department

ClassIVlajordepa七中￡n±osaiD計(jì)苜機(jī)計(jì)肯tn108Kl計(jì)司禮欽件OM510機(jī)城白城化白朗化比61口羥濟(jì)音理任首08309計(jì)苜機(jī)計(jì)算譏口8312輻江相08320信導(dǎo)安全計(jì)異機(jī)DS321值熨安全計(jì)算機(jī)primarykey,CourseNameCourseinfo(CourseNumberchar(20)char(20),Gradeint);primarykey,CourseName包含：課程編號(hào)CourseNumber、課程姓名CourseName學(xué)分|(flcoureeinfo甚nHFisggET..*]QCOiT弓aWo心manjggM,,—M]FifeFdhV^ndawH-lpBNePEm心鈿"Am.dAddA#ld""ReidDt-WjpFtldPrilTHi^fMmF-d￡-n匚ftc產(chǎn)roreqr7r?CFr:J[iticr^IL'cTirr^rr-rFJpwGradeLengthGradeLength[>ttcinidliAIIdvjNuil卜CfluneNLmb*rchar200>1CMH0NMTi也charwAGrftde加110互CourseNumbcrCuDuirseName Gradck1D01標(biāo)庫(kù) 5100!信息計(jì)量字 51003信息管理 510(M1005計(jì)到兒轉(zhuǎn)￡譙構(gòu) 41006軟件工程 410C7, 5StudentCourse(StudentIDchar(20),CourseNumberchar(20),Marksint);包含：學(xué)號(hào)StudentID、課程編號(hào)CourseNumber得分Marks亡tfudwfcMi*gmwatu.*.ISeludftittouiw磐mana聚xtileEditVfindojeHelp」?N-*(ri3sdvF早Jdddnrd3bupftFfc-ldriDe^Flfld.-MOWyrWds|indant]RWAfgnKays|T,槍第0|OpUan&|Ommmm]SQLMM?wNameTypeLerglhDedmdkaIIomNull卜StirtkntfDchar200CDkirseNiirrbefthv的0MMarksrnt110EtudertJOCD」r5Q、LEberVlarkicoci1001EQ8口？IDOL明8聯(lián)1001自CM100262CC051092&4CC061009f7COO；1003bHCOOE1004EECOO?2003C

Studentinfo(StudentIDchar(20)primarykey,StudentNamechar(20),Classchar(20),StudentPasswordChar(20));包含：學(xué)號(hào)StudentID、學(xué)生姓名StudentNama班級(jí)號(hào)Class、學(xué)生密碼StudentPasswordRath |F二:畤gn*特T(用「』Cptiftfi^.Comment|&QUPr-ewew3一leogtDecimalAll戢制HIk5g忙Stildentf-fcarnechdrtlMrCh*r20 9 □ #L父 m // 0 昆20 d ?StudentIDStudentNameCla5sStudentPassvvardi00010002■螢瑩王佳欣083100821040010002?0003［注31口|OOD3FileLl；K.閭歸口蛻l-Kd￡P(guān)rimaryKjonf/ma>J聞gf匕Eh網(wǎng)5Ae.AridAcd-ZfitortFis-dr匚1GbB小/Teacherinfo(TeacherIDchar(20)primarykey,TeacherNamechar(20),TeacherPasswordchar(20));包含：教師編號(hào)TeacherID、教師姓名TeacherName教師密碼TeacherPassword吏hadarfa將 工CtwcMr同口研mmgwmt.X"戶Edit Hfl。tjjrwwlr]SaveQ瑞vfAf_jAddfidd三JntereHeld號(hào)Lelete■ie-d>PrimaryM.tMewF*IueFor白lg『忙?心Triggers|Qp的黑|Comnwit&QLP1例fewN^m:TypeungihDKlmalt/4owMl4IkT*M『h*dDcharM0 □ >1TMcherNamechar切0 (?C.hdFsoc itTeacherIDTeacherNsrne TeacherPasswordJooooci|bb000901OODOD2何澤恒DCO30?OOOOC2李梭搽DCO309OOOQQ4壁偌DCQ3Q4OOOOC5聯(lián)歸MQM5ouooce出少喋?DOOOObDODO07瑜DCOD07ooooceMQM8Teachinginfo(CourseNumberchar(20)primarykey,TeacherIDchar(20));包含：課程編號(hào)CourseNumber教師編號(hào)TeacherIDBtEatTinginfn在rnarFCm-箕03工一擊匕拿回1ag所“.FF#EdllWlrdo^H碗kJ Ae_jAdd±iyHtrierl=DeleteFeld.：.PrimaryKf1FiWthkde#曾：「cr甯n麻：r-nflgcr5口mti二n二ConmentSQL~^-1^NameTypeLengthDecii?kAllowNull卜匚oun;qiMjmzsqrdiar20□匚TeacherIDchar200匣

CourseNumberTeecherlD10010000011D0200000210030000031004000004100500000510060000061007000007100S0000011QQ9000008.軟件結(jié)構(gòu)設(shè)計(jì)開發(fā)環(huán)境服務(wù)器搭建使用基于windows7操作系統(tǒng)，數(shù)據(jù)庫(kù)系統(tǒng)使用 Mysql,服務(wù)器搭建使用Apache,Web編寫使用PHP系統(tǒng)功能結(jié)構(gòu)系統(tǒng)結(jié)構(gòu) -模塊劃分登陸模塊系統(tǒng)使用人員登陸系統(tǒng)，輸入 ID號(hào)密碼，選擇身份。之后根據(jù)身份，查詢系統(tǒng)數(shù)據(jù)庫(kù)，判斷該 ID是否存在，密碼是否正確，確認(rèn)無(wú)誤之后繼續(xù)進(jìn)行之后的功能。實(shí)現(xiàn)程序段(與)：<phpsession_start();$_SESSION['firstlogin']=1;><head><metahttp-equiv="Content-Type"content="text/html;charset=gbk"/><title>學(xué)生管理信息系統(tǒng) </title><style>*{padding:0px;margin:0px;}a{color:White}body{font-family:Arial,Helvetica,sans-serif;background:url('images/')no-repeatcenter;font-size:13px;}img{border:0;}.lg{width:468px; height:468px;margin:100pxauto;background:url('images/')no-repeat;align:center;}.lg_top{height:200px;width:468px;align:center;}.lg_main{width:400px; height:180px;margin:025px;align="center";}.lg_m_1{width:290px;height:100px;padding:60px55px20px55px;margin:0pxauto;}.ur{height:37px;border:0;color:#666;width:236px;margin:4px28px;background:url('images/')no-repeat;padding-left:10px;font-size:16pt;font-family:Arial,Helvetica,sans-serif;}.pw{height:37px;border:0;color:#666;width:236px;margin:4px28px;background:url('images/')no-repeat;padding-left:10px;font-size:16pt;font-family:Arial,Helvetica,sans-serif;}.lg_foot{height:80px;width:330px;padding:6px68px068px;align="center"}</style></head><bodyclass="b"><divclass="lg"><divclass="lg_top"></div><divclass="lg_main"><divclass="lg_m_1"><form method="post" action=""><inputtype="text"name='user_name'class="ur"/><input type="password" name='user_pass'class="pw"/><pstyle="text-align: center"><fontsize='3'face='楷體'><strong>請(qǐng)選擇身份 </strong></font>:<br/></p><bodystyle="text-align:center;"><selectname="shenfen"size="1"style="text-align:center"><optionvalue="1"> 學(xué)生 </option><optionvalue="2"> 教師 </option><optionvalue="3">管理員</option></select><pstyle="text-align: center"><inputname="submit1"type="submit"value="登錄"/></p></form><formmethod="post"action=""><pstyle="text-align: center"><inputname="submitOtype="submit"value="重置"/></p></form></div></div></form></body></html><phpsession_start();if($_SESSION['firstlogin']){$_SESSION['username']=$_POST['user_name'];$_SESSION['password']=$_POST['user_pass'];$_SESSION['shenfen']=$_POST['shenfen'];$_SESSION['firstlogin']=false;}$shenfen=$_SESSION['shenfen'];$user_name=$_SESSION['username'];$user_pass=$_SESSION['password'];><html><head><title>登陸成功 !</title><metahttp-equiv="Content-Type"content="text/html;charset=gbk"><styletype="text/css">body{background-image:url(images/;background-repeat:repeat;}</style></head><body><php$db=mysql_connect(':3306','root','')ordie(" 連接失敗 ");mysql_select_db('management',$db)ordie(mysql_error($db));if($shenfen['shenfen']==1){

$query="SELECTStudentID,StudentName,,Major,departmentfromstudentinfo,ClassInfowhereANDStudentID='$user_name'ANDStudentPassword='$user_pass'AND=;";mysql_query("setnames'gbk'");mysql_query("SETCHARACTERSETgbk");$result=mysql_query($query,$db)ordie("ERROR");if(mysql_numrows($result)==0){".'<br/>';echo"用戶名或密碼錯(cuò)誤！".'<br/>';echo"<ahref=''>";echo"重新登錄 ";echo"</a>";}else{echo"<ahref=''>";}else{echo"<ahref=''>";echo"<palign='right'>echo"</a>";echo"<ahref=''>";echo"<palign='right'>echo"</a>";echo"<ahref=''>";echo"<palign=right>echo"</a>";value.'</td>';注銷</p>";修改密碼 </p>"."<br/>";修改選課信息 </p>";}while($row=mysql_fetch_assoc($result)){echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';}echo'</tr>';}echo'</table>';$class'-' .$StudentName. '-' .$class$StudentPassword.'<br/>';echo'</br>';echo'</br>';$query="SELECT,CourseName,Grade,Marksfromstudentcourse,CourseInfowhereStudentID='$user_name'and=";$result=mysql_query($query,$db)ordie("未知錯(cuò)誤!")；echo'<tableborder="0"align=center>';echo"<td>選課信息：</td>";echo'<tableborder="1"align=center>';$row=array('課程編號(hào)',’課程名‘,‘學(xué)分','分?jǐn)?shù)')；echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';}while($row=mysql_fetch_assoc($result)){echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';}echo'</tr>';}echo'</table>';}}if($shenfen['shenfen']==2){<br/>';echo"<ahref=''>";echo"重新登錄";echo"</a>";}else{echo"<ahref=''>";echo”<palign='right'>注銷</p>”;echo"</a>";echo"<ahref=''>";echo"<palign='right'> 修改密碼</p>"."<br/>";echo"</a>";echo'<tableborder="0"align="center">';echo"<td>教師信息：</td>";echo'<tableborder="1"align="center">';$row=array('教師編號(hào)','姓名');echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';)while($row=mysql_fetch_assoc($result)){echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';)echo'</tr>';)echo'</table>';$query="SELECT,CourseNamefromTeachinginfo,CourseInfowhereTeacherID='$user_name'and=";$result=mysql_query($query,$db) ordie("Unexpectederror(mark)!");echo"<palign=center>課程:</p>";while(mysql_num_rows($result)!=0&&$row=mysql_fetch_assoc($result)){extract($row);echo"<ahref='course=$CourseNumber'>";echo"<palign=center>$CourseName</p>";echo"</a>";)))if($shenfen['shenfen']==3){<br/>';echo"<ahref=''>";echo"重新登錄";echo"</a>";)else{echo"<ahref=''>";echo"<palign=right>注銷</p>";echo"</a>";echo"<ahref=''>";echo"<palign=right> 修改密碼</p>"."<br/>";echo"</a>";echo'<tableborder="0"align=center>';echo"<td>管理員信息：</td>";echo'<tableborder-'1"align=center>';$row=array('管理員編號(hào)？姓名')；echo'<tr>';foreach($rowas$value){echo,<td>'.$value.,</td>,;)while($row=mysql_fetch_assoc($result)){echo'<tr>';foreach($rowas$value){echo,<td>'.$value.,</td>,;)echo'</tr>';)echo'</table>';echo"<palign=center>請(qǐng)選擇要修改的內(nèi)容：</p>","<br/>";echo"<ahref='select=r>";echo"<palign=center>管理員信息</p>"."<br/>";echo"</a>";echo"<ahref=,select=2'>";echo"<palign=center> 教師信息</p>"."<br/>";echo"</a>";echo"<ahref=,select=3'>";echo"<palign=center> 學(xué)生信息</p>"."<br/>";echo"</a>";echo"<ahref=,select=4'>";echo"<palign=center> 課程信息</p>"."<br/>";echo"</a>";echo"<ahref=,select=5'>";echo"<palign=center>教師授課信息</p>"."<br/>";echo"</a>";))></div></body></html>增刪模塊教師部分，輸入新學(xué)生ID,新成績(jī)，再根據(jù)教師是的任課課程修改數(shù)據(jù)可中的學(xué)生成績(jī)。管理員部分，先選擇想要錄入的人員身份或者是課程編號(hào)， 冉根據(jù)輸入的基本信息，錄入到數(shù)據(jù)庫(kù)中。實(shí)現(xiàn)程序段：<phpsession_start();$_SESSION['admin_select']=$_GET['select'];$admin_select=$_SESSION['admin_select'];$db=mysql_connect('','root','')ordie("Unabletoconnect.Checkyourconnectionparameters.");mysql_select_db('management',$db)ordie(mysql_error($db));><head><title>輸入教師編號(hào) </title><styletype="text/css">body{background-image:url(pic/;}</style></head><body><phpecho"<ahref=''>";echo"<palign=right>返回</p>";echo"</a>";mysql_query("setnames'gbk'");mysql_query("SETCHARACTERSETgbk");$query="SELECTTeacherID,TeacherNamefromTeacherinfo";$result=mysql_query($query,$db)ordie("Unexpectederror(scole))");echo'<tableborder="1">';$row=array('教師編號(hào) ','姓名');echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';}while($row=mysql_fetch_assoc($result)){echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';}echo'</tr>';}echo'</table>';><formmethod="post"action=""><p><strong>輸入要修改的教師編號(hào) </strong>:<br/><inputtype="text"name="sel_id"/></p><p><inputtype="submit"name="submit4"value="確認(rèn)"/></p></form></body></html>修改模塊：以教師身份登錄，根據(jù)已有學(xué)生 ID,和輸入的新成績(jī)，對(duì)數(shù)據(jù)庫(kù)進(jìn)行修改。 一管理員身份登錄， 先選擇要修改那種身份人員或課程的信息， 根據(jù)輸入的新信息修改數(shù)據(jù)庫(kù)。實(shí)現(xiàn)程序段：已修改學(xué)生成績(jī)?yōu)槔?lt;phpsession_start();$_SESSION['new_course']=$_GET['course'];$teaching_course=$_SESSION['new_course'];$user_name=$_SESSION['username'];$user_pass=$_SESSION['password'];$db=mysql_connect('','root','')ordie("Unabletoconnect.Checkyourconnectionparameters.");mysql_select_db('management',$db)ordie(mysql_error($db));><html><head><title>課程信息 </title><metahttp-equiv="Content-Type"content="text/html;charset=gb2312"><styletype="text/css">body{background-image:url(pic/;background-repeat:repeat;}</style></head><body><phpecho"<ahref=''>";echo"<palign=right>返回</p>";echo"</a>";echo"<br>"."課程編號(hào)： ",$teaching_course,"<br>";mysql_query("setnames'gbk'");mysql_query("SETCHARACTERSETgbk");$query_scole="select,StudentName,Marksfrom

studentcourse,StudentInfowhere=andCourseNumber='$teaching_courseorderbyStudentID";or$result_scole=mysql_query($query_scole,$db)die("Unexpectederror(scole))”);orecho'<tableborder="1">';$row=array('學(xué)號(hào)',’姓名',‘分?jǐn)?shù)')；echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';}while($row=mysql_fetch_assoc($result_scole)){echo'<tr>';foreach($rowas$value){echo'<td>'.$value.'</td>';}echo'</tr>';}echo'</table>';件調(diào)試進(jìn)入主頁(yè)登錄界面輸入正確的用戶名和密碼，選擇合適的身份，點(diǎn)擊登錄按鈕，登錄到系統(tǒng)

根據(jù)用戶身份登錄到對(duì)應(yīng)界面學(xué)生登錄界面顯示學(xué)生基本信息和選課信息，可以修改密碼、注銷、選課用戶隹息：用戶隹息：(XMH L| >注銷諄一改密和影竦住息：修改;洗課信層影竦住息：修改;洗課信層點(diǎn)擊注銷按鈕，退出登錄，返回登錄界面；點(diǎn)擊修改密碼按鈕，進(jìn)入密碼修改界面；踏清輸入廨蠻植：話前人斯奇眄;濤再.央輸入郭定硒：確LL點(diǎn)擊取消按鈕，返回上一界面；按提示輸入原密碼和新密碼，點(diǎn)擊確認(rèn)按鈕，跳轉(zhuǎn)到修改結(jié)果界面;若成功:若原密碼錯(cuò)誤:原鞭蟒快!

話番A若密碼兩次輸入不一致：.點(diǎn)擊鏈接返回。點(diǎn)擊修改選課信息進(jìn)行選課南式空*輸仇小一丸野將府三1001樹6用5如:i后果占ET周程名就］1001若原密碼錯(cuò)誤:原鞭蟒快!

話番A若密碼兩次輸入不一致：.點(diǎn)擊鏈接返回。點(diǎn)擊修改選課信息進(jìn)行選課南式空*輸仇小一丸野將府三1001樹6用5如:i后果占ET周程名就］1001曲型s1002芯息ua7100J唁色官澧底10W蜘即百用3lOOi法型”醫(yī)蛀姑向410063件工程410074希人鼻左用:：r：輸入課程編號(hào)，選擇選課或刪除操作，點(diǎn)擊確認(rèn)進(jìn)行選課選課時(shí)若該科目已存在己選該課程!成功選課刪除課程時(shí)，若未選該課未選該課程!成功刪除修改成功?點(diǎn)擊返回點(diǎn)擊鏈接返回.教師登錄界面顯示教師基本信息，所授課程，可以修改密碼和注銷,教師信息：逗函領(lǐng)師編號(hào)000001課程：

數(shù)棍庫(kù)許梢修改堂也點(diǎn)擊注銷按鈕，返回登錄界面;點(diǎn)擊修改密碼按鈕，修改用戶密碼，跳轉(zhuǎn)到密碼修改界面