Jump to
[1]
[Full screen preview]
<?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>
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Repo: How To Revive Teammates
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
4 weeks agoByDDD
R.E.P.O. Save File Location: Where Is It & How to Protect It?
4 weeks agoByDDD
Hot Tools
Atom editor mac version download
The most popular open source editor
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
Dreamweaver Mac version
Visual web development tools
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
