FK对接平台数据库测试研究
- WBOYOriginal
- 2016-07-11 08:44:041569Durchsuche
跳至
[1]
[全屏预览]
<?php
//1.导入配置文件
require("conf/dbconfig.php");
$link = mysql_connect(HOST, USER, PASS);
mysql_select_db(DBNAME);
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>小雨在线-课堂教学评价跟踪表系统</title>
<link href="//cdn.bootcss.com/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
<script src="//cdn.bootcss.com/jquery/1.11.3/jquery.min.js"></script>
<script src="../js/jquery.stickytableheaders.min.js"></script>
<script src="js/all.js"></script>
<style>
fieldset {
padding: .35em .625em .75em;
margin: 0 2px;
border: 1px solid #DDDDDD
}
legend {
padding: .5em;
border: 0;
width: auto
}
</style>
</head>
<body>
<div id="box" class="container-fluid">
<fieldset>
<legend>欢迎管理员</legend>
<?php
$sql = "SELECT
edu_trxorder.id 'id',
edu_trxorder.student_name 'stu_name',
edu_trxorder.mobile 'stu_mob',
edu_course.subject_major_str 'nianji',
user_expand.realname 'tea_name',
user_user.mobile 'tea_mob',
edu_course.join_num 'bm_num',
edu_trxorder.lession_num 'keshi',
edu_trxorder.course_name 'kecheng',
edu_course.course_plan 'kaike_time',
edu_trxorder.pay_time 'tijiao_time'
FROM
edu_trxorder
INNER JOIN edu_course ON edu_trxorder.course_id = edu_course.id
INNER JOIN edu_teacher ON edu_trxorder.teacher_id = edu_teacher.id
INNER JOIN user_user ON user_user.id = edu_teacher.user_id
INNER JOIN user_expand ON user_expand.user_id = user_user.id
ORDER BY
edu_trxorder.id DESC";
$result = mysql_query($sql);
$n = 1;
echo "<table border=\"1\" bordercolor=\"#CCCCCC\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse:collapse\" width=\"100%\">";
echo "<tr>
<td>排序号</td>
<td>id</td>
<td>学生姓名</td>
<td>学生手机</td>
<td>年级/学科</td>
<td>教师姓名</td>
<td>教师手机</td>
<td>课时</td>
<td>报名人数</td>
<td>课程</td>
<td>课程安排</td>
<td>提交时间</td>
</tr>";
while ($row = mysql_fetch_assoc($result)) {
echo "<tr>
<td> {$n}</td>
<td> {$row['id']}</td>
<td> {$row['stu_name']}</td>
<td> {$row['stu_mob']}</td>
<td> {$row['nianji']}</td>
<td> {$row['tea_name']}</td>
<td> {$row['tea_mob']}</td>
<td>{$row['keshi']}</td>
<td>{$row['bm_num']}</td>
<td> {$row['kecheng']}</td>
<td> {$row['kaike_time']}</td>
<td> {$row['tijiao_time']}</td>
</tr>";
$n++;
}
echo "</table>";
?>
</fieldset>
</div>
<script type="text/javascript">
$(document).ready(function () {
});
</script>
</body>
</html>
Stellungnahme：
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Vorheriger Artikel：PHP记住密码功能实现例子Nächster Artikel：分享一个PHP的多店铺的电商网站，只要几千块