-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathCourseManagement.final.php
More file actions
60 lines (60 loc) · 2.19 KB
/
CourseManagement.final.php
File metadata and controls
60 lines (60 loc) · 2.19 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<html>
<head>
<style type="text/css">
div#container{width:100%}
div#header {background-color:#6A6AFF;height:110px;}
div#menu {background-color:#87CEEB;height:100%;width:10%;float:left;}
div#content{background-color:#E6E6FA;height:100%;width:90%; display:table;}
div#innercon{background-color:#E6E6FA;display:table-cell;text-align:center;}//垂直水平居中
</style>
</head>
<body>
<div id="header"> <img src="header.PNG" width=100% height=110px; /> </div>
<div id="menu"> <img src="menu.PNG" width=100% height=100%; /></div>
<div id="content">
<div id="innercon">
<table width="80%" border="1" cellpadding="1" cellspacing="1" align="center" text-align="center">
<h1 style="font-size:30px;color:lightskyblue;">2015  教  师  开  课  计  划</h1>
<tr align="center">
<th width="5%">年级</th>
<th width="15%">专业</th>
<th width="5%">专业人数</th>
<th width="20%">课程名称</th>
<th width="15%">选修类型</th>
<th width="5%">学分</th>
<th width="5%">学时</th>
<th width="5%">实验学时</th>
<th width="5%">上机学时</th>
<th width="5%">起讫周序</th>
<th width="5%">任课教师</th>
<th width="5%">备注</th>
</tr>
<?php
mysql_connect('localhost','root','123456');
mysql_select_db('coursemanagement');
mysql_query("SET NAMES utf8");
$sql = "select * from course";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
echo '<tr align="center">';
echo "<td>" . $row['年级'] . "</td>";
echo "<td>" . $row['专业'] . "</td>";
echo "<td>" . $row['专业人数'] . "</td>";
echo "<td>" . $row['课程名称'] . "</td>";
echo "<td>" . $row['选修类型'] . "</td>";
echo "<td>" . $row['学分'] . "</td>";
echo "<td>" . $row['学时'] . "</td>";
echo "<td>" . $row['实验学时'] . "</td>";
echo "<td>" . $row['上机学时'] . "</td>";
echo "<td>" . $row['起讫周序'] . "</td>";
echo "<td>" . $row['任课教师'] . "</td>";
echo "<td>" . $row['备注'] . "</td>";
echo "</tr>";
}
mysql_close();
?>
</table>
</div>
</div>
</body>
</html>