$myrow_class = $seppage->ShowCourse($sql, $conn, pagesize, $_GET["pagec"]);
}
/*******************搜索视频*********************/
if ($newstr == false) {
$myrow_chapter = array();
} else {
if (count($newstr) == 1) {
$sql3 = "select * from " . tb_table_chapter . " where m_chapter like '%{$newstr['0']}%' order by m_numconcern desc";
} else {
for ($i = 0; $i < count($newstr); $i++) {
$sql4 .= " m_chapter like '%{$newstr[$i]}%' or";
}
$sql4 = substr($sql4, 0, -2);
$sql3 = "select * from " . tb_table_chapter . " where" . $sql4 . "order by m_numconcern desc";
}
$myrow_chapter = $seppagep->ShowChapter($sql3, $conn, pagesize, $_GET["pagep"]);
}
} else {
if ($teachermatch == true) {
/**************搜索到老师的情况******************/
$coursesql = "select m_courseid from t_teacourse where m_teacherid={$teacher_id['0']}";
for ($i = 1; $i < count($teacher_id); $i++) {
$coursesql .= " or m_teacherid={$teacher_id[$i]}";
}
$rs = $conn->query($coursesql);
$course_id = array();
if ($rs) {
while ($row = mysqli_fetch_array($rs)) {
$course_id[] = $row['m_courseid'];
}
$sql = "select * from " . tb_table_course . " where m_courseid={$course_id['0']}";
<?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"]);
