public static function getList($teacherId) { $pdo = new DBUtils(); $sql = "select * from teacherDes where teacherId = '{$teacherId}'"; $rs = $pdo->query($sql); return $rs; }
public static function getList($snavId) { $pdo = new DBUtils(); $sql = "select * from article where snavId = {$snavId}"; $rs = $pdo->query($sql); return $rs; }
public static function getBuyList() { $pdo = new DBUtils(); $sql = "select * from buy"; $rs = $pdo->query($sql); return $rs; }
public static function getIndex() { $pdo = new DBUtils(); $sql = "select * from homepage"; $rs = $pdo->query($sql); return $rs; }
function getNav() { $pdo = new DBUtils(); $sql = "select * from nav"; $nav = $pdo->query($sql); $header = array(); foreach ($nav as $key => $val) { $header[$val['navId']] = array("navName" => $val['navName'], "navId" => $val['navId'], "second" => array()); } $sql = "select * from second_nav"; $second = $pdo->query($sql); foreach ($second as $key => $val) { $header[$val['navId']]['second'][$val['snavId']] = array("snavName" => $val['snavName'], "snavId" => $val['snavId'], "link" => $val['snavName']); } return $header; }
public static function getAdviceList() { $pdo = new DBUtils(); $sql = "select * from advice"; $rs = $pdo->query($sql); return $rs; }
public static function getJoinusList() { $pdo = new DBUtils(); $sql = "select * from joinus"; $rs = $pdo->query($sql); return $rs; }
public static function getStudentReportList($type) { $pdo = new DBUtils(); $sql = "select * from student_report where type = '{$type}'"; $rs = $pdo->query($sql); return $rs; }
public static function getOne($courseId) { $pdo = new DBUtils(); $sql = "select * from course where courseId = {$courseId}"; $course = $pdo->getOne($sql); $sql = "select * from courseType where courseId = {$courseId}"; $courseType = $pdo->query($sql); return array("course" => $course, "courseType" => $courseType); }
<?php header("Content-Type:text/html;charset=utf-8"); include_once "config/dbconfig.php"; include_once "utils/dbutils.php"; $mysql = new DBUtils(); $sql = "SELECT * from articles"; $mysql->query($sql); $qInfo = array(); if ($mysql->getResultSize() == 0) { $qInfo['isSuccess'] = false; } else { $qInfo['isSuccess'] = true; $qInfo['responseText'] = $mysql->getResultSet(); } echo json_encode($qInfo);