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