在数据库中创建表CREATETABLE-湖南大学信息科学与工程学院.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 ($resu