//没有搜索到老师的情况
/*******************搜索课程*********************/
if ($newstr == false) {
$myrow_class = array();
} else {
if (count($newstr) == 1) {
$sql = "select * from " . tb_table_course . " where m_course like '%{$newstr['0']}%' or m_content like '%{$newstr['0']}%' order by m_numconcern desc";
} else {
for ($i = 0; $i < count($newstr); $i++) {
$sql1 .= " m_course like '%{$newstr[$i]}%' or";
$sql2 .= " m_content like '%{$newstr[$i]}%' and";
}
$sql2 = substr($sql1, 0, -3);
$sql = "select * from " . tb_table_course . " where" . $sql1 . $sql2 . "order by m_numconcern desc";
}
$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"]);
<?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"]);
