<?php require "system.smarty.inc.php"; //包含Smarty配置类 require "system.class.inc.php"; //包含数据库连接和操作类 $connobj = new ConnDB("mysql", "localhost", "louss", "123456", "online_meal_data"); //数据库连接类实例化 $conn = $connobj->GetConnId(); //执行连接操作,返回连接标识 $admindb = new AdminDB(); //数据库操作类实例化 $seppage = new SepPage(); //分页类实例化 $smarty = new SmartyProject(); //调用smarty模板
<?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;