<?php
require "./conn/config.php";
//获取老师的ID号
session_start();
$teacherid = $_SESSION['userid'];
$DB = new ConnDB(dbtype, host, user, pwd, dbname);
$conn = $DB->GetConnId();
$courseid_array = array();
$courseid_sql = "select m_courseid from " . tb_table_teacourse . " where m_teacherid={$teacherid}";
$rs = $conn->query($courseid_sql);
if ($rs) {
while ($row = mysqli_fetch_array($rs)) {
$courseid_array[] = $row['m_courseid'];
}
}
$course_sql = "select * from " . tb_table_course . " where m_courseid={$courseid_array['0']}";
for ($i = 1; $i < count($courseid_array); $i++) {
$course_sql .= " or m_courseid={$courseid_array[$i]}";
}
$coursepage = new SepPage();
$myrow_course = $coursepage->ShowCourse($course_sql, $conn, pagesize, $_GET["pagec"]);
<?php
require "./conn/config.php";
define('pagesize', 4);
/************mysql*************/
$DB = new ConnDB(dbtype, host, user, pwd, dbname);
$conn = $DB->GetConnId();
$admindb = new AdminDB();
$seppage = new SepPage();
$seppagep = new SepPage();
$unhtml = new UseFun();
$teacher_id = array();
$course_id = array();
$teachermatch = false;
/******************先判断搜索内容是否为老师名字 *******************/
if ($newstr[0]) {
$teasql = "select * from t_teacher where m_teacher like '{$newstr['0']}%'";
for ($j = 1; $j < count($newstr); $j++) {
$teasql .= " or m_teacher like '{$newstr[$j]}%'";
}
$rs = $conn->query($teasql);
if ($rs) {
while ($row = mysqli_fetch_array($rs)) {
$teacher_id[] = $row['m_teacherid'];
}
if (count($teacher_id)) {
$teachermatch = true;
} else {
$teachermatch = false;
}
} else {
$teachermatch = false;
<?php
require "./conn/config.php";
//获取课程的ID号
$courseid = $_GET['courseid'];
$DB = new ConnDB(dbtype, host, user, pwd, dbname);
$conn = $DB->GetConnId();
$chapterid_sql = "select * from " . tb_table_chapter . " where m_courseid={$courseid} order by m_chapterindex asc";
$chapterpage = new SepPage();
$myrow_chapter = $chapterpage->ShowChapter($chapterid_sql, $conn, 3, $_GET["pagep"]);
