$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"]);