软件学院学生姓名 - 湖南大学信息科学与工程学院.ppt

Teacher.php (1) ?php include DB.php; $name=$_REQUEST[name]; $sql=select o,ame,c.hours,tc.semester,c.credit,d.dname from course as c, teacher as t, teacher_course as tc , department as d where t.tname=$name and t.tno=tc.tno and o=o and t.dno=d.dno ; $result= mysql_query ( $sql ); $num=mysql_num_rows($result); echo table border=\0\ align=\center\ tr align=\center\ bgcolor=\#00CCCC\ td colspan=\6\$name 老师开课信息/td/tr; echo tr align=\center\ bgcolor=\#9D9D9D\; echo td课程编号/tdtd课程名称/tdtd授课学时/tdtd开课学期/tdtd课程学分/tdtd课程归属院系/td; echo /tr; Teacher.php (2) if($num0) { $flag=true; while ($result_row=mysql_fetch_array($result)) { $result_cno = $result_row[cno]; $result_cnnme = $result_row[cname]; $result_hours = $result_row[hours]; $result_semester = $result_row[semester]; $result_credit = $result_row[credit]; $result_dname = $result_row[dname]; $flag=$flag?false:true; $color=$flag?#9999FF:#99CCFF; echo tr align=\center\ bgcolor=\$color\; echo td$result_cno/tdtd$result_cnnme/tdtd$result_hours/tdtd$result_semester/tdtd$result_credit/tdtd$result_dname/td; echo /tr; } } Teacher.php (3) else { echo tr align=\center\; echo td colspan=\9\无开课信息/td; echo /tr; } echo /table; mysql_close ( $link ); ? student.php (1) ?php include DB.php; $name=$_REQUEST[name]; $sql=select s.sno,s.sex,s.birthday,d.dname,s.classno from student as s,department as d where s.sname=$name and s.dno=d.dno; $result= mysql_query ( $sql ); $num=mysql_num_rows($result); echo table border=\0\ align=\center\ tr align=\center\ bgcolor=\#00CCCC\ td colspan=\6\$name 个人信息/td/tr; echo tr align=\center\ bgcolor=\#1AFD9C\; echo td学号/tdtd性别/tdtd出生年月/tdtd所在院系/tdtd班级/td; echo /tr; student.php (2) $result_row=mysql_fetch_array($result); $result_sno=$result_row[sno]; $result_sex=$result_row[sex]; $result_birthday=$result_row[birthday]; $result_dno=$result_row[dname]; $result_classno=$result_row[classno]; echo tr align=\center\ bgcolor=\#96FED1\; echo td$result_sno/tdtd $result_sex/tdtd$resu